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