protected void btnView_Click(object sender, EventArgs e)
{
if (dtmStart.SelectedDate == null)
{
ntf.Text = "Chưa nhập ngày bắt đầu.";
ntf.VisibleOnPageLoad = true;
dtmStart.Focus();
return;
}
if (dtmEnd.SelectedDate == null)
{
ntf.Text = "Chưa nhập ngày kết thúc.";
ntf.VisibleOnPageLoad = true;
dtmEnd.Focus();
return;
}
DateTime startDate = (DateTime)dtmStart.SelectedDate;
DateTime endDate = (DateTime)dtmEnd.SelectedDate;
string siteID = Request.QueryString["si"];
t_Sites site = _siteBL.GetSite(siteID);
var list = _loggerDataHelper.GetComplexLoggerData(site.SiteId, startDate, endDate);
lblTitle.Text = "Chi tiết dữ liệu logger điểm " + site.Location + " (" + site.SiteAliasName + ") " + startDate.ToString("dd-MM-yyyy") + " đến " + endDate.ToString("dd-MM-yyyy");
grv.DataSource = list;
grv.DataBind();
grv.ExportSettings.FileName = site.SiteAliasName + "_" + startDate.ToString("yyyy_MM_dd") + "_to_" + endDate.ToString("yyyy_MM_dd");
}
protected void btnView_Click(object sender, EventArgs e)
{
List <t_LanguageTranslate> list1 = languageBL.FindAll(x => x.Language == language && x.Noted.Contains("/Supervisor/Warning")).ToList();
var winTable_empty_start_date = list1.Where(x => x.ControlId.Contains("winTable_empty_start_date")).FirstOrDefault();
var winTable_empty_end_date = list1.Where(x => x.ControlId.Contains("winTable_empty_end_date")).FirstOrDefault();
if (dtmStart.SelectedDate == null)
{
ntf.Text = winTable_empty_start_date.Contents;
ntf.VisibleOnPageLoad = true;
dtmStart.Focus();
return;
}
if (dtmEnd.SelectedDate == null)
{
ntf.Text = winTable_empty_end_date.Contents;
ntf.VisibleOnPageLoad = true;
dtmEnd.Focus();
return;
}
DateTime startDate = (DateTime)dtmStart.SelectedDate;
DateTime endDate = (DateTime)dtmEnd.SelectedDate;
string siteID = Request.QueryString["si"];
t_Sites site = _siteBL.GetSite(siteID);
var list = _loggerDataHelper.GetComplexLoggerData(site.SiteId, startDate, endDate);
lblTitle.Text = tileContent + " " + site.Location + " (" + site.SiteAliasName + ") " + startDate.ToString("dd-MM-yyyy") + " đến " + endDate.ToString("dd-MM-yyyy");
grv.DataSource = list;
grv.DataBind();
grv.ExportSettings.FileName = site.SiteAliasName + "_" + startDate.ToString("yyyy_MM_dd") + "_to_" + endDate.ToString("yyyy_MM_dd");
}
public void DeleteSite(t_Sites site)
{
try
{
// var list1 = context.t_Data_Complexes.Where(d => d.LoggerId == site.LoggerId).ToList();
// foreach (var item in list1)
// {
// context.t_Data_Complexes.Remove(item);
//}
context.Database.ExecuteSqlCommand("exec delete_complexdata @LoggerId", new SqlParameter("@LoggerId", site.LoggerId));
var list2 = context.t_Channel_Configurations.Where(c => c.LoggerId == site.LoggerId).ToList();
//.ForEach(context.t_Channel_Configurations.Remove);
foreach (var item in list2)
{
context.t_Channel_Configurations.Remove(item);
context.Database.ExecuteSqlCommand("exec p_Drop_Data_Table @channelId", new SqlParameter("channelId", item.ChannelId));
}
var list3 = context.t_Logger_Configurations.Where(c => c.LoggerId == site.LoggerId).ToList();
//.ForEach(context.t_Logger_Configurations.Remove);
foreach (var item in list3)
{
context.t_Logger_Configurations.Remove(item);
}
context.t_Sites.Attach(site);
context.t_Sites.Remove(site);
context.SaveChanges();
}
catch (Exception ex)
{
//
throw ex;
}
}
public void InsertSite(t_Sites site)
{
try
{
siteRepository.InsertSite(site);
}
catch (Exception ex)
{
//
throw ex;
}
}
public void DeleteSite(t_Sites site)
{
try
{
siteRepository.DeleteSite(site);
}
catch (Exception ex)
{
//
throw ex;
}
}
public void UpdateSite(t_Sites site, t_Sites origSite)
{
try
{
siteRepository.UpdateSite(site, origSite);
}
catch (Exception ex)
{
//
throw ex;
}
}
protected void Page_Load(object sender, EventArgs e)
{
// Pi-solution developer - multi languages
if (!IsPostBack)
{
language = (Session["myapplication.language"] == null) ? "vi" : Session["myapplication.language"].ToString();
List <t_LanguageTranslate> listLanguage = languageBL.FindAll(x => x.Language == language && x.Noted.Contains("/Supervisor/Logger/DetailTable.aspx")).ToList();
//Parse content to form
var var1 = listLanguage.Where(x => x.ControlId.Contains("lbFrom")).FirstOrDefault();
lbFrom.Text = (var1 == null) ? "" : var1.Contents;
var var2 = listLanguage.Where(x => x.ControlId.Contains("lbTo")).FirstOrDefault();
lbTo.Text = (var2 == null) ? "" : var2.Contents;
var var3 = listLanguage.Where(x => x.ControlId.Contains("btnView")).FirstOrDefault();
btnView.Text = (var3 == null) ? "" : var3.Contents;
var var4 = listLanguage.Where(x => x.ControlId.Contains("btnExport")).FirstOrDefault();
btnExport.Text = (var4 == null) ? "" : var4.Contents;
// Title
var var5 = listLanguage.Where(x => x.ControlId.Contains("lbTitleContent")).FirstOrDefault();
tileContent = (var5 == null) ? "" : var5.Contents;
// Change header of rad grid
var var15 = listLanguage.Where(x => x.ControlId.Contains("grv_TimeStamp")).FirstOrDefault();
grv.MasterTableView.GetColumn("column3").HeaderText = (var15 == null) ? "" : var15.Contents;
var var16 = listLanguage.Where(x => x.ControlId.Contains("grv_FlowRate")).FirstOrDefault();
grv.MasterTableView.GetColumn("column").HeaderText = (var16 == null) ? "" : var16.Contents;
var var17 = listLanguage.Where(x => x.ControlId.Contains("grv_ForwardIndex")).FirstOrDefault();
grv.MasterTableView.GetColumn("column2").HeaderText = (var17 == null) ? "" : var17.Contents;
var var18 = listLanguage.Where(x => x.ControlId.Contains("grv_ReverseIndex")).FirstOrDefault();
grv.MasterTableView.GetColumn("column4").HeaderText = (var18 == null) ? "" : var18.Contents;
var var19 = listLanguage.Where(x => x.ControlId.Contains("grv_NetIndex")).FirstOrDefault();
grv.MasterTableView.GetColumn("column5").HeaderText = (var19 == null) ? "" : var19.Contents;
var var20 = listLanguage.Where(x => x.ControlId.Contains("grv_Pressure")).FirstOrDefault();
grv.MasterTableView.GetColumn("column1").HeaderText = (var20 == null) ? "" : var20.Contents;
}
CultureInfo culture = new CultureInfo("en-GB");
string siteID = Request.QueryString["si"];
double oADate = double.Parse(Request.QueryString["dt"]);
DateTime date = DateTime.FromOADate(oADate);
t_Sites site = _siteBL.GetSite(siteID);
var list = _loggerDataHelper.GetComplexLoggerData(site.SiteId, date, date);
lblTitle.Text = tileContent + " " + site.SiteAliasName + " (" + site.Location + ") " + date.ToString("dd-MM-yyyy");
grv.DataSource = list;
grv.DataBind();
grv.ExportSettings.FileName = site.SiteAliasName + "_" + date.ToString("yyyy_MM_dd");
ntf.VisibleOnPageLoad = false;
}
protected void Page_Load(object sender, EventArgs e)
{
CultureInfo culture = new CultureInfo("en-GB");
string siteID = Request.QueryString["si"];
double oADate = double.Parse(Request.QueryString["dt"]);
DateTime date = DateTime.FromOADate(oADate);
t_Sites site = _siteBL.GetSite(siteID);
var list = _loggerDataHelper.GetComplexLoggerData(site.SiteId, date, date);
lblTitle.Text = "Chi tiết dữ liệu logger điểm " + site.SiteAliasName + " (" + site.Location + ") " + date.ToString("dd-MM-yyyy");
grv.DataSource = list;
grv.DataBind();
grv.ExportSettings.FileName = site.SiteAliasName + "_" + date.ToString("yyyy_MM_dd");
ntf.VisibleOnPageLoad = false;
}
public void UpdateSite(t_Sites site, t_Sites origSite)
{
try
{
context.t_Sites.Attach(origSite);
origSite.SiteId = site.SiteId;
origSite.SiteAliasName = site.SiteAliasName;
if (string.IsNullOrEmpty(origSite.SiteAliasName))
{
origSite.SiteAliasName = site.SiteId;
}
origSite.ConsumerId = site.ConsumerId;
origSite.DisplayGroup = site.DisplayGroup;
origSite.Latitude = site.Latitude;
origSite.Location = site.Location;
origSite.LoggerId = site.LoggerId;
origSite.Longitude = site.Longitude;
origSite.StartDay = site.StartDay;
origSite.Zoom = site.Zoom;
origSite.Description = site.Description;
origSite.MeterSerial = site.MeterSerial;
origSite.TransmitterSerial = site.TransmitterSerial;
origSite.LoggerSerial = site.LoggerSerial;
origSite.Status = site.Status;
origSite.Availability = site.Availability;
origSite.Staffs = site.Staffs;
origSite.PipeSize = site.PipeSize;
origSite.SetDelayTime = site.SetDelayTime;
origSite.SetDiffValue = site.SetDiffValue;
origSite.Baseline = site.Baseline;
if (site.t_Logger_Configurations != null)
{
var loggerConfiguration = origSite.t_Logger_Configurations;
loggerConfiguration.SiteId = site.t_Logger_Configurations.SiteId;
loggerConfiguration.StartHour = site.t_Logger_Configurations.StartHour;
loggerConfiguration.TelephoneNumber = site.t_Logger_Configurations.TelephoneNumber;
origSite.t_Logger_Configurations = loggerConfiguration;
}
context.SaveChanges();
}
catch (Exception ex)
{
//
throw ex;
}
}
private void SetValues(t_Sites site)
{
txtAliasName.Text = site.SiteAliasName;
cboConsumers.SelectedValue = site.ConsumerId;
txtDescription.Text = site.Description;
cboDisplayGroups.SelectedValue = site.DisplayGroup;
nmrLatitude.Value = site.Latitude;
txtLocation.Text = site.Location;
txtLoggerID.Text = site.LoggerId;
nmrLongitude.Value = site.Longitude;
cboSites.Text = site.SiteId;
if (site.StartDay != null)
{
cboStartDays.SelectedIndex = (int)site.StartDay - 1;
}
if (site.Zoom != null)
{
cboZoomLevels.SelectedIndex = (byte)site.Zoom - 1;
}
if (site.t_Logger_Configurations != null)
{
cboStartHours.SelectedIndex = (byte)site.t_Logger_Configurations.StartHour;
txtLoggerPhoneNumber.Text = site.t_Logger_Configurations.TelephoneNumber;
}
else
{
cboStartHours.SelectedIndex = 0;
txtLoggerPhoneNumber.Text = string.Empty;
}
cboMeterSerials.Text = site.MeterSerial;
cboTransmitterSerials.Text = site.TransmitterSerial;
cboLoggerSerials.Text = site.LoggerSerial;
cboStatus.SelectedValue = site.Status;
cboAvailabilities.SelectedValue = site.Availability;
txtStaffs.Text = site.Staffs;
txtPipeSize.Text = site.PipeSize;
nmrSetDiffValue.Value = site.SetDiffValue;
if (site.SetDiffValue != null)
{
nmrSetDiffValue.Value = (double)site.SetDiffValue * 100;
}
nmrSetDelayTime.Value = site.SetDelayTime;
txtBaseline.Value = site.Baseline;
SetDateChanged();
}
public void InsertSite(t_Sites site)
{
try
{
site.LabelLat = site.Latitude;
site.LabelLng = site.Longitude;
site.LabelAnchorX = 15;
site.LabelAnchorY = 0;
if (string.IsNullOrEmpty(site.SiteAliasName))
{
site.SiteAliasName = site.SiteId;
}
context.t_Sites.Add(site);
context.SaveChanges();
}
catch (Exception ex)
{
//
throw ex;
}
}
private t_Sites GetSite()
{
t_Sites site = new t_Sites();
site.SiteAliasName = txtAliasName.Text;
site.ConsumerId = cboConsumers.Text;
site.Description = txtDescription.Text;
site.DisplayGroup = cboDisplayGroups.Text;
site.Latitude = nmrLatitude.Value;
site.Location = txtLocation.Text;
site.LoggerId = txtLoggerID.Text;
if (string.IsNullOrEmpty(site.LoggerId))
{
site.LoggerId = null;
}
site.Longitude = nmrLongitude.Value;
site.SiteId = cboSites.Text;
site.StartDay = byte.Parse(cboStartDays.Text);
site.Zoom = byte.Parse(cboZoomLevels.Text);
site.MeterSerial = string.IsNullOrEmpty(cboMeterSerials.Text) ? null : cboMeterSerials.Text;
site.TransmitterSerial = string.IsNullOrEmpty(cboTransmitterSerials.Text) ? null : cboTransmitterSerials.Text;
site.LoggerSerial = string.IsNullOrEmpty(cboLoggerSerials.Text) ? null : cboLoggerSerials.Text;
site.Status = string.IsNullOrEmpty(cboStatus.SelectedValue) ? null : cboStatus.SelectedValue;
site.Availability = string.IsNullOrEmpty(cboAvailabilities.SelectedValue) ? null : cboAvailabilities.SelectedValue;
site.MeterDateChanged = dtmMeterChanged.SelectedDate;
site.TransmitterDateChanged = dtmTransmitterChanged.SelectedDate;
site.LoggerDateChanged = dtmLoggerChanged.SelectedDate;
site.Staffs = txtStaffs.Text;
site.PipeSize = txtPipeSize.Text;
if (nmrSetDelayTime.Value != null)
{
site.SetDelayTime = (int)nmrSetDelayTime.Value;
}
if (nmrSetDiffValue.Value != null)
{
site.SetDiffValue = (double)nmrSetDiffValue.Value / 100;
}
site.Baseline = (txtBaseline.Value != null)?(double)txtBaseline.Value:0;
return(site);
}
