public IList <Common.Model.CurrentStatus.GeneralInsurance> GetAll(int plannerId) { try { Logger.LogInfo("Get: General insurance process start"); IList <Common.Model.CurrentStatus.GeneralInsurance> lstGeneralInsurance = new List <Common.Model.CurrentStatus.GeneralInsurance>(); DataTable dtAppConfig = DataBase.DBService.ExecuteCommand(string.Format(SELECT_ALL, plannerId)); foreach (DataRow dr in dtAppConfig.Rows) { Common.Model.CurrentStatus.GeneralInsurance GeneralInsurance = convertToGeneralInsuranceObject(dr); lstGeneralInsurance.Add(GeneralInsurance); } Logger.LogInfo("Get: General insurance process completed."); return(lstGeneralInsurance); } catch (Exception ex) { StackTrace st = new StackTrace(); StackFrame sf = st.GetFrame(0); MethodBase currentMethodName = sf.GetMethod(); LogDebug(currentMethodName.Name, ex); return(null); } }
public void Add(Common.Model.CurrentStatus.GeneralInsurance GeneralInsurance) { try { string clientName = DataBase.DBService.ExecuteCommandScalar(string.Format(GET_CLIENT_NAME_QUERY, GeneralInsurance.Pid)); DataBase.DBService.BeginTransaction(); DataBase.DBService.ExecuteCommandString(string.Format(INSERT_LIFE_INSURANCE, GeneralInsurance.Pid, GeneralInsurance.Applicant, (GeneralInsurance.IssueDate != null) ? GeneralInsurance.IssueDate.Value.ToString("yyyy-MM-dd hh:mm:ss") : null, GeneralInsurance.TermsInYears, (GeneralInsurance.RenewalDate != null) ? GeneralInsurance.RenewalDate.Value.ToString("yyyy-MM-dd hh:mm:ss") : null, GeneralInsurance.PolicyNo, GeneralInsurance.Company, GeneralInsurance.Policy, GeneralInsurance.Type, GeneralInsurance.SumAssured, GeneralInsurance.Bonus, GeneralInsurance.Premium, GeneralInsurance.Remark, GeneralInsurance.AttachmentPath, GeneralInsurance.CreatedOn.ToString("yyyy-MM-dd hh:mm:ss"), GeneralInsurance.CreatedBy, GeneralInsurance.UpdatedOn.ToString("yyyy-MM-dd hh:mm:ss"), GeneralInsurance.UpdatedBy, (GeneralInsurance.SetReminder == true) ? 1 : 0), true); Activity.ActivitiesService.Add(ActivityType.CreateGeneralInsurance, EntryStatus.Success, Source.Server, GeneralInsurance.UpdatedByUserName, clientName, GeneralInsurance.MachineName); DataBase.DBService.CommitTransaction(); } catch (Exception ex) { DataBase.DBService.RollbackTransaction(); StackTrace st = new StackTrace(); StackFrame sf = st.GetFrame(0); MethodBase currentMethodName = sf.GetMethod(); LogDebug(currentMethodName.Name, ex); throw ex; } }
private Common.Model.CurrentStatus.GeneralInsurance convertToGeneralInsuranceObject(DataRow dr) { Common.Model.CurrentStatus.GeneralInsurance GeneralInsurance = new Common.Model.CurrentStatus.GeneralInsurance(); GeneralInsurance.Id = dr.Field <int>("ID"); GeneralInsurance.Pid = dr.Field <int>("PID"); GeneralInsurance.Applicant = dr.Field <string>("Applicant"); GeneralInsurance.IssueDate = dr.Field <DateTime>("IssueDate"); GeneralInsurance.TermsInYears = dr.Field <int>("TermsInYears"); GeneralInsurance.RenewalDate = dr.Field <DateTime>("RenewalDate"); GeneralInsurance.PolicyNo = dr.Field <string>("PolicyNo"); GeneralInsurance.Company = dr.Field <string>("Company"); GeneralInsurance.Policy = dr.Field <string>("Policy"); GeneralInsurance.Type = dr.Field <string>("Type"); GeneralInsurance.SumAssured = double.Parse(dr["SumAssured"].ToString()); GeneralInsurance.Bonus = double.Parse(dr["Bonus"].ToString()); GeneralInsurance.Premium = double.Parse(dr["Premium"].ToString()); GeneralInsurance.Remark = dr.Field <string>("Remark"); GeneralInsurance.AttachmentPath = dr.Field <string>("AttachmentPath"); GeneralInsurance.UpdatedBy = dr.Field <int>("UpdatedBy"); GeneralInsurance.UpdatedOn = dr.Field <DateTime>("UpdatedOn"); GeneralInsurance.UpdatedByUserName = dr.Field <string>("UpdatedByUserName"); GeneralInsurance.SetReminder = (dr["SetReminder"] == DBNull.Value) ? false : bool.Parse(dr["SetReminder"].ToString()); return(GeneralInsurance); }
public void Delete(Common.Model.CurrentStatus.GeneralInsurance GeneralInsurance) { try { string clientName = DataBase.DBService.ExecuteCommandScalar(string.Format(GET_CLIENT_NAME_QUERY, GeneralInsurance.Pid)); DataBase.DBService.BeginTransaction(); DataBase.DBService.ExecuteCommandString(string.Format(DELETE_LIFE_INSURNACE, GeneralInsurance.Id, GeneralInsurance.Pid), true); Activity.ActivitiesService.Add(ActivityType.DeleteGeneralInsurance, EntryStatus.Success, Source.Server, GeneralInsurance.UpdatedByUserName, clientName, GeneralInsurance.MachineName); DataBase.DBService.CommitTransaction(); } catch (Exception ex) { DataBase.DBService.RollbackTransaction(); StackTrace st = new StackTrace(); StackFrame sf = st.GetFrame(0); MethodBase currentMethodName = sf.GetMethod(); LogDebug(currentMethodName.Name, ex); throw ex; } }