public GTRANS GetGTRANSFromReader(IDataReader reader)
{
try
{
GTRANS gTRANS = new GTRANS
(
(int)reader["GTRANSID"],
reader["UTILITYID"].ToString(),
reader["CUSTID"].ToString(),
reader["STOREID"].ToString(),
reader["LOCATIONID"].ToString(),
(DateTime)reader["TRANSDATE"],
reader["TRANSACC"].ToString(),
(int)reader["TRANSAMT"],
(int)reader["TRANSFEES"],
(int)reader["TRANSCASH"],
(int)reader["TRANSCHECK"],
reader["AUTHCODE"].ToString(),
reader["EMPID"].ToString(),
reader["STATIONID"].ToString(),
reader["SHIFTID"].ToString(),
(char)reader["VOIDFLAG"],
reader["VOIDAUTHORIZATION"].ToString()
);
return(gTRANS);
}
catch (Exception ex)
{
return(null);
}
}
public bool UpdateGTRANS(GTRANS gTRANS)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("AbiMatuEnterprise_UpdateGTRANS", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@GTRANSID", SqlDbType.Int).Value = gTRANS.GTRANSID;
cmd.Parameters.Add("@UTILITYID", SqlDbType.VarChar).Value = gTRANS.UTILITYID;
cmd.Parameters.Add("@CUSTID", SqlDbType.VarChar).Value = gTRANS.CUSTID;
cmd.Parameters.Add("@STOREID", SqlDbType.VarChar).Value = gTRANS.STOREID;
cmd.Parameters.Add("@LOCATIONID", SqlDbType.VarChar).Value = gTRANS.LOCATIONID;
cmd.Parameters.Add("@TRANSDATE", SqlDbType.DateTime).Value = gTRANS.TRANSDATE;
cmd.Parameters.Add("@TRANSACC", SqlDbType.VarChar).Value = gTRANS.TRANSACC;
cmd.Parameters.Add("@TRANSAMT", SqlDbType.Int).Value = gTRANS.TRANSAMT;
cmd.Parameters.Add("@TRANSFEES", SqlDbType.Int).Value = gTRANS.TRANSFEES;
cmd.Parameters.Add("@TRANSCASH", SqlDbType.Int).Value = gTRANS.TRANSCASH;
cmd.Parameters.Add("@TRANSCHECK", SqlDbType.Int).Value = gTRANS.TRANSCHECK;
cmd.Parameters.Add("@AUTHCODE", SqlDbType.VarChar).Value = gTRANS.AUTHCODE;
cmd.Parameters.Add("@EMPID", SqlDbType.VarChar).Value = gTRANS.EMPID;
cmd.Parameters.Add("@STATIONID", SqlDbType.VarChar).Value = gTRANS.STATIONID;
cmd.Parameters.Add("@SHIFTID", SqlDbType.VarChar).Value = gTRANS.SHIFTID;
cmd.Parameters.Add("@VOIDFLAG", SqlDbType.Char).Value = gTRANS.VOIDFLAG;
cmd.Parameters.Add("@VOIDAUTHORIZATION", SqlDbType.VarChar).Value = gTRANS.VOIDAUTHORIZATION;
connection.Open();
int result = cmd.ExecuteNonQuery();
return(result == 1);
}
}
public static GTRANS GetGTRANSByID(int id)
{
GTRANS gTRANS = new GTRANS();
SqlGTRANSProvider sqlGTRANSProvider = new SqlGTRANSProvider();
gTRANS = sqlGTRANSProvider.GetGTRANSByID(id);
return(gTRANS);
}
public static bool UpdateGTRANS(GTRANS gTRANS)
{
SqlGTRANSProvider sqlGTRANSProvider = new SqlGTRANSProvider();
return(sqlGTRANSProvider.UpdateGTRANS(gTRANS));
}
public static int InsertGTRANS(GTRANS gTRANS)
{
SqlGTRANSProvider sqlGTRANSProvider = new SqlGTRANSProvider();
return(sqlGTRANSProvider.InsertGTRANS(gTRANS));
}
