public string Delete(ProductType oProductType, int nUserID) { string sReturnMessage = ""; Connection.Open(); Command.CommandText = ProductTypeDA.IUD(oProductType, EnumDBOperation.Delete, nUserID); try { Command.ExecuteNonQuery(); } catch (Exception e) { sReturnMessage = e.Message.Split('~')[0]; } Connection.Close(); return(sReturnMessage); }
public ProductType IUD(ProductType oProductType, EnumDBOperation eDBAction, int nUserID) { Connection.Open(); Command.CommandText = ProductTypeDA.IUD(oProductType, eDBAction, nUserID); SqlDataReader reader = Command.ExecuteReader(); ProductType _oProductType = new ProductType(); if (reader.HasRows) { _oProductType = MakeObject(reader); } reader.Close(); Connection.Close(); return(_oProductType); }