Example #1
0
 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());
     }
 }
Example #2
0
 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>());
     }
 }
Example #3
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));
     }
 }
Example #4
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());
     }
 }
Example #5
0
 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));
     }
 }
Example #6
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));
     }
 }
Example #7
0
 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));
     }
 }
Example #8
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());
     }
 }
Example #9
0
 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>());
     }
 }
Example #10
0
 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));
     }
 }
Example #11
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);
     }
 }
Example #12
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>());
     }
 }
Example #13
0
 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);
     }
 }
Example #14
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);
     }
 }
Example #15
0
 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());
     }
 }
Example #16
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);
     }
 }
Example #17
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));
     }
 }
Example #18
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());
     }
 }
Example #19
0
 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());
     }
 }
Example #20
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));
     }
 }
Example #21
0
 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>());
     }
 }
Example #22
0
 /// <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>());
     }
 }
Example #23
0
 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);
     }
 }
Example #24
0
 /// <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());
     }
 }
Example #25
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));
     }
 }
Example #26
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));
     }
 }
Example #27
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));
     }
 }
Example #28
0
 /// <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>());
     }
 }
Example #29
0
 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>());
     }
 }
Example #30
0
 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());
     }
 }