public static DCReceipt GetDCReceiptsByReceiptId(int DCReceiptID)
{
DataRow DcReceiptRow = DCReceiptDataAccess.GetInstance.GetDCReceiptsByReceiptId(DCReceiptID);
DCReceipt TheDcReceiptRow = DataRowToObject(DcReceiptRow);
return(TheDcReceiptRow);
}
public int CancelDcReceipt(DCReceipt theDcReceipt)
{
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("@CancelledReceiptID", SqlDbType.Int, theDcReceipt.CancelledReceiptID));
UpdateCommand.Parameters.Add(GetParameter("@ModifiedBy", SqlDbType.Int, Micro.Commons.Connection.LoggedOnUser.UserID));
UpdateCommand.CommandText = "pCRM_DCReceipts_Cancel";
ExecuteStoredProcedure(UpdateCommand);
ReturnValue = int.Parse(UpdateCommand.Parameters[0].Value.ToString());
return(ReturnValue);
}
}
public static List <DCReceipt> GetDCReceiptsByAccountID(int DCAccountID)
{
List <DCReceipt> DcReceiptList = new List <DCReceipt>();
DataTable DcReceiptTable = new DataTable();
DcReceiptTable = DCReceiptDataAccess.GetInstance.GetDCReceiptsByAccountID(DCAccountID);
foreach (DataRow dr in DcReceiptTable.Rows)
{
DCReceipt TheDcReceipt = DataRowToObject(dr);
DcReceiptList.Add(TheDcReceipt);
}
return(DcReceiptList);
}
public static List <DCReceipt> GetDCReceiptList(bool allOffices = false, bool showDeleted = false)
{
List <DCReceipt> DcReceiptList = new List <DCReceipt>();
DataTable DcReceiptTable = new DataTable();
DcReceiptTable = DCReceiptDataAccess.GetInstance.GetDCReceiptList(allOffices, showDeleted);
foreach (DataRow dr in DcReceiptTable.Rows)
{
DCReceipt TheDcReceipt = DataRowToObject(dr);
DcReceiptList.Add(TheDcReceipt);
}
return(DcReceiptList);
}
public int InsertDcReceipt(DCReceipt theDcReceipt)
{
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("@DCAccountID", SqlDbType.Int, theDcReceipt.DCAccountID));
InsertCommand.Parameters.Add(GetParameter("@DCReceiptDate", SqlDbType.VarChar, theDcReceipt.DCReceiptDate));
InsertCommand.Parameters.Add(GetParameter("@DCReceiptAmount", SqlDbType.Decimal, theDcReceipt.DCReceiptAmount));
InsertCommand.Parameters.Add(GetParameter("@DCPaymentMode", SqlDbType.VarChar, theDcReceipt.DCPaymentMode));
InsertCommand.Parameters.Add(GetParameter("@DCPaymentReference", SqlDbType.VarChar, theDcReceipt.DCPaymentReference));
InsertCommand.Parameters.Add(GetParameter("@DCAmountActualCollectionDateTime", SqlDbType.VarChar, theDcReceipt.DCAmountActualCollectionDateTime));
InsertCommand.Parameters.Add(GetParameter("@OfficeID", SqlDbType.Int, Micro.Commons.Connection.LoggedOnUser.OfficeID));
InsertCommand.Parameters.Add(GetParameter("@AddedBy", SqlDbType.Int, Micro.Commons.Connection.LoggedOnUser.UserID));
InsertCommand.CommandText = "pCRM_DCReceipts_Insert";
ExecuteStoredProcedure(InsertCommand);
ReturnValue = int.Parse(InsertCommand.Parameters[0].Value.ToString());
return(ReturnValue);
}
}
public static DCReceipt DataRowToObject(DataRow dr)
{
DCReceipt TheDCReceipt = new DCReceipt();
TheDCReceipt.DCReceiptID = int.Parse(dr["DCReceiptID"].ToString());
TheDCReceipt.DCAccountID = int.Parse(dr["DCAccountID"].ToString());
TheDCReceipt.DCAccountCode = dr["DCAccountCode"].ToString();
TheDCReceipt.CustomerName = dr["CustomerName"].ToString();
TheDCReceipt.DCReceiptDate = DateTime.Parse(dr["DCReceiptDate"].ToString()).ToString(MicroConstants.DateFormat);
TheDCReceipt.DCReceiptAmount = decimal.Parse(dr["DCReceiptAmount"].ToString());
TheDCReceipt.DCReceiptNumber = dr["DCReceiptNumber"].ToString();
TheDCReceipt.DCCollectorID = int.Parse(dr["DCCollectorID"].ToString());
TheDCReceipt.DCCollectorCode = dr["DCCollectorCode"].ToString();
TheDCReceipt.DCCollectorName = dr["DCCollectorName"].ToString();
TheDCReceipt.DCDeviceID = int.Parse(dr["DCDeviceID"].ToString());
TheDCReceipt.DCDeviceCode = dr["DCDeviceCode"].ToString();
TheDCReceipt.DCDeviceSerialNumber = dr["DCDeviceSerialNumber"].ToString();
TheDCReceipt.DCPaymentMode = dr["DCPaymentMode"].ToString();
TheDCReceipt.DCPaymentReference = dr["DCPaymentReference"].ToString();
TheDCReceipt.DCAmountActualCollectionDateTime = DateTime.Parse(dr["DCReceiptDate"].ToString()).ToString(MicroConstants.DateFormat);
return(TheDCReceipt);
}
public static int CancelDcReceipt(DCReceipt theDcReceipt)
{
return(DCReceiptDataAccess.GetInstance.CancelDcReceipt(theDcReceipt));
}
public int CancelDcReceipt(DCReceipt theDcReceipt)
{
return(DCReceiptIntegration.CancelDcReceipt(theDcReceipt));
}
public int InsertDcReceipt(DCReceipt theDcReceipt)
{
return(DCReceiptIntegration.InsertDcReceipt(theDcReceipt));
}
