public static CUSTOMERUTILITYPAYMENT GetCUSTOMERUTILITYPAYMENTByID(int id)
{
CUSTOMERUTILITYPAYMENT cUSTOMERUTILITYPAYMENT = new CUSTOMERUTILITYPAYMENT();
SqlCUSTOMERUTILITYPAYMENTProvider sqlCUSTOMERUTILITYPAYMENTProvider = new SqlCUSTOMERUTILITYPAYMENTProvider();
cUSTOMERUTILITYPAYMENT = sqlCUSTOMERUTILITYPAYMENTProvider.GetCUSTOMERUTILITYPAYMENTByID(id);
return(cUSTOMERUTILITYPAYMENT);
}
public int InsertCUSTOMERUTILITYPAYMENT(CUSTOMERUTILITYPAYMENT cUSTOMERUTILITYPAYMENT)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("AbiMatuEnterprise_InsertCUSTOMERUTILITYPAYMENT", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@CUSTOMERUTILITYPAYMENTID", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.Parameters.Add("@CUSTID", SqlDbType.VarChar).Value = cUSTOMERUTILITYPAYMENT.CUSTID;
cmd.Parameters.Add("@UTILITYID", SqlDbType.VarChar).Value = cUSTOMERUTILITYPAYMENT.UTILITYID;
cmd.Parameters.Add("@ACCOUNTNUMBER", SqlDbType.VarChar).Value = cUSTOMERUTILITYPAYMENT.ACCOUNTNUMBER;
connection.Open();
int result = cmd.ExecuteNonQuery();
return((int)cmd.Parameters["@CUSTOMERUTILITYPAYMENTID"].Value);
}
}
public CUSTOMERUTILITYPAYMENT GetCUSTOMERUTILITYPAYMENTFromReader(IDataReader reader)
{
try
{
CUSTOMERUTILITYPAYMENT cUSTOMERUTILITYPAYMENT = new CUSTOMERUTILITYPAYMENT
(
(int)reader["CUSTOMERUTILITYPAYMENTID"],
reader["CUSTID"].ToString(),
reader["UTILITYID"].ToString(),
reader["ACCOUNTNUMBER"].ToString()
);
return(cUSTOMERUTILITYPAYMENT);
}
catch (Exception ex)
{
return(null);
}
}
public static bool UpdateCUSTOMERUTILITYPAYMENT(CUSTOMERUTILITYPAYMENT cUSTOMERUTILITYPAYMENT)
{
SqlCUSTOMERUTILITYPAYMENTProvider sqlCUSTOMERUTILITYPAYMENTProvider = new SqlCUSTOMERUTILITYPAYMENTProvider();
return(sqlCUSTOMERUTILITYPAYMENTProvider.UpdateCUSTOMERUTILITYPAYMENT(cUSTOMERUTILITYPAYMENT));
}
public static int InsertCUSTOMERUTILITYPAYMENT(CUSTOMERUTILITYPAYMENT cUSTOMERUTILITYPAYMENT)
{
SqlCUSTOMERUTILITYPAYMENTProvider sqlCUSTOMERUTILITYPAYMENTProvider = new SqlCUSTOMERUTILITYPAYMENTProvider();
return(sqlCUSTOMERUTILITYPAYMENTProvider.InsertCUSTOMERUTILITYPAYMENT(cUSTOMERUTILITYPAYMENT));
}
