private void SetValues(String sm_Vehicle) { try { M_VehicleDL objm_VehicleDL = new M_VehicleDL(); M_Vehicles objm_Vehicle = new M_Vehicles(); if (sm_Vehicle != "") { objm_Vehicle.VehicleID = sm_Vehicle; objm_Vehicle = objm_VehicleDL.Selectm_Vehicle(objm_Vehicle); if (objm_Vehicle != null) { incomingvehicle = objm_Vehicle.VehicleNo.ToString(); txt_VehicleID.Text = objm_Vehicle.VehicleID.ToString(); txt_VehicleNo.Text = objm_Vehicle.VehicleNo.ToString(); //txt_CompCode.Text = objm_Vehicle.CompCode.ToString(); //txt_Locacode.Text = objm_Vehicle.Locacode.ToString(); txt_Make.Text = objm_Vehicle.Make.ToString(); txt_Model.Text = objm_Vehicle.Model.ToString(); txt_Driver.Text = objm_Vehicle.Driver.ToString(); txt_Milage.Text = objm_Vehicle.Milage.ToString(); txt_FuelEfficiency.Text = objm_Vehicle.FuelEfficiency.ToString(); txt_Status.Text = objm_Vehicle.Status.ToString(); txt_Route.Text = objm_Vehicle.Route.ToString(); //txt_Userx.Text = objm_Vehicle.Userx.ToString(); //txt_Datex.Text = objm_Vehicle.Datex.ToString(); formMode = 3; } } } catch (Exception ex) { throw ex; } }
private void GetData() { try { M_VehicleDL bdl = new M_VehicleDL(); dataGridView1.DataSource = bdl.SelectAllm_Vehicle(); if (dataGridView1.DataSource != null) { dataGridView1.Columns[0].Width = 120; dataGridView1.Columns[1].Width = 585; } } catch (Exception ex) { throw ex; } }
private void performButtons(xEnums.PerformanceType xenum) { switch (xenum) { case xEnums.PerformanceType.View: if (ActiveControl.Name.Trim() == txt_VehicleID.Name.Trim()) { int length = Convert.ToInt32(ConfigurationManager.AppSettings["VehicleFieldLength"]); string[] strSearchField = new string[length]; string strSQL = ConfigurationManager.AppSettings["VehicleSQL"].ToString(); for (int i = 0; i < length; i++) { string m; m = i.ToString(); strSearchField[i] = ConfigurationManager.AppSettings["VehicleField" + m + ""].ToString(); } frmU_Search find = new frmU_Search(strSQL, strSearchField, this); find.ShowDialog(this); } break; case xEnums.PerformanceType.New: FunctionButtonStatus(xEnums.PerformanceType.New); formMode = 1; txt_VehicleID.Focus(); errorProvider1.Clear(); break; case xEnums.PerformanceType.Edit: FunctionButtonStatus(xEnums.PerformanceType.Edit); formMode = 3; txt_VehicleID.Enabled = false; txt_VehicleNo.Focus(); errorProvider1.Clear(); break; case xEnums.PerformanceType.Save: errorProvider1.Clear(); if (txt_VehicleNo.Text.Trim() == "") { errorProvider1.SetError(txt_VehicleNo, "Please enter a vehicle number !"); return; } if (txt_VehicleID.Text.Trim() == "") { errorProvider1.SetError(txt_VehicleID, "Please enter a vehicle ID !"); return; } if (incomingvehicle.Trim().ToUpper() != txt_VehicleNo.Text.Trim()) { if (M_VehicleDL.ExistingM_VehicleNo(txt_VehicleNo.Text.Trim())) { errorProvider1.SetError(txt_VehicleNo, "The vehicle number you have entered already exists!"); return; } } if (formMode == 1) { if (M_VehicleDL.ExistingM_Vehicle(txt_VehicleID.Text.Trim())) { errorProvider1.SetError(txt_VehicleID, "The vehicle code you have entered already exists!"); return; } if (UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_PerfmBtn_Save, commonFunctions.Softwarename.Trim()) == System.Windows.Forms.DialogResult.Yes) { M_Vehicles objm_Vehicle = new M_Vehicles(); objm_Vehicle.VehicleID = txt_VehicleID.Text.Trim(); objm_Vehicle.VehicleNo = txt_VehicleNo.Text.Trim(); objm_Vehicle.CompCode = commonFunctions.GlobalCompany; //txt_CompCode.Text.Trim(); objm_Vehicle.Locacode = commonFunctions.GlobalLocation; //txt_Locacode.Text.Trim(); objm_Vehicle.Make = txt_Make.Text.Trim(); objm_Vehicle.Model = txt_Model.Text.Trim(); objm_Vehicle.Driver = txt_Driver.Text.Trim(); objm_Vehicle.Milage = txt_Milage.Text.Trim(); objm_Vehicle.FuelEfficiency = commonFunctions.ToDecimal(txt_FuelEfficiency.Text.Trim()); objm_Vehicle.Status = txt_Status.Text.Trim(); objm_Vehicle.Route = txt_Route.Text.Trim(); objm_Vehicle.Userx = commonFunctions.Loginuser; //txt_Userx.Text.Trim(); objm_Vehicle.Datex = DateTime.Now; //txt_Datex.Text.Trim(); M_VehicleDL bal = new M_VehicleDL(); bal.SaveM_VehicleSP(objm_Vehicle, 1); GetData(); txt_VehicleID.Enabled = true; FunctionButtonStatus(xEnums.PerformanceType.Save); commonFunctions.SetMDIStatusMessage(UserDefineMessages.Msg_Save_Sucess_string, 2); } } else if (formMode == 3) { if (UserDefineMessages.ShowMsg("", UserDefineMessages.Msg_PerfmBtn_Update, commonFunctions.Softwarename.Trim()) == System.Windows.Forms.DialogResult.Yes) { M_Vehicles objm_Vehicle = new M_Vehicles(); objm_Vehicle.VehicleID = txt_VehicleID.Text.Trim(); objm_Vehicle.VehicleNo = txt_VehicleNo.Text.Trim(); objm_Vehicle.CompCode = commonFunctions.GlobalCompany; //txt_CompCode.Text.Trim(); objm_Vehicle.Locacode = commonFunctions.GlobalLocation; //txt_Locacode.Text.Trim(); objm_Vehicle.Make = txt_Make.Text.Trim(); objm_Vehicle.Model = txt_Model.Text.Trim(); objm_Vehicle.Driver = txt_Driver.Text.Trim(); objm_Vehicle.Milage = txt_Milage.Text.Trim(); objm_Vehicle.FuelEfficiency = commonFunctions.ToDecimal(txt_FuelEfficiency.Text.Trim()); objm_Vehicle.Status = txt_Status.Text.Trim(); objm_Vehicle.Route = txt_Route.Text.Trim(); objm_Vehicle.Userx = commonFunctions.Loginuser; //txt_Userx.Text.Trim(); objm_Vehicle.Datex = DateTime.Now; //txt_Datex.Text.Trim(); M_VehicleDL bal = new M_VehicleDL(); bal.SaveM_VehicleSP(objm_Vehicle, 3); GetData(); txt_VehicleID.Enabled = true; FunctionButtonStatus(xEnums.PerformanceType.Save); commonFunctions.SetMDIStatusMessage(UserDefineMessages.Msg_Update_Sucess_string, 2); } } break; case xEnums.PerformanceType.Cancel: txt_VehicleID.Enabled = true; FunctionButtonStatus(xEnums.PerformanceType.Default); errorProvider1.Clear(); break; case xEnums.PerformanceType.Print: UserDefineMessages.ShowMsg1("Print still in process", UserDefineMessages.Msg_Information); break; } }