/// <summary>
/// Delete Street Light Rate code from Database
/// </summary>
/// <param name="stltRateCode"></param>
private void DelStreetLightRateCode(StreetLightRateCode stltRateCode)
{
string sqlStmt = "Delete From STLT_RATECODE_VL Where RATE_CODE='{0}'";
sqlStmt = string.Format(sqlStmt, stltRateCode.RateCode);
CommonUtil.Execute(sqlStmt);
}
/// <summary>
/// Insert Street Light Rate code
/// </summary>
/// <param name="stltRateCode"></param>
private void InsStreetLightRateCode(StreetLightRateCode stltRateCode)
{
string sqlStmt = "Insert into STLT_RATECODE_VL(RATE_CODE) values('{0}')";
sqlStmt = string.Format(sqlStmt, stltRateCode.RateCode);
CommonUtil.Execute(sqlStmt);
}
/// <summary>
/// Update Street Light Rate code
/// </summary>
/// <param name="stltRateCode"></param>
private void UpdStreetLightRateCode(StreetLightRateCode stltRateCode)
{
string sqlStmt = "Update STLT_RATECODE_VL set RATE_CODE='{0}' Where RATE_CODE='{1}'";
sqlStmt = string.Format(sqlStmt, stltRateCode.RateCode, stltRateCode.PrevRateCodeVal);
CommonUtil.Execute(sqlStmt);
}
/// <summary>
/// Persist Street Light Rate Code into database
/// </summary>
/// <param name="stltRateCode"></param>
public void SaveStreetLightRateCode(StreetLightRateCode stltRateCode)
{
if (stltRateCode.EntityState == EntityMode.Add)
{
InsStreetLightRateCode(stltRateCode);
}
if (stltRateCode.EntityState == EntityMode.Update)
{
UpdStreetLightRateCode(stltRateCode);
}
if (stltRateCode.EntityState == EntityMode.Delete)
{
DelStreetLightRateCode(stltRateCode);
}
}
