public ClsCarFleet GetCarFleetByCarFleetId(long lgCarFleetId) { ClsCarFleet objClsCarFleet = new ClsCarFleet(); try { using (this.objDataContext = new CarFleetDataContext(Functions.StrConnection)) { GetCarFleetByIdResult item = this.objDataContext.GetCarFleetById(lgCarFleetId).ToList().FirstOrDefault(); if (item != null) { objClsCarFleet.inId = item.ID; objClsCarFleet.inOwner_Id = item.Owner_Id; objClsCarFleet.strLast_Trip = item.Last_Trip.Replace(' ', '/'); objClsCarFleet.strCode = item.Code; objClsCarFleet.strReg = item.Reg; objClsCarFleet.strDesc = item.Description; objClsCarFleet.inColor_Id = item.Color_Id; objClsCarFleet.strFuel_Type = item.Fuel_Type; objClsCarFleet.inLast_Km = item.Last_Km; objClsCarFleet.strLast_Location = item.Last_Location; objClsCarFleet.strMake = item.Make; objClsCarFleet.inFleetModels_Id = Convert.ToInt32(item.FleetModels_Id); } } } catch (Exception ex) { Functions.Write(ex, System.Reflection.MethodBase.GetCurrentMethod().Name, PageMaster.CarFleet, mySession.Current.UserId); } return(objClsCarFleet); }
public Task <List <SelectListItem> > GetAllCarFleetCodeForDropDown() { List <SelectListItem> lstCarFleet = new List <SelectListItem>(); try { using (this.objDataContext = new CarFleetDataContext(Functions.StrConnection)) { lstCarFleet.Add(new SelectListItem { Text = "--Select--", Value = string.Empty }); List <GetCarFleetAllResult> lstCarFleetResult = this.objDataContext.GetCarFleetAll().ToList(); if (lstCarFleetResult != null && lstCarFleetResult.Count > 0) { foreach (var item in lstCarFleetResult) { lstCarFleet.Add(new SelectListItem { Text = item.Code, Value = item.ID.ToString() }); } } } } catch (Exception ex) { Functions.Write(ex, System.Reflection.MethodBase.GetCurrentMethod().Name, PageMaster.TripReason, mySession.Current.UserId); } return(Task.FromResult(lstCarFleet)); }
public int SaveCarFleet(ClsCarFleet objSave) { try { using (TransactionScope scope = new TransactionScope()) { using (this.objDataContext = new CarFleetDataContext(Functions.StrConnection)) { var result = this.objDataContext.InsertOrUpdateCarFleet(objSave.inId, objSave.inOwner_Id, objSave.strCode, objSave.strReg, objSave.strDesc, objSave.inColor_Id, objSave.strFuel_Type, objSave.strLast_Trip, objSave.inLast_Km, objSave.strLast_Location, objSave.inFleetModels_Id, objSave.inFleetMakes_Id, mySession.Current.UserId, PageMaster.CarFleet.ToString().intSafe(), null, null).FirstOrDefault(); if (result != null) { objSave.inId = result.InsertedId; } } scope.Complete(); } return(objSave.inId); } catch (Exception ex) { Functions.Write(ex, System.Reflection.MethodBase.GetCurrentMethod().Name, PageMaster.CarFleet, mySession.Current.UserId); return(0); } }
public List <GetCarFleetAllResult> GetCarFleetAll() { try { using (this.objDataContext = new CarFleetDataContext(Functions.StrConnection)) { List <GetCarFleetAllResult> lstCarFleetAll = this.objDataContext.GetCarFleetAll().ToList(); return(lstCarFleetAll); } } catch (Exception ex) { Functions.Write(ex, System.Reflection.MethodBase.GetCurrentMethod().Name, PageMaster.CarFleet, mySession.Current.UserId); return(null); } }
public List <SearchCarFleetResult> SearchCarFleet(int inRow, int inPage, string strSearch, string strSort, string strTripStartDate, string strTripEndDate) { try { using (this.objDataContext = new CarFleetDataContext(Functions.StrConnection)) { List <SearchCarFleetResult> lstSearchCarFleet = this.objDataContext.SearchCarFleet(inRow, inPage, strSort, strTripStartDate, strTripEndDate, strSearch).ToList(); return(lstSearchCarFleet); } } catch (Exception ex) { Functions.Write(ex, System.Reflection.MethodBase.GetCurrentMethod().Name, PageMaster.CarFleet, mySession.Current.UserId); return(null); } }
public DeleteCarFleetResult DeleteCarFleet(string strCarFleetId, long lgDeletedBy) { try { using (this.objDataContext = new CarFleetDataContext(Functions.StrConnection)) { DeleteCarFleetResult result = this.objDataContext.DeleteCarFleet(strCarFleetId, lgDeletedBy, PageMaster.User).FirstOrDefault(); if (result == null) { result = new DeleteCarFleetResult(); } return(result); } } catch (Exception ex) { Functions.Write(ex, System.Reflection.MethodBase.GetCurrentMethod().Name, PageMaster.User, mySession.Current.UserId); return(null); } }