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