public CHECKCASHED GetCHECKCASHEDFromReader(IDataReader reader)
{
try
{
CHECKCASHED cHECKCASHED = new CHECKCASHED
(
(int)reader["CHECKCASHEDID"],
(DateTime)reader["CHKDT"],
(int)reader["CUSTID"],
(int)reader["MAKERID"],
reader["CHKTYPE"].ToString(),
reader["CHKNO"].ToString(),
(int)reader["CHKAMOUNT"],
(int)reader["CHKFEES"],
(int)reader["CHKAMOUNTOWE"],
(char)reader["ISDEPOSITED"],
reader["EMP_ID"].ToString(),
reader["SHIFT_ID"].ToString(),
reader["STATION_ID"].ToString(),
reader["CREATEDBY"].ToString(),
(DateTime)reader["CREATEDON"],
(char)reader["ISBAD"],
(int)reader["BADCHECKAMOUNTOWE"],
reader["BADCHECKREMARKS"].ToString()
);
return(cHECKCASHED);
}
catch (Exception ex)
{
return(null);
}
}
public bool UpdateCHECKCASHED(CHECKCASHED cHECKCASHED)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("AbiMatuEnterprise_UpdateCHECKCASHED", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@CHECKCASHEDID", SqlDbType.Int).Value = cHECKCASHED.CHECKCASHEDID;
cmd.Parameters.Add("@CHKDT", SqlDbType.DateTime).Value = cHECKCASHED.CHKDT;
cmd.Parameters.Add("@CUSTID", SqlDbType.Int).Value = cHECKCASHED.CUSTID;
cmd.Parameters.Add("@MAKERID", SqlDbType.Int).Value = cHECKCASHED.MAKERID;
cmd.Parameters.Add("@CHKTYPE", SqlDbType.VarChar).Value = cHECKCASHED.CHKTYPE;
cmd.Parameters.Add("@CHKNO", SqlDbType.VarChar).Value = cHECKCASHED.CHKNO;
cmd.Parameters.Add("@CHKAMOUNT", SqlDbType.Int).Value = cHECKCASHED.CHKAMOUNT;
cmd.Parameters.Add("@CHKFEES", SqlDbType.Int).Value = cHECKCASHED.CHKFEES;
cmd.Parameters.Add("@CHKAMOUNTOWE", SqlDbType.Int).Value = cHECKCASHED.CHKAMOUNTOWE;
cmd.Parameters.Add("@ISDEPOSITED", SqlDbType.Char).Value = cHECKCASHED.ISDEPOSITED;
cmd.Parameters.Add("@EMP_ID", SqlDbType.VarChar).Value = cHECKCASHED.EMP_ID;
cmd.Parameters.Add("@SHIFT_ID", SqlDbType.VarChar).Value = cHECKCASHED.SHIFT_ID;
cmd.Parameters.Add("@STATION_ID", SqlDbType.VarChar).Value = cHECKCASHED.STATION_ID;
cmd.Parameters.Add("@CREATEDBY", SqlDbType.VarChar).Value = cHECKCASHED.CREATEDBY;
cmd.Parameters.Add("@CREATEDON", SqlDbType.DateTime).Value = cHECKCASHED.CREATEDON;
cmd.Parameters.Add("@ISBAD", SqlDbType.Char).Value = cHECKCASHED.ISBAD;
cmd.Parameters.Add("@BADCHECKAMOUNTOWE", SqlDbType.Int).Value = cHECKCASHED.BADCHECKAMOUNTOWE;
cmd.Parameters.Add("@BADCHECKREMARKS", SqlDbType.VarChar).Value = cHECKCASHED.BADCHECKREMARKS;
connection.Open();
int result = cmd.ExecuteNonQuery();
return(result == 1);
}
}
public static CHECKCASHED GetCHECKCASHEDByID(int id)
{
CHECKCASHED cHECKCASHED = new CHECKCASHED();
SqlCHECKCASHEDProvider sqlCHECKCASHEDProvider = new SqlCHECKCASHEDProvider();
cHECKCASHED = sqlCHECKCASHEDProvider.GetCHECKCASHEDByID(id);
return(cHECKCASHED);
}
public static bool UpdateCHECKCASHED(CHECKCASHED cHECKCASHED)
{
SqlCHECKCASHEDProvider sqlCHECKCASHEDProvider = new SqlCHECKCASHEDProvider();
return(sqlCHECKCASHEDProvider.UpdateCHECKCASHED(cHECKCASHED));
}
public static int InsertCHECKCASHED(CHECKCASHED cHECKCASHED)
{
SqlCHECKCASHEDProvider sqlCHECKCASHEDProvider = new SqlCHECKCASHEDProvider();
return(sqlCHECKCASHEDProvider.InsertCHECKCASHED(cHECKCASHED));
}
