public Tuple <bool, string, long> Save()
{
try
{
long id = 0;
using (Easycase.DataModel.EasyCaseDBEntities DB = new DataModel.EasyCaseDBEntities())
{
var task = new DataModel.Task
{
Notes = this.Notes,
CreatedBy = this.CreatedBy,
CreatedOn = DateTime.Now,
Deleted = false,
DueDate = this.DueDate,
Name = this.Name,
Priority = this.Priority,
RelatedCase = this.RelatedCase,
Status = this.Status,
TimeDue = this.TimeDue,
Archived = false
};
DB.Tasks.Add(task);
DB.SaveChanges();
id = task.ID;
//Save Mentions and Assigned
if (this.Mentions.Length > 0)
{
foreach (var item in this.Mentions)
{
var mention = new DataModel.Mention
{
TaskId = id,
ClientId = item
};
DB.Mentions.Add(mention);
}
}
if (this.Assigned.Length > 0)
{
foreach (var item in this.Assigned)
{
var assign = new DataModel.Assigned
{
TaskId = id,
ClientId = item
};
DB.Assigneds.Add(assign);
}
}
//
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 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, 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));
}
}
public Tuple <bool, string, long> Save()
{
try
{
long id = 0;
using (Easycase.DataModel.EasyCaseDBEntities DB = new DataModel.EasyCaseDBEntities())
{
var businessHours = new DataModel.Holiday
{
CreatedBy = this.CreatedBy,
HolidayOfYear = this.HolidayOfYear,
Year = this.Year,
HolidayDates = this.HolidayDates
};
DB.Holidays.Add(businessHours);
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 long Save()
{
try
{
long id = 0;
using (Easycase.DataModel.EasyCaseDBEntities DB = new DataModel.EasyCaseDBEntities())
{
var image = new DataModel.Document
{
OriginalName = this.OriginalName,
CreatedOn = DateTime.Now,
CretedBy = this.CretedBy,
Deleted = false,
DocPath = this.DocPath,
FileName = this.FileName,
FolderName = this.FolderName,
LinkId = this.LinkId,
LinkTable = this.LinkTable,
Status = "In Review"
};
DB.Documents.Add(image);
DB.SaveChanges();
id = image.ID;
}
return(id);
}
catch (Exception ex)
{
Logs.SaveLog(ex.Message);
return(0);
}
}
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())
{
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 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 bool LinkCase(long caseid, string createdBy)
{
try
{
using (Easycase.DataModel.EasyCaseDBEntities DB = new DataModel.EasyCaseDBEntities())
{
var _case = DB.LinkCases.Where(d => d.CaseId == caseid && d.UserId == createdBy).FirstOrDefault();
if (_case == null)
{
var _linkcase = new DataModel.LinkCas
{
CaseId = caseid,
UserId = createdBy
};
DB.LinkCases.Add(_linkcase);
}
DB.SaveChanges();
return(true);
}
}
catch (Exception ex)
{
Logs.SaveLog(ex.Message);
return(false);
}
}
/// <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> Save()
{
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,
DocumentId = this.DocumentId,
Private = this.Private
};
DB.DocumentNotes.Add(casenote);
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> 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()
{
try
{
using (Easycase.DataModel.EasyCaseDBEntities DB = new DataModel.EasyCaseDBEntities())
{
var _case = new DataModel.Case
{
CaseTypeId = this.CaseTypeId,
ClientId = this.ClientId,
CreatedOn = DateTime.Now,
Deleted = false,
CaseNumber = this.CaseNumber,
CreatedBy = this.CreatedBy
};
DB.Cases.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));
}
}
/// <summary>
/// Save image
/// </summary>
/// <returns></returns>
public long Save()
{
try
{
long id = 0;
using (Easycase.DataModel.EasyCaseDBEntities DB = new DataModel.EasyCaseDBEntities())
{
var image = new DataModel.Image
{
ImageName = this.ImageName,
OriginalName = this.OriginalName,
ImagePath = this.ImagePath,
CreatedOn = DateTime.Now,
};
DB.Images.Add(image);
DB.SaveChanges();
id = image.ID;
}
return(id);
}
catch (Exception ex)
{
Logs.SaveLog(ex.Message);
return(0);
}
}
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 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> Save()
{
try
{
long id = 0;
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
};
DB.Supports.Add(client);
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, 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> 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 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 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 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 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 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 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 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);
}
}
