protected void btnUpload_Click(object sender, EventArgs e)
{
if ((txtFilePath.HasFile))
{
DataSet ds = ReadExcelFile();
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
SourceConnection.MFMPoints.AddObject(new MFMPoints()
{
MeasurementSection = dr["MeasurementSection"].ToString(), PointGas = StringHelper.TryParse(dr["PointGas"].ToString()), PointOil = StringHelper.TryParse(dr["PointOil"].ToString()), MeterName = dr["MeterName"].ToString()
});
}
SourceConnection.SaveChanges();
}
lblMessage.Text = "Data successfully Imported! Total Recodes:" + ds.Tables[0].Rows.Count;
lblMessage.ForeColor = System.Drawing.Color.Green;
lblMessage.Visible = true;
}
else
{
lblMessage.Text = "Please select an excel file first";
lblMessage.ForeColor = System.Drawing.Color.Red;
lblMessage.Visible = true;
}
}
protected void btnUpload_Click(object sender, EventArgs e)
{
if ((txtFilePath.HasFile))
{
DataSet ds = ReadExcelFile();
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
SourceConnection.MeterNotes.AddObject(new DataSource.MeterNote()
{
Comment = dr["Comments"].ToString(), MeterNumber = dr["MeterName"].ToString()
});
}
SourceConnection.SaveChanges();
}
lblMessage.Text = "Data successfully Imported! Total Records:" + ds.Tables[0].Rows.Count;
lblMessage.ForeColor = System.Drawing.Color.Green;
lblMessage.Visible = true;
}
else
{
lblMessage.Text = "Please select an excel file first";
lblMessage.ForeColor = System.Drawing.Color.Red;
lblMessage.Visible = true;
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
Id = (Update) ? StringHelper.TryParse(StringHelper.Decrypt(Request.QueryString["Id"].ToString())) : 0;
DataSource.MeterNoteCategory data = (!Update) ? new DataSource.MeterNoteCategory() : SourceConnection.MeterNoteCategories.Where(x => x.Id.Equals(Id)).First();
data.Description = txtDescription.Text;
data.Category = txtCategory.Text;
if (!Update)
{
SourceConnection.MeterNoteCategories.AddObject(data);
}
SourceConnection.SaveChanges();
Response.Redirect("DataView.aspx");
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
Id = (Update) ? StringHelper.TryParse(StringHelper.Decrypt(Request.QueryString["Id"].ToString())) : 0;
MFMGVF data = (!Update) ? new MFMGVF() : SourceConnection.MFMGVFs.Where(x => x.GVFID.Equals(Id)).First();
data.GVF = Convert.ToDouble(txtGVF.Text);
data.MeterName = txtMeterName.Text;
if (!Update)
{
SourceConnection.MFMGVFs.AddObject(data);
}
SourceConnection.SaveChanges();
Response.Redirect("DataView.aspx");
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
Id = (Update) ? StringHelper.TryParse(StringHelper.Decrypt(Request.QueryString["Id"].ToString())) : 0;
DataSource.MeterNote data = (!Update) ? new DataSource.MeterNote() : SourceConnection.MeterNotes.Where(x => x.Id.Equals(Id)).First();
data.Comment = txtComment.Text;
data.CategoryId = StringHelper.TryParse(ddlCategory.SelectedValue);
if (!Update)
{
data.MeterNumber = meterNumber;
SourceConnection.MeterNotes.AddObject(data);
}
SourceConnection.SaveChanges();
Response.Redirect("DataView.aspx?tagnumber=" + meterNumber);
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
Id = (Update) ? StringHelper.TryParse(StringHelper.Decrypt(Request.QueryString["Id"].ToString())) : 0;
MFMPoints data = (!Update) ? new MFMPoints() : SourceConnection.MFMPoints.Where(x => x.MFMPointsID.Equals(Id)).First();
data.PointGas = Convert.ToInt32(txtPointGas.Text);
data.PointOil = Convert.ToInt32(txtPointOil.Text);
data.MeasurementSection = txtMeasurementSection.Text;
data.MeterName = txtMeterName.Text;
if (!Update)
{
SourceConnection.MFMPoints.AddObject(data);
}
SourceConnection.SaveChanges();
Response.Redirect("DataView.aspx");
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
Id = (Update) ? StringHelper.TryParse(StringHelper.Decrypt(Request.QueryString["Id"].ToString())) : 0;
MFMAxisData data = (!Update) ? new MFMAxisData() : SourceConnection.MFMAxisDatas.Where(x => x.Id.Equals(Id)).First();
data.MaxValue = Convert.ToInt64(txtMaxValue.Text);
data.MinValue = Convert.ToInt64(txtMinValue.Text);
data.Axis = ddlAxis.SelectedValue;
data.LogBase = Convert.ToInt32(txtLogBase.Text);
data.MeterName = txtMeterName.Text;
if (!Update)
{
SourceConnection.MFMAxisDatas.AddObject(data);
}
SourceConnection.SaveChanges();
Response.Redirect("DataView.aspx");
}
protected void gvMFMPoints_RowCommand(object sender, GridCommandEventArgs e)
{
int dataId;
switch (e.CommandName)
{
case "DeletePoint":
dataId = Convert.ToInt32(e.CommandArgument);
MFMPoints data = SourceConnection.MFMPoints.Where(x => x.MFMPointsID.Equals(dataId)).First();
if (data != null)
{
SourceConnection.MFMPoints.DeleteObject(data);
SourceConnection.SaveChanges();
}
BindPointsData();
break;
case "EditPoint":
dataId = Convert.ToInt32(e.CommandArgument);
Response.Redirect("AddorEdit.aspx?Id=" + StringHelper.Encrypt(dataId.ToString()));
break;
}
}
protected void gvMeterNotes_RowCommand(object sender, GridCommandEventArgs e)
{
int dataId;
switch (e.CommandName)
{
case "DeleteNote":
dataId = Convert.ToInt32(e.CommandArgument);
DataSource.MeterNote data = SourceConnection.MeterNotes.Where(x => x.Id.Equals(dataId)).First();
if (data != null)
{
SourceConnection.MeterNotes.DeleteObject(data);
SourceConnection.SaveChanges();
}
BindNoteData();
break;
case "EditNote":
dataId = Convert.ToInt32(e.CommandArgument);
Response.Redirect("AddorEdit.aspx?meter=" + meterNumber + "&Id=" + StringHelper.Encrypt(dataId.ToString()));
break;
}
}
