public BLCorporateJobDetail GetById(long id) { try { using (Easycase.DataModel.EasyCaseDBEntities DB = new DataModel.EasyCaseDBEntities()) { var client = DB.CorporateJobDetails.Where(d => d.ProfileId == id).Select(s => new BLCorporateJobDetail { ID = s.ID, ApprovedDate = s.ApprovedDate, Expiry = s.Expiry, LMIANo = s.LMIANo, PositionAvailable = s.PositionAvailable, PositionDescription = s.PositionDescription, Status = s.Status, ProfileId = s.ProfileId, CorporatePositions = s.CorporatePositions.Select(p => new BLCorporatePosition { FirstName = p.FirstName, LastName = p.LastName, Position = p.Position, ID = p.ID, CorporateJobDetailId = p.CorporateJobDetailId }).ToList() }).FirstOrDefault(); return(client); } } catch (Exception ex) { Logs.SaveLog(ex.Message); return(new BLCorporateJobDetail()); } }
public List <BLCaseviewModal> GetAllCases() { try { using (Easycase.DataModel.EasyCaseDBEntities DB = new DataModel.EasyCaseDBEntities()) { var client = DB.Cases.Where(d => d.Deleted == false).Select(c => new BLCaseviewModal { DOB = c.Client.DOB, Email = c.Client.Email, FamilyName = c.Client.LastName, Name = c.Client.FirstName, ClientId = c.ID, CaseTypeName = c.CaseType.Name, CaseID = c.ID }).ToList(); return(client); } } catch (Exception ex) { Logs.SaveLog(ex.Message); return(new List <BLCaseviewModal>()); } }
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)); } }
/// <summary> /// Get Case by id /// </summary> /// <param name="id"></param> /// <returns></returns> public BLCases GetCaseById(long id) { try { using (Easycase.DataModel.EasyCaseDBEntities DB = new DataModel.EasyCaseDBEntities()) { var client = DB.Cases.Where(d => d.ID == id && d.Deleted == false).Select(c => new BLCases { DOB = c.Client.DOB, Email = c.Client.Email, FamilyName = c.Client.LastName, Name = c.Client.FirstName, ClientId = c.ClientId, CaseID = c.ID, CaseTypeId = c.CaseTypeId }).FirstOrDefault(); return(client); } } catch (Exception ex) { Logs.SaveLog(ex.Message); return(new BLCases()); } }
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)); } }
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, 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 BLEducationDetails GetByCaseId(long id) { try { using (Easycase.DataModel.EasyCaseDBEntities DB = new DataModel.EasyCaseDBEntities()) { var client = DB.EducationDetails.Where(d => d.CaseId == id).Select(c => new BLEducationDetails { ID = c.ID, CaseId = c.CaseId, CICEnglishExam = c.CICEnglishExam, CICEnglishExamSpouse = c.CICEnglishExamSpouse, ECACompleted = c.ECACompleted, EducationHistory = c.EducationHistory, SpouseEducation = c.SpouseEducation, }).FirstOrDefault(); return(client); } } catch (Exception ex) { Logs.SaveLog(ex.Message); return(new BLEducationDetails()); } }
public List <BLCasesNote> GetByCaseId(long id) { try { using (Easycase.DataModel.EasyCaseDBEntities DB = new DataModel.EasyCaseDBEntities()) { var casenote = DB.CasesNotes.Where(d => d.CaseId == id).Select(c => new BLCasesNote { ID = c.ID, Notes = c.Notes, CaseId = c.CaseId, Subject = c.Subject, Date = c.Date, CreatedOn = c.CreatedOn, CreatedBy = c.CreatedBy, }).ToList(); return(casenote); } } catch (Exception ex) { Logs.SaveLog(ex.Message); return(new List <BLCasesNote>()); } }
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)); } }
/// <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 List <BLTaskViewModal> GetAll() { try { using (Easycase.DataModel.EasyCaseDBEntities DB = new DataModel.EasyCaseDBEntities()) { var task = DB.Tasks.Where(s => s.Deleted == false && s.Archived == false).Select(c => new BLTaskViewModal { Notes = c.Notes, Name = c.Name, ID = c.ID, CreatedOn = c.CreatedOn, Deleted = c.Deleted, DueDate = c.DueDate, Priority = c.Priority, RelatedCase = c.RelatedCase, Status = c.Status, TimeDue = c.TimeDue, Assigned = DB.Assigneds.Where(t => t.TaskId == c.ID).Select(s => new BLAssigned { TaskId = s.TaskId, ClientId = s.ClientId, ClientName = s.Client.FirstName + " " + s.Client.LastName, TaskName = s.Task.Name }).ToList() }).ToList(); return(task); } } catch (Exception ex) { Logs.SaveLog(ex.Message); return(new List <BLTaskViewModal>()); } }
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 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 BLSupport GetById(string id) { try { string defaultprofilepath = ConfigurationManager.AppSettings["DefaultProfile"]; using (Easycase.DataModel.EasyCaseDBEntities DB = new DataModel.EasyCaseDBEntities()) { var client = DB.Supports.Where(d => d.CreatedBy == id).Select(c => new BLSupport { UpdatedOn = DateTime.Now, CreatedBy = c.CreatedBy, Email = c.Email, Greeting = c.Greeting, FacebookUrl = c.FacebookUrl, ImageId = c.ImageId, Linkdin = c.Linkdin, PhoneNo = c.PhoneNo, WebsiteUrl = c.WebsiteUrl, ID = c.ID, ImagePath = c.Image != null ? c.Image.ImagePath : defaultprofilepath, }).FirstOrDefault(); return(client); } } catch (Exception ex) { Logs.SaveLog(ex.Message); return(new BLSupport()); } }
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> 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 BLDocument GetById(long id) { try { using (Easycase.DataModel.EasyCaseDBEntities DB = new DataModel.EasyCaseDBEntities()) { var client = DB.Documents.Where(d => d.ID == id).Select(c => new BLDocument { ID = c.ID, OriginalName = c.OriginalName, LinkId = c.LinkId, LinkTable = c.LinkTable, FolderName = c.FolderName, FileName = c.FileName, DocPath = c.DocPath, CreatedOn = c.CreatedOn, CretedBy = c.CretedBy, Deleted = c.Deleted, Status = c.Status }).FirstOrDefault(); return(client); } } catch (Exception ex) { Logs.SaveLog(ex.Message); return(new BLDocument()); } }
public BLDocumentNote GetById(long id) { try { using (Easycase.DataModel.EasyCaseDBEntities DB = new DataModel.EasyCaseDBEntities()) { var casenote = DB.DocumentNotes.Where(d => d.ID == id).Select(c => new BLDocumentNote { ID = c.ID, Notes = c.Notes, Subject = c.Subject, CreatedOn = c.CreatedOn, CreatedBy = c.CreatedBy, DocumentId = c.DocumentId, Private = c.Private }).First(); return(casenote); } } catch (Exception ex) { Logs.SaveLog(ex.Message); return(new BLDocumentNote()); } }
/// <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 List <BLServiceFee> GetAll() { try { using (Easycase.DataModel.EasyCaseDBEntities DB = new DataModel.EasyCaseDBEntities()) { var client = DB.ServiceFees.Where(d => d.Deleted == false).Select(c => new BLServiceFee { ID = c.ID, CreatedOn = c.CreatedOn, AdditionalInfo = c.AdditionalInfo, CreatedBy = c.CreatedBy, Deleted = c.Deleted, Description = c.Description, Fee = c.Fee, IsExpense = c.IsExpense, ServiceName = c.ServiceName }).OrderByDescending(d => d.CreatedOn).ToList(); return(client); } } catch (Exception ex) { Logs.SaveLog(ex.Message); return(new List <BLServiceFee>()); } }
/// <summary> /// Get all from database /// </summary> /// <returns></returns> public List <BLClientViewModal> GetAll() { try { string defaultprofilepath = ConfigurationManager.AppSettings["DefaultProfile"]; using (Easycase.DataModel.EasyCaseDBEntities DB = new DataModel.EasyCaseDBEntities()) { var client = DB.Clients.Where(s => s.Deleted == false).Select(c => new BLClientViewModal { FirstName = c.FirstName, Citizenship = c.Citizenship, Country = c.Country, DOB = c.DOB == null?DateTime.Now: c.DOB, Email = c.Email, ImageId = c.ImageId, LastName = c.LastName, MartialStatus = c.MartialStatu.Name, Notes = c.Notes, PhoneNo = c.PhoneNo, Prefix = c.Prefix, Purpose = c.PurposeId, ID = c.ID, Name = c.FirstName + " " + c.LastName, ImagePath = c.Image != null ? c.Image.ImagePath : defaultprofilepath }).ToList(); return(client); } } catch (Exception ex) { Logs.SaveLog(ex.Message); return(new List <BLClientViewModal>()); } }
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> /// Get by id /// </summary> /// <param name="id"></param> /// <returns></returns> public BLClientModel GetById(long id) { try { string defaultprofilepath = ConfigurationManager.AppSettings["DefaultProfile"]; using (Easycase.DataModel.EasyCaseDBEntities DB = new DataModel.EasyCaseDBEntities()) { var client = DB.Clients.Where(d => d.ID == id).Select(c => new BLClientModel { FirstName = c.FirstName, Citizenship = c.Citizenship, Country = c.Country, DOB = c.DOB.Value, Email = c.Email, ImageId = c.ImageId, LastName = c.LastName, MartialStatusId = c.MartialStatu.ID, Notes = c.Notes, PhoneNo = c.PhoneNo, Prefix = c.Prefix, PurposeId = c.PurposeId, ID = c.ID, ImagePath = c.Image != null ? c.Image.ImagePath : defaultprofilepath, }).FirstOrDefault(); return(client); } } catch (Exception ex) { Logs.SaveLog(ex.Message); return(new BLClientModel()); } }
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, 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> 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)); } }
/// <summary> /// get all corporate profile /// </summary> /// <returns></returns> public List <BLCorporateViewProfile> GetAll() { try { using (Easycase.DataModel.EasyCaseDBEntities DB = new DataModel.EasyCaseDBEntities()) { var client = DB.CorporateProfileInformations.Where(s => s.Deleted == false).Select(c => new BLCorporateViewProfile { ID = c.ID, Address1 = c.Address1, Address2 = c.Address2, Address3 = c.Address3, BussinessName = c.BussinessName, CRA = c.CRA, Email = c.Email, Fax = c.Fax, KeyContactPerson = c.KeyContactPerson, KeyContactPosition = c.KeyContactPosition, Notes = c.Notes, Phone = c.Phone, Website = c.Website }).ToList(); return(client); } } catch (Exception ex) { Logs.SaveLog(ex.Message); return(new List <BLCorporateViewProfile>()); } }
public List <BLTaskNote> GetByCorporateProfileId(long id) { try { using (Easycase.DataModel.EasyCaseDBEntities DB = new DataModel.EasyCaseDBEntities()) { var casenote = DB.TaskNotes.Where(d => d.TaskId == id).Select(c => new BLTaskNote { ID = c.ID, Notes = c.Notes, TaskId = c.TaskId, Subject = c.Subject, Date = c.Date == null?DateTime.Now: c.Date, CreatedOn = c.CreatedOn, NotifyUser = c.NotifyUser }).ToList(); return(casenote); } } catch (Exception ex) { Logs.SaveLog(ex.Message); return(new List <BLTaskNote>()); } }
public BLContact GetById(long id) { try { using (Easycase.DataModel.EasyCaseDBEntities DB = new DataModel.EasyCaseDBEntities()) { var client = DB.Contacts.Where(d => d.ID == id).Select(c => new BLContact { FirstName = c.FirstName, Email = c.Email, LastName = c.LastName, Notes = c.Notes, Prefix = c.Prefix, ID = c.ID, ContactTypeId = c.ContactTypeId, CreatedBy = c.CreatedBy, CreatedOn = c.CreatedOn, Status = c.Status, Deleted = c.Deleted, FaxNo = c.FaxNo, MailingAddress = c.MailingAddress, MobileNo = c.MobileNo, OtherNo = c.OtherNo, WorkNo = c.WorkNo }).FirstOrDefault(); return(client); } } catch (Exception ex) { Logs.SaveLog(ex.Message); return(new BLContact()); } }