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