public string GetTruckMasterByTruckNo(string truckno) { TruckMaster truckMaster = _truckRepo.GetTruckMasterByTruckNo(truckno.ToLower()); string mystring = new JavaScriptSerializer().Serialize(truckMaster); return(mystring); }
//Get:TruckMaster Record For Update private void GetTruckForUpdate() { if (!string.IsNullOrEmpty(Request.QueryString["Id"])) { divoptions.Style.Add("display", "block"); txtTruckRegNo.Enabled = false; int id = Convert.ToInt32(Request.QueryString["Id"].ToString()); TruckMaster _truck = _truckrepo.Get_TruckMasterById(id); if (_truck != null) { txtTruckRegNo.Text = _truck.TruckRegNo.Trim().ToUpper().ToString(); ddlClassificationCode.SelectedValue = _truck.ClassificationCode.Trim(); txtStoredTareWeight.Text = _truck.StoredTareWeight.Trim().ToString(); txtTareValidityDate.Text = _truck.TareValidityDate.ToString(); //txtAverageTareScheme.Text = _truck.AverageTareScheme.Trim().ToString(); ddlTareToleranceType.Text = _truck.AverageTareScheme.Trim().ToString(); //txtCUrrentTareValue.Text = _truck.CurrentAverageTareValue.Trim().ToString(); txtWtValue.Text = _truck.CurrentAverageTareValue.Trim().ToString(); txtStoredTareDateTime.Text = _truck.StoredTareDateTime.ToString(); try { ddlTransporterCode.Text = _truck.TransporterCode.Trim(); } catch { } Get_VehicleClassificationCode(); Get_TransporterCode(); ddluom.SelectedValue = _truck.UOMWeight.Trim().ToString(); } } }
public string CreatePendingRecord(string TripId, string truckNo) { TruckMaster _tmaster = _truckRepo.GetTruckMasterByTruckNo(truckNo); tblTransaction _trans = new tblTransaction(); tblTransaction trans = db.tblTransactions.Where(x => x.TruckNo == truckNo && x.TransactionStatus == 1).FirstOrDefault(); if (trans == null) { _trans.TripId = Convert.ToInt32(TripId); _trans.TruckNo = truckNo; _trans.TransporterCode = _tmaster.TransporterCode; _trans.TransporterName = _tmaster.TransporterName; _trans.WeighingUnit = _tmaster.UOMWeight; //_trans.CompanyCode = Session["CompanyCode"].ToString(); //_trans.PlantCode = Session["PlantID"].ToString(); _trans.TripType = 2; _trans.CreateDate = DateTime.Now; _trans.TransactionStatus = 1; _trans.IsMultiProduct = false; _trans.FirstWeight = Convert.ToDecimal(_tmaster.StoredTareWeight); _trans.FirstWtDateTime = _tmaster.StoredTareDateTime; db.tblTransactions.InsertOnSubmit(_trans); db.SubmitChanges(); } string myJsonString = (new JavaScriptSerializer()).Serialize(_trans); return(myJsonString); }
public string Check_TruckMaster(string truckno) { string json = string.Empty; TruckMaster t = _truckRepo.GetTruckMasterByTruckNo(truckno); if (t != null) { json = new JavaScriptSerializer().Serialize(t); } return(json); }
//Add:New Truck Master Record public bool Add_TruckMaster(TruckMaster truck) { bool status = false; if (truck != null) { db.TruckMasters.InsertOnSubmit(truck); db.SubmitChanges(); status = true; } return(status); }
//Delete:Truck Master record by Id public bool Delete_TruckMaster(int id) { bool status = false; TruckMaster truck = db.TruckMasters.FirstOrDefault(x => x.Id == id && x.IsDeleted == false); if (truck != null) { truck.IsDeleted = true; db.SubmitChanges(); status = true; } return(status); }
//Add:New TruckMaster Record private void AddTruck() { if (Request.QueryString["Id"] == null) { try { TruckMaster _tran = _truckrepo.GetTruckMasterByTruckNo(txtTruckRegNo.Text.Trim()); if (_tran != null) { ScriptManager.RegisterStartupScript(this, this.GetType(), "toastr", "toastr.error('Same Truck No exist! Please try again');", true); } else { TruckMaster _vc = new TruckMaster(); _vc.UOMWeight = ddluom.SelectedValue.ToString(); _vc.ClassificationCode = ddlClassificationCode.SelectedValue; _vc.TruckRegNo = txtTruckRegNo.Text.ToUpper(); if (txtStoredTareWeight.Text != "") { _vc.TareValidityDate = txtTareValidityDate.Text; } _vc.StoredTareWeight = txtStoredTareWeight.Text; _vc.CurrentAverageTareValue = txtWtValue.Text; // txtCUrrentTareValue.Text; _vc.AverageTareScheme = ddlTareToleranceType.Text; // txtAverageTareScheme.Text; _vc.StoredTareDateTime = Convert.ToDateTime(txtStoredTareDateTime.Text); _vc.IsDeleted = false; if (ddlTransporterCode.SelectedItem.Value == "0") { _vc.TransporterCode = ddlTransporterCode.SelectedItem.Value; _vc.TransporterName = ""; } else { _vc.TransporterCode = ddlTransporterCode.SelectedItem.Value; _vc.TransporterName = ddlTransporterCode.SelectedItem.Text.Split('(')[0].Replace("(", ""); } if (_truckrepo.Add_TruckMaster(_vc)) { ScriptManager.RegisterStartupScript(this, this.GetType(), "toastr", "toastr.success('Truck Record Saved Successfully');", true); } } } catch (Exception ex) { ScriptManager.RegisterStartupScript(this, this.GetType(), "toastr", "toastr.error('" + ex.Message.ToString() + "');", true); } } }
//Add:New TruckMaster Record private void AddTruck() { if (Request.QueryString["Id"] == null) { try { TruckMaster _tran = _truckrepo.GetTruckMasterByTruckNo(txtTruckRegNo.Text.Trim()); if (_tran != null) { ScriptManager.RegisterStartupScript(this, this.GetType(), "toastr", "toastr.error('Same Truck No exist! Please try again');", true); } else { TruckMaster _vc = new TruckMaster(); _vc.UOMWeight = ddluom.SelectedValue.ToString(); _vc.ClassificationCode = ddlClassificationCode.SelectedValue; _vc.TruckRegNo = txtTruckRegNo.Text; if (txtStoredTareWeight.Text != "") { _vc.TareValidityDate = txtTareValidityDate.Text; } _vc.StoredTareWeight = txtStoredTareWeight.Text; _vc.CurrentAverageTareValue = txtCUrrentTareValue.Text; _vc.AverageTareScheme = txtAverageTareScheme.Text; _vc.TareWtDateTime = DateTime.Now; _vc.IsDeleted = false; if (_truckrepo.Add_TruckMaster(_vc)) { ScriptManager.RegisterStartupScript(this, this.GetType(), "toastr", "toastr.success('Truck Record Saved Successfully')", true); HtmlMeta meta = new HtmlMeta { HttpEquiv = "Refresh", Content = "1;url=AddEdit.aspx" }; Page.Controls.Add(meta); } } } catch (Exception ex) { ScriptManager.RegisterStartupScript(this, this.GetType(), "toastr", "toastr.error('" + ex.Message.ToString() + "');", true); } } }
//Update:TruckMaster private void UpdateTruck() { if (Request.QueryString["Id"] != null) { int id = Convert.ToInt32(Request.QueryString["Id"].ToString()); TruckMaster _tran = _truckrepo.GetTruckMasters_List().Where(x => x.Id != id && x.TruckRegNo == txtTruckRegNo.Text.Trim() && x.IsDeleted == false).SingleOrDefault(); if (_tran != null) { ScriptManager.RegisterStartupScript(this, this.GetType(), "toastr", "toastr.error('Same Truck Reg. No exist! Please try again');", true); } else { TruckMaster _vc = db.TruckMasters.FirstOrDefault(x => x.Id == id && x.IsDeleted == false); if (_vc != null) { _vc.UOMWeight = ddluom.SelectedValue.ToString(); _vc.ClassificationCode = ddlClassificationCode.SelectedItem.Value.ToString(); _vc.TruckRegNo = txtTruckRegNo.Text.ToUpper(); if (txtStoredTareWeight.Text != "") { _vc.TareValidityDate = txtTareValidityDate.Text; } _vc.StoredTareWeight = txtStoredTareWeight.Text; _vc.CurrentAverageTareValue = txtWtValue.Text.Trim(); // txtCUrrentTareValue.Text; _vc.AverageTareScheme = ddlTareToleranceType.Text; // txtAverageTareScheme.Text; _vc.StoredTareDateTime = Convert.ToDateTime(txtStoredTareDateTime.Text); if (ddlTransporterCode.SelectedItem.Value == "0") { _vc.TransporterCode = ddlTransporterCode.SelectedItem.Value; _vc.TransporterName = ""; } else { _vc.TransporterCode = ddlTransporterCode.SelectedItem.Value; _vc.TransporterName = ddlTransporterCode.SelectedItem.Text.Split('(')[0].Replace("(", ""); } db.SubmitChanges(); ScriptManager.RegisterStartupScript(this, this.GetType(), "toastr", "toastr.success('Truck Record Saved Successfully');", true); } } } }
//Get:Previous Record protected void Previous_Record_Click(object sender, EventArgs e) { int id = Convert.ToInt32(Request.QueryString["Id"].ToString()); TruckMaster next = null; try { next = _truckrepo.GetTruckMasters_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); } }
//Update:TruckMaster private void UpdateTruck() { if (Request.QueryString["Id"] != null) { int id = Convert.ToInt32(Request.QueryString["Id"].ToString()); TruckMaster _tran = _truckrepo.GetTruckMasters_List().Where(x => x.Id != id && x.TruckRegNo == txtTruckRegNo.Text.Trim() && x.IsDeleted == false).SingleOrDefault(); if (_tran != null) { ScriptManager.RegisterStartupScript(this, this.GetType(), "toastr", "toastr.error('Same Truck Reg. No exist! Please try again');", true); } else { TruckMaster _vc = db.TruckMasters.FirstOrDefault(x => x.Id == id && x.IsDeleted == false); if (_vc != null) { _vc.UOMWeight = ddluom.SelectedValue.ToString(); _vc.ClassificationCode = ddlClassificationCode.SelectedItem.Value.ToString(); _vc.TruckRegNo = txtTruckRegNo.Text; if (txtStoredTareWeight.Text != "") { _vc.TareValidityDate = txtTareValidityDate.Text; } _vc.StoredTareWeight = txtStoredTareWeight.Text; _vc.CurrentAverageTareValue = txtCUrrentTareValue.Text; _vc.AverageTareScheme = txtAverageTareScheme.Text; db.SubmitChanges(); ScriptManager.RegisterStartupScript(this, this.GetType(), "toastr", "toastr.success('Truck Record Saved Successfully')", true); HtmlMeta meta = new HtmlMeta { HttpEquiv = "Refresh", Content = "1;url=AddEdit.aspx?id=" + id }; Page.Controls.Add(meta); } } } }
public TruckMaster GetTruckMasterRecord(string recordID, string UserSNo) { TruckMaster truckMaster = new TruckMaster(); SqlParameter[] Parameters = { new SqlParameter("@SNo", Convert.ToInt32(recordID)), new SqlParameter("@UserID", Convert.ToInt32(UserSNo)) }; SqlDataReader dr = SqlHelper.ExecuteReader(ReadConnectionString.WebConfigConnectionString, CommandType.StoredProcedure, "GetRecordTruckMaster", Parameters); if (dr.Read()) { truckMaster.SNo = Convert.ToInt32(dr["SNo"]); truckMaster.TruckNo = dr["TruckNo"].ToString().ToUpper(); truckMaster.AssignedTruckRegNo = dr["AssignedTruckRegNo"].ToString().ToUpper(); truckMaster.AssignedTruckExpDate = Convert.ToDateTime(dr["AssignedTruckExpDate"].ToString()); truckMaster.EIDNo = dr["EIDNo"].ToString().ToUpper(); truckMaster.EIDNoExpDate = Convert.ToDateTime(dr["EIDNoExpDate"].ToString()); truckMaster.PPNo = dr["PPNo"].ToString().ToUpper(); truckMaster.PPExpDate = Convert.ToDateTime(dr["PPExpDate"].ToString()); truckMaster.SHJcustomsCardNo = dr["SHJcustomsCardNo"].ToString().ToUpper(); truckMaster.SHJcustomscardNoexpDate = Convert.ToDateTime(dr["SHJcustomscardNoexpDate"].ToString()); truckMaster.DXBcustomsCardNo = dr["DXBcustomsCardNo"].ToString().ToUpper(); truckMaster.DXBcustomsExpDate = Convert.ToDateTime(dr["DXBcustomsExpDate"].ToString()); truckMaster.ADPNo = dr["ADPNo"].ToString().ToUpper(); truckMaster.ADPNoExpDate = Convert.ToDateTime(dr["ADPNoExpDate"].ToString()); if (!String.IsNullOrEmpty(dr["IsActive"].ToString())) { truckMaster.IsActive = Convert.ToBoolean(dr["IsActive"]); truckMaster.Active = dr["Active"].ToString().ToUpper(); } truckMaster.UpdatedBy = dr["UpdatedUser"].ToString(); truckMaster.CreatedBy = dr["CreatedUser"].ToString(); } dr.Close(); return(truckMaster); }
//:Save excel data to database internal 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 _TruckRegNo = dr["Truck Reg No"].ToString(); string _ClassificationCode = dr["Classification Code"].ToString(); string _StoreTareWeight = dr["Store Tare Weight"].ToString(); string _TareValidityDate = dr["Tare Validity Date"].ToString(); string _AveraTareScheme = dr["Average Tare Scheme"].ToString(); string _CurrentAverageTareValue = dr["Current Average Tare Value"].ToString(); string _UOMWeight = dr["UOM Weight"].ToString(); TruckMaster _TruckMaster = db.TruckMasters.Where(x => x.TruckRegNo == _TruckRegNo && x.IsDeleted == false).FirstOrDefault(); VehicleClassification _vc = db.VehicleClassifications.FirstOrDefault(x => x.ClassificationCode == _ClassificationCode && x.IsDeleted == false); if (_TruckMaster != null) { if (string.IsNullOrEmpty(_ClassificationCode)) { _failed++; } else { _TruckMaster.ClassificationCode = _ClassificationCode; _TruckMaster.StoredTareWeight = _StoreTareWeight; _TruckMaster.TareValidityDate = _TareValidityDate; _TruckMaster.AverageTareScheme = _AveraTareScheme; _TruckMaster.CurrentAverageTareValue = _CurrentAverageTareValue; _TruckMaster.UOMWeight = _UOMWeight; db.SubmitChanges(); _update++; } } else { if (!string.IsNullOrEmpty(_TruckRegNo) && !string.IsNullOrEmpty(_ClassificationCode)) { if (_vc == null) { _failed++; } else { TruckMaster t = new TruckMaster(); t.TruckRegNo = _TruckRegNo; t.ClassificationCode = _ClassificationCode; t.AverageTareScheme = _AveraTareScheme; t.CurrentAverageTareValue = _CurrentAverageTareValue; t.StoredTareWeight = _StoreTareWeight; t.TareValidityDate = _TareValidityDate; t.UOMWeight = _UOMWeight; t.IsDeleted = false; db.TruckMasters.InsertOnSubmit(t); db.SubmitChanges(); _success++; } } else { _failed++; } } } catch { _failed++; } } result = "New Added: " + _success + " Updated: " + _update + " Failed: " + _failed + ""; } return(result); }
//Get:TruckMaster By Id public TruckMaster Get_TruckMasterById(int id) { TruckMaster truck = db.TruckMasters.FirstOrDefault(x => x.Id == id && x.IsDeleted == false); return(truck); }
//: Get Truck Master By Truck Number public TruckMaster GetTruckMasterByTruckNo(string TruckNo) { TruckMaster _truck = db.TruckMasters.FirstOrDefault(x => x.TruckRegNo == TruckNo && x.IsDeleted == false); return(_truck); }