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();
}
