Exemplo n.º 1
0
        public ActionResult UpdateCustomer(CustomerModels.CustomerModel customer)
        {
            var cCode = Entities.S_Customer.Where(c => c.CustomerID != customer.CustomerID && c.Code == customer.Code).FirstOrDefault();

            if (cCode != null)
            {
                var township = Entities.S_Township.ToList();
                ViewBag.Township = new SelectList(township, "TownshipID", "TownshipName");
                GetisMultiBranch();
                if (ViewBag.isMultiBranch == true)
                {
                    var branches = Entities.S_Branch.ToList();
                    ViewBag.Branches = new SelectList(branches, "BranchID", "BranchName");
                }
                ViewBag.Message  = "Customer Code Duplicated....";
                ViewBag.formType = 2;
                return(View("CreateCustomer"));
            }
            else
            {
                if (customer.BranchID > 0)
                {
                    Entities.PrcUpdateCustomerData(customer.CustomerID, customer.Code, customer.CustomerName, customer.TownshipID, customer.Contact, customer.Address, customer.Phone, customer.Email, customer.IsCredit, customer.IsDefault, customer.BranchID);
                }
                else
                {
                    Entities.PrcUpdateCustomerData(customer.CustomerID, customer.Code, customer.CustomerName, customer.TownshipID, customer.Contact, customer.Address, customer.Phone, customer.Email, customer.IsCredit, customer.IsDefault, null);
                }
                ViewBag.Message = "Customer Updated Successful...";
                return(View("CustomerList", GetCustomerList().ToList()));
            }
        }
Exemplo n.º 2
0
        public List <CustomerModels.CustomerModel> GetCustomerList()
        {
            List <CustomerModels.CustomerModel> lstCustomer = new List <CustomerModels.CustomerModel>();
            var customer = Entities.PrcRetrieveCustomer();

            foreach (var model in customer)
            {
                CustomerModels.CustomerModel data = new CustomerModels.CustomerModel();
                data.CustomerID   = Convert.ToInt32(model.CustomerID);
                data.Code         = Convert.ToString(model.Code);
                data.CustomerName = Convert.ToString(model.CustomerName);
                data.TownshipID   = Convert.ToInt32(model.TownshipID);
                data.TownshipName = Convert.ToString(model.TownshipName);
                data.BranchID     = Convert.ToInt32(model.BranchID);
                data.BranchName   = Convert.ToString(model.BranchName);
                data.Contact      = Convert.ToString(model.Contact);
                data.Address      = Convert.ToString(model.Address);
                data.Phone        = Convert.ToString(model.Phone);
                data.Email        = Convert.ToString(model.Email);
                data.IsCredit     = Convert.ToBoolean(model.IsCredit);
                data.IsDefault    = Convert.ToBoolean(model.IsDefault);
                lstCustomer.Add(data);
            }
            return(lstCustomer);
        }
Exemplo n.º 3
0
        public ActionResult EditCustomer(int id)
        {
            var township = Entities.S_Township.ToList();

            ViewBag.Township = new SelectList(township, "TownshipID", "TownshipName");
            GetisMultiBranch();
            if (ViewBag.isMultiBranch == true)
            {
                var branches = Entities.S_Branch.ToList();
                ViewBag.Branches = new SelectList(branches, "BranchID", "BranchName");
            }
            var customer = Entities.S_Customer.Find(id);

            if (customer != null)
            {
                CustomerModels.CustomerModel model = new CustomerModels.CustomerModel();
                model.CustomerID   = Convert.ToInt32(customer.CustomerID);
                model.CustomerName = Convert.ToString(customer.CustomerName);
                model.Code         = Convert.ToString(customer.Code);
                model.Phone        = Convert.ToString(customer.Phone);
                model.Email        = Convert.ToString(customer.Email);
                model.Contact      = Convert.ToString(customer.Contact);
                model.Address      = Convert.ToString(customer.Address);
                model.TownshipID   = Convert.ToInt32(customer.TownshipID);
                model.BranchID     = Convert.ToInt32(customer.BranchID);
                model.IsCredit     = Convert.ToBoolean(customer.IsCredit);
                ViewBag.formType   = 2;
                return(View("CreateCustomer", model));
            }
            else
            {
                return(View("CreateCustomer"));
            }
        }
Exemplo n.º 4
0
        public List <CustomerModels.CustomerModel> SearchingCustomerData(string customer, int township, int branch)
        {
            List <CustomerModels.CustomerModel> lstCustomer = new List <CustomerModels.CustomerModel>();
            var cData = Entities.PrcSearchCustomerData(customer, township, branch);

            foreach (var item in cData)
            {
                CustomerModels.CustomerModel model = new CustomerModels.CustomerModel();
                model.CustomerID   = Convert.ToInt32(item.CustomerID);
                model.Code         = Convert.ToString(item.Code);
                model.CustomerName = Convert.ToString(item.CustomerName);
                model.TownshipName = Convert.ToString(item.TownshipName);
                model.BranchName   = Convert.ToString(item.BranchName);
                lstCustomer.Add(model);
            }
            return(lstCustomer);
        }
Exemplo n.º 5
0
        public ActionResult InsertCustomer(CustomerModels.CustomerModel customer)
        {
            var township = Entities.S_Township.ToList();

            ViewBag.Township = new SelectList(township, "TownshipID", "TownshipName");
            GetisMultiBranch();
            if (ViewBag.isMultiBranch == true)
            {
                var branches = Entities.S_Branch.ToList();
                ViewBag.Branches = new SelectList(branches, "BranchID", "BranchName");
            }
            try
            {
                var cCode = Entities.S_Customer.Where(c => c.Code == customer.Code).FirstOrDefault();
                if (cCode != null)
                {
                    ViewBag.Message = "Customer Code Duplicate...";
                    ViewBag.Type    = 2;
                }
                else
                {
                    S_Customer tbl_customer = new S_Customer();
                    tbl_customer.CustomerName = customer.CustomerName;
                    tbl_customer.Code         = customer.Code;
                    tbl_customer.Phone        = customer.Phone;
                    tbl_customer.Email        = customer.Email;
                    tbl_customer.Contact      = customer.Contact;
                    tbl_customer.Address      = customer.Address;
                    if (customer.BranchID > 0)
                    {
                        tbl_customer.BranchID = customer.BranchID;
                    }
                    else
                    {
                        tbl_customer.BranchID = null;
                    }
                    if (customer.TownshipID > 0)
                    {
                        tbl_customer.TownshipID = customer.TownshipID;
                    }
                    else
                    {
                        tbl_customer.TownshipID = null;
                    }
                    tbl_customer.IsCredit  = customer.IsCredit;
                    tbl_customer.IsDefault = false;
                    Entities.S_Customer.Add(tbl_customer);
                    Entities.SaveChanges();
                    ModelState.Clear();
                    ViewBag.Message = "New Customer is inserted successful..";
                    ViewBag.Type    = 1;
                }
                return(View("CreateCustomer"));
            }
            catch (Exception ex)
            {
                ViewBag.Message = "Please Enter Customer Detail...";
                ViewBag.Type    = 2;
                return(View("CreateCustomer"));
            }
        }