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