public string Get_BarrierByCode(string code) { BarrierMaster _bb = _barrierrepo.GetBarrierByCode(code.ToLower()); string myjsonresult = (new JavaScriptSerializer()).Serialize(_bb); return(myjsonresult); }
//Add:New Barrier Master Record public bool Add_BarrierMaster(BarrierMaster bar) { bool status = false; if (bar != null) { db.BarrierMasters.InsertOnSubmit(bar); db.SubmitChanges(); status = true; } return(status); }
//Delete:Barrier Master By Id public bool Delete_BarrierMaster(int id) { bool status = false; BarrierMaster master = db.BarrierMasters.FirstOrDefault(x => x.Id == id && x.IsDeleted == false); if (master != null) { master.IsDeleted = true; db.SubmitChanges(); status = true; } return(status); }
//Add:New BarrierMaster Record protected void Add_Barrier() { try { int count = _repo.GetBarrierMasters_List().Count(x => x.PlantCodeId == ddlplantid.SelectedValue && x.MachineId == ddlmachinid.SelectedValue && x.IsDeleted == false); if (count < 2) { var check = _repo.GetBarrierMasters_List().Where(x => x.PlantCodeId == ddlplantid.SelectedValue && x.BarrierIP == txtip.Text && x.IsDeleted == false).FirstOrDefault(); if (check != null) { ScriptManager.RegisterStartupScript(this, this.GetType(), "toastr", "toastr.error('Same Barrier IP Exist! Please Try Again.');", true); } else { BarrierMaster _bm = new BarrierMaster(); _bm.PlantCodeId = ddlplantid.SelectedValue.ToString(); _bm.MachineId = ddlmachinid.SelectedValue.ToString(); _bm.BarrierIdentification = txtidentification.Text.ToString(); _bm.BarrierIP = txtip.Text.ToString(); _bm.BarrierPort = txtport.Text.ToString(); _bm.BarrierScheme = ddlscheme.SelectedValue.ToString(); _bm.IsDeleted = false; if (_repo.Add_BarrierMaster(_bm)) { 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 Barrier Allow In 1 Plant.');", true); } } catch (Exception ex) { ScriptManager.RegisterStartupScript(this, this.GetType(), "toastr", "toastr.error('" + ex.Message.ToString() + "');", true); } }
//Get:Barrier master previous record protected void Previous_Record_Click(object sender, EventArgs e) { int id = Convert.ToInt32(Request.QueryString["Id"].ToString()); BarrierMaster next = null; try { next = _repo.GetBarrierMasters_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 _failed = 0; int _success = 0; int _update = 0; foreach (DataRow dr in dt.Rows) { try { string _plantcodeid = dr["Plant Code"].ToString(); string _machinid = dr["Machine Id"].ToString(); string _barrieridentification = dr["Barrier Identification"].ToString(); string _barrierip = dr["Barrier IP"].ToString(); string _barrierport = dr["Barrier PORT"].ToString(); string _barrierscheme = dr["Barrier Scheme"].ToString(); var _bm = db.BarrierMasters.Where(x => x.BarrierIP == _barrierip && x.IsDeleted == false).FirstOrDefault(); if (_bm != null) { var _plantcode = db.PlantMasters.Where(x => x.PlantCode == _plantcodeid && x.IsDeleted == false).FirstOrDefault(); var _mid = db.WeightMachineMasters.Where(x => x.MachineId == _machinid && x.IsDeleted == false).FirstOrDefault(); if (_plantcode != null && _mid != null) { _bm.PlantCodeId = _plantcodeid; _bm.MachineId = _machinid; _bm.BarrierIdentification = _barrieridentification; _bm.BarrierPort = _barrierport; if (_barrierscheme == "N/C" || _barrierscheme == "N/O") { _bm.BarrierScheme = _barrierscheme; } else { _bm.BarrierScheme = ""; } _update++; db.SubmitChanges(); } else { _failed++; } } else { if (!string.IsNullOrEmpty(_barrierip)) { BarrierMaster _brm = db.BarrierMasters.Where(x => x.BarrierIP == _barrierip && x.IsDeleted == false).FirstOrDefault(); if (_brm != null) { _failed++; } else { if (_barrierscheme == "N/C" || _barrierscheme == "N/O") { } else { _barrierscheme = ""; } db.BarrierMasters.InsertOnSubmit(new BarrierMaster { PlantCodeId = _plantcodeid, MachineId = _machinid, BarrierIdentification = _barrieridentification, BarrierIP = _barrierip, BarrierPort = _barrierport, BarrierScheme = _barrierscheme, IsDeleted = false }); _success++; db.SubmitChanges(); } } else { _failed++; } } } catch { _failed++; } } result = "New Added: " + _success + " Updated: " + _update + " Failed: " + _failed + ""; } return(result); }
//Get:Barrier Master by Id public BarrierMaster Get_BarrierMasterBy_Id(int id) { BarrierMaster barrier = db.BarrierMasters.FirstOrDefault(x => x.Id == id && x.IsDeleted == false); return(barrier); }