public static CUSTOMERACCOUNT GetCUSTOMERACCOUNTByID(int id)
{
CUSTOMERACCOUNT cUSTOMERACCOUNT = new CUSTOMERACCOUNT();
SqlCUSTOMERACCOUNTProvider sqlCUSTOMERACCOUNTProvider = new SqlCUSTOMERACCOUNTProvider();
cUSTOMERACCOUNT = sqlCUSTOMERACCOUNTProvider.GetCUSTOMERACCOUNTByID(id);
return(cUSTOMERACCOUNT);
}
public int InsertCUSTOMERACCOUNT(CUSTOMERACCOUNT cUSTOMERACCOUNT)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("AbiMatuEnterprise_InsertCUSTOMERACCOUNT", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@CUSTOMERACCOUNTID", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.Parameters.Add("@ACCOUNTNO", SqlDbType.VarChar).Value = cUSTOMERACCOUNT.ACCOUNTNO;
cmd.Parameters.Add("@SERVICEID", SqlDbType.Int).Value = cUSTOMERACCOUNT.SERVICEID;
cmd.Parameters.Add("@CUST_ID", SqlDbType.Int).Value = cUSTOMERACCOUNT.CUST_ID;
connection.Open();
int result = cmd.ExecuteNonQuery();
return((int)cmd.Parameters["@CUSTOMERACCOUNTID"].Value);
}
}
public CUSTOMERACCOUNT GetCUSTOMERACCOUNTFromReader(IDataReader reader)
{
try
{
CUSTOMERACCOUNT cUSTOMERACCOUNT = new CUSTOMERACCOUNT
(
(int)reader["CUSTOMERACCOUNTID"],
reader["ACCOUNTNO"].ToString(),
(int)reader["SERVICEID"],
(int)reader["CUST_ID"]
);
return(cUSTOMERACCOUNT);
}
catch (Exception ex)
{
return(null);
}
}
public static bool UpdateCUSTOMERACCOUNT(CUSTOMERACCOUNT cUSTOMERACCOUNT)
{
SqlCUSTOMERACCOUNTProvider sqlCUSTOMERACCOUNTProvider = new SqlCUSTOMERACCOUNTProvider();
return(sqlCUSTOMERACCOUNTProvider.UpdateCUSTOMERACCOUNT(cUSTOMERACCOUNT));
}
public static int InsertCUSTOMERACCOUNT(CUSTOMERACCOUNT cUSTOMERACCOUNT)
{
SqlCUSTOMERACCOUNTProvider sqlCUSTOMERACCOUNTProvider = new SqlCUSTOMERACCOUNTProvider();
return(sqlCUSTOMERACCOUNTProvider.InsertCUSTOMERACCOUNT(cUSTOMERACCOUNT));
}
