public static void AddClient(ClientsModel model, ServicesModel ModelServices, int postedbyId) { DataContext db = new DataContext(); TblClient tbl = new TblClient(); TblBusinessType tblBusinessType = new TblBusinessType(); tbl.Name = model.Name; tbl.TypeOfCompany = model.TypeOfCompany; tbl.LimitedBy = model.LimitedBy; tbl.ShareValue1 = model.ShareValue1; tbl.ShareValue2 = model.ShareValue2; tbl.ShareCapitalProduct = model.ProductOfShareValues; tbl.BusinessObjectives = model.BusinessObjectives; tbl.CNIC = model.CNIC; tbl.NTN = model.NTN; tbl.PINCode = model.PINCode; tbl.FBRLogin = model.FBRLogin; tbl.FBRPassword = model.FBRPassword; tbl.IncorporationNo = model.IncorporationNo; tbl.RegistrationNo = model.RegistrationNo; tbl.RegisteredWith = model.RegisteredWith; tbl.Address = model.Address; tbl.Email = model.Email; tbl.PhoneNo = model.PhoneNo; tbl.MobileNo = model.MobileNo; tbl.FaxNo = model.FaxNo; tbl.CreatedById = postedbyId; tbl.CreatedDate = Convert.ToDateTime(DateTime.Now.ToShortDateString()); tbl.IsActive = true; db.TblClients.InsertOnSubmit(tbl); db.SubmitChanges(); TblService tblServices = new TblService(); var res = (from c in db.TblClients orderby c.Id descending select c).FirstOrDefault(); tbl = res; int currentClientId = tbl.Id; tblServices.ClientId = currentClientId; tblBusinessType.BusinessType = model.BusinessType; tblBusinessType.ClientId = currentClientId; tblServices.Accounting = true ? ModelServices.Accounting == "Accounting" : false; tblServices.Audit = true ? ModelServices.Audit == "Audit" : false; tblServices.Legal = true ? ModelServices.Legal == "Legal" : false; tblServices.Taxation = true ? ModelServices.Taxation == "Taxation" : false; tblServices.Corporate = true ? ModelServices.Corporate == "Corporate" : false; db.TblBusinessTypes.InsertOnSubmit(tblBusinessType); db.TblServices.InsertOnSubmit(tblServices); db.SubmitChanges(); db.Dispose(); //UpdateAndSaveService( ModelServices, currentClientId); }
public static void UpdatedClient(ClientsModel model, ServicesModel ModelServices, int postedbyId, int ClientId) { DataContext db = new DataContext(); TblClient result = (from c in db.TblClients where c.Id == ClientId select c).Single(); result.Name = model.Name; result.TypeOfCompany = model.TypeOfCompany; result.LimitedBy = model.LimitedBy; result.BusinessObjectives = model.BusinessObjectives; result.ShareValue1 = model.ShareValue1; result.ShareValue2 = model.ShareValue2; result.ShareCapitalProduct = model.ProductOfShareValues; result.CNIC = model.CNIC; result.IncorporationNo = model.IncorporationNo; result.RegistrationNo = model.RegistrationNo; result.RegisteredWith = model.RegisteredWith; result.Address = model.Address; result.Email = model.Email; result.PhoneNo = model.PhoneNo; result.MobileNo = model.MobileNo; result.FaxNo = model.FaxNo; result.UpdatedById = postedbyId; result.UpdatedDate = Convert.ToDateTime(DateTime.Now.ToShortDateString()); db.SubmitChanges(); /****************************************************************************************/ TblService resultServices = (from s in db.TblServices where s.ClientId == ClientId select s).SingleOrDefault(); resultServices.Accounting = true ? ModelServices.Accounting == "Accounting" : false; resultServices.Audit = true ? ModelServices.Audit == "Audit" : false; resultServices.Legal = true ? ModelServices.Legal == "Legal" : false; resultServices.Taxation = true ? ModelServices.Taxation == "Taxation" : false; resultServices.Corporate = true ? ModelServices.Corporate == "Corporate" : false; /***************************************************************************************/ TblBusinessType resultBusinessType = (from b in db.TblBusinessTypes where b.ClientId == ClientId select b).SingleOrDefault(); resultBusinessType.BusinessType = model.BusinessType; db.SubmitChanges(); db.Dispose(); }