public int UpdatePolicyApplication(PolicyApplication thePolicyMaster)
{
try
{
return(PolicyApplicationIntegration.UpdatePolicyApplication(thePolicyMaster));
}
catch (Exception ex)
{
throw (new Exception(MethodBase.GetCurrentMethod().DeclaringType.ToString() + "." + (new System.Diagnostics.StackFrame()).GetMethod().Name, ex));
}
}
private void PopulatePageFields(PolicyApplication thePolicyApplication)
{
ddl_AcademicYear.SelectedIndex = GetDropDownSelectedIndex(ddl_AcademicYear, Convert.ToString(thePolicyApplication.SessionID));
ddl_EmployeeName.SelectedIndex = GetDropDownSelectedIndex(ddl_EmployeeName, Convert.ToString(thePolicyApplication.EmployeeID));
ddl_PolicyType.SelectedIndex = GetDropDownSelectedIndex(ddl_PolicyType, Convert.ToString(thePolicyApplication.PolicyID));
txt_emi.Text = thePolicyApplication.EMI.ToString();
txt_Policyamount.Text = thePolicyApplication.PolicyAmount.ToString();
txt_Policyappdate.Text = thePolicyApplication.PolicyDate;
txt_RequiredFor.Text = thePolicyApplication.Comment;
txt_toalnoinstalment.Text = thePolicyApplication.TotalNoInstallment.ToString();
}
public static int InsertPolicyApplication(PolicyApplication thePolicyMaster)
{
try
{
return(StaffLICDataAccess.GetInstance.InsertPolicyApplication(thePolicyMaster));
}
catch (Exception ex)
{
throw (new Exception(MethodBase.GetCurrentMethod().DeclaringType.ToString() + "." + (new System.Diagnostics.StackFrame()).GetMethod().Name, ex));
}
}
public static List <PolicyApplication> GetPolicyEmployeeList(bool allOffices = false, bool showDeleted = false)
{
List <PolicyApplication> PolicyMasterList = new List <PolicyApplication>();
DataTable PolicyApplicatioTable = StaffLICDataAccess.GetInstance.GetLICEmployeeList(allOffices, showDeleted);
foreach (DataRow dr in PolicyApplicatioTable.Rows)
{
PolicyApplication ThepolicyAppilication = DataRowToObject(dr);
PolicyMasterList.Add(ThepolicyAppilication);
}
return(PolicyMasterList);
}
public static List <PolicyApplication> GetEmployeeActivePolicyList(bool allOffices = false, bool showDeleted = false)
{
List <PolicyApplication> EmployeeActiveLoanList = new List <PolicyApplication>();
List <PolicyApplication> EmployeeLoanList = GetPolicyEmployeeList(allOffices, showDeleted);
if (EmployeeLoanList.Count > 0)
{
var ActiveLoanList = (from ThepolicyList in EmployeeLoanList
where ThepolicyList.PolicyStatus == false
select ThepolicyList);
foreach (PolicyApplication EachLoan in ActiveLoanList)
{
PolicyApplication TheEmployeeLoanApplication = (PolicyApplication)EachLoan;
EmployeeActiveLoanList.Add(TheEmployeeLoanApplication);
}
}
return(EmployeeActiveLoanList);
}
private int SaveEmployeePolicyDetails()
{
int ProcReturnValue = 0;
PolicyApplication ThePolicyApplications = new PolicyApplication();
ThePolicyApplications.SessionID = int.Parse(ddl_AcademicYear.SelectedValue);
ThePolicyApplications.EmployeeID = int.Parse(ddl_EmployeeName.SelectedValue);
ThePolicyApplications.PolicyID = int.Parse(ddl_PolicyType.SelectedValue);
ThePolicyApplications.PolicyAmount = decimal.Parse(txt_Policyamount.Text);
ThePolicyApplications.PolicyDate = txt_Policyappdate.Text;
ThePolicyApplications.PolicyStatus = true;
ThePolicyApplications.Comment = txt_RequiredFor.Text;
ThePolicyApplications.TotalNoInstallment = int.Parse(txt_toalnoinstalment.Text);
ThePolicyApplications.EMI = decimal.Parse(txt_emi.Text);
ProcReturnValue = PolicyApplicationManagement.GetInstance.InsertPolicyApplication(ThePolicyApplications);
return(ProcReturnValue);
}
//public static PolicyApplication GetActiveEmployeeLoanByEmployeeID(int employeeID)
//{
// PolicyApplication ActiveEmployeeLoan = new PolicyApplication();
// List<PolicyApplication> EmployeeLoanList = GetEmployeeLoanDetailsByEmployeeID(employeeID);
// if (EmployeeLoanList.Count > 0)
// {
// var TheActiveEmployeeLoan = (from TheLoanList in EmployeeLoanList
// where TheLoanList.LoanStatus == true && TheLoanList.LoanID == TheLoanList.LoanID
// select TheLoanList).LastOrDefault();
// if (TheActiveEmployeeLoan != null)
// ActiveEmployeeLoan = TheActiveEmployeeLoan;
// }
// return ActiveEmployeeLoan;
//}
public static PolicyApplication DataRowToObject(DataRow dr)
{
PolicyApplication ThePplicyApplication = new PolicyApplication();
ThePplicyApplication.PolicyApplicationID = int.Parse(dr["PolicyApplicationID"].ToString());
ThePplicyApplication.SessionID = int.Parse(dr["SessionID"].ToString());
ThePplicyApplication.EmployeeID = int.Parse(dr["EmployeeID"].ToString());
ThePplicyApplication.EmployeeName = dr["EmployeeName"].ToString();
ThePplicyApplication.PolicyDate = DateTime.Parse(dr["PolicyDate"].ToString()).ToString(MicroConstants.DateFormat);
ThePplicyApplication.PolicyID = int.Parse(dr["PolicyID"].ToString());
ThePplicyApplication.PolicyTypeDescriptions = dr["PolicyTypeDescriptions"].ToString();
ThePplicyApplication.PolicyAmount = decimal.Parse(dr["PolicyAmount"].ToString());
ThePplicyApplication.TotalNoInstallment = int.Parse(dr["TotalNoInstallment"].ToString());
ThePplicyApplication.EMI = decimal.Parse(dr["EMI"].ToString());
ThePplicyApplication.Comment = dr["Comment"].ToString();
ThePplicyApplication.PolicyStatus = bool.Parse(dr["PolicyStatus"].ToString());
ThePplicyApplication.OfficeID = int.Parse(dr["OfficeID"].ToString());
ThePplicyApplication.OfficeName = dr["OfficeName"].ToString();
return(ThePplicyApplication);
}
public int UpdatePolicyApplication(PolicyApplication ThePolicyMaster)
{
try
{
int ReturnValue = 0;
SqlCommand UpdateCommand = new SqlCommand();
UpdateCommand.CommandType = CommandType.StoredProcedure;
UpdateCommand.Parameters.Add(GetParameter("@ReturnValue", SqlDbType.Int, ReturnValue)).Direction = ParameterDirection.Output;
UpdateCommand.Parameters.Add(GetParameter("@PolicyApplicationID", SqlDbType.Int, ThePolicyMaster.PolicyApplicationID));
UpdateCommand.Parameters.Add(GetParameter("@PolicyID", SqlDbType.Int, ThePolicyMaster.PolicyID));
UpdateCommand.Parameters.Add(GetParameter("@SessionID", SqlDbType.Int, ThePolicyMaster.SessionID));
UpdateCommand.Parameters.Add(GetParameter("@PolicyDate", SqlDbType.VarChar, ThePolicyMaster.PolicyDate));
UpdateCommand.Parameters.Add(GetParameter("@EmployeeID", SqlDbType.Int, ThePolicyMaster.EmployeeID));
UpdateCommand.Parameters.Add(GetParameter("@PolicyAmount", SqlDbType.Decimal, ThePolicyMaster.PolicyAmount));
UpdateCommand.Parameters.Add(GetParameter("@TotalNoInstallment", SqlDbType.Int, ThePolicyMaster.TotalNoInstallment));
UpdateCommand.Parameters.Add(GetParameter("@EMI", SqlDbType.Decimal, ThePolicyMaster.EMI));
UpdateCommand.Parameters.Add(GetParameter("@PolicyStatus", SqlDbType.Bit, ThePolicyMaster.PolicyStatus));
UpdateCommand.Parameters.Add(GetParameter("@Comment", SqlDbType.VarChar, ThePolicyMaster.Comment));
UpdateCommand.Parameters.Add(GetParameter("@SanctionedByID", SqlDbType.Int, Micro.Commons.Connection.LoggedOnUser.UserID));
UpdateCommand.Parameters.Add(GetParameter("@OfficeId", SqlDbType.Int, Micro.Commons.Connection.LoggedOnUser.OfficeID));
//SqlCmd.Parameters.Add(GetParameter("@IsActive", SqlDbType.Int, Desg.IsActive));
UpdateCommand.Parameters.Add(GetParameter("@ModifiedBy", SqlDbType.Int, Micro.Commons.Connection.LoggedOnUser.UserID));
UpdateCommand.CommandText = "pHRMS_TRN_StaffLIC_Payments_Update";
ExecuteStoredProcedure(UpdateCommand);
ReturnValue = int.Parse(UpdateCommand.Parameters[0].Value.ToString());
return(ReturnValue);
}
catch (Exception ex)
{
throw (new Exception(MethodBase.GetCurrentMethod().DeclaringType.ToString() + "." + (new System.Diagnostics.StackFrame()).GetMethod().Name, ex));
}
}
