public string GetAlphaByCode(string code) { AlphaDisplayMaster alphaDisplay = _alpharepo.GetAlphaDisplayByCode(code.ToLower()); string myjsonresult = (new JavaScriptSerializer()).Serialize(alphaDisplay); return(myjsonresult); }
//Add:New AlphaDisplayMaster Record public bool Add_AlphaDisplay(AlphaDisplayMaster alpha) { bool status = false; if (alpha != null) { db.AlphaDisplayMasters.InsertOnSubmit(alpha); db.SubmitChanges(); status = true; } return(status); }
//Delete:AlphaDisplayMaster by Id public bool Delete_AlphaDisplayById(int id) { bool status = false; AlphaDisplayMaster master = db.AlphaDisplayMasters.FirstOrDefault(x => x.Id == id && x.IsDeleted == false); if (master != null) { master.IsDeleted = true; db.SubmitChanges(); status = true; } return(status); }
//Add:New AlphaDisplayMaster Record private void Add() { try { int count = db.AlphaDisplayMasters.Count(x => x.PlantCodeId == ddlplantcode.SelectedValue && x.MachineId == ddlmachineid.SelectedValue && x.IsDeleted == false); if (count < 2) { var check = db.AlphaDisplayMasters.Where(x => x.PlantCodeId == ddlplantcode.SelectedValue && x.AlphaDisplayIP == txtip.Text && x.IsDeleted == false).FirstOrDefault(); if (check != null) { ScriptManager.RegisterStartupScript(this, this.GetType(), "toastr", "toastr.error('Same Alpha Display IP Exist! Please Try Again.');", true); } else { AlphaDisplayMaster _ad = new AlphaDisplayMaster(); _ad.PlantCodeId = ddlplantcode.SelectedValue; _ad.MachineId = ddlmachineid.SelectedValue; _ad.AlphaDisplayIdentification = txtidentification.Text.ToString(); _ad.AlphaDisplayIP = txtip.Text.ToString(); _ad.AlphaDisplayPort = txtport.Text.ToString(); _ad.IsDeleted = false; if (_repo.Add_AlphaDisplay(_ad)) { ScriptManager.RegisterStartupScript(this, this.GetType(), "toastr", "toastr.success('Save Successfully')", true); HtmlMeta meta = new HtmlMeta(); meta.HttpEquiv = "Refresh"; meta.Content = "1;url=AddEdit.aspx"; this.Page.Controls.Add(meta); } } } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "toastr", "toastr.error('Maximum 2 Alpha Display Allow In 1 Plant.');", true); } } catch (Exception ex) { ScriptManager.RegisterStartupScript(this, this.GetType(), "toastr", "toastr.error('" + ex.Message.ToString() + "');", true); } }
//Get:AlphaDisplayMaster Previous Record protected void Previous_Record_Click(object sender, EventArgs e) { int id = Convert.ToInt32(Request.QueryString["Id"].ToString()); AlphaDisplayMaster next = null; try { next = _repo.GetAlphaDisplayMasters_List().Where(x => x.Id < id && x.IsDeleted == false).OrderByDescending(i => i.Id).FirstOrDefault(); } catch { } if (next != null) { Response.Redirect("AddEdit.aspx?id=" + next.Id.ToString()); } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "toastr", "toastr.success('No more records founds.')", true); } }
//Save:Excel Data To The Server public string SaveDataToServer(DataSet ds) { string result = string.Empty; using (DataClasses1DataContext db = new DataClasses1DataContext()) { string connection = ConfigurationManager.ConnectionStrings["AveryDBConnectionString"].ConnectionString; DataTable dt = ds.Tables[0]; int fail = 0; int success = 0; int update = 0; foreach (DataRow dr in dt.Rows) { try { string PlantCodeId = dr["Plant Code Id"].ToString(); string MachineId = dr["Machine Id"].ToString(); string AlphaDisplayIdentification = dr["Alpha Display Identification"].ToString(); string AlphaDisplayIp = dr["Alpha Display IP"].ToString(); string AlphaDisplayPort = dr["Alpha Display PORT"].ToString(); var plantmaster = db.PlantMasters.Where(x => x.PlantCode == PlantCodeId && x.IsDeleted == false).ToList(); var machinemaster = db.WeightMachineMasters.Where(x => x.MachineId == MachineId && x.IsDeleted == false).ToList(); int count = db.AlphaDisplayMasters.Count(x => x.PlantCodeId == PlantCodeId & x.MachineId == MachineId && x.IsDeleted == false); if (plantmaster.Count > 0 && machinemaster.Count > 0) { if (AlphaDisplayIdentification.Length <= 10 && AlphaDisplayIp.Length <= 15 && AlphaDisplayPort.Length <= 5) { var data = db.AlphaDisplayMasters.FirstOrDefault(x => x.PlantCodeId == PlantCodeId && x.MachineId == MachineId && x.AlphaDisplayIP == AlphaDisplayIp && x.IsDeleted == false); var IPExist = db.AlphaDisplayMasters.FirstOrDefault(x => x.PlantCodeId == PlantCodeId && x.AlphaDisplayIP == AlphaDisplayIp && x.Id != data.Id && x.IsDeleted == false); if (data != null) { if (IPExist == null) { if (regex.CheckIPAddress(AlphaDisplayIp)) { data.PlantCodeId = PlantCodeId; data.MachineId = MachineId; data.AlphaDisplayPort = AlphaDisplayPort; data.AlphaDisplayIdentification = AlphaDisplayIdentification; data.AlphaDisplayIP = AlphaDisplayIp; db.SubmitChanges(); update++; } else { fail++; } } else { fail++; } } else { if (count < 2) { var a = db.AlphaDisplayMasters.FirstOrDefault(x => x.PlantCodeId == PlantCodeId && x.AlphaDisplayIP == AlphaDisplayIp && x.IsDeleted == false); if (a != null) { if (regex.CheckIPAddress(AlphaDisplayIp)) { AlphaDisplayMaster alpha = new AlphaDisplayMaster(); alpha.PlantCodeId = PlantCodeId; alpha.MachineId = MachineId; alpha.AlphaDisplayIdentification = AlphaDisplayIdentification; alpha.AlphaDisplayIP = AlphaDisplayIp; alpha.AlphaDisplayPort = AlphaDisplayPort; db.AlphaDisplayMasters.InsertOnSubmit(alpha); db.SubmitChanges(); success++; } } } else { fail++; } } } else { fail++; } } else { fail++; } } catch { fail++; } } result = "New Added: " + success + " Updated: " + update + " Failed: " + fail + ""; } return(result); }
//Get:AlphaDisplayMaster by Id public AlphaDisplayMaster Get_AlphaDisplayById(int id) { AlphaDisplayMaster master = db.AlphaDisplayMasters.FirstOrDefault(x => x.Id == id && x.IsDeleted == false); return(master); }