public bool UpdateDeleteStatus(long id, string action) { try { using (Easycase.DataModel.EasyCaseDBEntities DB = new DataModel.EasyCaseDBEntities()) { var client = DB.Tasks.Where(d => d.ID == id).FirstOrDefault(); if (action == "D") { client.Deleted = true; } else { client.Archived = true; } DB.Entry(client).State = System.Data.Entity.EntityState.Modified; DB.SaveChanges(); return(true); } } catch (Exception ex) { Logs.SaveLog(ex.Message); return(false); } }
public Tuple <bool, string, long> Update() { try { long id = 0; using (Easycase.DataModel.EasyCaseDBEntities DB = new DataModel.EasyCaseDBEntities()) { var businessHours = new DataModel.BusinessHour { ConsultingDuration = this.ConsultingDuration, LeadDays = this.LeadDays, WaitTime = this.WaitTime, CreatedBy = this.CreatedBy, ID = this.ID }; DB.Entry(businessHours).State = System.Data.Entity.EntityState.Modified; DB.SaveChanges(); id = businessHours.ID; } return(new Tuple <bool, string, long>(true, Messages.SUCCESS, id)); } catch (Exception ex) { Logs.SaveLog(ex.Message); return(new Tuple <bool, string, long>(false, ex.Message, 0)); } }
public bool UpdateAssignee(long[] assignedIds, long taskId) { try { using (Easycase.DataModel.EasyCaseDBEntities DB = new DataModel.EasyCaseDBEntities()) { var assignees = DB.Assigneds.Where(t => t.TaskId == taskId).ToList(); // Remove assignee foreach (var item in assignees) { DB.Entry(item).State = System.Data.Entity.EntityState.Deleted; } DB.SaveChanges(); //Save Assigned foreach (var item in assignedIds) { var assign = new DataModel.Assigned { TaskId = taskId, ClientId = item }; DB.Assigneds.Add(assign); } // DB.SaveChanges(); } return(true); } catch (Exception ex) { Logs.SaveLog(ex.Message); return(false); } }
public Tuple <bool, string> Update() { try { using (Easycase.DataModel.EasyCaseDBEntities DB = new DataModel.EasyCaseDBEntities()) { var client = new DataModel.Support { UpdatedOn = DateTime.Now, CreatedBy = this.CreatedBy, Email = this.Email, Greeting = this.Greeting, FacebookUrl = this.FacebookUrl, ImageId = this.ImageId, Linkdin = this.Linkdin, PhoneNo = this.PhoneNo, WebsiteUrl = this.WebsiteUrl, ID = this.ID }; DB.Entry(client).State = System.Data.Entity.EntityState.Modified; DB.SaveChanges(); } return(new Tuple <bool, string>(true, Messages.SUCCESS)); } catch (Exception ex) { Logs.SaveLog(ex.Message); return(new Tuple <bool, string>(false, ex.Message)); } }
public Tuple <bool, string> Update() { try { using (Easycase.DataModel.EasyCaseDBEntities DB = new DataModel.EasyCaseDBEntities()) { var _case = DB.Cases.Where(d => d.ID == this.CaseID).FirstOrDefault(); if (_case != null) { _case.CaseTypeId = this.CaseTypeId; _case.ClientId = this.ClientId; _case.CreatedOn = DateTime.Now; _case.CreatedBy = this.CreatedBy; DB.Entry(_case).State = System.Data.Entity.EntityState.Modified; DB.SaveChanges(); } } return(new Tuple <bool, string>(true, Messages.SUCCESS)); } catch (Exception ex) { Logs.SaveLog(ex.Message); return(new Tuple <bool, string>(false, ex.Message)); } }
public Tuple <bool, string> Save(string name, string createdBy, long id) { try { using (Easycase.DataModel.EasyCaseDBEntities DB = new DataModel.EasyCaseDBEntities()) { var _case = new DataModel.CaseType { Name = name, CreatedOn = DateTime.Now, CreatedBy = createdBy }; if (id > 0) { _case.ID = id; DB.Entry(_case).State = System.Data.Entity.EntityState.Modified; } else { DB.CaseTypes.Add(_case); } DB.SaveChanges(); } return(new Tuple <bool, string>(true, Messages.SUCCESS)); } catch (Exception ex) { Logs.SaveLog(ex.Message); return(new Tuple <bool, string>(false, ex.Message)); } }
public Tuple <bool, string, long> Update() { try { long id = 0; using (Easycase.DataModel.EasyCaseDBEntities DB = new DataModel.EasyCaseDBEntities()) { var casenote = new DataModel.DocumentNote { Notes = this.Notes, CreatedBy = this.CreatedBy, CreatedOn = DateTime.Now, Subject = this.Subject, ID = this.ID, DocumentId = this.DocumentId, Private = this.Private }; DB.Entry(casenote).State = System.Data.Entity.EntityState.Modified; DB.SaveChanges(); id = casenote.ID; } return(new Tuple <bool, string, long>(true, Messages.SUCCESS, id)); } catch (Exception ex) { Logs.SaveLog(ex.Message); return(new Tuple <bool, string, long>(false, ex.Message, 0)); } }
public Tuple <bool, string, long> Update() { try { long id = 0; using (Easycase.DataModel.EasyCaseDBEntities DB = new DataModel.EasyCaseDBEntities()) { var holiday = new DataModel.Holiday { CreatedBy = this.CreatedBy, HolidayOfYear = this.HolidayOfYear, Year = this.Year, ID = this.ID, HolidayDates = this.HolidayDates }; DB.Entry(holiday).State = System.Data.Entity.EntityState.Modified; DB.SaveChanges(); id = holiday.ID; } return(new Tuple <bool, string, long>(true, Messages.SUCCESS, id)); } catch (Exception ex) { Logs.SaveLog(ex.Message); return(new Tuple <bool, string, long>(false, ex.Message, 0)); } }
/// <summary> /// Update Client /// </summary> /// <returns></returns> public Tuple <bool, string> Update() { try { using (Easycase.DataModel.EasyCaseDBEntities DB = new DataModel.EasyCaseDBEntities()) { var client = new DataModel.Client { FirstName = this.FirstName, Citizenship = this.Citizenship, Country = this.Country, DOB = this.DOB, Email = this.Email, ImageId = this.ImageId, LastName = this.LastName, MartialStatusId = this.MartialStatusId, Notes = this.Notes, PhoneNo = this.PhoneNo, Prefix = this.Prefix, PurposeId = this.PurposeId, ID = this.ID, Deleted = false, CreatedBy = this.CreatedBy }; DB.Entry(client).State = System.Data.Entity.EntityState.Modified; DB.SaveChanges(); } return(new Tuple <bool, string>(true, Messages.SUCCESS)); } catch (Exception ex) { Logs.SaveLog(ex.Message); return(new Tuple <bool, string>(false, ex.Message)); } }
public Tuple <bool, string, long> Update() { try { long id = 0; using (Easycase.DataModel.EasyCaseDBEntities DB = new DataModel.EasyCaseDBEntities()) { var tasknote = new DataModel.TaskNote { Notes = this.Notes, CreatedOn = DateTime.Now, Date = this.Date, Subject = this.Subject, TaskId = this.TaskId, ID = this.ID, NotifyUser = this.NotifyUser, CaseId = this.CaseId }; DB.Entry(tasknote).State = System.Data.Entity.EntityState.Modified; DB.SaveChanges(); id = tasknote.ID; } return(new Tuple <bool, string, long>(true, Messages.SUCCESS, id)); } catch (Exception ex) { Logs.SaveLog(ex.Message); return(new Tuple <bool, string, long>(false, ex.Message, 0)); } }
public Tuple <bool, string, long> Update() { try { long id = 0; using (Easycase.DataModel.EasyCaseDBEntities DB = new DataModel.EasyCaseDBEntities()) { // Savecorporate detail var client = new DataModel.CorporateJobDetail { CreatedOn = DateTime.Now, ApprovedDate = this.ApprovedDate, Expiry = this.Expiry, LMIANo = this.LMIANo, PositionAvailable = this.PositionAvailable, PositionDescription = this.PositionDescription, ProfileId = this.ProfileId, Status = this.Status, ID = this.ID }; DB.Entry(client).State = System.Data.Entity.EntityState.Modified; id = client.ID; // // save position for (int i = 0; i < this.PositionArray.Length; i++) { var corporateposition = new DataModel.CorporatePosition { CreatedOn = DateTime.Now, CorporateJobDetailId = id, FirstName = this.FirstNameArray[i], LastName = this.LastNameArray[i], Position = this.PositionArray[i] }; DB.CorporatePositions.Add(corporateposition); } // DB.SaveChanges(); } return(new Tuple <bool, string, long>(true, Messages.SUCCESS, id)); } catch (Exception ex) { Logs.SaveLog(ex.Message); return(new Tuple <bool, string, long>(false, ex.Message, 0)); } }
public Tuple <bool, string> Update(string userId) { try { using (Easycase.DataModel.EasyCaseDBEntities DB = new DataModel.EasyCaseDBEntities()) { var manageHours = DB.ManageHours.Where(d => d.CreatedBy == userId).ToList(); if (manageHours.Count == 0) { for (int i = 0; i < this.ID.Count(); i++) { var managerHour = new ManageHour(); managerHour.IsActive = this.IsActive[i]; managerHour.StartTime = this.StartTime[i]; managerHour.EndTime = this.EndTime[i]; managerHour.LunchStartTime = this.LunchStartTime[i]; managerHour.LunchEndTime = this.LunchEndTime[i]; managerHour.CreatedBy = userId; DB.ManageHours.Add(managerHour); } } else { for (int i = 0; i < manageHours.Count; i++) { manageHours[i].ID = this.ID[i]; manageHours[i].IsActive = this.IsActive[i]; manageHours[i].StartTime = this.StartTime[i]; manageHours[i].EndTime = this.EndTime[i]; manageHours[i].LunchStartTime = this.LunchStartTime[i]; manageHours[i].LunchEndTime = this.LunchEndTime[i]; manageHours[i].CreatedBy = userId; DB.Entry(manageHours[i]).State = System.Data.Entity.EntityState.Modified; } } DB.SaveChanges(); } return(new Tuple <bool, string>(true, Messages.SUCCESS)); } catch (Exception ex) { Logs.SaveLog(ex.Message); return(new Tuple <bool, string>(false, ex.Message)); } }
public Tuple <bool, string> Save() { try { using (Easycase.DataModel.EasyCaseDBEntities DB = new DataModel.EasyCaseDBEntities()) { for (int i = 0; i < this.ServiceName.Count(); i++) { var servicefee = new DataModel.ServiceFee { CreatedOn = DateTime.Now, CreatedBy = this.CreatedBy, ServiceName = this.ServiceName[i], IsExpense = this.IsExpense[i], Fee = this.Fee[i], Description = this.Description[i], Deleted = false, AdditionalInfo = this.AdditionalInfo[i], ID = this.ID[i], }; if (servicefee.ID == 0) { if (!string.IsNullOrEmpty(servicefee.ServiceName) && servicefee.Fee > 0) { DB.ServiceFees.Add(servicefee); } } else { if (!string.IsNullOrEmpty(servicefee.ServiceName) && servicefee.Fee > 0) { DB.Entry(servicefee).State = System.Data.Entity.EntityState.Modified; } } } DB.SaveChanges(); } return(new Tuple <bool, string>(true, Messages.SUCCESS)); } catch (Exception ex) { Logs.SaveLog(ex.Message); return(new Tuple <bool, string>(false, ex.Message)); } }
public bool Delete(long id) { try { using (Easycase.DataModel.EasyCaseDBEntities DB = new DataModel.EasyCaseDBEntities()) { var client = DB.TaskNotes.Where(d => d.ID == id).FirstOrDefault(); DB.Entry(client).State = System.Data.Entity.EntityState.Deleted; DB.SaveChanges(); return(true); } } catch (Exception ex) { Logs.SaveLog(ex.Message); return(false); } }
public bool UpdateDeleteStatus(long id) { try { using (Easycase.DataModel.EasyCaseDBEntities DB = new DataModel.EasyCaseDBEntities()) { var client = DB.CorporateProfileInformations.Where(d => d.ID == id).FirstOrDefault(); client.Deleted = true; DB.Entry(client).State = System.Data.Entity.EntityState.Modified; DB.SaveChanges(); return(true); } } catch (Exception ex) { Logs.SaveLog(ex.Message); return(false); } }
public bool UpdateCaseNumber(long id, string caseNumber) { try { using (Easycase.DataModel.EasyCaseDBEntities DB = new DataModel.EasyCaseDBEntities()) { var _case = DB.Cases.Where(d => d.ID == id).FirstOrDefault(); _case.CaseNumber = caseNumber; DB.Entry(_case).State = System.Data.Entity.EntityState.Modified; DB.SaveChanges(); return(true); } } catch (Exception ex) { Logs.SaveLog(ex.Message); return(false); } }
public bool UpdateDeleteStatus(long docId) { try { using (Easycase.DataModel.EasyCaseDBEntities DB = new DataModel.EasyCaseDBEntities()) { var task = DB.Documents.Where(t => t.ID == docId).FirstOrDefault(); task.Deleted = true; DB.Entry(task).State = System.Data.Entity.EntityState.Modified; DB.SaveChanges(); } return(true); } catch (Exception ex) { Logs.SaveLog(ex.Message); return(false); } }
public Tuple <bool, string> Save() { try { using (Easycase.DataModel.EasyCaseDBEntities DB = new DataModel.EasyCaseDBEntities()) { var _case = DB.EducationDetails.Where(d => d.ID == this.ID).FirstOrDefault(); if (_case != null) { _case.CICEnglishExam = this.CICEnglishExam; _case.CICEnglishExamSpouse = this.CICEnglishExamSpouse; _case.ECACompleted = this.ECACompleted; _case.UpdatedOn = DateTime.Now; _case.EducationHistory = this.EducationHistory; _case.SpouseEducation = this.SpouseEducation; DB.Entry(_case).State = System.Data.Entity.EntityState.Modified; } else { var _educationDetail = new DataModel.EducationDetail { CaseId = this.CaseId, CICEnglishExam = this.CICEnglishExam, CICEnglishExamSpouse = this.CICEnglishExamSpouse, ECACompleted = this.ECACompleted, UpdatedOn = DateTime.Now, EducationHistory = this.EducationHistory, SpouseEducation = this.SpouseEducation, }; DB.EducationDetails.Add(_educationDetail); } DB.SaveChanges(); } return(new Tuple <bool, string>(true, Messages.SUCCESS)); } catch (Exception ex) { Logs.SaveLog(ex.Message); return(new Tuple <bool, string>(false, ex.Message)); } }
public bool UpdateStatus(string status, long contactId) { try { using (Easycase.DataModel.EasyCaseDBEntities DB = new DataModel.EasyCaseDBEntities()) { //Update Priority var task = DB.Contacts.Where(t => t.ID == contactId).FirstOrDefault(); task.Status = status; DB.Entry(task).State = System.Data.Entity.EntityState.Modified; // DB.SaveChanges(); } return(true); } catch (Exception ex) { Logs.SaveLog(ex.Message); return(false); } }
public bool UpdateTaskName(string name, long taskId) { try { using (Easycase.DataModel.EasyCaseDBEntities DB = new DataModel.EasyCaseDBEntities()) { //Update Priority var task = DB.Tasks.Where(t => t.ID == taskId).FirstOrDefault(); task.Name = name; DB.Entry(task).State = System.Data.Entity.EntityState.Modified; // DB.SaveChanges(); } return(true); } catch (Exception ex) { Logs.SaveLog(ex.Message); return(false); } }
public bool DeleteLinkCase(long caseid) { try { using (Easycase.DataModel.EasyCaseDBEntities DB = new DataModel.EasyCaseDBEntities()) { var _case = DB.LinkCases.Where(d => d.ID == caseid).FirstOrDefault(); if (_case != null) { DB.Entry(_case).State = System.Data.Entity.EntityState.Deleted; } DB.SaveChanges(); return(true); } } catch (Exception ex) { Logs.SaveLog(ex.Message); return(false); } }
public bool Delete(long id) { try { using (Easycase.DataModel.EasyCaseDBEntities DB = new DataModel.EasyCaseDBEntities()) { var client = DB.CorporatePositions.Where(d => d.CorporateJobDetailId == id).ToList(); foreach (var item in client) { DB.Entry(item).State = System.Data.Entity.EntityState.Deleted; } DB.SaveChanges(); return(true); } } catch (Exception ex) { Logs.SaveLog(ex.Message); return(false); } }
public bool UpdateFileName(string fileName, long docId) { try { using (Easycase.DataModel.EasyCaseDBEntities DB = new DataModel.EasyCaseDBEntities()) { //Update FileName var task = DB.Documents.Where(t => t.ID == docId).FirstOrDefault(); task.OriginalName = fileName; DB.Entry(task).State = System.Data.Entity.EntityState.Modified; // DB.SaveChanges(); } return(true); } catch (Exception ex) { Logs.SaveLog(ex.Message); return(false); } }
public Tuple <bool, string, long> Update() { try { long id = 0; using (Easycase.DataModel.EasyCaseDBEntities DB = new DataModel.EasyCaseDBEntities()) { var profileInfo = DB.ProfileInformations.Where(d => d.ID == this.ProfileInformationID).FirstOrDefault(); profileInfo.Address = this.Address; profileInfo.ProfileId = this.CaseID; profileInfo.FurtherInformation = this.FurtherInformation; profileInfo.HaveVisitorOrStudentVisa = this.HaveVisitorOrStudentVisa; profileInfo.HaveYourSpouseVisitorOrStudentVisa = this.HaveYourSpouseVisitorOrStudentVisa; profileInfo.HaveYouAcceptedSchoolCollege = this.HaveYouAcceptedSchoolCollege; profileInfo.HearFromAboutus = this.HearFromAboutus; profileInfo.LikeToDoInCanada = this.LikeToDoInCanada; profileInfo.PreferedDestination = this.PreferedDestination; profileInfo.RelationToPrimaryApplicant = this.RelationToPrimaryApplicant; profileInfo.SpuseAnyIllegalCase = this.SpuseAnyIllegalCase; profileInfo.SpuseAppliedAnyVisa = this.SpuseAppliedAnyVisa; profileInfo.SpuseAppliedPermanentResidence = this.SpuseAppliedPermanentResidence; profileInfo.SpuseRefusedAnyApplication = this.SpuseRefusedAnyApplication; profileInfo.UpdatedOn = DateTime.Now; profileInfo.VisitPrevious = this.VisitPrevious; profileInfo.PrimaryLanguage = this.PrimaryLanguage; DB.Entry(profileInfo).State = System.Data.Entity.EntityState.Modified; DB.SaveChanges(); id = profileInfo.ID; } return(new Tuple <bool, string, long>(true, Messages.SUCCESS, id)); } catch (Exception ex) { Logs.SaveLog(ex.Message); return(new Tuple <bool, string, long>(false, ex.Message, 0)); } }
public Tuple <bool, string, long> Update() { try { long id = 0; using (Easycase.DataModel.EasyCaseDBEntities DB = new DataModel.EasyCaseDBEntities()) { var client = new DataModel.CorporateProfileInformation { Email = this.Email, Notes = this.Notes, Deleted = false, CreatedBy = this.CreatedBy, Address1 = this.Address1, Address2 = this.Address2, Address3 = this.Address3, BussinessName = this.BussinessName, CRA = this.CRA, CreatedOn = DateTime.Now, Fax = this.Fax, KeyContactPerson = this.KeyContactPerson, KeyContactPosition = this.KeyContactPosition, Phone = this.Phone, Website = this.Website, ID = this.ID }; DB.Entry(client).State = System.Data.Entity.EntityState.Modified; DB.SaveChanges(); id = client.ID; } return(new Tuple <bool, string, long>(true, Messages.SUCCESS, id)); } catch (Exception ex) { Logs.SaveLog(ex.Message); return(new Tuple <bool, string, long>(false, ex.Message, 0)); } }
public Tuple <bool, string> Save() { try { using (Easycase.DataModel.EasyCaseDBEntities DB = new DataModel.EasyCaseDBEntities()) { var _case = DB.TaxInformations.Where(d => d.ID == this.ID).FirstOrDefault(); if (_case != null) { _case.IsTaxable = this.IsTaxable; _case.UserId = this.UserId; _case.TaxPercent = this.TaxPercent; _case.TaxType = this.TaxType; _case.UpdatedOn = DateTime.Now; DB.Entry(_case).State = System.Data.Entity.EntityState.Modified; } else { var _clientAccount = new DataModel.TaxInformation { IsTaxable = this.IsTaxable, UpdatedOn = DateTime.Now, TaxType = this.TaxType, TaxPercent = this.TaxPercent, UserId = this.UserId }; DB.TaxInformations.Add(_clientAccount); } DB.SaveChanges(); } return(new Tuple <bool, string>(true, Messages.SUCCESS)); } catch (Exception ex) { Logs.SaveLog(ex.Message); return(new Tuple <bool, string>(false, ex.Message)); } }
public Tuple <bool, string> Update() { try { using (Easycase.DataModel.EasyCaseDBEntities DB = new DataModel.EasyCaseDBEntities()) { var client = new DataModel.CompanyDetail { FirstName = this.FirstName, Country = this.Country, LastName = this.LastName, CreatedBy = this.CreatedBy, AddressLine1 = this.AddressLine1, AddressLine2 = this.AddressLine2, City = this.City, CompanyEmail = this.CompanyEmail, CompanyName = this.CompanyName, Fax = this.Fax, MembershipNumber = this.MembershipNumber, MembershipType = this.MembershipType, PostalCode = this.PostalCode, Province = this.Province, Telephone = this.Telephone, UpdatedOn = DateTime.Now, ID = this.ID }; DB.Entry(client).State = System.Data.Entity.EntityState.Modified; DB.SaveChanges(); } return(new Tuple <bool, string>(true, Messages.SUCCESS)); } catch (Exception ex) { Logs.SaveLog(ex.Message); return(new Tuple <bool, string>(false, ex.Message)); } }
public Tuple <bool, string> Save() { try { using (Easycase.DataModel.EasyCaseDBEntities DB = new DataModel.EasyCaseDBEntities()) { var _case = DB.ClientAccounts.Where(d => d.ID == this.ID).FirstOrDefault(); if (_case != null) { _case.BankName = this.BankName; _case.CreatedBy = this.CreatedBy; _case.Currency = this.Currency; _case.CreatedOn = DateTime.Now; DB.Entry(_case).State = System.Data.Entity.EntityState.Modified; } else { var _clientAccount = new DataModel.ClientAccount { BankName = this.BankName, Currency = this.Currency, CreatedOn = DateTime.Now, CreatedBy = this.CreatedBy, }; DB.ClientAccounts.Add(_clientAccount); } DB.SaveChanges(); } return(new Tuple <bool, string>(true, Messages.SUCCESS)); } catch (Exception ex) { Logs.SaveLog(ex.Message); return(new Tuple <bool, string>(false, ex.Message)); } }
public Tuple <bool, string> Update() { try { using (Easycase.DataModel.EasyCaseDBEntities DB = new DataModel.EasyCaseDBEntities()) { var contact = new DataModel.Contact { FirstName = this.FirstName, Email = this.Email, LastName = this.LastName, Notes = this.Notes, Prefix = this.Prefix, CreatedBy = this.CreatedBy, ContactTypeId = this.ContactTypeId, CreatedOn = DateTime.Now, Deleted = false, FaxNo = this.FaxNo, Status = this.Status, MailingAddress = this.MailingAddress, MobileNo = this.MobileNo, WorkNo = this.WorkNo, OtherNo = this.OtherNo, ID = this.ID, }; DB.Entry(contact).State = System.Data.Entity.EntityState.Modified; DB.SaveChanges(); } return(new Tuple <bool, string>(true, Messages.SUCCESS)); } catch (Exception ex) { Logs.SaveLog(ex.Message); return(new Tuple <bool, string>(false, ex.Message)); } }
public Tuple <bool, string> Save() { try { using (Easycase.DataModel.EasyCaseDBEntities DB = new DataModel.EasyCaseDBEntities()) { var _case = DB.OtherDetails.Where(d => d.ID == this.OtherID).FirstOrDefault(); if (_case != null) { _case.AppliedPNPFromEmployerPast = Convert.ToBoolean(this.AppliedPNPFromEmployerPast); _case.BCCurrentEmployer = Convert.ToBoolean(this.BCCurrentEmployer); _case.BCDistrict = this.BCDistrict; _case.UpdatedOn = DateTime.Now; _case.BCJobNOC = this.BCJobNOC; _case.Children = Convert.ToBoolean(this.Children); _case.ChildrenAges = this.ChildrenAges; _case.ChildrenCount = this.ChildrenCount; _case.CLBLevel = this.CLBLevel; _case.EmployementHistory = this.EmployementHistory; _case.FamilyLivingCanada = Convert.ToBoolean(this.FamilyLivingCanada); _case.FullTimeEmployees = this.FullTimeEmployees; _case.HourlyWage = this.HourlyWage; _case.IsBCEmployerOffer = Convert.ToBoolean(this.isBCEmployerOffer); _case.IsECAObtained = Convert.ToBoolean(this.IsECAObtained); _case.IsEmployerWillingToSupportPNP = Convert.ToBoolean(this.IsEmployerWillingToSupportPNP); _case.IsPostSecondaryCredentialBC = Convert.ToBoolean(this.IsPostSecondaryCredentialBC); _case.IsTradesCertificationTrainingAuthority = Convert.ToBoolean(this.IsTradesCertificationTrainingAuthority); _case.JobOffer = Convert.ToBoolean(this.JobOffer); _case.Networth = this.Networth; _case.PaymentCycle = this.PaymentCycle; _case.PositionsApplied = this.PositionsApplied; _case.ProvinceNominee = Convert.ToBoolean(this.ProvinceNominee); _case.SkilledWorker = Convert.ToBoolean(this.SkilledWorker); _case.SpouseEmployementHistory = this.SpouseEmployementHistory; _case.TemporaryWorker = Convert.ToBoolean(this.TemporaryWorker); _case.TradeCertificate = Convert.ToBoolean(this.TradeCertificate); _case.Wage = this.Wage; _case.YearsBCRelatedJobExperience = this.YearsBCRelatedJobExperience; DB.Entry(_case).State = System.Data.Entity.EntityState.Modified; } else { var _educationDetail = new DataModel.OtherDetail { CaseId = this.CaseId, YearsBCRelatedJobExperience = this.YearsBCRelatedJobExperience, Wage = this.Wage, TradeCertificate = Convert.ToBoolean(this.TradeCertificate), TemporaryWorker = Convert.ToBoolean(this.TemporaryWorker), SpouseEmployementHistory = this.SpouseEmployementHistory, SkilledWorker = Convert.ToBoolean(this.SkilledWorker), AppliedPNPFromEmployerPast = Convert.ToBoolean(this.AppliedPNPFromEmployerPast), BCCurrentEmployer = Convert.ToBoolean(this.BCCurrentEmployer), BCDistrict = this.BCDistrict, BCJobNOC = this.BCJobNOC, Children = Convert.ToBoolean(this.Children), ChildrenAges = this.ChildrenAges, ChildrenCount = this.ChildrenCount, CLBLevel = this.CLBLevel, EmployementHistory = this.EmployementHistory, FamilyLivingCanada = Convert.ToBoolean(this.FamilyLivingCanada), FullTimeEmployees = this.FullTimeEmployees, HourlyWage = this.HourlyWage, IsBCEmployerOffer = Convert.ToBoolean(this.isBCEmployerOffer), IsECAObtained = Convert.ToBoolean(this.IsECAObtained), IsEmployerWillingToSupportPNP = Convert.ToBoolean(this.IsEmployerWillingToSupportPNP), IsPostSecondaryCredentialBC = Convert.ToBoolean(this.IsPostSecondaryCredentialBC), IsTradesCertificationTrainingAuthority = Convert.ToBoolean(this.IsTradesCertificationTrainingAuthority), JobOffer = Convert.ToBoolean(this.JobOffer), Networth = this.Networth, PaymentCycle = this.PaymentCycle, PositionsApplied = this.PositionsApplied, ProvinceNominee = Convert.ToBoolean(this.ProvinceNominee), UpdatedOn = DateTime.Now, }; DB.OtherDetails.Add(_educationDetail); } DB.SaveChanges(); } return(new Tuple <bool, string>(true, Messages.SUCCESS)); } catch (Exception ex) { Logs.SaveLog(ex.Message); return(new Tuple <bool, string>(false, ex.Message)); } }