コード例 #1
0
ファイル: CRUDManager.cs プロジェクト: Jayendra88/PhoneShop
 public void AddNewCustomer(CustomerM customer)
 {
     using (PhoneShopdbEntities e = new PhoneShopdbEntities())
     {
         try
         {
             Customer c = new Customer();
             c.Name = customer.Name;
             c.NIC = customer.NIC;
             c.Email = customer.Email;
             e.Customers.Add(c);
             e.SaveChanges();
         }
         catch { }
     }
 }
コード例 #2
0
ファイル: CRUDManager.cs プロジェクト: Jayendra88/PhoneShop
        public bool AddNewJobDetailed(DetailedJobModelM job)
        {
            using (PhoneShopdbEntities ctx = new PhoneShopdbEntities())
            {
                Customer customer = ctx.Customers.Where(x => x.NIC == job.Customer.NIC).FirstOrDefault();
                if (customer == null)
                {
                    customer = new Customer();
                    customer.Name = job.Customer.Name;
                    customer.NIC = job.Customer.NIC;
                    customer.Email = job.Customer.Email;
                    ctx.Customers.Add(customer);
                }
                else
                {
                    customer = GetCustomerByNIC(job.Customer.NIC);
                    customer.Name = job.Customer.Name;
                    customer.Email = job.Customer.Email;
                }

                var telNums = ctx.TelephoneNumbers.Where(x => x.Customer_Id == customer.Id).ToList();
                TelephoneNumber home = null;
                TelephoneNumber mobile = null;

                foreach (var item in job.Customer.TelephoneNumbers)
                {
                    if (item.IsHome)
                    {
                        home = telNums.Where(x => x.IsHome == true).FirstOrDefault();
                        if (home == null)
                        {
                            home = new TelephoneNumber();
                            home.Customer_Id = customer.Id;
                            home.IsHome = item.IsHome;
                            home.TelNo = item.TelNo;
                            ctx.TelephoneNumbers.Add(home);
                        }
                        else
                        {
                            home.TelNo = item.TelNo;
                        }
                    }
                    else
                    {
                        mobile = telNums.Where(x => x.IsHome == false).FirstOrDefault();
                        if (mobile == null)
                        {
                            mobile = new TelephoneNumber();
                            mobile.Customer_Id = customer.Id;
                            mobile.IsHome = item.IsHome;
                            mobile.TelNo = item.TelNo;
                            ctx.TelephoneNumbers.Add(mobile);
                        }
                        else
                        {
                            mobile.TelNo = item.TelNo;
                        }
                    }
                }

                PhoneBrand brand = ctx.PhoneBrands.Where(x => x.BrandName == job.PhoneModel.BrandName).FirstOrDefault();
                PhoneModel model = null;
                if (brand == null)
                {
                    brand = new PhoneBrand();
                    brand.BrandName = job.PhoneModel.BrandName;
                    ctx.PhoneBrands.Add(brand);

                    model = new PhoneModel();
                    model.Brand_Id = brand.Id;
                    model.ModelNumber = job.PhoneModel.SelectedPhoneModel.ModelNumber;
                    model.ImageURI = job.PhoneModel.SelectedPhoneModel.ImageURI;

                    ctx.PhoneModels.Add(model);
                }
                else
                {
                    model = ctx.PhoneModels.Where(x => x.ModelNumber == job.PhoneModel.SelectedPhoneModel.ModelNumber).FirstOrDefault();
                    if (model == null)
                    {
                        model = new PhoneModel();
                        model.Brand_Id = (int)brand.Id;
                        model.ModelNumber = job.PhoneModel.SelectedPhoneModel.ModelNumber;
                        model.ImageURI = job.PhoneModel.SelectedPhoneModel.ImageURI;
                        ctx.PhoneModels.Add(model);
                    }
                    else
                    {
                        model.ImageURI = job.PhoneModel.SelectedPhoneModel.ImageURI;
                    }

                    //model.ImageURI = job.PhoneModel.SelectedPhoneModel.ImageURI;
                }

                Job newJob = new Job();
                newJob.Customer_Id = customer.Id;
                newJob.IsCompleted = false;
                newJob.IsDevice = job.DeviceOrAccaccessories.Count == 0 ? false : true;
                newJob.JobDiscription = job.Job.JobDiscription;
                newJob.JobNo = job.Job.JobNumber;
                newJob.OtherDiscription = job.Job.OtherDiscription;
                newJob.PhoneModel_Id = model.Id;
                //advanced pavement
                ctx.Jobs.Add(newJob);

                foreach (var item in job.DeviceOrAccaccessories)
                {
                    Device d = new Device();
                    d.Job_Id = newJob.Id;
                    if (item.IsPhone)
                    {
                        d.IsPhone = true;
                        d.EmiNumber = item.EmiNumber;
                    }
                    d.Discription = item.Discription;
                    ctx.Devices.Add(d);
                }

                ctx.SaveChanges();
            }
            return false;
        }
コード例 #3
0
ファイル: CRUDManager.cs プロジェクト: Jayendra88/PhoneShop
        public Customer GetCustomerByNIC(string NIC)
        {
            Customer customer = new Customer();

            using (PhoneShopdbEntities e = new PhoneShopdbEntities())
            {
                customer = e.Customers.Where(x => x.NIC == NIC).FirstOrDefault();

                //if (c != null)
                //{
                //    customer.Id = c.Id;
                //    customer.Name = c.Name;
                //    customer.NIC = c.NIC;
                //    customer.Email = c.Email;
                //}
            }

            return customer;
        }