private void BindData(DbObject dbobj)
{
DataSet dsobj = new DataSet();
SqlParameter[] parameters2 =
{
new SqlParameter("@OrgId",SqlDbType.Int,4,ParameterDirection.Input,false,0,0,null,DataRowVersion.Default,OrgId),
};
dsobj=dbobj.dsRunProcedure("sp_SelectEquipAltLists",parameters2,"Lists");
ddStatusId.DataSource = dsobj;
ddStatusId.DataMember = "Lists";
ddStatusId.DataValueField = "id";
ddStatusId.DataTextField = "vchName";
ddStatusId.DataBind();
ddPMScheduleId.DataSource = dsobj;
ddPMScheduleId.DataMember = "Lists1";
ddPMScheduleId.DataValueField = "id";
ddPMScheduleId.DataTextField = "vchName";
ddPMScheduleId.DataBind();
ddPMScheduleId.Items.Insert(0,"");
ddInspectionId.DataSource = dsobj;
ddInspectionId.DataMember = "Lists2";
ddInspectionId.DataValueField = "id";
ddInspectionId.DataTextField = "vchName";
ddInspectionId.DataBind();
ddInspectionId.Items.Insert(0,"");
}
private void BindData(DbObject dbobj)
{
DataSet dsobj = new DataSet();
SqlParameter[] parameters2 = {
new SqlParameter("@OrgId",SqlDbType.Int)
};
parameters2[0].Value = OrgId;
dsobj=dbobj.dsRunProcedure("sp_SelectEquipTypesMakesModels",parameters2,"Types");
dsobj.Relations.Add( new DataRelation( "Types_Makes", dsobj.Tables["Types"].Columns["Id"], dsobj.Tables["Types1"].Columns["TypeId"] ) );
dsobj.Relations.Add( new DataRelation( "Makes_Models", dsobj.Tables["Types1"].Columns["Id"], dsobj.Tables["Types2"].Columns["MakeId"] ) );
ddTypeId.DataSource = dsobj;
ddTypeId.DataMember = "Types";
ddTypeId.DataValueField = "id";
ddTypeId.DataTextField = "vchName";
ddTypeId.DataBind();
ddTypeId.Items.Insert(0,"");
ddMakeId.DataSource = dsobj;
ddMakeId.DataMember = "Types1";
ddMakeId.DataValueField = "id";
ddMakeId.DataTextField = "vchMakeName";
ddMakeId.DataBind();
ddMakeId.Items.Insert(0,"");
ddModelId.DataSource = dsobj;
ddModelId.DataMember = "Types2";
ddModelId.DataValueField = "id";
ddModelId.DataTextField = "vchModelName";
ddModelId.DataBind();
ddModelId.Items.Insert(0,"");
ddDeptId.DataSource = dsobj;
ddDeptId.DataMember = "Types3";
ddDeptId.DataValueField = "id";
ddDeptId.DataTextField = "vchName";
ddDeptId.DataBind();
ddDeptId.Items.Insert(0,"");
ddLocationId.DataSource = dsobj;
ddLocationId.DataMember = "Types4";
ddLocationId.DataValueField = "id";
ddLocationId.DataTextField = "vchName";
ddLocationId.DataBind();
ddLocationId.Items.Insert(0,"");
ListLink1.DataBind();
ListLink2.DataBind();
}
private void BindData()
{
SqlParameter[] parameters = {
new SqlParameter("@OrgId",SqlDbType.Int,4,ParameterDirection.Input,false,0,0,null,DataRowVersion.Default,OrgId)
};
DbObject dbobj1 = new DbObject();
dbobj1.CntOpen();
DataGrid1.DataSource=dbobj1.drRunProcedure("sp_SelectEquipList",parameters);
DataGrid1.DataBind();
dbobj1.CntClose();
}
private void btSave_FormSubmit(object sender, EventArgs e)
{
Trace.Write("btSave-UserId", UId.ToString());
Trace.Write("btSave-SelectedValue",ddAssignTo.SelectedValue);
SqlParameter[] parameters =
{
new SqlParameter("@OrgId",SqlDbType.Int,4,ParameterDirection.Input,false,0,0,null,DataRowVersion.Default,OrgId),
new SqlParameter("@UID",SqlDbType.Int,4,ParameterDirection.Input,false,0,0,null,DataRowVersion.Default,UId),
new SqlParameter("@EquipId",SqlDbType.Int,4,ParameterDirection.Input,false,0,0,null,DataRowVersion.Default,EquipId),
new SqlParameter("@intAssignedTo",SqlDbType.Int,4,ParameterDirection.Input,false,0,0,null,DataRowVersion.Default,ddAssignTo.SelectedValue),
new SqlParameter("@vchNote",SqlDbType.VarChar,250,ParameterDirection.Input,false,0,0,null,DataRowVersion.Default,tbNote.Text)
};
DbObject dbobj1 = new DbObject();
dbobj1.intRunProcedure("sp_UpdateEquipAssignedTo",parameters);
Response.Redirect(ParentPageURL);
}
private void LoadData()
{
int returnValue;
SqlCommand cmd;
SqlParameter[] parameters =
{
new SqlParameter("@OrgId",SqlDbType.Int,4,ParameterDirection.Input,false,0,0,null,DataRowVersion.Default,OrgId),
new SqlParameter("@Id",SqlDbType.Int,4,ParameterDirection.Input,false,0,0,null,DataRowVersion.Default,EquipId),
new SqlParameter("@vchEquipId",SqlDbType.Int,4,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
new SqlParameter("@intYear",SqlDbType.Int,4,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
new SqlParameter("@vchType",SqlDbType.VarChar,50,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
new SqlParameter("@vchMake",SqlDbType.VarChar,50,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
new SqlParameter("@vchModel",SqlDbType.VarChar,50,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
new SqlParameter("@vchAssignedTo",SqlDbType.VarChar,100,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null)
};
DbObject dbobj = new DbObject();
cmd = dbobj.cmdRunProcedure("sp_SelectEquipView",parameters,out returnValue);
if(returnValue!=-1)
{
lbEquipId.Text=cmd.Parameters["@vchEquipId"].Value.ToString();
lbTypeMakeModel.Text=cmd.Parameters["@vchType"].Value.ToString()+"/"+cmd.Parameters["@vchMake"].Value.ToString()+"/"+cmd.Parameters["@vchModel"].Value.ToString();
lbYear.Text=cmd.Parameters["@intYear"].Value.ToString();
lbAssignFrom.Text=cmd.Parameters["@vchAssignedTo"].Value.ToString();
}
SqlParameter[] parameters2 =
{
new SqlParameter("@OrgId",SqlDbType.Int,4,ParameterDirection.Input,false,0,0,null,DataRowVersion.Default,OrgId),
new SqlParameter("@EquipId",SqlDbType.Int,4,ParameterDirection.Input,false,0,0,null,DataRowVersion.Default,EquipId)
};
DataSet dsobj=dbobj.dsRunProcedure("sp_SelectEquipAssignTo",parameters2,"Names");
ddAssignTo.DataSource = dsobj;
ddAssignTo.DataMember = "Names";
ddAssignTo.DataValueField = "id";
ddAssignTo.DataTextField = "vchName";
ddAssignTo.DataBind();
ddAssignTo.Items.Insert(0,new System.Web.UI.WebControls.ListItem("","0"));
}
private void Page_Load(object sender, System.EventArgs e)
{
EquipId=Convert.ToInt32(Request.QueryString["id"]);
if(EquipId==0){ //Add New
string [,] arrBrdCrumbs = new string [2,2];
arrBrdCrumbs[0,0]="../default.aspx";
arrBrdCrumbs[0,1]="Home";
arrBrdCrumbs[1,0]="list.aspx";
arrBrdCrumbs[1,1]="Equipment List";
PageTitle = "Add Equipment";
Header.BrdCrumbs=ParseBreadCrumbs(arrBrdCrumbs,PageTitle);
Header.PageTitle=PageTitle;
ckReassign.Visible=false;
lbAssignedToCap.Visible=false;
lbReassignCap.Visible=false;
lbReassignHelp.Visible=false;
}else{
string [,] arrBrdCrumbs = new string [3,2];
arrBrdCrumbs[0,0]="../default.aspx";
arrBrdCrumbs[0,1]="Home";
arrBrdCrumbs[1,0]="list.aspx";
arrBrdCrumbs[1,1]="Equipment List";
arrBrdCrumbs[2,0]="view.aspx?id="+EquipId+"";
arrBrdCrumbs[2,1]="Equipment Detail";
PageTitle = "Equipment-Edit Main";
Header.BrdCrumbs=ParseBreadCrumbs(arrBrdCrumbs,PageTitle);
Header.PageTitle=PageTitle;
}
SaveCancelControl.ParentPageURL=ParentPageURL;
#region Not Postback
if(!Page.IsPostBack)//Not Postback
{
DbObject dbobj1 = new DbObject();
if(EquipId!=0) //Look up existing values
{
//Lookup current DB values
SqlParameter[] parameters =
{
new SqlParameter("@Action",SqlDbType.Char,1,ParameterDirection.Input,false,0,0,null,DataRowVersion.Default,"S"),
new SqlParameter("@OrgId",SqlDbType.Int,4,ParameterDirection.Input,false,0,0,null,DataRowVersion.Default,OrgId),
new SqlParameter("@Id",SqlDbType.Int,4,ParameterDirection.Input,false,0,0,null,DataRowVersion.Default,EquipId),
new SqlParameter("@TypeId",SqlDbType.Int,4,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
new SqlParameter("@MakeId",SqlDbType.Int,4,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
new SqlParameter("@ModelId",SqlDbType.Int,4,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
new SqlParameter("@vchEquipId",SqlDbType.VarChar,25,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
new SqlParameter("@intYear",SqlDbType.Int,4,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
new SqlParameter("@DeptId",SqlDbType.Int,4,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
new SqlParameter("@LocId",SqlDbType.Int,4,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
new SqlParameter("@vchAssignedTo",SqlDbType.VarChar,100,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
new SqlParameter("@vchVinSerial",SqlDbType.VarChar,50,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
new SqlParameter("@vchFuelCode",SqlDbType.VarChar,25,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null)
};
int returnValue;
//SqlCommand cmd = dbobj1.cmdRunProcedure("sp_SelectEquipDetail",parameters,out returnValue);
SqlCommand cmd = dbobj1.cmdRunProcedure("sp_EquipEditDetail",parameters,out returnValue);
if(returnValue!=-1)
{
ddTypeId.SelectedValue=cmd.Parameters["@TypeId"].Value.ToString();
ddMakeId.SelectedValue=cmd.Parameters["@MakeId"].Value.ToString();
ddModelId.SelectedValue=cmd.Parameters["@ModelId"].Value.ToString();
tbEquipId.Text=cmd.Parameters["@vchEquipId"].Value.ToString();
tbYear.Text=cmd.Parameters["@intYear"].Value.ToString();
ddDeptId.SelectedValue=cmd.Parameters["@DeptId"].Value.ToString();
ddLocationId.SelectedValue=cmd.Parameters["@LocId"].Value.ToString();
lbAssignedTo.Text=cmd.Parameters["@vchAssignedTo"].Value.ToString();
tbVinSerial.Text=cmd.Parameters["@vchVinSerial"].Value.ToString();
tbFuelCode.Text=cmd.Parameters["@vchFuelCode"].Value.ToString();
}
else //record not found
{
Response.Redirect("list.aspx");
}
} //End looking up current values
BindData(dbobj1);
}//End Not Postback
#endregion
}
private void btSave_FormSubmit(object sender, EventArgs e)
{
EquipId=Convert.ToInt32(Request.QueryString["id"]);
bool AddNew=false;
if(EquipId==0){
AddNew=true;
}
DbObject dbobj1 = new DbObject();
SqlParameter[] parameters =
{
new SqlParameter("@Action",SqlDbType.Char,1,ParameterDirection.Input,false,0,0,null,DataRowVersion.Default,"U"),
new SqlParameter("@OrgId",SqlDbType.Int,4,ParameterDirection.Input,false,0,0,null,DataRowVersion.Default,OrgId),
new SqlParameter("@Id",SqlDbType.Int,4,ParameterDirection.Input,false,0,0,null,DataRowVersion.Default,EquipId),
new SqlParameter("@TypeId",SqlDbType.Int,4,ParameterDirection.Input,false,0,0,null,DataRowVersion.Default,ddTypeId.SelectedValue),
new SqlParameter("@MakeId",SqlDbType.Int,4,ParameterDirection.Input,false,0,0,null,DataRowVersion.Default,ddMakeId.SelectedValue),
new SqlParameter("@ModelId",SqlDbType.Int,4,ParameterDirection.Input,false,0,0,null,DataRowVersion.Default,ddModelId.SelectedValue),
new SqlParameter("@DeptId",SqlDbType.Int,4,ParameterDirection.Input,false,0,0,null,DataRowVersion.Default,ddDeptId.SelectedValue),
new SqlParameter("@LocId",SqlDbType.Int,4,ParameterDirection.Input,false,0,0,null,DataRowVersion.Default,ddLocationId.SelectedValue),
new SqlParameter("@intYear",SqlDbType.Int,4,ParameterDirection.Input,false,0,0,null,DataRowVersion.Default,tbYear.Text),
new SqlParameter("@vchEquipId",SqlDbType.VarChar,25,ParameterDirection.Input,false,0,0,null,DataRowVersion.Default,tbEquipId.Text),
new SqlParameter("@vchVinSerial",SqlDbType.VarChar,50,ParameterDirection.Input,false,0,0,null,DataRowVersion.Default,tbVinSerial.Text),
new SqlParameter("@vchFuelCode",SqlDbType.VarChar,25,ParameterDirection.Input,false,0,0,null,DataRowVersion.Default,tbFuelCode.Text)
};
EquipId = dbobj1.intRunProcedure("sp_EquipEditDetail",parameters);
if(ckReassign.Checked | AddNew==true){
Response.Redirect("reassign.aspx?id="+EquipId+"");
}
else{
Response.Redirect("view.aspx?id="+EquipId+"");
}
}
private void Page_Load(object sender, System.EventArgs e)
{
EquipId=Convert.ToInt32(Request.QueryString["id"]);
PageTitle = "Equipment Detail";
string [,] arrBrdCrumbs = new string [2,2];
arrBrdCrumbs[0,0]="../default.aspx";
arrBrdCrumbs[0,1]="Home";
arrBrdCrumbs[1,0]="list.aspx";
arrBrdCrumbs[1,1]="Equipment List";
Header.BrdCrumbs=ParseBreadCrumbs(arrBrdCrumbs,PageTitle);
Header.PageTitle=PageTitle;
DbObject dbobj1 = new DbObject();
SqlParameter[] parameters =
{
new SqlParameter("@OrgId",SqlDbType.Int,4,ParameterDirection.Input,false,0,0,null,DataRowVersion.Default,OrgId),
new SqlParameter("@Id",SqlDbType.Int,4,ParameterDirection.Input,false,0,0,null,DataRowVersion.Default,EquipId),
new SqlParameter("@vchEquipId",SqlDbType.VarChar,25,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
new SqlParameter("@intYear",SqlDbType.Int,4,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
new SqlParameter("@vchType",SqlDbType.VarChar,50,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
new SqlParameter("@vchMake",SqlDbType.VarChar,50,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
new SqlParameter("@vchModel",SqlDbType.VarChar,50,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
new SqlParameter("@vchDept",SqlDbType.VarChar,50,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
new SqlParameter("@vchLocation",SqlDbType.VarChar,50,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
new SqlParameter("@vchAssignedTo",SqlDbType.VarChar,100,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
new SqlParameter("@vchVinSerial",SqlDbType.VarChar,50,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
new SqlParameter("@vchStatus",SqlDbType.VarChar,50,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
new SqlParameter("@vchPMSched",SqlDbType.VarChar,25,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
new SqlParameter("@vchInspect",SqlDbType.VarChar,50,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
new SqlParameter("@intCurrentUnits",SqlDbType.Int,4,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
new SqlParameter("@dtInService",SqlDbType.SmallDateTime,4,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
new SqlParameter("@dtAquired",SqlDbType.SmallDateTime,4,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
new SqlParameter("@vchPurOrgContact",SqlDbType.VarChar,50,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
new SqlParameter("@smPurAmount",SqlDbType.SmallMoney,4,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
new SqlParameter("@intPurUnits",SqlDbType.Int,4,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
new SqlParameter("@vchPurNotes",SqlDbType.VarChar,250,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
new SqlParameter("@dtOutOfService",SqlDbType.SmallDateTime,4,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
new SqlParameter("@dtDisposed",SqlDbType.SmallDateTime,4,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
new SqlParameter("@vchDispOrgContact",SqlDbType.VarChar,50,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
new SqlParameter("@smDispAmount",SqlDbType.SmallMoney,4,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
new SqlParameter("@intDispUnits",SqlDbType.Int,4,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
new SqlParameter("@vchDispNotes",SqlDbType.VarChar,250,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
new SqlParameter("@vchDispMethod",SqlDbType.VarChar,25,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
new SqlParameter("@vchTransMake",SqlDbType.VarChar,25,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
new SqlParameter("@vchTransModel",SqlDbType.VarChar,25,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
new SqlParameter("@vchTransPart",SqlDbType.VarChar,25,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
new SqlParameter("@vchTransSerial",SqlDbType.VarChar,25,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
new SqlParameter("@vchEngineMake",SqlDbType.VarChar,25,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
new SqlParameter("@vchEngineModel",SqlDbType.VarChar,25,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
new SqlParameter("@vchEnginePart",SqlDbType.VarChar,25,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
new SqlParameter("@vchEngineSerial",SqlDbType.VarChar,25,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
new SqlParameter("@vchChasisMake",SqlDbType.VarChar,25,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
new SqlParameter("@vchChasisNumber",SqlDbType.VarChar,25,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null),
new SqlParameter("@vchFuelCode",SqlDbType.VarChar,25,ParameterDirection.Output,false,0,0,null,DataRowVersion.Default,null)
};
int returnValue;
SqlCommand cmd = dbobj1.cmdRunProcedure("sp_SelectEquipView",parameters,out returnValue);
lbYear.Text=cmd.Parameters["@intYear"].Value.ToString();
lbDept.Text=cmd.Parameters["@vchDept"].Value.ToString();
lbLoc.Text=cmd.Parameters["@vchLocation"].Value.ToString();
lbVinSerial.Text=cmd.Parameters["@vchVinSerial"].Value.ToString();
lbAssignedTo.Text=cmd.Parameters["@vchAssignedTo"].Value.ToString();
lbStrEquipId.Text=cmd.Parameters["@vchEquipId"].Value.ToString();
lbMake.Text=cmd.Parameters["@vchMake"].Value.ToString();
lbModel.Text=cmd.Parameters["@vchModel"].Value.ToString();;
lbType.Text=cmd.Parameters["@vchType"].Value.ToString();
lbStatus.Text=cmd.Parameters["@vchStatus"].Value.ToString();
lbPMSched.Text=cmd.Parameters["@vchPMSched"].Value.ToString();
lbInspection.Text=cmd.Parameters["@vchInspect"].Value.ToString();
lbUnits.Text=cmd.Parameters["@intCurrentUnits"].Value.ToString();
lbDtInService.Text=String.Format("{0:d}",cmd.Parameters["@dtInService"].Value);
lbDtAquired.Text=String.Format("{0:d}",cmd.Parameters["@dtAquired"].Value);
lbVchPurOrgContact.Text=cmd.Parameters["@vchPurOrgContact"].Value.ToString();
lbSmPurAmount.Text=String.Format("{0:0.00}",cmd.Parameters["@smPurAmount"].Value);
lbIntPurUnits.Text=cmd.Parameters["@intPurUnits"].Value.ToString();
lbVchPurNotes.Text=cmd.Parameters["@vchPurNotes"].Value.ToString();
lbDtOutOfService.Text=String.Format("{0:d}",cmd.Parameters["@dtOutOfService"].Value);;
lbDtDisposed.Text=String.Format("{0:d}",cmd.Parameters["@dtDisposed"].Value);;
lbVchDispOrgContact.Text=cmd.Parameters["@vchDispOrgContact"].Value.ToString();;
lbSmDispAmount.Text=String.Format("{0:0.00}",cmd.Parameters["@smDispAmount"].Value);;
lbIntDispUnits.Text=cmd.Parameters["@intDispUnits"].Value.ToString();;
lbVchDispNotes.Text=cmd.Parameters["@vchDispNotes"].Value.ToString();
lbVchDispMethod.Text=cmd.Parameters["@vchDispMethod"].Value.ToString();
lbTranMake.Text=cmd.Parameters["@vchTransMake"].Value.ToString();
tbTransModel.Text=cmd.Parameters["@vchTransModel"].Value.ToString();
lbTranPart.Text=cmd.Parameters["@vchTransPart"].Value.ToString();
lbTranSerial.Text=cmd.Parameters["@vchTransSerial"].Value.ToString();
lbEngineMake.Text=cmd.Parameters["@vchEngineMake"].Value.ToString();
lbEngineModel.Text=cmd.Parameters["@vchEngineModel"].Value.ToString();
lbEnginePart.Text=cmd.Parameters["@vchEnginePart"].Value.ToString();
lbEngineSerial.Text=cmd.Parameters["@vchEngineSerial"].Value.ToString();
lblChasisMake.Text = cmd.Parameters["@vchChasisMake"].Value.ToString();
lblChasisNumber.Text = cmd.Parameters["@vchChasisNumber"].Value.ToString();
lbFuelCode.Text=cmd.Parameters["@vchFuelCode"].Value.ToString();
}