public static MOMASTER GetMOMASTERByID(int id)
{
MOMASTER mOMASTER = new MOMASTER();
SqlMOMASTERProvider sqlMOMASTERProvider = new SqlMOMASTERProvider();
mOMASTER = sqlMOMASTERProvider.GetMOMASTERByID(id);
return(mOMASTER);
}
public int InsertMOMASTER(MOMASTER mOMASTER)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("AbiMatuEnterprise_InsertMOMASTER", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@MOMASTERID", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.Parameters.Add("@AGENTID", SqlDbType.Int).Value = mOMASTER.AGENTID;
cmd.Parameters.Add("@STARTMO", SqlDbType.Int).Value = mOMASTER.STARTMO;
cmd.Parameters.Add("@ENDMO", SqlDbType.Int).Value = mOMASTER.ENDMO;
cmd.Parameters.Add("@CURRMO", SqlDbType.Int).Value = mOMASTER.CURRMO;
connection.Open();
int result = cmd.ExecuteNonQuery();
return((int)cmd.Parameters["@MOMASTERID"].Value);
}
}
public MOMASTER GetMOMASTERFromReader(IDataReader reader)
{
try
{
MOMASTER mOMASTER = new MOMASTER
(
(int)reader["MOMASTERID"],
(int)reader["AGENTID"],
(int)reader["STARTMO"],
(int)reader["ENDMO"],
(int)reader["CURRMO"]
);
return(mOMASTER);
}
catch (Exception ex)
{
return(null);
}
}
public static bool UpdateMOMASTER(MOMASTER mOMASTER)
{
SqlMOMASTERProvider sqlMOMASTERProvider = new SqlMOMASTERProvider();
return(sqlMOMASTERProvider.UpdateMOMASTER(mOMASTER));
}
public static int InsertMOMASTER(MOMASTER mOMASTER)
{
SqlMOMASTERProvider sqlMOMASTERProvider = new SqlMOMASTERProvider();
return(sqlMOMASTERProvider.InsertMOMASTER(mOMASTER));
}
