public int InsertPRODUCTMASTER(PRODUCTMASTER pRODUCTMASTER)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("AbiMatuEnterprise_InsertPRODUCTMASTER", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@PRODUCTMASTERID", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.Parameters.Add("@PROD_NAME", SqlDbType.VarChar).Value = pRODUCTMASTER.PROD_NAME;
cmd.Parameters.Add("@PROD_DESC", SqlDbType.VarChar).Value = pRODUCTMASTER.PROD_DESC;
cmd.Parameters.Add("@SUPPLIERID", SqlDbType.Int).Value = pRODUCTMASTER.SUPPLIERID;
cmd.Parameters.Add("@PROD_UPCCODE", SqlDbType.VarChar).Value = pRODUCTMASTER.PROD_UPCCODE;
cmd.Parameters.Add("@PROD_RETAILPRICE", SqlDbType.Int).Value = pRODUCTMASTER.PROD_RETAILPRICE;
cmd.Parameters.Add("@PROD_STOCKINHAND", SqlDbType.Int).Value = pRODUCTMASTER.PROD_STOCKINHAND;
cmd.Parameters.Add("@PROD_REORDERLEVEL", SqlDbType.Int).Value = pRODUCTMASTER.PROD_REORDERLEVEL;
cmd.Parameters.Add("@CREATED_ON", SqlDbType.DateTime).Value = pRODUCTMASTER.CREATED_ON;
cmd.Parameters.Add("@CREATED_BY", SqlDbType.VarChar).Value = pRODUCTMASTER.CREATED_BY;
cmd.Parameters.Add("@UPDATED_ON", SqlDbType.DateTime).Value = pRODUCTMASTER.UPDATED_ON;
cmd.Parameters.Add("@UPDATED_BY", SqlDbType.VarChar).Value = pRODUCTMASTER.UPDATED_BY;
cmd.Parameters.Add("@IS_TAXABLE", SqlDbType.Char).Value = pRODUCTMASTER.IS_TAXABLE;
cmd.Parameters.Add("@PROD_COSTPRICE", SqlDbType.Int).Value = pRODUCTMASTER.PROD_COSTPRICE;
cmd.Parameters.Add("@DEPT_ID", SqlDbType.Int).Value = pRODUCTMASTER.DEPT_ID;
cmd.Parameters.Add("@AGENTID", SqlDbType.Int).Value = pRODUCTMASTER.AGENTID;
connection.Open();
int result = cmd.ExecuteNonQuery();
return((int)cmd.Parameters["@PRODUCTMASTERID"].Value);
}
}
public static PRODUCTMASTER GetPRODUCTMASTERByID(int id)
{
PRODUCTMASTER pRODUCTMASTER = new PRODUCTMASTER();
SqlPRODUCTMASTERProvider sqlPRODUCTMASTERProvider = new SqlPRODUCTMASTERProvider();
pRODUCTMASTER = sqlPRODUCTMASTERProvider.GetPRODUCTMASTERByID(id);
return(pRODUCTMASTER);
}
public static bool UpdatePRODUCTMASTER(PRODUCTMASTER pRODUCTMASTER)
{
SqlPRODUCTMASTERProvider sqlPRODUCTMASTERProvider = new SqlPRODUCTMASTERProvider();
return(sqlPRODUCTMASTERProvider.UpdatePRODUCTMASTER(pRODUCTMASTER));
}
public static int InsertPRODUCTMASTER(PRODUCTMASTER pRODUCTMASTER)
{
SqlPRODUCTMASTERProvider sqlPRODUCTMASTERProvider = new SqlPRODUCTMASTERProvider();
return(sqlPRODUCTMASTERProvider.InsertPRODUCTMASTER(pRODUCTMASTER));
}
