public void SaveChargeInfo(ChargeInfoBO objBO) { string QueryString = ""; QueryString = @"INSERT INTO dbo.SBP_Transaction_ChargeInfo ( [ChargeName] , [ChargeDesc] ) VALUES (" + "'" + objBO.Charge_Name + "'" + ",'" + objBO.Charge_Desc + "'" + ")"; try { _dbConnection.ConnectDatabase(); _dbConnection.ExecuteNonQuery(QueryString); } catch (Exception ex) { throw ex; } finally { _dbConnection.CloseDatabase(); } }
public void SaveChargeDetailsInfo(ChargeInfoBO objBO) { string QueryString = ""; QueryString = @"INSERT INTO SBP_Transaction_ChargeDetails ( [Charge_ID] , [Charge_Name] , [Minimum_Effective_Amount] , [Charge_Rate] , [Charge_Amount] ) VALUES (" + objBO.ChargeId + ",'" + objBO.Charge_Name + "'" + "," + objBO.Min_Effective_Amount + "," + objBO.Charge_Rate + "," + objBO.Charge_Amount + ")"; try { _dbConnection.ConnectDatabase(); _dbConnection.ExecuteNonQuery(QueryString); } catch (Exception ex) { throw ex; } finally { _dbConnection.CloseDatabase(); } }
public void UpdateChargeInfo(ChargeInfoBO objBO, int chargeId) { string query = @"UPDATE SBP_Transaction_ChargeInfo SET ChargeName='" + objBO.Charge_Name + "'" + ", ChargeDesc='" + objBO.Charge_Desc + "'" + " WHERE ID=" + chargeId; try { _dbConnection.ConnectDatabase(); _dbConnection.ExecuteNonQuery(query); } catch (Exception ex) { throw ex; } finally { _dbConnection.CloseDatabase(); } }
public void UpdateChargeDetailsInfo(ChargeInfoBO objBO, int chargeDetaisId) { string query = @"UPDATE SBP_Transaction_ChargeDetails SET Charge_Name='" + objBO.Charge_Name + "'" + ", Charge_ID=" + objBO.ChargeId + ", Minimum_Effective_Amount=" + objBO.Min_Effective_Amount + ", Charge_Rate=" + objBO.Charge_Rate + ", Charge_Amount=" + objBO.Charge_Amount + " WHERE ID=" + chargeDetaisId; try { _dbConnection.ConnectDatabase(); _dbConnection.ExecuteNonQuery(query); } catch (Exception ex) { throw ex; } finally { _dbConnection.CloseDatabase(); } }