public STORETRANS GetSTORETRANSFromReader(IDataReader reader)
{
try
{
STORETRANS sTORETRANS = new STORETRANS
(
(int)reader["STORETRANSID"],
(DateTime)reader["DT"],
(int)reader["EMP_ID"],
(int)reader["SHIFT_ID"],
(int)reader["STATION_ID"],
(int)reader["CURRREG"],
(int)reader["REGOPEN"],
(int)reader["REGCLOSE"],
(char)reader["REGOPENSTATUS"],
(char)reader["REGCLOSESTATUS"],
(DateTime)reader["CLOSEDT"],
reader["TOTTIME"].ToString(),
(int)reader["TOTSECONDS"],
(int)reader["DIFF"]
);
return(sTORETRANS);
}
catch (Exception ex)
{
return(null);
}
}
public bool UpdateSTORETRANS(STORETRANS sTORETRANS)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("AbiMatuEnterprise_UpdateSTORETRANS", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@STORETRANSID", SqlDbType.Int).Value = sTORETRANS.STORETRANSID;
cmd.Parameters.Add("@DT", SqlDbType.DateTime).Value = sTORETRANS.DT;
cmd.Parameters.Add("@EMP_ID", SqlDbType.Int).Value = sTORETRANS.EMP_ID;
cmd.Parameters.Add("@SHIFT_ID", SqlDbType.Int).Value = sTORETRANS.SHIFT_ID;
cmd.Parameters.Add("@STATION_ID", SqlDbType.Int).Value = sTORETRANS.STATION_ID;
cmd.Parameters.Add("@CURRREG", SqlDbType.Int).Value = sTORETRANS.CURRREG;
cmd.Parameters.Add("@REGOPEN", SqlDbType.Int).Value = sTORETRANS.REGOPEN;
cmd.Parameters.Add("@REGCLOSE", SqlDbType.Int).Value = sTORETRANS.REGCLOSE;
cmd.Parameters.Add("@REGOPENSTATUS", SqlDbType.Char).Value = sTORETRANS.REGOPENSTATUS;
cmd.Parameters.Add("@REGCLOSESTATUS", SqlDbType.Char).Value = sTORETRANS.REGCLOSESTATUS;
cmd.Parameters.Add("@CLOSEDT", SqlDbType.DateTime).Value = sTORETRANS.CLOSEDT;
cmd.Parameters.Add("@TOTTIME", SqlDbType.VarChar).Value = sTORETRANS.TOTTIME;
cmd.Parameters.Add("@TOTSECONDS", SqlDbType.Int).Value = sTORETRANS.TOTSECONDS;
cmd.Parameters.Add("@DIFF", SqlDbType.Int).Value = sTORETRANS.DIFF;
connection.Open();
int result = cmd.ExecuteNonQuery();
return(result == 1);
}
}
public static STORETRANS GetSTORETRANSByID(int id)
{
STORETRANS sTORETRANS = new STORETRANS();
SqlSTORETRANSProvider sqlSTORETRANSProvider = new SqlSTORETRANSProvider();
sTORETRANS = sqlSTORETRANSProvider.GetSTORETRANSByID(id);
return(sTORETRANS);
}
public static bool UpdateSTORETRANS(STORETRANS sTORETRANS)
{
SqlSTORETRANSProvider sqlSTORETRANSProvider = new SqlSTORETRANSProvider();
return(sqlSTORETRANSProvider.UpdateSTORETRANS(sTORETRANS));
}
public static int InsertSTORETRANS(STORETRANS sTORETRANS)
{
SqlSTORETRANSProvider sqlSTORETRANSProvider = new SqlSTORETRANSProvider();
return(sqlSTORETRANSProvider.InsertSTORETRANS(sTORETRANS));
}
