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