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