protected void gvReading_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
string month = gvReading.DataKeys[e.RowIndex].Values[0].ToString();
string feeder = gvReading.DataKeys[e.RowIndex].Values[1].ToString();
TextBox txtCur_Kwh_Reading = (TextBox)gvReading.Rows[e.RowIndex].FindControl("txtCur_Kwh_Reading");
TextBox txtCur_Kvarh_Reading = (TextBox)gvReading.Rows[e.RowIndex].FindControl("txtCur_Kvarh_Reading");
TextBox txtCur_Meter_Status = (TextBox)gvReading.Rows[e.RowIndex].FindControl("txtCur_Meter_Status");
TextBox txtCur_MF = (TextBox)gvReading.Rows[e.RowIndex].FindControl("txtCur_MF");
string uName = Session["uname"].ToString();
using (MMR_CP22Entities1 context = new MMR_CP22Entities1())
{
var FrmBRow = context.CP22_FORMB.Find(month, feeder);
if (FrmBRow != null)
{
//update
FrmBRow.FIN_READ = !string.IsNullOrEmpty(txtCur_Kwh_Reading.Text) ? decimal.Parse(txtCur_Kwh_Reading.Text) : FrmBRow.FIN_READ;
FrmBRow.FIN_KVARH_READ = !string.IsNullOrEmpty(txtCur_Kvarh_Reading.Text) ? decimal.Parse(txtCur_Kvarh_Reading.Text) : FrmBRow.FIN_KVARH_READ;
FrmBRow.STATUS_CODE = txtCur_Meter_Status.Text.Length > 0 ? txtCur_Meter_Status.Text.Substring(0, 1) : string.Empty;
FrmBRow.MFACTOR = !string.IsNullOrEmpty(txtCur_MF.Text) ? decimal.Parse(txtCur_MF.Text) : FrmBRow.MFACTOR;
FrmBRow.MODIFIED_BY = uName;
FrmBRow.MODIFIED_ON = DateTime.Now;
}
context.SaveChanges();
}
gvReading.EditIndex = -1;
BindGrid();
}
protected void GVEmployee_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "InsertNew")
{
GridViewRow row = GVEmployee.FooterRow;
TextBox txtName = row.FindControl("txtEmpNameNew") as TextBox;
TextBox txtPassword = row.FindControl("txtPasswordNew") as TextBox;
DropDownList ddlStatusNew = row.FindControl("ddlStatusNew") as DropDownList;
DropDownList ddlRoleNew = row.FindControl("ddlRoleNew") as DropDownList;
DropDownList ddlCompanyNew = row.FindControl("ddlCompanyNew") as DropDownList;
TextBox txtuFULL_NAME = row.FindControl("txtuFULL_NAMENew") as TextBox;
DropDownList ddlGridCodeNew = row.FindControl("ddlGridCodeNew") as DropDownList;
if (ddlRoleNew.SelectedValue.ToString() != "1")
{
using (MMR_CP22Entities1 context = new MMR_CP22Entities1())
{
User obj = new User();
obj.uName = txtName.Text;
obj.uPassword = txtPassword.Text;
obj.uStatus = bool.Parse(ddlStatusNew.SelectedValue);
obj.rID = int.Parse(ddlRoleNew.SelectedValue);
obj.CMP_CODE = ddlCompanyNew.SelectedValue;
obj.uFULL_NAME = txtuFULL_NAME.Text;
obj.GRID_CODE = ddlGridCodeNew.SelectedValue;
context.Users.Add(obj);
var mrExis = context.MR_CONTROL.Find(obj.CMP_CODE, DateTime.Now.AddMonths(-1).ToString("MMyyyy"));
if (mrExis == null)
{
var mr = new MR_CONTROL();
mr.BMONTH = DateTime.Now.AddMonths(-1);
mr.CMP_CODE = obj.CMP_CODE;
mr.CREATED_BY = Session["uname"].ToString();
mr.CREATED_DATE = DateTime.Now;
mr.MONTH = DateTime.Now.AddMonths(-1).ToString("MMyyyy");
mr.STATUS = "1";
context.MR_CONTROL.Add(mr);
}
context.SaveChanges();
BindGrid();
lblErrorExp.Text = "User added successfully!";
lblErrorExp.ForeColor = System.Drawing.Color.Green;
}
}
else
{
lblErrorExp.Text = "Cannot add another Admin user!";
lblErrorExp.ForeColor = System.Drawing.Color.Red;
}
}
else if (e.CommandName == "Cancel" || e.CommandName == "CancelNew")
{
GVEmployee.EditIndex = -1;
BindGrid();
lblErrorExp.Text = "";
}
}
protected void GVEmployee_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
int uID = Convert.ToInt32(GVEmployee.DataKeys[e.RowIndex].Value);
using (MMR_CP22Entities1 context = new MMR_CP22Entities1())
{
User obj = context.Users.First(x => x.uID == uID);
context.Users.Remove(obj);
context.SaveChanges();
BindGrid();
lblErrorExp.Text = "User deleted successfully!";
lblErrorExp.ForeColor = System.Drawing.Color.Green;
}
}
protected void gvReading_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
string month = gvReading.DataKeys[e.RowIndex].Values[0].ToString();
string feeder = gvReading.DataKeys[e.RowIndex].Values[1].ToString();
using (MMR_CP22Entities1 context = new MMR_CP22Entities1())
{
CP22_FORMB obj = context.CP22_FORMB.Where(s => s.MONTH == month &&
s.FEEDER == feeder
).FirstOrDefault();
context.CP22_FORMB.Remove(obj);
context.SaveChanges();
string snapFolderPath = System.Web.Hosting.HostingEnvironment.MapPath("~/Images/Snaps/");
string kwhSnapPath = snapFolderPath + obj.MONTH + "_" + obj.GRID_CODE + "_" + obj.FEEDER + "_kwh.jpg";
string kvarhSnapPath = snapFolderPath + obj.MONTH + "_" + obj.GRID_CODE + "_" + obj.FEEDER + "_kvarh.jpg";
ImageDeleteFromFolder(obj.MONTH + "_" + obj.GRID_CODE + "_" + obj.FEEDER + "_kwh.jpg", kwhSnapPath);
ImageDeleteFromFolder(obj.MONTH + "_" + obj.GRID_CODE + "_" + obj.FEEDER + "_kwh.jpg", kvarhSnapPath);
BindGrid();
lblErrorExp.Text = "Deleted successfully.";
}
}
protected void GVEmployee_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
GridViewRow row = GVEmployee.Rows[e.RowIndex];
TextBox txtName = row.FindControl("txtEmpName") as TextBox;
TextBox txtPassword = row.FindControl("txtPassword") as TextBox;
DropDownList ddlStatus = row.FindControl("ddlStatus") as DropDownList;
DropDownList ddlRole = row.FindControl("ddlRole") as DropDownList;
DropDownList ddlCompany = row.FindControl("ddlCompany") as DropDownList;
TextBox txtuFULL_NAME = row.FindControl("txtuFULL_NAME") as TextBox;
DropDownList ddlGridCode = row.FindControl("ddlGridCode") as DropDownList;
if (ddlRole.SelectedValue != "1")
{
using (MMR_CP22Entities1 context = new MMR_CP22Entities1())
{
int uID = Convert.ToInt32(GVEmployee.DataKeys[e.RowIndex].Value);
User obj = context.Users.First(x => x.uID == uID);
obj.uName = txtName.Text;
obj.uPassword = txtPassword.Text;
obj.uStatus = bool.Parse(ddlStatus.SelectedValue);
obj.rID = int.Parse(ddlRole.SelectedValue);
obj.CMP_CODE = ddlCompany.SelectedValue;
obj.uFULL_NAME = txtuFULL_NAME.Text;
obj.GRID_CODE = ddlGridCode.SelectedValue;
context.SaveChanges();
GVEmployee.EditIndex = -1;
BindGrid();
lblErrorExp.Text = "User updated successfully!";
lblErrorExp.ForeColor = System.Drawing.Color.Green;
}
}
else
{
lblErrorExp.Text = "Cannot add another Admin user!";
lblErrorExp.ForeColor = System.Drawing.Color.Red;
}
}
protected void Page_Load(object sender, EventArgs e)
{
//return;
//System.Drawing.Image kwhImg = System.Drawing.Image.FromFile(Server.MapPath("~/Images/selectedtab.GIF"));
//byte[] arrKwh;
//MemoryStream mskwh = new MemoryStream();
//kwhImg.Save(mskwh, System.Drawing.Imaging.ImageFormat.Jpeg);
//arrKwh = mskwh.ToArray();
//System.Drawing.Image imgKvh = System.Drawing.Image.FromFile(Server.MapPath("~/Images/unselectedtab.GIF"));
// byte[] arrKvh;
// MemoryStream msKvh = new MemoryStream();
// imgKvh.Save(msKvh, System.Drawing.Imaging.ImageFormat.Jpeg);
// arrKvh = msKvh.ToArray();
//// MemoryStream ms1 = new MemoryStream(arr);
//// System.Drawing.Image i = System.Drawing.Image.FromStream(ms1, true, true);
//// i.Save(Server.MapPath("~/Images/Snaps/test.gif"));
if (Session["auth"] != null && Session["auth"].ToString() == "1")
{
return;
}
else
{
Response.Redirect("~/Login.aspx", false);
}
var _context = new MMR_CP22Entities1();
var FrmBRow = _context.CP22_FORMB.Find("082019", "200123");
if (FrmBRow != null)
{
_context.SaveChanges();
try
{
//MemoryStream ms = new MemoryStream(arrKwh);
MemoryStream ms = new MemoryStream(Convert.FromBase64String("R0lGODlhAQABAIAAAAAAAAAAACH5BAAAAAAALAAAAAABAAEAAAICTAEAOw=="));
System.Drawing.Image i = System.Drawing.Image.FromStream(ms, true, true);
i.Save(Server.MapPath("~/Images/Snaps/kwh.jpg"));
}
catch (Exception ex)
{
lblError.Text = ex.ToString();
}
try
{
MemoryStream ms = new MemoryStream(Convert.FromBase64String("R0lGODlhAQABAIAAAAAAAAAAACH5BAAAAAAALAAAAAABAAEAAAICTAEAOw=="));
System.Drawing.Image i = System.Drawing.Image.FromStream(ms, true, true);
i.Save(Server.MapPath("~/Images/Snaps/kvh.jpg"));
}
catch (Exception ex)
{
lblError.Text += ex.ToString();
}
}
return;
if (Session["auth"] != null && Session["auth"].ToString() == "1")
{
;
}
else
{
Response.Redirect("~/Login.aspx");
}
}
public static string SaveReadings(List <MonReadingSnap> mrs, string snapFolderPath)
{
string result = "Unkown";
try
{
int recUpdated = 0;
var _context = new MMR_CP22Entities1();
foreach (var fdr in mrs)
{
var FrmBRow = _context.CP22_FORMB.Find(fdr.month, fdr.feeder_code);
if (FrmBRow != null)
{
//update
FrmBRow.FIN_READ = fdr.cur_kwh_reading != null?decimal.Parse(fdr.cur_kwh_reading) : 0;
FrmBRow.KWH_SNAP = fdr.kwh_snap != null ? fdr.kwh_snap : null;
FrmBRow.FIN_KVARH_READ = fdr.cur_kvarh_reading != null?decimal.Parse(fdr.cur_kvarh_reading) : 0;
FrmBRow.D_UNITS = fdr.cur_kwh_reading != null?decimal.Parse(fdr.cur_kwh_reading) - FrmBRow.PREV_READ : 0;
FrmBRow.STATUS_CODE = fdr.cur_meter_status != null?fdr.cur_meter_status.Substring(0, 1) : null;
FrmBRow.MFACTOR = fdr.cur_mf != null?decimal.Parse(fdr.cur_mf) : 1;
FrmBRow.METER_RANGE = fdr.cur_meter_range != null?byte.Parse(fdr.cur_meter_range) : Byte.MinValue;
FrmBRow.KVARH_SNAP = fdr.kvarh_snap != null ? fdr.kvarh_snap : null;
FrmBRow.LATITUDE = fdr.latitude != null ? fdr.latitude : null;
FrmBRow.LONGITUDE = fdr.longitude != null ? fdr.longitude : null;
FrmBRow.MODIFIED_BY = fdr.mr_name != null ? fdr.mr_name : null;
DateTime dtime = DateTime.Now;
if (fdr.time_stamp != null)
{
DateTime.TryParseExact(fdr.time_stamp, "dd-MM-yyyy HH:mm:ss", System.Globalization.CultureInfo.InvariantCulture, System.Globalization.DateTimeStyles.None, out dtime);
}
FrmBRow.MODIFIED_ON = dtime;
_context.SaveChanges();
//kwh snap creation at path ~/Images/Snaps/
SaveSnap(fdr.kwh_snap, snapFolderPath + fdr.month + "_" + fdr.grid_code + "_" + fdr.feeder_code + "_kwh.jpg");
//kvarh snap creation at path ~/Images/Snaps/
SaveSnap(fdr.kvarh_snap, snapFolderPath + fdr.month + "_" + fdr.grid_code + "_" + fdr.feeder_code + "_kvarh.jpg");
recUpdated++;
}
}
result = recUpdated.ToString() + " Updated Successfully";
}
catch (DbEntityValidationException e)
{
StringBuilder sb = new StringBuilder();
foreach (var eve in e.EntityValidationErrors)
{
sb.AppendFormat("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
eve.Entry.Entity.GetType().Name, eve.Entry.State);
foreach (var ve in eve.ValidationErrors)
{
sb.AppendFormat("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage);
}
}
result = sb.ToString();
}
catch (Exception ex)
{
result = ex.ToString();
}
return(result);
}
public static string CreatePreEnter(string bmonth, string SDivCode, string CcCode, VW_USER user)
{
string status = "UnKnown";
try
{
string conStr = System.Configuration.ConfigurationManager.ConnectionStrings["hesco"].ToString();
DBUtil dbUtil = new DBUtil(conStr);
DataTable dt = dbUtil.GetCP22MasterData(bmonth, SDivCode, CcCode);
var _context = new MMR_CP22Entities1();
if (dt != null && dt.Rows.Count > 0)
{
int recNO = 0;
foreach (DataRow dr in dt.Rows)
{
try
{
/*
* Insert Into Cp22_Formb("MONTH", Bmonth, Feeder, Feeder_Name, Mfactor, Prev_Read, PREV_KVARH_READ, Meter_Range, Sdiv_1, Share_1, Fdrsdiv, Fdrcircle, Proof_Listing_Flag, Posted_Flag, Divcode, U_Name, Cp_No, Cc_Code, Record_No, Created_On, Created_By,Type,Main_Feeder,METER_NO,STATUS_CODE)
* Values(Vmonth, P_Month, Vfdrcode, Vfdrname, Vmfactor, Vprev_Reading, vPREV_KVARH_READING_A, Vmeter_Range, Vfdrsdiv , '100.00', Vfdrsdiv, Vcircle, 'N', 'N', Vdivcode, Vu_Name, Vcp_No, Vcc_Code, Vrecord_No, Systimestamp, 'PREENTER',Vtype,Vmain_Feeder,vMTR_NO,'P');
*/
CP22_FORMB formB = new CP22_FORMB();
formB.MONTH = dr["Vmonth"].ToString();
formB.BMONTH = DateTime.ParseExact(dr["vPMonth"].ToString(), "MMyyyy", System.Globalization.CultureInfo.InvariantCulture);
formB.FEEDER = dr["Vfdrcode"].ToString();
formB.FEEDER_NAME = dr["Vfdrname"].ToString();
formB.MFACTOR = decimal.Parse(dr["Vmfactor"].ToString());
formB.PREV_READ = decimal.Parse(dr["Vprev_Reading"].ToString());
formB.PREV_KVARH_READ = !string.IsNullOrEmpty(dr["vPREV_KVARH_READING_A"].ToString()) ? decimal.Parse(dr["vPREV_KVARH_READING_A"].ToString()) : 0;
formB.METER_RANGE = !string.IsNullOrEmpty(dr["vMTR_RANGE"].ToString()) ? byte.Parse(dr["vMTR_RANGE"].ToString()) : new byte();
formB.SDIV_1 = dr["Vfdrsdiv"].ToString();
formB.SHARE_1 = 100;
formB.FDRSDIV = dr["Vfdrsdiv"].ToString();
formB.FDRCIRCLE = dr["Vcircle"].ToString();
formB.PROOF_LISTING_FLAG = "N";
formB.POSTED_FLAG = "N";
formB.DIVCODE = SDivCode;
formB.U_NAME = user.uName;
formB.CP_NO = "CP22";
formB.CC_CODE = CcCode;
formB.RECORD_NO = recNO + 1;
formB.CREATED_ON = DateTime.Now;
formB.CREATED_BY = "PREENTER-MMR";
formB.TYPE = dr["Vtype"].ToString();
formB.MAIN_FEEDER = dr["vMAIN_FEEDER"].ToString();
formB.METER_NO = dr["vMTR_NO"].ToString();
formB.STATUS_CODE = "P";
formB.GRID_CODE = user.GRID_CODE;
formB.GRID_NAME = user.GRID_NAME;
_context.CP22_FORMB.Add(formB);
recNO++;
}
catch (Exception ex)
{
}
}
_context.SaveChanges();
status = recNO.ToString() + " / " + dt.Rows.Count.ToString() + " created successfully";
}
else
{
status = "No data found for given criteria!";
}
}
catch (DbEntityValidationException e)
{
StringBuilder sb = new StringBuilder();
foreach (var eve in e.EntityValidationErrors)
{
sb.AppendFormat("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
eve.Entry.Entity.GetType().Name, eve.Entry.State);
foreach (var ve in eve.ValidationErrors)
{
sb.AppendFormat("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage);
}
}
status = sb.ToString();
}
catch (Exception ex)
{
status = ex.ToString();
}
return(status);
}
