public static MediclaimPayment DataRowToObject(DataRow dr)
{
MediclaimPayment TheMediclaimPayment = new MediclaimPayment();
TheMediclaimPayment.MediclaimPaymentID = int.Parse(dr["MediclaimPaymentID"].ToString());
TheMediclaimPayment.MediclaimApplicationID = int.Parse(dr["MediclaimApplicationID"].ToString());
TheMediclaimPayment.CustomerCode = dr["CustomerCode"].ToString();
TheMediclaimPayment.CustomerName = dr["CustomerName"].ToString();
TheMediclaimPayment.PaymentDate = DateTime.Parse(dr["PaymentDate"].ToString()).ToString(MicroConstants.DateFormat);
TheMediclaimPayment.AmountPaid = decimal.Parse(dr["AmountPaid"].ToString());
return(TheMediclaimPayment);
}
public static List <MediclaimPayment> GetMediClaimPaymentList(bool allOffices = false, bool showDeleted = false)
{
List <MediclaimPayment> MediclaimPaymentList = new List <MediclaimPayment>();
DataTable MediclaimPaymentTable = PaymentsMediclaimDataAccess.GetInstance.GetMediClaimPaymentList(allOffices, showDeleted);
foreach (DataRow dr in MediclaimPaymentTable.Rows)
{
MediclaimPayment TheMediclaimPayment = DataRowToObject(dr);
MediclaimPaymentList.Add(TheMediclaimPayment);
}
return(MediclaimPaymentList);
}
public static MediclaimPayment GetMediclaimPaymentByMediClaimApplicationID(int mediclaimApplicationID)
{
MediclaimPayment TheMediclaimPayment;
DataRow TheMediclaimPaymentRow = PaymentsMediclaimDataAccess.GetInstance.GetMediclaimPaymentByMediClaimApplicationID(mediclaimApplicationID);
if (TheMediclaimPaymentRow != null)
{
TheMediclaimPayment = DataRowToObject(TheMediclaimPaymentRow);
}
else
{
TheMediclaimPayment = new MediclaimPayment();
}
return(TheMediclaimPayment);
}
public int InsertMediclaimPayment(MediclaimPayment theMediclaimPayment)
{
int ReturnValue = 0;
using (SqlCommand InsertCommand = new SqlCommand())
{
InsertCommand.CommandType = CommandType.StoredProcedure;
InsertCommand.Parameters.Add(GetParameter("@ReturnValue", SqlDbType.Int, ReturnValue)).Direction = ParameterDirection.Output;
InsertCommand.Parameters.Add(GetParameter("@MediclaimApplicationID", SqlDbType.Int, theMediclaimPayment.MediclaimApplicationID));
InsertCommand.Parameters.Add(GetParameter("@PaymentDate", SqlDbType.VarChar, theMediclaimPayment.PaymentDate));
InsertCommand.Parameters.Add(GetParameter("@AmountPaid", SqlDbType.Decimal, theMediclaimPayment.AmountPaid));
InsertCommand.Parameters.Add(GetParameter("@AddedBy", SqlDbType.Int, Micro.Commons.Connection.LoggedOnUser.UserID));
InsertCommand.CommandText = "pCRM_MediclaimPayments_Insert";
ExecuteStoredProcedure(InsertCommand);
ReturnValue = int.Parse(InsertCommand.Parameters[0].Value.ToString());
return(ReturnValue);
}
}
public static int InsertMediclaimPayment(MediclaimPayment theMediclaimPayment)
{
return(PaymentsMediclaimDataAccess.GetInstance.InsertMediclaimPayment(theMediclaimPayment));
}
public int InsertMediclaimPayment(MediclaimPayment theMediclaimPayment)
{
return(PaymentsMediclaimIntegration.InsertMediclaimPayment(theMediclaimPayment));
}
