Monday, 16 December 2013

Repository Details for employees

Account Repository

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;

namespace MVCDemo.Repository
{
    public class AccountRepository
    {
        public bool AuthenticateUser(string UserName, string Password)
        {
            try
            {
                if (UserName == "Admin@gmail.com" && Password == "admin")
                    return true;
                else
                    return false;
            }
            catch (Exception ex)
            {
                return false;
            }
        }
    }
}

Employee Repository :

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
using MVCDemo.Models;

namespace MVCDemo.Repository
{
    public class EmployeeRepository
    {
        TestEntities _db = new TestEntities();

        public IEnumerable<EmployeeMaster> GetAllEmployee()
        {
            return (from e in _db.EmployeeMasters select e);
        }

        public bool SaveEmployee(EmployeeMaster emp)
        {
            try
            {
                if (emp.EmployeeId > 0)
                    _db.Entry(emp).State = EntityState.Modified;
                else
                    _db.EmployeeMasters.Add(emp);
                _db.SaveChanges();
                return true;
            }
            catch
            {
                return false;
            }
           
        }

        public EmployeeMaster GetEmpByID(int Id = 0)
        {
            return (from e in _db.EmployeeMasters where e.EmployeeId == Id select e).FirstOrDefault();
        }

        public bool DeleteEmp(int Id = 0)
        {
            var emp = GetEmpByID(Id);
            _db.EmployeeMasters.Remove(emp);
            _db.SaveChanges();
            return true;
        }
    }
}

Invoice Repository :

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using MVCDemo.Models;
using System.Data;

namespace MVCDemo.Repository
{
    public class InvoiceRepository
    {
        TestEntities _db = new TestEntities();

        public IEnumerable<InvoiceMaster> GetAllInvoice()
        {
            return (from e in _db.InvoiceMasters select e);
        }

        public bool SaveInvoice(InvoiceMaster Inv)
        {
            try
            {
                if (Inv.InvoiceID > 0)
                    _db.Entry(Inv).State = EntityState.Modified;
                else
                    _db.InvoiceMasters.Add(Inv);
                _db.SaveChanges();
                return true;
            }
            catch
            {
                return false;
            }

        }

        public InvoiceMaster GetInvByID(int Id = 0)
        {
            return (from e in _db.InvoiceMasters where e.InvoiceID == Id select e).FirstOrDefault();
        }

        public bool DeleteInv(int Id = 0)
        {
            var Inv = GetInvByID(Id);
            _db.InvoiceMasters.Remove(Inv);
            _db.SaveChanges();
            return true;
        }
    }
}

No comments:

Post a Comment