public int UpdateChargeConfiguration(ChargeConfigurationEntity oChargeConfigurationEntity)
{
con = oConnectionDatabase.DatabaseConnection();
int i = 0;
cmd = new SqlCommand("UPDATE tblChargeConfiguration SET ChargeConfigurationDetails='" + oChargeConfigurationEntity.ChargeConfigurationDetails + "',ChargeCategoryCode='" + oChargeConfigurationEntity.ChargeCategoryCode + "',ChargeCRemarks='" + oChargeConfigurationEntity.ChargeCRemarks + "',ChargeCode='" + oChargeConfigurationEntity.ChargeCode + "',ChargeCLastModifiedBy='" + oChargeConfigurationEntity.ChargeCLastModifiedBy + "' WHERE ChargeConfigurationID=" + oChargeConfigurationEntity.ChargeConfigurationID, con);
try
{
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
i = 1;
}
catch { }
con.Close();
return(i);
}
public int DeleteChargeConfiguration(ChargeConfigurationEntity oChargeConfigurationEntity)
{
con = oConnectionDatabase.DatabaseConnection();
int i = 0;
cmd = new SqlCommand("DELETE FROM tblChargeConfiguration WHERE ChargeConfigurationID=" + oChargeConfigurationEntity.ChargeConfigurationID, con);
try
{
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
i = 1;
}
catch { }
con.Close();
return(i);
}
public int InsertChargeConfiguration(ChargeConfigurationEntity oChargeConfigurationEntity)
{
con = oConnectionDatabase.DatabaseConnection();
int i = 0;
cmd = new SqlCommand("INSERT INTO tblChargeConfiguration (ChargeCategoryCode,ChargeConfigurationDetails,ChargeCode,ChargeCRemarks,ChargeCCreatedBy,ChargeCLastModifiedBy) VALUES('" + oChargeConfigurationEntity.ChargeCategoryCode + "','" + oChargeConfigurationEntity.ChargeConfigurationDetails + "','" + oChargeConfigurationEntity.ChargeCode + "','" + oChargeConfigurationEntity.ChargeCRemarks + "','" + oChargeConfigurationEntity.ChargeCCreatedBy + "','" + oChargeConfigurationEntity.ChargeCLastModifiedBy + "')", con);
try
{
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
i = 1;
}
catch { }
con.Close();
return(i);
}
