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; } }