/// <summary>
/// Delete Street Light Owner from Database
/// </summary>
/// <param name="stltOwner"></param>
public void DelStreetLightOwner(StreetLightOwner stltOwner)
{
string sqlStmt = "Delete From STLT_OWNER_VL Where OWNER_CODE='{0}'";
sqlStmt = string.Format(sqlStmt, stltOwner.OwnerCode);
CommonUtil.Execute(sqlStmt);
}
/// <summary>
/// Update Street Light Owner
/// </summary>
/// <param name="stltOwner"></param>
public void UpdStreetLightOwner(StreetLightOwner stltOwner)
{
string sqlStmt = "Update STLT_OWNER_VL set OWNER_CODE='{0}',OWNER_NAME='{1}' Where OWNER_CODE='{2}'";
sqlStmt = string.Format(sqlStmt, stltOwner.OwnerCode, stltOwner.OwnerName, stltOwner.PrevOwnerCodeVal);
CommonUtil.Execute(sqlStmt);
}
/// <summary>
/// Insert Street Light Owner
/// </summary>
/// <param name="stltOwner"></param>
public void InsStreetLightOwner(StreetLightOwner stltOwner)
{
string sqlStmt = "Insert into STLT_OWNER_VL(OWNER_CODE,OWNER_NAME) " +
"values('{0}','{1}')";
sqlStmt = string.Format(sqlStmt, stltOwner.OwnerCode, stltOwner.OwnerName);
CommonUtil.Execute(sqlStmt);
}
/// <summary>
/// Persist Street Light Owner into Database
/// </summary>
/// <param name="stltOwner"></param>
public void SaveStreetLightOwner(StreetLightOwner stltOwner)
{
if (stltOwner.EntityState == EntityMode.Add)
{
InsStreetLightOwner(stltOwner);
}
if (stltOwner.EntityState == EntityMode.Update)
{
UpdStreetLightOwner(stltOwner);
}
if (stltOwner.EntityState == EntityMode.Delete)
{
DelStreetLightOwner(stltOwner);
}
}
