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);
}
