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 { }
}
}
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;
}
internal ObservableCollection<DetailedPhoneModelM> GetAllPhoneModels()
{
ObservableCollection<DetailedPhoneModelM> phoneModels = new ObservableCollection<DetailedPhoneModelM>();
using (PhoneShopdbEntities ctx = new PhoneShopdbEntities())
{
var brands = ctx.PhoneBrands.ToList();
foreach (var item in brands)
{
DetailedPhoneModelM phoneM = new DetailedPhoneModelM();
phoneM.Id = (int)item.Id;
phoneM.BrandName = (string)item.BrandName;
var models = ctx.PhoneModels.Where(x => x.Brand_Id == item.Id).ToList();
foreach (var m in models)
{
PhoneModelM pm = new PhoneModelM();
pm.Id = m.Id;
pm.BrandId = (int)m.Brand_Id;
pm.ModelNumber = m.ModelNumber;
pm.ImageURI = m.ImageURI;
phoneM.PhoneModels.Add(pm);
}
phoneModels.Add(phoneM);
}
}
return phoneModels;
}
public ObservableCollection<TelephoneNumberM> getTelephoneNumberByCustomerId(int customerId)
{
ObservableCollection<TelephoneNumberM> tels = new ObservableCollection<TelephoneNumberM>();
using (PhoneShopdbEntities e = new PhoneShopdbEntities())
{
TelephoneNumberM tel = new TelephoneNumberM();
var t = e.TelephoneNumbers.Where(a => a.Customer_Id == customerId).ToList();
foreach (var item in t)
{
tel.Id = (int)item.Id;
tel.TelNo = (string)item.TelNo;
tel.IsHome = (bool)item.IsHome;
tel.CustomerId = (int)item.Customer_Id;
tels.Add(tel);
}
}
return tels;
}
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;
}
public ObservableCollection<CustomerM> GetAllCustomers()
{
ObservableCollection<CustomerM> customers = new ObservableCollection<CustomerM>();
using (PhoneShopdbEntities ctx = new PhoneShopdbEntities())
{
var c = ctx.Customers.ToList();
foreach (var item in c)
{
CustomerM customer = new CustomerM();
customer.Id = (int)item.Id;
customer.Name = (string)item.Name;
customer.NIC = (string)item.NIC;
customer.Email = (string)item.Email;
var t = ctx.TelephoneNumbers.Where(x => x.Customer_Id == item.Id).ToList();
foreach (var t1 in t)
{
TelephoneNumberM tel = new TelephoneNumberM();
tel.Id = t1.Id;
tel.CustomerId = (int)t1.Customer_Id;
tel.IsHome = (bool)t1.IsHome;
tel.TelNo = t1.TelNo;
customer.TelephoneNumbers.Add(tel);
}
customers.Add(customer);
}
}
return customers;
}