public static PreMaturityApplication GetPreMaturityApplicationByID(int preMaturityApplicationID)
{
DataRow PreMaturityApplicationRow = PreMaturityApplicationDataAccess.GetInstance.GetPreMaturityApplicationByID(preMaturityApplicationID);
PreMaturityApplication ThePreMaturityApplications = DataRowToObject(PreMaturityApplicationRow);
return(ThePreMaturityApplications);
}
public static List <PreMaturityApplication> GetPreMaturityApplicationListByCustomerAccountID(int customerAccountID)
{
List <PreMaturityApplication> PreMaturityApplicationList = new List <PreMaturityApplication>();
DataTable PreMaturityApplicationDataTable = PreMaturityApplicationDataAccess.GetInstance.GetPreMaturityApplicationListByCustomerAccountID(customerAccountID);
foreach (DataRow dr in PreMaturityApplicationDataTable.Rows)
{
PreMaturityApplication ThePreMaturityApplications = DataRowToObject(dr);
PreMaturityApplicationList.Add(ThePreMaturityApplications);
}
return(PreMaturityApplicationList);
}
public static List <PreMaturityApplication> GetPreMaturityApplicationListByApprovalStatus(string approvalStatus, bool allOffices = true)
{
List <PreMaturityApplication> ThePreMaturityApplicationsList = new List <PreMaturityApplication>();
DataTable ThePreMaturityApplicationsTable = PreMaturityApplicationDataAccess.GetInstance.GetPreMaturityApplicationListByApprovalStatus(approvalStatus, allOffices);
foreach (DataRow dr in ThePreMaturityApplicationsTable.Rows)
{
PreMaturityApplication ThePreMaturityApplications = DataRowToObject(dr);
ThePreMaturityApplicationsList.Add(ThePreMaturityApplications);
}
return(ThePreMaturityApplicationsList);
}
public static List <PreMaturityApplication> GetPrematurityApplicationList(bool allOffices = false, bool showDeleted = false)
{
List <PreMaturityApplication> PreMaturityApplicationList = new List <PreMaturityApplication>();
DataTable PreMaturityApplicationTable = PreMaturityApplicationDataAccess.GetInstance.GetPrematurityApplicationList(allOffices, showDeleted);
foreach (DataRow dr in PreMaturityApplicationTable.Rows)
{
PreMaturityApplication ThePreMaturityApplications = DataRowToObject(dr);
PreMaturityApplicationList.Add(ThePreMaturityApplications);
}
return(PreMaturityApplicationList);
}
public int RejectPreMaturityApplication(PreMaturityApplication thePreMaturityApplication)
{
int ReturnValue = 0;
using (SqlCommand UpdateCommand = new SqlCommand())
{
UpdateCommand.CommandType = CommandType.StoredProcedure;
UpdateCommand.Parameters.Add(GetParameter("@ReturnValue", SqlDbType.Int, ReturnValue)).Direction = ParameterDirection.Output;
UpdateCommand.Parameters.Add(GetParameter("@PreMaturityApplicationID", SqlDbType.Int, thePreMaturityApplication.PreMaturityApplicationID));
UpdateCommand.Parameters.Add(GetParameter("@PreMaturityApprovalStatus", SqlDbType.VarChar, thePreMaturityApplication.PreMaturityApprovalStatus));
UpdateCommand.Parameters.Add(GetParameter("@Remarks", SqlDbType.VarChar, thePreMaturityApplication.Remarks));
UpdateCommand.Parameters.Add(GetParameter("@ModifiedBy", SqlDbType.Int, Micro.Commons.Connection.LoggedOnUser.UserID));
UpdateCommand.CommandText = "pCRM_PreMaturityApplications_UpdateApprovalStatus";
ExecuteStoredProcedure(UpdateCommand);
ReturnValue = int.Parse(UpdateCommand.Parameters[0].Value.ToString());
return(ReturnValue);
}
}
public static PreMaturityApplication GetLastPreMaturtiyApplicationByCustomerAccountID(int customerAccountID)
{
PreMaturityApplication ThePreMaturityApplication = null;
List <PreMaturityApplication> PreMaturityApplicationList = GetPreMaturityApplicationListByCustomerAccountID(customerAccountID);
if (PreMaturityApplicationList.Count > 0)
{
var LastPreMaturityApplication = (from TheApplicationList in PreMaturityApplicationList
where TheApplicationList.PreMaturityApprovalStatus != MicroEnums.GetStringValue(MicroEnums.ApprovalStatus.Rejected)
orderby DateTime.Parse(TheApplicationList.PreMaturityApplicationDate)
select TheApplicationList).LastOrDefault();
ThePreMaturityApplication = (PreMaturityApplication)LastPreMaturityApplication;
}
return(ThePreMaturityApplication);
}
public static PreMaturityApplication DataRowToObject(DataRow dr)
{
PreMaturityApplication ThePreMaturityApplications = new PreMaturityApplication();
ThePreMaturityApplications.PreMaturityApplicationID = int.Parse(dr["PreMaturityApplicationID"].ToString());
ThePreMaturityApplications.PreMaturityApplicationDate = DateTime.Parse(dr["PreMaturityApplicationDate"].ToString()).ToString(MicroConstants.DateFormat);
ThePreMaturityApplications.CustomerAccountID = int.Parse(dr["CustomerAccountID"].ToString());
if (!string.IsNullOrEmpty(dr["DeathCertificate"].ToString()))
{
ThePreMaturityApplications.DeathCertificate = (byte[])dr["DeathCertificate"];
}
ThePreMaturityApplications.PreMaturityRemark = dr["PreMaturityRemark"].ToString();
ThePreMaturityApplications.PreMaturityApplicationLetterDate = DateTime.Parse(dr["PreMaturityApplicationLetterDate"].ToString()).ToString(MicroConstants.DateFormat);
ThePreMaturityApplications.PreMaturityApplicationLetterReference = dr["PreMaturityApplicationLetterReference"].ToString();
ThePreMaturityApplications.PreMaturityApprovalStatus = dr["PreMaturityApprovalStatus"].ToString();
ThePreMaturityApplications.CustomerName = dr["CustomerName"].ToString();
ThePreMaturityApplications.CustomerID = int.Parse(dr["CustomerID"].ToString());
ThePreMaturityApplications.CustomerAccountCode = dr["CustomerAccountCode"].ToString();
return(ThePreMaturityApplications);
}
public int UpdatePrematurityApplication(PreMaturityApplication thePreMaturityApplications)
{
int ReturnValue = 0;
using (SqlCommand UpdateCommand = new SqlCommand())
{
UpdateCommand.CommandType = CommandType.StoredProcedure;
UpdateCommand.Parameters.Add(GetParameter("@ReturnValue", SqlDbType.Int, ReturnValue)).Direction = ParameterDirection.Output;
UpdateCommand.Parameters.Add(GetParameter("@PreMaturityApplicationID", SqlDbType.Int, thePreMaturityApplications.PreMaturityApplicationID));
UpdateCommand.Parameters.Add(GetParameter("@PreMaturityApplicationDate", SqlDbType.VarChar, thePreMaturityApplications.PreMaturityApplicationDate));
UpdateCommand.Parameters.Add(GetParameter("@CustomerAccountID", SqlDbType.Int, thePreMaturityApplications.CustomerAccountID));
UpdateCommand.Parameters.Add(GetParameter("@DeathCertificate", SqlDbType.VarBinary, thePreMaturityApplications.DeathCertificate));
UpdateCommand.Parameters.Add(GetParameter("@PreMaturityRemark", SqlDbType.VarChar, thePreMaturityApplications.PreMaturityRemark));
UpdateCommand.Parameters.Add(GetParameter("@PreMaturityApplicationLetterDate", SqlDbType.VarChar, thePreMaturityApplications.PreMaturityApplicationLetterDate));
UpdateCommand.Parameters.Add(GetParameter("@PreMaturityApplicationLetterReference", SqlDbType.VarChar, thePreMaturityApplications.PreMaturityApplicationLetterReference));
UpdateCommand.Parameters.Add(GetParameter("@ModifiedBy", SqlDbType.Int, Micro.Commons.Connection.LoggedOnUser.UserID));
UpdateCommand.CommandText = "pCRM_PreMaturityApplications_Update";
ExecuteStoredProcedure(UpdateCommand);
ReturnValue = int.Parse(UpdateCommand.Parameters[0].Value.ToString());
return(ReturnValue);
}
}
public static int RejectPreMaturityApplication(PreMaturityApplication thePreMaturityApplication)
{
return(PreMaturityApprovalDataAccess.GetInstance.RejectPreMaturityApplication(thePreMaturityApplication));
}
/// <summary>
/// Reject The Prematurity Application
/// </summary>
/// <param name="thePreMaturityApplication"></param>
/// <returns></returns>
public int RejectPreMaturityApplication(PreMaturityApplication thePreMaturityApplication)
{
return(PreMaturityApprovalIntegration.RejectPreMaturityApplication(thePreMaturityApplication));
}
public static int UpdatePrematurityApplication(PreMaturityApplication thePreMaturityApplications)
{
return(PreMaturityApplicationDataAccess.GetInstance.UpdatePrematurityApplication(thePreMaturityApplications));
}
public int UpdatePrematurityApplication(PreMaturityApplication thePreMaturityApplications)
{
return(PreMaturityApplicationIntegration.UpdatePrematurityApplication(thePreMaturityApplications));
}
public int InsertPrematurityApplication(PreMaturityApplication thePreMaturityApplications)
{
return(PreMaturityApplicationIntegration.InsertPrematurityApplication(thePreMaturityApplications));
}
