public bool Remove(GeneralCharge data) { 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(data, 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(GeneralCharge data, SqlConnection oConn) { string sql = "DELETE FROM GeneralCharges " + " WHERE (GChargeId = @id)"; sql = String.Format(sql, data.GChargeId); SqlCommand cmd = new SqlCommand(sql, oConn); cmd.Parameters.Add("@id", SqlDbType.Int).Value = data.GChargeId; int number = Convert.ToInt32(cmd.ExecuteNonQuery()); if (number > 0) { return(true); } return(false); }
public GeneralCharge Get(int id) { 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; }; GeneralCharge data = Get(id, oConn); ConnManager.CloseConn(oConn); return(data); }
public GeneralCharge Add(GeneralCharge data) { 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 GeneralCharges ({0}) VALUES ({1}) " + "SELECT SCOPE_IDENTITY()"; EnumExtension.setListValues(data, "GChargeId", 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; } GeneralCharge returnData = Get(keyGenerated, oConn); ConnManager.CloseConn(oConn); return(returnData); }
private void loadGeneralCharges(QuoteHeader data) { var list = chargesDescRepo.GetList(); if (list.Count == 0) { return; } foreach (var item in list) { var gcharge = new GeneralCharge(); gcharge.ChargeDescId = item.ChargeDescId; gcharge.QHeaderId = data.QHeaderId; gcharge.GChargeFactor = item.ChargeDefaultFactor; gcharge.GChargeCreatedDate = data.QHeaderCreatedDate; gcharge.GChargeCreatedBy = data.QHeaderCreatedBy; generalChargesRepo.Add(gcharge); } }
public GeneralCharge Update(GeneralCharge data) { 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 = "UPDATE GeneralCharges SET {0} WHERE GChargeId = @id"; EnumExtension.setUpdateValues(data, "GChargeId", ref sql); SqlCommand cmd = new SqlCommand(sql, oConn); cmd.Parameters.Add("@id", SqlDbType.Int).Value = data.GChargeId; 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; } GeneralCharge returnData = Get(data.GChargeId, oConn); ConnManager.CloseConn(oConn); return(returnData); }