public static GLOBALPAYMENT GetGLOBALPAYMENTByID(int id)
{
GLOBALPAYMENT gLOBALPAYMENT = new GLOBALPAYMENT();
SqlGLOBALPAYMENTProvider sqlGLOBALPAYMENTProvider = new SqlGLOBALPAYMENTProvider();
gLOBALPAYMENT = sqlGLOBALPAYMENTProvider.GetGLOBALPAYMENTByID(id);
return(gLOBALPAYMENT);
}
public bool UpdateGLOBALPAYMENT(GLOBALPAYMENT gLOBALPAYMENT)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("AbiMatuEnterprise_UpdateGLOBALPAYMENT", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@GLOBALPAYMENTID", SqlDbType.Int).Value = gLOBALPAYMENT.GLOBALPAYMENTID;
cmd.Parameters.Add("@ID", SqlDbType.VarChar).Value = gLOBALPAYMENT.ID;
cmd.Parameters.Add("@UTILITYNAME", SqlDbType.VarChar).Value = gLOBALPAYMENT.UTILITYNAME;
cmd.Parameters.Add("@UTILITYFEES", SqlDbType.Int).Value = gLOBALPAYMENT.UTILITYFEES;
cmd.Parameters.Add("@STORECOMM", SqlDbType.Int).Value = gLOBALPAYMENT.STORECOMM;
cmd.Parameters.Add("@GLOBALCOMM", SqlDbType.Int).Value = gLOBALPAYMENT.GLOBALCOMM;
cmd.Parameters.Add("@ACCOUNTLENGTH", SqlDbType.Int).Value = gLOBALPAYMENT.ACCOUNTLENGTH;
cmd.Parameters.Add("@ACCOUNTSTART", SqlDbType.Int).Value = gLOBALPAYMENT.ACCOUNTSTART;
cmd.Parameters.Add("@SCALELINEFROMBOTTON", SqlDbType.Int).Value = gLOBALPAYMENT.SCALELINEFROMBOTTON;
cmd.Parameters.Add("@SCALELINEWIDTH", SqlDbType.Int).Value = gLOBALPAYMENT.SCALELINEWIDTH;
connection.Open();
int result = cmd.ExecuteNonQuery();
return(result == 1);
}
}
public GLOBALPAYMENT GetGLOBALPAYMENTFromReader(IDataReader reader)
{
try
{
GLOBALPAYMENT gLOBALPAYMENT = new GLOBALPAYMENT
(
(int)reader["GLOBALPAYMENTID"],
reader["ID"].ToString(),
reader["UTILITYNAME"].ToString(),
(int)reader["UTILITYFEES"],
(int)reader["STORECOMM"],
(int)reader["GLOBALCOMM"],
(int)reader["ACCOUNTLENGTH"],
(int)reader["ACCOUNTSTART"],
(int)reader["SCALELINEFROMBOTTON"],
(int)reader["SCALELINEWIDTH"]
);
return(gLOBALPAYMENT);
}
catch (Exception ex)
{
return(null);
}
}
public static bool UpdateGLOBALPAYMENT(GLOBALPAYMENT gLOBALPAYMENT)
{
SqlGLOBALPAYMENTProvider sqlGLOBALPAYMENTProvider = new SqlGLOBALPAYMENTProvider();
return(sqlGLOBALPAYMENTProvider.UpdateGLOBALPAYMENT(gLOBALPAYMENT));
}
public static int InsertGLOBALPAYMENT(GLOBALPAYMENT gLOBALPAYMENT)
{
SqlGLOBALPAYMENTProvider sqlGLOBALPAYMENTProvider = new SqlGLOBALPAYMENTProvider();
return(sqlGLOBALPAYMENTProvider.InsertGLOBALPAYMENT(gLOBALPAYMENT));
}
