protected void Page_LoadComplete(object sender, EventArgs e)
{
CurrentUser cuser = new CurrentUser();
cuser.userName = "******";
cuser.Load();
string tiercode = Request.QueryString["tiercode"];
string deptcode = Request.QueryString["deptcode"];
string sitecode = Request.QueryString["sitecode"];
string panelcode = Request.QueryString["panelcode"];
string devicecode = Request.QueryString["devicecode"];
string fromdate = Request.QueryString["fdate"];
string todate = Request.QueryString["tdate"];
tbl_alarm_time_details alarmDet = new tbl_alarm_time_details(cuser);
IntelWebField tierFld = alarmDet.Field("tier_code");
tierFld.fieldValue = tiercode;
IntelWebField deptFld = alarmDet.Field("department_code");
deptFld.fieldValue = deptcode;
IntelWebField siteFld = alarmDet.Field("site_code");
siteFld.fieldValue = sitecode;
IntelWebField panelFld = alarmDet.Field("panel_code");
panelFld.fieldValue = panelcode;
IntelWebField deviceFld = alarmDet.Field("alarm_device_code");
deviceFld.fieldValue = devicecode;
IntelWebField fdateFld = new IntelWebField("todate", OleDbType.DBDate, 10, 10, 0, DataRowVersion.Current, false, fromdate);
IntelWebField tdateFld = new IntelWebField("todate", OleDbType.DBDate, 10, 10, 0, DataRowVersion.Current, false, todate);
List<IntelWebField> bparam = new List<IntelWebField>();
bparam.Add(tierFld);
bparam.Add(deptFld);
bparam.Add(siteFld);
bparam.Add(panelFld);
bparam.Add(deviceFld);
bparam.Add(fdateFld);
bparam.Add(tdateFld);
List<IntelWebObject> alarmDets = alarmDet.Load("tier_code=? and department_code=? and site_code=? and panel_code=? and alarm_device_code=? and alarm_date between ? and ?", "alarm_date,alarm_time", bparam);
if (alarmDets.Count > 0)
{
StringBuilder sb = new StringBuilder();
sb.Append("<table style=\"width:100%;\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\" class=\"webgrid\"><thead class=\"titlegrid\"><tr><th>Device</th><th>Alarm Date</th><th>Alarm Hour</th><th>Alaram Time</th><th>Alarm Details</th><th>Alarm Comment</th></tr>");
int rowCnt = 0;
foreach (tbl_alarm_time_details alarm in alarmDets)
{
string trclass = (rowCnt % 2 == 0 ? "" : " class=\"gridodd\" ");
sb.Append("<tr" + trclass + "><td>" + HttpUtility.HtmlEncode(alarm.alarm_device_code) + "</td><td>" + HttpUtility.HtmlEncode(alarm.alarm_date.ToString("MM/dd/yyyy")) + "</td><td>" + HttpUtility.HtmlEncode(alarm.alarm_hour) + "</td><td>" + HttpUtility.HtmlEncode(alarm.alarm_time) + "</td><td>" + HttpUtility.HtmlEncode(alarm.alarm_details) + "</td><td>" + HttpUtility.HtmlEncode(alarm.alarm_comment) + "</td></tr>");
rowCnt++;
}
sb.Append("</table>");
Response.Write(sb.ToString());
}
else
{
Response.Write("There are no details found.");
}
}
public DeptGrid(NameValueCollection form, ControlCollection controls, CurrentUser user)
{
grid = new WebGrid("lkup_department", user, "deptGrid");
grid.objectId = "lkup_department";
grid.form = form;
grid.controls = controls;
grid.fields.Add(new DisplayField(grid, "department_code", "Dept Code", null, true, "department_code"));
grid.fields.Add(new DisplayField(grid, "department_code_description", "Dept Description", null, true, "department_code_description"));
grid.fields.Add(new DisplayField(grid, "first_name", "Contact Name", null, true, "first_name"));
grid.fields.Add(new DisplayField(grid, "last_name", "Last Name", null, false, "last_name"));
}
protected void Page_LoadComplete(object sender, EventArgs e)
{
CurrentUser cuser = new CurrentUser();
cuser.userName = "******";
cuser.Load();
string tiercode = Request.QueryString["tiercode"];
string deptcode = Request.QueryString["deptcode"];
string sitecode = Request.QueryString["sitecode"];
string fromdate = Request.QueryString["fdate"];
string todate = Request.QueryString["tdate"];
tbl_alarm_time_details alarmDet = new tbl_alarm_time_details(cuser);
IntelWebField tierFld = alarmDet.Field("tier_code");
tierFld.fieldValue = tiercode;
IntelWebField deptFld = alarmDet.Field("department_code");
deptFld.fieldValue = deptcode;
IntelWebField siteFld = alarmDet.Field("site_code");
siteFld.fieldValue = sitecode;
IntelWebField fdateFld = new IntelWebField("todate", OleDbType.DBDate, 10, 10, 0, DataRowVersion.Current, false, fromdate);
IntelWebField tdateFld = new IntelWebField("todate", OleDbType.DBDate, 10, 10, 0, DataRowVersion.Current, false, todate);
List<IntelWebField> bparam = new List<IntelWebField>();
bparam.Add(tierFld);
bparam.Add(deptFld);
bparam.Add(siteFld);
bparam.Add(fdateFld);
bparam.Add(tdateFld);
List<IntelWebObject> alarmDets = alarmDet.Load("tier_code=? and department_code=? and site_code=? and alarm_date between ? and ?", "panel_code", bparam);
if (alarmDets.Count > 0)
{
StringBuilder sb = new StringBuilder();
/* Panels Table */
sb.Append("<table><tr>");
var distPanels = alarmDets.Select(x => x.Field("panel_code").fieldValue ?? "").Distinct();
foreach (string panel in distPanels)
{
sb.Append("<td>" + AlaramDeviceHTML(sitecode, panel, alarmDets) + "</td>");
}
sb.Append("</tr></table>");
Response.Write(sb.ToString());
}
else
{
Response.Write("There are no details found.");
}
}
public SiteGrid(NameValueCollection form, ControlCollection controls, CurrentUser user)
{
grid = new WebGrid("lkup_site", user, "siteGrid");
grid.objectId = "lkup_site";
grid.form = form;
grid.controls = controls;
grid.fields.Add(new DisplayField(grid, "department_code", "Dept Code", null, true, "department_code"));
grid.fields.Add(new DisplayField(grid, "site_code", "Site Code", null, true, "site_code"));
grid.fields.Add(new DisplayField(grid, "site_code_description", "Site Description", null, true, "site_code_description"));
grid.fields.Add(new DisplayField(grid, "building_name", "Building Name", null, true, "building_name"));
grid.fields.Add(new DisplayField(grid, "facility_contact", "Facility Contact", null, true, "facility_contact"));
grid.fields.Add(new DisplayField(grid, "address1", "Address1", null, false, "address1"));
grid.fields.Add(new DisplayField(grid, "address2", "Address2", null, false, "address2"));
grid.fields.Add(new DisplayField(grid, "city", "City", null, true, "city"));
grid.fields.Add(new DisplayField(grid, "state_code", "State", null, true, "state_code"));
grid.fields.Add(new DisplayField(grid, "zip_code", "Zip", null, false, "zip_code"));
grid.fields.Add(new DisplayField(grid, "country_code", "Country", null, true, "country_code"));
grid.fields.Add(new DisplayField(grid, "mobile_number", "Cell", null, false, "mobile_number"));
grid.fields.Add(new DisplayField(grid, "land_number", "Home", null, false, "land_number"));
grid.fields.Add(new DisplayField(grid, "fax_number", "Fax", null, false, "fax_number"));
grid.fields.Add(new DisplayField(grid, "email_id", "EMail", null, false, "email_id"));
}
public tbl_alarm_time_details(CurrentUser oUser, List<IntelWebField> oselectFieldsList, bool _internalFlag_LoadingFromDataSet)
{
base.loadObjectDefaults = _internalFlag_LoadingFromDataSet;
Initialize(oUser);
base.selectFieldsList = oselectFieldsList;
}
public lkup_panel(CurrentUser oUser)
{
Initialize(oUser);
}
private void Initialize(CurrentUser oUser)
{
base.User = oUser;
base.primaryKey = new IntelWebField("panel_id", System.Data.OleDb.OleDbType.Integer, 0, 10, 0, DataRowVersion.Current, false, null);
base.FieldList = this.myFields();
base.tableName = "lkup_panel";
}
public static WebGridController ControllerFromName(string name, NameValueCollection form, ControlCollection controls, CurrentUser user)
{
WebGridController result;
switch (name)
{
case "lkup_department":
result = new DeptGrid(form, controls, user);
return result;
case "lkup_site":
result = new SiteGrid(form, controls, user);
return result;
default:
break;
}
return null;
}
public lkup_site(CurrentUser oUser)
{
Initialize(oUser);
}
public lkup_alarm_device(CurrentUser oUser)
{
Initialize(oUser);
}
protected void Page_LoadComplete(object sender, EventArgs e)
{
CurrentUser cuser = new CurrentUser();
cuser.userName = "******";
cuser.Load();
WebGridController siteGC = WebGridController.ControllerFromName("lkup_site", Request.Form, this.Form.Controls, cuser);
lkup_department lkupDept = new lkup_department(cuser);
List<IntelWebObject> lkupDepts = lkupDept.Load();
this.ltrDepts.Text = string.Join("", lkupDepts.Cast<lkup_department>().Select(x=>"<option value=\"" + HttpUtility.HtmlEncode(x.department_code) + "\">" + HttpUtility.HtmlEncode(x.department_code + " (" + x.department_code_description + ")") + "</option>").ToArray());
lkup_site lkupSite = new lkup_site(cuser);
List<IntelWebObject> lkupSites = lkupSite.Load("","department_code,site_code");
siteGC.grid.data = lkupSites;
siteGC.grid.uiFormShowJS = @"function(){
$('#divSiteEntry').dialog({width:750,modal:true,title:'Site/Building Info',close:function(){webGrid.removeNewItems()}});$('#site_code').focus();}";
siteGC.grid.afterSubmitJS = @"function(result,grid){
if(result.ok && result.gridInfos){
webGrid.mergeGridInfos(result.gridInfos);
webGrid.drawFilteredRows(grid,function(record){
if((typeof record.fields.markedforremoval != undefined) && !record.fields.markedforremoval){
return true;
}
return false;
});
if($('#divSiteEntry').is(':visible')){
try{
$('#divSiteEntry').dialog('close');
}
catch(ex){}
}
}
}";
siteGC.grid.uiFormName = "theform";
var gtable = new WebGridTable();
gtable.UIHeaderText = "Site / Building Information";
gtable.tableId = "tblFieldsId";
gtable.Grid = siteGC.grid;
var myButtonFunction = new Func<IntelWebObject, object>((obj) =>
{
return @"<a href=""javascript:void(0);"" title=""Edit Site"" onclick=""editSite([gridName],[recordIndex])"" ><img alt=""Edit"" title=""Edit Site"" src=""Images/table_edit.png""></a> <a href=""javascript:void(0);"" title=""Delete Site"" onclick=""delSite([gridName],[recordIndex])"" ><img title=""Delete Site"" src=""Images/delete.png"" alt=""delete""></a>";
});
gtable.extraColumns.Add(new WebGridTable.extraColumn()
{
fieldTemplate = new DisplayField()
{
submitField = false
,
fieldName = "EditButtons"
,
formatFunction = myButtonFunction
,
isHeaderField = true
,
jsFormatFunction = @"return '<a href=""javascript:void(0);"" title=""Edit Site"" onclick=""editSite([gridName],[recordIndex])"" ><img alt=""Edit"" title=""Edit Site"" src=""Images/table_edit.png""></a> <a href=""javascript:void(0);"" title=""Delete Site"" onclick=""delSite([gridName],[recordIndex])"" ><img title=""Delete Site"" src=""Images/delete.png"" alt=""delete""></a> '"
}
});
ltrGrid.Text = "<div class=\"centered\">" + gtable.tableUI() + "</div>";
ltrGridScript.Text = "<script type=\"text/javascript\">" + siteGC.grid.gridScript() + "</script>\n" + gtable.tableScript();
}
public JobQ(CurrentUser oUser, string selectFields)
{
Initialize(oUser);
base.selectFields = selectFields;
}
public JobQ(CurrentUser oUser)
{
Initialize(oUser);
}
public tbl_alarm_time_details(CurrentUser oUser, string selectFields)
{
Initialize(oUser);
base.selectFields = selectFields;
}
public tbl_alarm_time_details(CurrentUser oUser)
{
Initialize(oUser);
}
protected void Page_LoadComplete(object sender, EventArgs e)
{
CurrentUser cuser = new CurrentUser();
cuser.userName = "******";
cuser.Load();
string formTier = Request.Form["tiercode"] ?? "";
string formdept = Request.Form["deptcode"] ?? "";
string formfdate = Request.Form["fromdate"] ?? "";
string formtdate = Request.Form["todate"] ?? "";
// Testing
if (string.IsNullOrEmpty(formfdate)) formfdate = "04/01/2011";
if (string.IsNullOrEmpty(formtdate)) formtdate = "04/30/2011";
/*
* if (string.IsNullOrEmpty(formfdate)) formfdate = DateTime.Today.ToString("MM/dd/yyyy");
* if (string.IsNullOrEmpry(formtdate)) formtdate = DateTime.Today.AddMonths(1).ToString("MM/dd/yyyy");
*/
lkup_tier tier = new lkup_tier(cuser);
List<IntelWebObject> tiers = tier.Load();
this.ltrTiers.Text = "<option value=\"\"></option>" + string.Join("", tiers.Cast<lkup_tier>().Select(x=>"<option value=\"" + HttpUtility.HtmlEncode(x.tier_code) + "\" " + (formTier.Equals(x.tier_code)?"selected":"") + " >" + HttpUtility.HtmlEncode(x.tier_code) + "</option>").ToArray());
lkup_department lkupDept = new lkup_department(cuser);
List<IntelWebObject> lkupDepts = lkupDept.Load();
this.ltrDepts.Text = "<option value=\"\"></option>" + string.Join("", lkupDepts.Cast<lkup_department>().Select(x => "<option value=\"" + HttpUtility.HtmlEncode(x.department_code) + "\" " + (formdept.Equals(x.department_code)?"selected":"") + " >" + HttpUtility.HtmlEncode(x.department_code + " (" + x.department_code_description + ")") + "</option>").ToArray());
tbl_alarm_time_details alarmDet = new tbl_alarm_time_details(cuser);
List<IntelWebField> bparams = new List<IntelWebField>();
IntelWebField tierFld = alarmDet.Field("tier_code");
tierFld.fieldValue = formTier;
IntelWebField deptFld = alarmDet.Field("department_code");
deptFld.fieldValue = formdept;
IntelWebField fdateFld = new IntelWebField("todate", OleDbType.DBDate, 10, 10, 0, DataRowVersion.Current, false, formfdate);
IntelWebField tdateFld = new IntelWebField("todate", OleDbType.DBDate, 10, 10, 0, DataRowVersion.Current, false, formtdate);
bparams.Add(tierFld);
bparams.Add(deptFld);
bparams.Add(fdateFld);
bparams.Add(tdateFld);
List<IntelWebObject> alaramDets = alarmDet.Load("tier_code=? and department_code=? and alarm_date between ? and ?", "site_code,panel_code,alarm_device_code", bparams);
if (alaramDets.Count > 0)
{
var distSites = alaramDets.Select(x => x.Field("site_code").fieldValue ?? "").Distinct().ToList();
/* Distinct Sites get Address City, State, Country */
lkup_site lkupsite = new lkup_site(cuser);
bparams.Clear();
string qs = "";
foreach (string site in distSites)
{
qs += ("?,");
IntelWebField fld = new IntelWebField("site_code", OleDbType.VarChar, 50, 50, 0, DataRowVersion.Current, false, null);
fld.fieldValue = site;
bparams.Add(fld);
}
bparams.Add(IntelWebParameter.GetParam("deptcode", OleDbType.VarChar, 50, formdept));
if (qs.Length > 0) qs = qs.Substring(0, qs.Length - 1);
List<IntelWebObject> Sites = lkupsite.Load("(site_code in (" + qs + ") or department_code=?)and city is not null ", "city", bparams);
Dictionary<string, string> distCities = new Dictionary<string, string>();
foreach (lkup_site site in Sites)
{
string mapcity = site.city + (((site.state_code ?? "").Length > 0) ? "," + site.state_code.Trim() : "");
string siteDets = site.site_code + "\t" + site.address1 + "\t" + site.address2 + "\t" + site.city + "\t" + site.country_code;
if (distCities.ContainsKey(mapcity))
{
distCities[mapcity] = distCities[mapcity] + "\n" + siteDets;
}
else
{
distCities.Add(mapcity, siteDets);
}
}
string jsCities = "[";
foreach (string key in distCities.Keys)
{
jsCities += "{\"address\":\"" + key + "\",\"sitesHtml\":\"";
string[] arySites = distCities[key].Split('\n');
jsCities += "<table style=\\\"width:95%;\\\"><tr>";
foreach (string st in arySites)
{
string[] arySiteAddr = st.Split('\t');
jsCities += "<td>";
if (arySiteAddr.Length > 0)
{
jsCities += "<div><img style=\\\"cursor:pointer;\\\" onclick=\\\"showDiv(this, '" + arySiteAddr[0] + "');\\\" src=\'Images/house.png\' alt=\'site\' /> " + JSUtil.EnquoteJS(HttpUtility.HtmlEncode(arySiteAddr[0])) + " </div>";
}
if(arySiteAddr.Length > 3)
{
jsCities += "<div style=\\\"border:1px solid #999;padding:2px;white-space:nowrap;\\\"><div>" + JSUtil.EnquoteJS(HttpUtility.HtmlEncode(arySiteAddr[1])) + "</div><div>" + JSUtil.EnquoteJS(HttpUtility.HtmlEncode(arySiteAddr[2])) + "</div><div>" + JSUtil.EnquoteJS(HttpUtility.HtmlEncode(arySiteAddr[3] + " " + arySiteAddr[4])) + "</div></div>";
}
jsCities += "</td>";
//<br />" + st + "<br /> Peak:50 <br />Non-Peak:20</td>";
}
jsCities += "</tr></table>\"},";
}
if (distCities.Count > 0) jsCities = jsCities.Substring(0, jsCities.Length - 1);
jsCities += "];";
/* Map Script STARTS */
ltrMapScript.Text = @"<script type=""text/javascript"">
jsMapCities = " + jsCities + @"
jsFromDate = '" + formfdate + @"';
jsToDate = '" + formtdate + @"';
function mapInit(){
if (GBrowserIsCompatible()) {
var map = new GMap2(document.getElementById('map_canvas'));
map.addControl(new GLargeMapControl());
map.addControl(new GMapTypeControl());
map.addControl(new GOverviewMapControl());
map.enableScrollWheelZoom();
map.setCenter(new GLatLng(39, -93), 4);
map.setUIToDefault();
var bounds = new GLatLngBounds();
geocoder = new GClientGeocoder();
function createMarker(address, thtml, cnt){
// Creates the customized marker icon
var blueIcon = new GIcon(G_DEFAULT_ICON);
if(cnt % 2 == 0) {
blueIcon.image = ""http://iweb.vasbal.com/images/grn-pushpin.png"";
} else if(cnt % 3 == 0) {
blueIcon.image = ""http://iweb.vasbal.com/images/red-pushpin.png"";
} else {
blueIcon.image = ""http://iweb.vasbal.com/images/ylw-pushpin.png"";
}
blueIcon.iconSize = new GSize(32, 32);
// Set up our GMarkerOptions object
var markerOptions = { icon:blueIcon };
if(geocoder){
geocoder.getLatLng(address, function(point) {
if (point) {
var marker = new GMarker(point, markerOptions);
map.addOverlay(marker);
bounds.extend(marker.getPoint());
var mhtml = thtml;
var mklatlng = new GLatLng(marker.getPoint().lat(), marker.getPoint().lng());
GEvent.addListener(marker, ""click"", function () { map.openInfoWindowHtml(mklatlng, '<div>'+mhtml+'</div>'); });
GEvent.addListener(marker, ""mouseover"", function () { map.openInfoWindowHtml(mklatlng, '<div>'+mhtml+'</div>'); });
}
});
}
}
map.clearOverlays();
var cnt = 0;
for(var x in jsMapCities){
createMarker(jsMapCities[x].address, jsMapCities[x].sitesHtml, cnt);
cnt++;
}
}
}
</script>";
/* End Script */
}
else
{
ltrMessage.Text = @"<div class=""ui-widget"">
<div class=""ui-state-error ui-corner-all"" style=""width:70%;margin-left:200px;margin-top: 5px; padding: 0 .7em;"">
<p style=""height:35px;""><span class=""ui-icon ui-icon-alert"" style=""float: left; margin-right: .3em;""></span>
<strong>Alert:</strong>There are no alarm details found between selected date period.</p></div></div>";
ltrMapScript.Text = @"<script type=""text/javascript"">
function mapInit(){
if (GBrowserIsCompatible()) {
var map = new GMap2(document.getElementById('map_canvas'));
map.addControl(new GLargeMapControl());
map.addControl(new GMapTypeControl());
map.addControl(new GOverviewMapControl());
map.enableScrollWheelZoom();
map.setCenter(new GLatLng(39, -93), 4);
map.setUIToDefault();
}
}
</script>";
}
}
public WebGrid(string type, CurrentUser myUser, string myGridName)
{
this.User = myUser;
this.objectType = type;
_protoObject = this.User.protoObject(this.objectType);
_pkfield = _protoObject.primaryKey;
_gridName = myGridName;
}
public void doImport(bool preview)
{
if (!File.Exists(fullFileName))
{
error = new ImportError();
error.errorMessage = fullFileName + " does not exist.";
_importproblems.Add(error);
return;
}
CurrentUser cuser = new CurrentUser();
cuser.userName = this.UserName;
cuser.Load();
using (StreamReader sr = File.OpenText(fullFileName))
{
String inputLine;
/* Read Header */
inputLine = sr.ReadLine();
if (inputLine != null)
{
Dictionary<string, string> headers = this.deviceHeaders;
string[] lineHeaders = inputLine.Split('\t');
int col = 0;
foreach (string str in lineHeaders)
{
if (headers.ContainsKey(str))
{
headers[str] = col.ToString();
col++;
}
}
Dictionary<string, string> mapFields = this.fieldsMap;
string deptcode="", sitecode="", panelcode="", alarmcode="", alarmtype="";
_line = 0;
while ((inputLine = sr.ReadLine()) != null)
{
/* Read File Each Line */
string[] lineFields = inputLine.Split('\t');
_line++;
tbl_alarm_time_details alarmDet = new tbl_alarm_time_details(cuser);
foreach(string fieldname in headers.Keys)
{
int idx;
int.TryParse(headers[fieldname], out idx);
object value = lineFields[idx];
PropertyInfo pi = alarmDet.GetType().GetProperty(mapFields[fieldname]);
if (pi != null)
{
value = IntelWebDataConverter.toType(lineFields[idx], pi.PropertyType, "Line: [" + _line.ToString() + "] Field: [" + fieldname + "] Value: [" + (lineFields[idx] ?? "") + "]");
pi.SetValue(alarmDet, value, null);
if (fieldname.Equals("DEPT/REG"))
{
deptcode = value.ToString();
}
if (fieldname.Equals("SITE"))
{
sitecode = value.ToString();
}
if (fieldname.Equals("PANEL"))
{
panelcode = value.ToString();
}
if (fieldname.Equals("ALARM DEVICE"))
{
alarmcode = value.ToString();
}
if (fieldname.Equals("ALARM TYPE"))
{
alarmtype = value.ToString();
}
}
}
UpSert(deptcode, sitecode, panelcode, alarmcode, alarmtype, cuser);
alarmDet.tier_code = tierCode;
alarmDet.LoadSingle();
bool isnew = alarmDet.isNew;
string desc = alarmDet.ChangedFieldsDescription();
if (!alarmDet.save())
{
error = new ImportError();
error.errorMessage = alarmDet.saveErrorText;
error.fieldFQR = alarmDet.friendlySingluarName();
error.lineNumber = _line;
_importproblems.Add(error);
}
else
{
iitem = new ImportedItem(_line, isnew, alarmDet.friendlySingluarName(), desc);
_importeditems.Add(iitem);
}
}
}
}
_enddate = DateTime.Now;
}
protected void Page_LoadComplete(object sender, EventArgs e)
{
string SaveFile="";
cuser = new CurrentUser();
cuser.userName = "******";
cuser.Load();
lkup_tier tier = new lkup_tier(cuser);
List<IntelWebObject> Tiers = tier.Load();
this.ltrTiers.Text = string.Join("", Tiers.Cast<lkup_tier>().Select(x => "<option value=\"" + HttpUtility.HtmlEncode(x.tier_code) + "\">" + HttpUtility.HtmlEncode(x.tier_code) + "</option>").ToArray());
if (IsPostBack)
{
bool createJob = false;
if (Request.Files.Count > 0)
{
HttpPostedFile File1 = Request.Files[0];
if (File1.ContentLength > 0)
{
SaveFile = System.IO.Path.GetFileName(File1.FileName);
if (System.IO.Path.GetExtension(SaveFile).Equals(".xls", StringComparison.InvariantCultureIgnoreCase))
{
string SaveLocation = Server.MapPath("Data") + "\\" + SaveFile;
try
{
File1.SaveAs(SaveLocation);
createJob = true;
}
catch (Exception ex)
{
ltrMessage.Text = "<div style=\"border:1px solid #FF0000;\">Error: " + HttpUtility.HtmlEncode(ex.Message) + "</div>";
}
}
else
{
ltrMessage.Text = "<div style=\"border:1px solid #FFFF00;\">Impoter support's only Excel files.</div>";
}
}
else
{
string xlsText = Request.Form["xlsTextArea"];
if (!string.IsNullOrEmpty(xlsText))
{
SaveFile = randomFile() + ".txt";
StreamWriter outfile = new StreamWriter(Server.MapPath("Data") + "\\" + SaveFile);
outfile.Write(xlsText);
outfile.Close();
createJob = true;
}
}
}
if (createJob)
{
JobQ job = new JobQ(cuser);
job.jobType = "Import";
job.jobStatus = "active";
job.tiername = Request.Form["tiername"];
job.filename = SaveFile;
if (job.save())
{
ltrMessage.Text = "<div style=\"border:1px solid #00FF00;\">The file has been uploaded.</div>";
}
else
{
ltrMessage.Text = "<div style=\"border:1px solid #FF0000;\">Error: " + HttpUtility.HtmlEncode(job.saveErrorText) + "</div>";
}
}
}
ltrJobStatus.Text = JobStatusHTML();
}
private void UpSert(string Dept, string Site, string Panel, string Alarm, string AlarmType, CurrentUser cuser)
{
/* Find If Department Exists or Insert it */
lkup_department dept = new lkup_department(cuser);
dept.department_code = Dept;
dept.LoadSingle();
if (dept.isNew)
{
dept.department_code_description = Dept;
string desc = dept.ChangedFieldsDescription();
if (!dept.save())
{
error = new ImportError();
error.errorMessage = dept.saveErrorText;
error.fieldFQR = dept.friendlySingluarName();
error.lineNumber = _line;
_importproblems.Add(error);
}
else
{
iitem = new ImportedItem(_line, true, dept.friendlySingluarName(), desc);
_importeditems.Add(iitem);
}
}
lkup_site site = new lkup_site(cuser);
site.department_code = Dept;
site.site_code = Site;
site.LoadSingle();
if (site.isNew)
{
site.site_code_description = Site;
string desc = site.ChangedFieldsDescription();
if (!site.save())
{
error = new ImportError();
error.errorMessage = site.saveErrorText;
error.fieldFQR = site.friendlySingluarName();
error.lineNumber = _line;
_importproblems.Add(error);
}
else
{
iitem = new ImportedItem(_line, true, site.friendlySingluarName(), desc);
_importeditems.Add(iitem);
}
}
lkup_panel panel = new lkup_panel(cuser);
panel.panel_code = Panel;
panel.site_code = Site;
panel.LoadSingle();
if (panel.isNew)
{
panel.alarm_device_code = Alarm;
panel.panel_code_description = Panel;
string desc = panel.ChangedFieldsDescription();
if (!panel.save())
{
error = new ImportError();
error.errorMessage = panel.saveErrorText;
error.fieldFQR = panel.friendlySingluarName();
error.lineNumber = _line;
_importproblems.Add(error);
}
else
{
iitem = new ImportedItem(_line, true, panel.friendlySingluarName(), desc);
_importeditems.Add(iitem);
}
}
lkup_alarm_device alarm = new lkup_alarm_device(cuser);
alarm.panel_code = Panel;
alarm.alarm_device_code = Alarm;
alarm.alarm_type_code = AlarmType;
alarm.LoadSingle();
if (alarm.isNew)
{
alarm.alarm_device_code_description = Alarm;
string desc = alarm.ChangedFieldsDescription();
if (!alarm.save())
{
error = new ImportError();
error.errorMessage = alarm.saveErrorText;
error.fieldFQR = alarm.friendlySingluarName();
error.lineNumber = _line;
_importproblems.Add(error);
}
else
{
iitem = new ImportedItem(_line, true, alarm.friendlySingluarName(), desc);
_importeditems.Add(iitem);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
int counter = 0;
string objectType = Request.Form.Get("grid" + counter.ToString() + "_objectId");
List<string> saveErrors = new List<string>();
var GridReturnRecordInfo = new StringBuilder();
if (!String.IsNullOrEmpty(objectType))
{
CurrentUser cuser = new CurrentUser();
cuser.userName = "******";
cuser.Load();
WebGridController gridController = WebGridController.ControllerFromName(objectType, Request.Form, null, cuser);
var myGrid = gridController.grid;
string submittedName = Request.Form.Get("grid" + counter.ToString() + "_objectName");
myGrid.gridName = submittedName; //change grid name to the value submitted - this supports multiple aliased gris - such as in Onboarding New Hire
GridReturnRecordInfo.Append("{name:'" + JSUtil.EnquoteJS(myGrid.gridName) + "',records:");
myGrid.LoadData();
if (myGrid.loadErrors != null && myGrid.loadErrors.Count != 0)
{
foreach (ApplicationException ae in myGrid.loadErrors)
{
saveErrors.Add(ae.Message);
}
}
myGrid.UpdateData();
if (!string.IsNullOrEmpty(myGrid.updateDataErrors))
{
Response.Write("{ok:false,errorMessage:'The save operation was cancelled because there were problems with the data that you submitted. " + JSUtil.EnquoteJS("\n" + myGrid.updateDataErrors) + "'}");
Response.End();
}
var myData = myGrid.data;
var removeObjs = new List<IntelWebObject>();
if (myData != null)
{
foreach (IntelWebObject obj in myData)
{
if (obj.isDirty)
{
if (!myGrid.deleteQueue.Contains(obj))
{ //don't save items marked for deletion
if (!obj.save())
{
saveErrors.Add(obj.saveErrorText);
if (obj.isNew)
{
removeObjs.Add(obj);
}
else
{
obj.revertChanges();
}
}
}
}
}
foreach (IntelWebObject removeIt in removeObjs)
{
myGrid.data.Remove(removeIt);
}
}
GridReturnRecordInfo.Append(myGrid.dataJS());
GridReturnRecordInfo.Append(",deletedKeys:[");
var deleteBuilder = new StringBuilder();
foreach (IntelWebObject apObj in myGrid.deleteQueue)
{
var dKey = JSUtil.SerializeJSProperty(apObj.primaryKey);
if (!apObj.delete())
{
saveErrors.Add(apObj.saveErrorText);
}
else
{
deleteBuilder.Append(dKey);
deleteBuilder.Append(",");
}
}
if (deleteBuilder.Length > 0)
{
deleteBuilder.Remove(deleteBuilder.Length - 1, 1);
}
GridReturnRecordInfo.Append(deleteBuilder.ToString());
GridReturnRecordInfo.Append("]}");
GridReturnRecordInfo.Append(",");
counter++;
objectType = Request.Form.Get("grid" + counter.ToString() + "_objectId");
}
else
{
saveErrors.Add("Object Id is null");
}
if (GridReturnRecordInfo.Length > 0) { GridReturnRecordInfo.Remove(GridReturnRecordInfo.Length - 1, 1); }
string output = "{ok:[paramOK],errorMessage:'[paramErrorMessage]'"; //action:[paramAction] - is implemented in the gridBase.js 7/22/2010
if (saveErrors.Count.Equals(0))
{
output = output.Replace("[paramOK]", "true");
output = output.Replace("[paramErrorMessage]", "");
}
else
{
output = output.Replace("[paramOK]", "false");
var sb = new StringBuilder();
foreach (string em in saveErrors)
{
sb.Append(JSUtil.EnquoteJS(em + "\n"));
}
output = output.Replace("[paramErrorMessage]", sb.ToString());
}
output += ",gridInfos:[" + GridReturnRecordInfo.ToString() + "]";
output += "}";
Response.Write(output);
}
public lkup_alarm_type(CurrentUser oUser)
{
Initialize(oUser);
}
public lkup_alarm_type(CurrentUser oUser, string selectFields)
{
Initialize(oUser);
base.selectFields = selectFields;
}
private void Initialize(CurrentUser oUser)
{
base.User = oUser;
base.primaryKey = new IntelWebField("guidfield", OleDbType.Guid, 50, 0, 0, DataRowVersion.Current, false, "");
base.FieldList = this.myFields();
base.tableName = "Users";
}
public lkup_tier(CurrentUser oUser)
{
Initialize(oUser);
}
public IntelWebUsers(CurrentUser oUser)
{
Initialize(oUser);
}
public lkup_panel(CurrentUser oUser, List<IntelWebField> oselectFieldsList, bool _internalFlag_LoadingFromDataSet)
{
base.loadObjectDefaults = _internalFlag_LoadingFromDataSet;
Initialize(oUser);
base.selectFieldsList = oselectFieldsList;
}
public IntelWebUsers(CurrentUser oUser, string selectFields)
{
Initialize(oUser);
base.selectFields = selectFields;
}
public lkup_panel(CurrentUser oUser, string selectFields)
{
Initialize(oUser);
base.selectFields = selectFields;
}
public lkup_department(CurrentUser oUser, string selectFields)
{
Initialize(oUser);
base.selectFields = selectFields;
}
