//:Get Plant Master For Update private void Get_PlantInfo_ForEdit() { if (!string.IsNullOrEmpty(Request.QueryString["Id"])) { divoptions.Style.Add("display", "block"); txtPlantCOde.Enabled = false; int id = Convert.ToInt32(Request.QueryString["Id"]); PlantMaster _pm = repo.Get_PlantMaster_by_Id(id); if (_pm != null) { txtPlantCOde.Text = _pm.PlantCode.ToString(); txtPlantName.Text = _pm.PlantName.ToString(); txtDesignation.Text = _pm.Designation.ToString(); txtContactPerson.Text = _pm.PlantContactPerson.ToString(); txtContactMobile.Text = _pm.ContactMobile.ToString(); txtContactEmail.Text = _pm.ContactEmail.ToString(); txtAddress1.Text = _pm.PlantAddress1.ToString(); txtAddress2.Text = _pm.PlantAddress2.ToString(); txtMachineCount.Text = _pm.NoOfMachine.ToString(); } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "toastr", "toastr.error('Plant code not found.please try again');", true); } } }
public string Get_PlantMasterByCode(string code) { PlantMaster _pm = _plantrepo.Get_PlantMaster_By_PlantCode(code.ToLower()); string myjsonresult = new JavaScriptSerializer().Serialize(_pm); return(myjsonresult); }
public string Check_PlantMaster(string code) { code = code.ToLower(); string jsonstring = string.Empty; PlantMaster mat = _plantrepo.Get_PlantList().Where(x => x.PlantCode.ToLower() == code && x.IsDeleted == false).FirstOrDefault(); if (mat != null) { jsonstring = new JavaScriptSerializer().Serialize(mat); } return(jsonstring); }
//Add:New plant master public bool Add_PlantMaster(PlantMaster plant) { bool status = false; if (plant != null) { db.PlantMasters.InsertOnSubmit(plant); db.SubmitChanges(); status = true; } return(status); }
//Delete:Plant Master By Id public bool Delete_PlantById(int id) { bool status = false; PlantMaster plant = db.PlantMasters.FirstOrDefault(x => x.Id == id && x.IsDeleted == false); if (plant != null) { plant.IsDeleted = true; db.SubmitChanges(); status = true; } return(status); }
protected void BtnLogin_Click(object sender, EventArgs e) { string _UserName = UserName.Value; string _Password = Password.Value; string _WBID = WBID.Value; string _PlantID = PlantID.Value; UserMaster um = umRepo.CheckUserCredentials(_UserName, _Password, _WBID, _PlantID); SiteParameterSetting setting = db.SiteParameterSettings.FirstOrDefault(); PlantMaster _plantCode = db.PlantMasters.Where(x => x.PlantCode == _PlantID).FirstOrDefault(); if (um != null && um.Id != 0) { Session["UserName"] = _UserName; Session["Password"] = _Password; Session["WBID"] = _WBID; Session["UserId"] = um.Id; Session["PlantID"] = _PlantID; Session["CompanyCode"] = _plantCode.CompanyCode; Session["WBFORM"] = "0"; GLOBALVARIABLE(); FormsAuthentication.RedirectFromLoginPage(um.Id.ToString(), true); UserClassification uc = umRepo.GetUserAuthorization(um.Id); New_Weighing_Unit(_WBID, _PlantID); Session["FIRSTWT_RCD"] = "0"; Session["SECONDWT_RCD"] = "0"; if (uc != null) { if (uc.GateEntry == true) { Response.Redirect("/GateEntryForm"); } else if (uc.Weighment == false) { Session["WBFORM"] = "1"; Response.Redirect("/ManageMasters"); } else { Response.Redirect("/Manual_Weighment"); } } } else { ClientScript.RegisterStartupScript(this.GetType(), "myalert", "toastr.error('No User account found. Please try again.');", true); } }
//:Get Previous Record From Plant Master protected void Previous_Record_Click(object sender, EventArgs e) { int id = Convert.ToInt32(Request.QueryString["Id"].ToString()); PlantMaster next = null; try { next = repo.Get_PlantList().Where(x => x.Id < id && x.IsDeleted == false).OrderByDescending(i => i.Id).FirstOrDefault(); } catch { } if (next != null) { Response.Redirect("PlantInfo.aspx?id=" + next.Id.ToString()); } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "toastr", "toastr.success('No more records founds.')", true); } }
//Update:Plant Master Record private void Update_PlantInfo() { if (!string.IsNullOrEmpty(Request.QueryString["Id"])) { int Id = Convert.ToInt32(Request.QueryString["Id"].ToString()); //PlantMaster _master = repo.Get_PlantMaster_by_Id(Id); PlantMaster _master = db.PlantMasters.FirstOrDefault(x => x.Id == Id && x.IsDeleted == false); if (_master != null) { PlantMaster _plant = repo.Get_PlantList().Where(x => x.PlantCode == txtPlantCOde.Text && x.Id != Id && x.IsDeleted == false).FirstOrDefault(); if (_plant != null) { ScriptManager.RegisterStartupScript(this, this.GetType(), "toastr", "toastr.error('Same Plant Code Exist! Please Try Again.');", true); } else { _master.ContactEmail = txtContactEmail.Text; _master.ContactMobile = txtContactMobile.Text; _master.Designation = txtDesignation.Text; _master.NoOfMachine = Convert.ToInt32(txtMachineCount.Text); _master.PlantAddress1 = txtAddress1.Text; _master.PlantAddress2 = txtAddress2.Text; _master.PlantCode = txtPlantCOde.Text; _master.PlantContactPerson = txtContactPerson.Text; _master.PlantName = txtPlantName.Text.Trim().ToString(); db.SubmitChanges(); ClientScript.RegisterStartupScript(this.GetType(), "toastr", "toastr.success('Plant info updated successfully.');", true); HtmlMeta meta = new HtmlMeta { HttpEquiv = "Refresh", Content = "1;url=PlantInfo.aspx?id=" + Id }; this.Page.Controls.Add(meta); } } } }
//:Add New Plant Master Record private void Add_PlantInfo() { PlantMaster _master = repo.Get_PlantMaster_By_PlantCode(txtPlantCOde.Text.Trim()); if (_master != null) { ClientScript.RegisterStartupScript(this.GetType(), "toastr", "toastr.error('Same Plant code is already exists.');", true); } else { _master = new PlantMaster(); _master.ContactEmail = txtContactEmail.Text; _master.ContactMobile = txtContactMobile.Text; _master.Designation = txtDesignation.Text; try { _master.NoOfMachine = Convert.ToInt32(txtMachineCount.Text); } catch { _master.NoOfMachine = 0; } _master.PlantAddress1 = txtAddress1.Text; _master.PlantAddress2 = txtAddress2.Text; _master.PlantCode = txtPlantCOde.Text; _master.PlantContactPerson = txtContactPerson.Text; _master.PlantName = txtPlantName.Text; _master.IsDeleted = false; if (repo.Add_PlantMaster(_master)) { ClientScript.RegisterStartupScript(this.GetType(), "myalert", "toastr.success('Plant info saved successfully.');", true); HtmlMeta meta = new HtmlMeta { HttpEquiv = "Refresh", Content = "1;url=PlantInfo.aspx" }; this.Page.Controls.Add(meta); } } }
protected void lnkprintPDF_Click(object sender, EventArgs e) { PlantMaster _plant = _plantRepo.getplantByWeighingMachine(Session["PlantID"].ToString(), "com1"); //BaseFont bfR = iTextSharp.text.pdf.BaseFont.CreateFont(BaseFont.TIMES_ROMAN, iTextSharp.text.pdf.BaseFont.CP1257, iTextSharp.text.pdf.BaseFont.EMBEDDED); //PdfWriter writer = PdfWriter.GetInstance(document, fs); StyleSheet style1 = new StyleSheet(); style1.LoadTagStyle(HtmlTags.TABLE, HtmlTags.FONTSIZE, "8px"); Response.ContentType = "application/pdf"; Response.AddHeader("content-disposition", "attachment;filename=DateWiseReports.pdf"); Response.Cache.SetCacheability(HttpCacheability.NoCache); StringWriter sw = new StringWriter(); HtmlTextWriter hw = new HtmlTextWriter(sw); hw.AddStyleAttribute("font-size", "8pt"); // rptList.DataBind(); Panel1.RenderControl(hw); StringReader sr = new StringReader(sw.ToString()); Document pdfDoc = new Document(PageSize.A4, 20f, 20f, 20f, 20f); // pdfDoc.SetPageSize(iTextSharp.text.PageSize.A4.Rotate()); HTMLWorker htmlparser = new HTMLWorker(pdfDoc); PdfWriter.GetInstance(pdfDoc, Response.OutputStream); pdfDoc.Open(); string CompanyLogo = HttpContext.Current.Server.MapPath(".") + @"\images\companylogo\logo.jpg"; string header1 = HttpContext.Current.Server.MapPath(".") + @"\images\header1.png"; string header2 = HttpContext.Current.Server.MapPath(".") + @"\images\header2.png"; //imgLogo.ImageUrl = "/images/companylogo/" + company.CompanyLogo; //added on 24-10-2019 BaseFont bfTimes = BaseFont.CreateFont(BaseFont.TIMES_ROMAN, BaseFont.CP1252, false); var boldTableFont = FontFactory.GetFont("Arial", 8, iTextSharp.text.Font.BOLD); var NORMALFont = FontFactory.GetFont("Arial", 8, iTextSharp.text.Font.NORMAL); PdfPTable table1 = new PdfPTable(4); table1.WidthPercentage = 100; table1.SetWidths(new float[] { 0.10f, 0.13f, 0.15f, 0.20f }); //First Row PdfPCell cellheaderleft = new PdfPCell(); cellheaderleft.Border = 0; iTextSharp.text.Image image = iTextSharp.text.Image.GetInstance(header1); image.ScaleAbsolute(230f, 200f); image.Alignment = Element.HEADER; cellheaderleft.AddElement(image); table1.AddCell(cellheaderleft); cellheaderleft = new PdfPCell(); cellheaderleft.Border = 0; image.ScaleAbsolute(230f, 200f); image.Alignment = Element.HEADER; cellheaderleft.AddElement(image); table1.AddCell(cellheaderleft); cellheaderleft = new PdfPCell(); cellheaderleft.Border = 0; image.ScaleAbsolute(230f, 200f); image.Alignment = Element.HEADER; cellheaderleft.AddElement(image); table1.AddCell(cellheaderleft); PdfPCell cellheaderright = new PdfPCell(); cellheaderright.Border = 0; cellheaderright.Rowspan = 2; iTextSharp.text.Image image2 = iTextSharp.text.Image.GetInstance(header2); image2.ScaleAbsolute(190f, 500f); image2.Alignment = Element.HEADER; cellheaderright.AddElement(image2); table1.AddCell(cellheaderright); //2nd Row cellheaderleft = new PdfPCell(); cellheaderleft.Border = 0; iTextSharp.text.Image logoImage = iTextSharp.text.Image.GetInstance(CompanyLogo); image.ScaleAbsolute(250f, 200f); image.Alignment = Element.HEADER; cellheaderleft.AddElement(logoImage); table1.AddCell(cellheaderleft); cellheaderleft = new PdfPCell(); cellheaderleft.Border = 0; table1.AddCell(cellheaderleft); string PlantCodeAddress = _plant.PlantName + "\n" + _plant.PlantAddress1 + "\n" + _plant.PlantAddress2; var p = new Paragraph(PlantCodeAddress, boldTableFont); cellheaderleft = new PdfPCell(); cellheaderleft.Border = 0; cellheaderleft.HorizontalAlignment = Element.ALIGN_CENTER; cellheaderleft.AddElement(p); table1.AddCell(cellheaderleft); PdfPCell Reportname = new PdfPCell(new Phrase("Date wise Report", boldTableFont)); Reportname.HorizontalAlignment = Element.ALIGN_LEFT; Reportname.Padding = 5; Reportname.Colspan = 2; table1.AddCell(Reportname); PdfPCell tripdatetime = new PdfPCell(new Phrase("Print Date/Time :", boldTableFont)); tripdatetime.HorizontalAlignment = Element.ALIGN_RIGHT; table1.AddCell(tripdatetime); PdfPCell tripdatetimeValue = new PdfPCell(new Phrase(DateTime.Now.ToString(), NORMALFont)); tripdatetimeValue.HorizontalAlignment = Element.ALIGN_LEFT; table1.AddCell(tripdatetimeValue); pdfDoc.Add(table1); htmlparser.Parse(sr); pdfDoc.Close(); Response.Write(pdfDoc); Response.End(); }
//Save Excel File Data To SQL 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) { int userid = 0; string _UserName = dr["User Name"].ToString(); string _Password = dr["Password"].ToString(); string _UserType = dr["User Type"].ToString(); string _PlantCode = dr["Plant Code"].ToString(); string _machines = dr["Weigh Machines"].ToString(); int _UserTypeId = 0; try { _UserTypeId = db.UserClassifications.FirstOrDefault(x => x.UserType == _UserType && x.IsDeleted == false).Id; } catch { } PlantMaster _pm = db.PlantMasters.FirstOrDefault(x => x.PlantCode == _PlantCode && x.IsDeleted == false); var data = db.UserMasters.FirstOrDefault(x => x.UserName == _UserName && x.IsDeleted == false); if (data != null) { int id = 0; try { id = db.UserMasters.FirstOrDefault(x => x.UserName == _UserName && x.IsDeleted == false).Id; } catch { } userid = id; UserMaster _um = db.UserMasters.FirstOrDefault(x => x.UserName == _UserName & x.IsDeleted == false && x.Id != id); if (_um != null) { _failed++; } else { if (!string.IsNullOrEmpty(_Password) && !string.IsNullOrEmpty(_UserName) && _UserTypeId > 0 && _pm != null) { data.UserName = _UserName; data.Password = _Password; data.UserType = _UserTypeId; data.Plantcode = _PlantCode; db.SubmitChanges(); _update++; } else { _failed++; } } } else { int id = db.UserClassifications.FirstOrDefault(x => x.UserType == _UserType && x.IsDeleted == false).Id; var _plant = db.PlantMasters.FirstOrDefault(x => x.PlantCode == _PlantCode && x.IsDeleted == false); if (id > 0 && _plant != null && !string.IsNullOrEmpty(_UserName) && !string.IsNullOrEmpty(_Password)) { var _user = db.UserMasters.FirstOrDefault(x => x.UserName == _UserName && x.IsDeleted == false); if (_user != null) { _failed++; } else { UserMaster _um = new UserMaster(); _um.UserName = _UserName; _um.Password = _Password; _um.UserType = id; _um.Plantcode = _PlantCode; db.UserMasters.InsertOnSubmit(_um); db.SubmitChanges(); userid = _um.Id; _success++; } } } string[] machines = _machines.Split(','); foreach (string _mc in machines) { int machineId = 0; try { machineId = db.WeightMachineMasters.Where(x => x.MachineId == _mc).FirstOrDefault().Id; } catch { } if (machineId != 0 && userid != 0) { UserWeightMachineMaster uwmm = db.UserWeightMachineMasters.Where(x => x.UserId == userid && x.WeightMachineId == machineId).FirstOrDefault(); if (uwmm == null) { uwmm = new UserWeightMachineMaster(); uwmm.WeightMachineId = machineId; uwmm.UserId = userid; db.UserWeightMachineMasters.InsertOnSubmit(uwmm); db.SubmitChanges(); } } } } result = "Result: Not saved: " + _failed + ", Saved: " + _success + ", Updated: " + _update; } return(result); }
//Save:Excel file 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 _PlantCode = dr["Plant Code"].ToString(); string _MachineId = dr["Machine Id"].ToString(); string _IPPort = dr["IP Port"].ToString(); string _PortNo = dr["Port No"].ToString(); string _ModeOfComs = dr["Mode Of Coms"].ToString(); string _StabilityNos = dr["Stability Nos"].ToString(); string _StabilityRange = dr["Stability Range"].ToString(); int _ZeroInterlock = Convert.ToInt32(dr["Zero Interlock"]); string _ZeroInterlockRange = dr["Zero Interlock Range"].ToString(); string _TransactionNoPrefix = dr["Transaction No Prefix"].ToString(); int _TareCheck = Convert.ToInt32(dr["Tare Check"]); int _StoredTare = Convert.ToInt32(dr["Stored Tare"]); var data = db.tblMachineWorkingParameters.Where(x => x.PlantCode == _PlantCode && x.MachineId == _MachineId && x.IsDeleted == false).FirstOrDefault(); if (data != null) { if (string.IsNullOrEmpty(_IPPort) && string.IsNullOrEmpty(_PortNo) && string.IsNullOrEmpty(_ModeOfComs)) { _failed++; } else { data.PlantCode = _PlantCode; data.MachineId = _MachineId; data.IPPort = _IPPort; data.PortNo = _PortNo; data.StabilityNos = _StabilityNos; data.StabilityRange = _StabilityRange; data.TransactionNoPrefix = _TransactionNoPrefix; data.ZeroInterlock = _ZeroInterlock; data.ZeroInterlockRange = _ZeroInterlockRange; data.ModeOfComs = _ModeOfComs; data.TareCheck = _TareCheck; data.StoredTare = _StoredTare; db.SubmitChanges(); _update++; } } else { if (!string.IsNullOrEmpty(_PlantCode) && !string.IsNullOrEmpty(_MachineId) && !string.IsNullOrEmpty(_ModeOfComs) && !string.IsNullOrEmpty(_IPPort) && !string.IsNullOrEmpty(_PortNo)) { PlantMaster _plantmaster = db.PlantMasters.Where(x => x.PlantCode == _PlantCode && x.IsDeleted == false).FirstOrDefault(); WeightMachineMaster _machinemaster = db.WeightMachineMasters.Where(x => x.MachineId == _MachineId && x.IsDeleted == false).FirstOrDefault(); if (_plantmaster != null && _machinemaster != null) { tblMachineWorkingParameter _machineparameter = db.tblMachineWorkingParameters.Where(x => x.PlantCode == _PlantCode && x.MachineId == _MachineId && x.IsDeleted == false).FirstOrDefault(); if (_machineparameter != null) { _failed++; } else { tblMachineWorkingParameter t = new tblMachineWorkingParameter(); t.PlantCode = _PlantCode; t.MachineId = _MachineId; t.IPPort = _IPPort; t.PortNo = _PortNo; t.StabilityNos = _StabilityNos; t.StabilityRange = _StabilityRange; t.TransactionNoPrefix = _TransactionNoPrefix; t.ZeroInterlock = _ZeroInterlock; t.ZeroInterlockRange = _ZeroInterlockRange; t.TareCheck = _TareCheck; t.StoredTare = _StoredTare; t.ModeOfComs = _ModeOfComs; db.tblMachineWorkingParameters.InsertOnSubmit(t); db.SubmitChanges(); _success++; } } else { _failed++; } } else { _failed++; } } } catch { _failed++; } } result = "New Added: " + _success + " Updated: " + _update + " Failed: " + _failed + ""; } return(result); }
//Save Excel File 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 _companycode = dr["Company Code"].ToString(); string _plantcode = dr["Plant Code"].ToString(); string _plantname = dr["Plant Name"].ToString(); string _plantcontactperson = dr["Plant Contact Person"].ToString(); string _designation = dr["Designation"].ToString(); string _contactmobile = dr["Contact Mobile"].ToString(); string _contactemail = dr["Contact Email"].ToString(); string _plantaddress1 = dr["Plant Address1"].ToString(); string _plantaddress2 = dr["Plant Address2"].ToString(); int? _noofmachine = Convert.ToInt32(dr["No Of Machine"]); if (_plantcode.Length <= 10 && _plantname.Length <= 25 && _plantcontactperson.Length <= 25 && _designation.Length <= 25 && _contactmobile.Length <= 12 && _plantaddress1.Length <= 25 && _plantaddress2.Length <= 25 && _noofmachine.ToString().Length <= 3) { var _plantmaster = db.PlantMasters.Where(x => x.PlantCode == _plantcode && x.IsDeleted == false).FirstOrDefault(); if (_plantmaster != null) { if (string.IsNullOrEmpty(_plantname)) { _failed++; } else { int id = db.PlantMasters.FirstOrDefault(x => x.PlantCode == _plantcode && x.IsDeleted == false).Id; var _pm = db.PlantMasters.FirstOrDefault(x => x.PlantCode == _plantcode && x.IsDeleted == false && x.Id != id); if (_pm != null) { _failed++; } else { if (regex.CheckNumber(_contactmobile) && regex.ValidateEmail(_contactemail)) { _plantmaster.PlantCode = _plantcode.ToString(); _plantmaster.PlantName = _plantname.ToString(); _plantmaster.Designation = _designation.ToString(); _plantmaster.PlantContactPerson = _plantcontactperson.ToString(); _plantmaster.PlantAddress1 = _plantaddress1.ToString(); _plantmaster.PlantAddress2 = _plantaddress2.ToString(); _plantmaster.ContactEmail = _contactemail.ToString(); _plantmaster.ContactMobile = _contactmobile.ToString(); _plantmaster.NoOfMachine = _noofmachine; db.SubmitChanges(); _update++; } else { _failed++; } } } } else { if (!string.IsNullOrEmpty(_plantcode) && !string.IsNullOrEmpty(_plantname)) { PlantMaster _master = db.PlantMasters.FirstOrDefault(x => x.PlantCode == _plantcode && x.IsDeleted == false); if (_master != null) { _failed++; } else { try { if (regex.CheckNumber(_contactmobile) && regex.ValidateEmail(_contactemail)) { PlantMaster plant = new PlantMaster(); plant.PlantCode = _plantcode.ToString(); plant.PlantName = _plantname.ToString(); plant.Designation = _designation.ToString(); plant.PlantContactPerson = _plantcontactperson.ToString(); plant.PlantAddress1 = _plantaddress1.ToString(); plant.PlantAddress2 = _plantaddress2.ToString(); plant.ContactEmail = _contactemail.ToString(); plant.ContactMobile = _contactmobile.ToString(); plant.NoOfMachine = _noofmachine; plant.IsDeleted = false; db.PlantMasters.InsertOnSubmit(plant); db.SubmitChanges(); _success++; } else { _failed++; } } catch { _failed++; } } } else { _failed++; } } } } catch { _failed++; } } result = "New Added:- " + _success + " Updated:- " + _update + " Failed:- " + _failed + ""; } return(result); }
public PlantMaster getplantByWeighingMachine(string plantCode, string companyCode) { PlantMaster master = db.PlantMasters.Where(x => x.PlantCode == plantCode && x.CompanyCode == companyCode).FirstOrDefault(); return(master); }
//Get:Plant Master By Plant Id public PlantMaster Get_PlantMaster_by_Id(int id) { PlantMaster plant = db.PlantMasters.FirstOrDefault(x => x.Id == id && x.IsDeleted == false); return(plant); }
//:Get Plant master record by plantcode public PlantMaster Get_PlantMaster_By_PlantCode(string code) { PlantMaster plantMaster = db.PlantMasters.FirstOrDefault(x => x.PlantCode == code && x.IsDeleted == false); return(plantMaster); }