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();
}
}
