public bool Remove(VendorCategory model) { SqlConnection oConn = null; try { oConn = ConnManager.OpenConn(); } catch (Exception ex) { LogManager.Write("ERROR:" + Environment.NewLine + "\tMETHOD = " + this.GetType().FullName + "." + MethodBase.GetCurrentMethod().Name + Environment.NewLine + "\tMESSAGE = " + ex.Message); throw; }; bool result; try { result = Remove(model, oConn); } catch (Exception ex) { ConnManager.CloseConn(oConn); LogManager.Write("ERROR:" + Environment.NewLine + "\tMETHOD = " + this.GetType().FullName + "." + MethodBase.GetCurrentMethod().Name + Environment.NewLine + "\tMESSAGE = " + ex.Message); throw; } ConnManager.CloseConn(oConn); return(result); }
private bool Remove(VendorCategory model, SqlConnection oConn) { string sql = "DELETE FROM VendorCategories WHERE (VendorCategoryKey = @key)"; SqlCommand cmd = new SqlCommand(sql, oConn); cmd.Parameters.Add("@key", SqlDbType.Int).Value = model.VendorCategoryKey; int number = Convert.ToInt32(cmd.ExecuteNonQuery()); if (number > 0) { return(true); } return(false); }
public VendorCategory Update(VendorCategory model) { SqlConnection oConn = null; try { oConn = ConnManager.OpenConn(); } catch (Exception ex) { LogManager.Write("ERROR:" + Environment.NewLine + "\tMETHOD = " + this.GetType().FullName + "." + MethodBase.GetCurrentMethod().Name + Environment.NewLine + "\tMESSAGE = " + ex.Message); throw; }; var oldData = Get(model.VendorCategoryKey, oConn); string sql = "UPDATE VendorCategories SET {0} WHERE VendorCategoryKey = @key"; EnumExtension.setUpdateValues(model, "VendorCategoryKey", ref sql); SqlCommand cmd = new SqlCommand(sql, oConn); cmd.Parameters.Add("@key", SqlDbType.Int).Value = model.VendorCategoryKey; try { cmd.ExecuteNonQuery(); } catch (Exception ex) { ConnManager.CloseConn(oConn); LogManager.Write("ERROR:" + Environment.NewLine + "\tMETHOD = " + this.GetType().FullName + "." + MethodBase.GetCurrentMethod().Name + Environment.NewLine + "\tMESSAGE = " + ex.Message); throw; } var returnData = Get(model.VendorCategoryKey, oConn); ConnManager.CloseConn(oConn); return(returnData); }
public VendorCategory Add(VendorCategory model) { SqlConnection oConn = null; try { oConn = ConnManager.OpenConn(); } catch (Exception ex) { LogManager.Write("ERROR:" + Environment.NewLine + "\tMETHOD = " + this.GetType().FullName + "." + MethodBase.GetCurrentMethod().Name + Environment.NewLine + "\tMESSAGE = " + ex.Message); throw; }; string sql = "INSERT INTO VendorCategories ({0}) VALUES ({1}) " + "SELECT SCOPE_IDENTITY()"; EnumExtension.setListValues(model, "VendorCategoryKey", ref sql); SqlCommand cmd = new SqlCommand(sql, oConn); int keyGenerated = 0; try { keyGenerated = Convert.ToInt32(cmd.ExecuteScalar()); } catch (Exception ex) { ConnManager.CloseConn(oConn); LogManager.Write("ERROR:" + Environment.NewLine + "\tMETHOD = " + this.GetType().FullName + "." + MethodBase.GetCurrentMethod().Name + Environment.NewLine + "\tMESSAGE = " + ex.Message); throw; } var returnData = Get(keyGenerated, oConn); ConnManager.CloseConn(oConn); return(returnData); }