//Add:New VehicleClassification record private void AddVC() { if (Request.QueryString["Id"] == null) { AverageTareSchema _tran = repo.GetTareTolerance_ByCode(ddlToleranceType.Text.Trim()); if (_tran != null) { ScriptManager.RegisterStartupScript(this, this.GetType(), "toastr", "toastr.error('Same Vehicle Classification code exist! Please try again');", true); } else { AverageTareSchema _vc = new AverageTareSchema(); _vc.Description = ddlToleranceType.Text.ToString(); _vc.weightvalue = Convert.ToDecimal(txtvalue.Text.ToString()); //_vc.GrossWeight = Convert.ToDecimal(txtGrossWt.Text); //_vc.KerbWt = Convert.ToDecimal(txtkerbWt.Text); //_vc.Make = txtMake.Text.ToString(); //_vc.ManufactureYear = Convert.ToInt32(txtYearManufacture.Text.ToString()); //_vc.Model = txtModel.Text.ToString(); //_vc.NoOfAxies = Convert.ToDecimal(txtNoOfAxles.Text.ToString()); //_vc.UOMWeight = ddluom.SelectedValue.ToString(); //_vc.IsDeleted = false; if (repo.Add_TareTolerance(_vc)) { ScriptManager.RegisterStartupScript(this, this.GetType(), "toastr", "toastr.success('Saved Successfully')", true); HtmlMeta meta = new HtmlMeta(); meta.HttpEquiv = "Refresh"; meta.Content = "1;url=Add.aspx"; this.Page.Controls.Add(meta); } } } }
//Update:VehicleClassification private void UpdateVC() { if (Request.QueryString["Id"] != null) { int id = Convert.ToInt32(Request.QueryString["Id"].ToString()); AverageTareSchema _tran = repo.Get_TareToleranceById(id); if (_tran != null) { ScriptManager.RegisterStartupScript(this, this.GetType(), "toastr", "toastr.error('Same Vehicle Classification code exist! Please try again');", true); } else { AverageTareSchema _vc = db.AverageTareSchemas.Where(x => x.Id == id).SingleOrDefault(); _vc.Description = ddlToleranceType.Text.ToString(); _vc.weightvalue = Convert.ToDecimal(txtvalue.Text.ToString()); db.SubmitChanges(); ScriptManager.RegisterStartupScript(this, this.GetType(), "toastr", "toastr.success('Record Update Successfully')", true); HtmlMeta meta = new HtmlMeta(); meta.HttpEquiv = "Refresh"; meta.Content = "1;url=Add.aspx?id=" + id; this.Page.Controls.Add(meta); } } }
protected void ddlTareToleranceType_SelectedIndexChanged(object sender, EventArgs e) { if (!string.IsNullOrEmpty(ddlTareToleranceType.Text.Trim())) { AverageTareSchema _avgtarewt = db.AverageTareSchemas.Where(x => x.Description == ddlTareToleranceType.Text.Trim()).FirstOrDefault(); this.txtWtValue.Text = _avgtarewt.weightvalue.ToString(); } }
public string ToleranceTypeValue(string ttype) { AverageTareSchema _toltype = db.AverageTareSchemas.Where(x => x.Description == ttype).FirstOrDefault(); //.Where(x => x.PlantCode == Session["PlantID"].ToString() && x.MachineId == Session["WBID"].ToString()).FirstOrDefault(); string myJsonString = (new JavaScriptSerializer()).Serialize(_toltype.weightvalue.ToString()); return(myJsonString); }
//Add:New Transporter Record public bool Add_TareTolerance(AverageTareSchema tran) { bool status = false; if (tran != null) { db.AverageTareSchemas.InsertOnSubmit(tran); db.SubmitChanges(); status = true; } return(status); }
//Delete:Tranporter by Id public bool Delete_TareToleranceById(int id) { bool status = false; AverageTareSchema tran = db.AverageTareSchemas.FirstOrDefault(x => x.Id == id); if (tran != null) { db.AverageTareSchemas.DeleteOnSubmit(tran); //tran.IsDeleted = true; db.SubmitChanges(); status = true; } return(status); }
//Get:Vehicle classification record for update private void GetVCForUpdate() { if (!string.IsNullOrEmpty(Request.QueryString["Id"])) { divoptions.Style.Add("display", "block"); //txtcode.Enabled = false; int id = Convert.ToInt32(Request.QueryString["Id"].ToString()); AverageTareSchema _vc = repo.Get_TareToleranceById(id); if (_vc != null) { ddlToleranceType.Text = _vc.Description.ToString(); txtvalue.Text = _vc.weightvalue.ToString(); } } }
//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 _Description = dr["Description"].ToString(); string _weightvalue = dr["weightvalue"].ToString(); var _transporter = db.AverageTareSchemas.Where(x => x.Description == _Description).FirstOrDefault(); if (_transporter != null) { if (string.IsNullOrEmpty(_Description)) { _failed++; } else { _transporter.Description = _Description; _transporter.weightvalue = Convert.ToDecimal(_weightvalue); db.SubmitChanges(); _update++; } } else { if (!string.IsNullOrEmpty(_Description) && !string.IsNullOrEmpty(_weightvalue)) { AverageTareSchema _trans = db.AverageTareSchemas.Where(x => x.Description == _Description).FirstOrDefault(); if (_trans != null) { _failed++; } else { db.AverageTareSchemas.InsertOnSubmit(new AverageTareSchema { Description = _Description, weightvalue = Convert.ToDecimal(_weightvalue) }); db.SubmitChanges(); _success++; } } else { _failed++; } } } catch { _failed++; } } result = "New Added: " + _success + " Updated: " + _update + " Failed: " + _failed + ""; } return(result); }
//Get:Transporter by transporter code public AverageTareSchema GetTareTolerance_ByCode(string code) { AverageTareSchema trans = db.AverageTareSchemas.Where(x => x.Description == code).SingleOrDefault(); return(trans); }
//Get:Transporter By Id public AverageTareSchema Get_TareToleranceById(int id) { AverageTareSchema tran = db.AverageTareSchemas.FirstOrDefault(x => x.Id == id); return(tran); }