/// <summary>
/// Delete Street Light Account from Database
/// </summary>
/// <param name="streetLightAct"></param>
private void DeleteStreetLightAccount(StreetLightAccount streetLightAct)
{
string sqlStmt = "Delete From STLT_ACCOUNT Where ESI_LOCATION='{0}'";
sqlStmt = string.Format(sqlStmt, streetLightAct.ESI_LOCATION);
CommonUtil.Execute(sqlStmt);
}
/// <summary>
/// Update Street light Account
/// </summary>
/// <param name="streetLightAct"></param>
private void UpdateStreetLightAccount(StreetLightAccount streetLightAct)
{
string sqlStmt = "Update STLT_ACCOUNT set BILLABLE='{0}',DESCRIPTION_ID=(SELECT DESCRIPTION_ID FROM STLT_DESC_VL WHERE DESCRIPTION='{1}'),OWNER_CODE='{2}',THRESHOLD_PERCENT={3},THRESHOLD_OVERRIDE='{4}',BOUNDARY_CLASS={5}, BOUNDARY_ID='{6}'" +
", RESTRICTED='{7}' where ESI_LOCATION='{8}'";
sqlStmt = string.Format(sqlStmt, CommonUtil.ConvertBoolToYN(streetLightAct.Billable), streetLightAct.Description, streetLightAct.OWNER_CODE, streetLightAct.THRESHOLD_PERCENT,
CommonUtil.ConvertBoolToYN(streetLightAct.THRESHOLD_OVERRIDE), string.IsNullOrEmpty(streetLightAct.BOUNDARY_CLASS) ? "NULL" : streetLightAct.BOUNDARY_CLASS, streetLightAct.BOUNDARY_ID, CommonUtil.ConvertBoolToYN(streetLightAct.Restricted), streetLightAct.ESI_LOCATION);
CommonUtil.Execute(sqlStmt);
}
/// <summary>
/// Load Street Lights assigned to given street light account
/// </summary>
/// <param name="stltAccount"></param>
public void LoadStreetLight(StreetLightAccount stltAccount)
{
if (stltAccount.MiscStructFid == default(int) && string.IsNullOrEmpty(stltAccount.BOUNDARY_CLASS))
{
dtGridViewNonLocated.AllowUserToAddRows = false;
}
this.streetLightAcct = stltAccount;
this.streetLights = stltNonLocatedCtx.GetStreetLightByAccountID(stltAccount.ESI_LOCATION);
dtGridViewNonLocated.DataSource = this.streetLights;
//Change btnstructure text
btnStructure.Text = (stltAccount.MiscStructFid == default(int)) ? "Place Structure" : "Locate Structue";
txtStreetLightAcct.Text = "ESI Location:" + stltAccount.ESI_LOCATION + "," + stltAccount.Wattage + "," + stltAccount.LAMP_TYPE + "," + stltAccount.LUMINARE_STYLE;
}
/// <summary>
/// Insert Street Light Account into Database
/// </summary>
/// <param name="streetLightAct"></param>
private void InsertStreetLightAccount(StreetLightAccount streetLightAct)
{
string sqlStmt = "Insert into STLT_ACCOUNT(ESI_LOCATION, BILLABLE, DESCRIPTION_ID, OWNER_CODE, WATTAGE, LAMP_TYPE, LUMINARE_STYLE," +
" RATE_SCHEDULE, RATE_CODE,THRESHOLD_PERCENT,THRESHOLD_OVERRIDE,BOUNDARY_CLASS, BOUNDARY_ID, RESTRICTED,MISC_STRUCT_FID) " +
"values('{0}','{1}',(SELECT DESCRIPTION_ID FROM STLT_DESC_VL WHERE DESCRIPTION='{2}'),'{3}','{4}','{5}','{6}','{7}'," +
" '{8}',{9},'{10}',{11},'{12}','{13}',{14})";
sqlStmt = string.Format(sqlStmt, streetLightAct.ESI_LOCATION, CommonUtil.ConvertBoolToYN(streetLightAct.Billable), streetLightAct.Description, streetLightAct.OWNER_CODE, streetLightAct.Wattage, streetLightAct.LAMP_TYPE, streetLightAct.LUMINARE_STYLE
, streetLightAct.RATE_SCHEDULE, streetLightAct.RATE_CODE, streetLightAct.THRESHOLD_PERCENT, CommonUtil.ConvertBoolToYN(streetLightAct.THRESHOLD_OVERRIDE)
, string.IsNullOrEmpty(streetLightAct.BOUNDARY_CLASS)? "NULL": streetLightAct.BOUNDARY_CLASS, streetLightAct.BOUNDARY_ID, CommonUtil.ConvertBoolToYN(streetLightAct.Restricted), streetLightAct.MiscStructFid);
CommonUtil.Execute(sqlStmt);
}
/// <summary>
/// Persist Street Light Account into Datbase
/// </summary>
/// <param name="act"></param>
public void SaveStreetLightAcct(StreetLightAccount act)
{
if (act.EntityState == EntityMode.Add)
{
InsertStreetLightAccount(act);
}
if (act.EntityState == EntityMode.Update)
{
UpdateStreetLightAccount(act);
}
if (act.EntityState == EntityMode.Delete)
{
DeleteStreetLightAccount(act);
}
}
/// <summary>
///
/// </summary>
private void CleanUp()
{
SubscribEvents(false);
if (_gtFeatureExplorerSrvc != null)
{
_gtFeatureExplorerSrvc.Clear();
_gtFeatureExplorerSrvc.Dispose();
_gtFeatureExplorerSrvc = null;
}
if (_gtPlacementSrvc != null)
{
_gtPlacementSrvc.Dispose();
_gtPlacementSrvc = null;
}
streetLights = null;
if (stltNonLocatedCtx != null)
{
stltNonLocatedCtx.Dispose();
}
stltNonLocatedCtx = null;
streetLightAcct = null;
_gtKeyObj = null;
_gtKeyEditObj = null;
}
