public List <SelectListItem> GetAllFleetModelsForDropDown() { List <SelectListItem> lstFleetModels = new List <SelectListItem>(); try { using (this.objDataContext = new FleetModelsDataContext(Functions.StrConnection)) { lstFleetModels.Add(new SelectListItem { Text = "--Select--", Value = string.Empty }); List <GetFleetModelsAllResult> lstFleetModelsResult = this.objDataContext.GetFleetModelsAll().ToList(); if (lstFleetModelsResult != null && lstFleetModelsResult.Count > 0) { foreach (var item in lstFleetModelsResult) { lstFleetModels.Add(new SelectListItem { Text = item.FleetModelsName, Value = item.Id.ToString() }); } } } } catch (Exception ex) { Functions.Write(ex, System.Reflection.MethodBase.GetCurrentMethod().Name, PageMaster.FleetModels, mySession.Current.UserId); } return(lstFleetModels); }
public long SaveFleetModels(ClsFleetModels objSave) { try { using (TransactionScope scope = new TransactionScope()) { using (this.objDataContext = new FleetModelsDataContext(Functions.StrConnection)) { var result = this.objDataContext.InsertOrUpdateFleetModels(objSave.lgId, objSave.strFleetModelsName, mySession.Current.UserId, PageMaster.FleetModels).FirstOrDefault(); if (result != null) { objSave.lgId = result.InsertedId; } } scope.Complete(); } return(objSave.lgId); } catch (Exception ex) { Functions.Write(ex, System.Reflection.MethodBase.GetCurrentMethod().Name, PageMaster.FleetModels, mySession.Current.UserId); return(0); } }
public List <GetFleetModelsAllResult> GetFleetModelsAll() { try { using (this.objDataContext = new FleetModelsDataContext(Functions.StrConnection)) { List <GetFleetModelsAllResult> lstFleetModelsAll = this.objDataContext.GetFleetModelsAll().ToList(); return(lstFleetModelsAll); } } catch (Exception ex) { Functions.Write(ex, System.Reflection.MethodBase.GetCurrentMethod().Name, PageMaster.FleetModels, mySession.Current.UserId); return(null); } }
public List <SearchFleetModelsResult> SearchFleetModels(int inRow, int inPage, string strSearch, string strSort) { try { using (this.objDataContext = new FleetModelsDataContext(Functions.StrConnection)) { List <SearchFleetModelsResult> lstSearchFleetModels = this.objDataContext.SearchFleetModels(inRow, inPage, strSearch, strSort).ToList(); return(lstSearchFleetModels); } } catch (Exception ex) { Functions.Write(ex, System.Reflection.MethodBase.GetCurrentMethod().Name, PageMaster.FleetModels, mySession.Current.UserId); return(null); } }
public bool IsFleetModelsExists(long lgFleetModelsId, string strFleetModelsName) { try { using (this.objDataContext = new FleetModelsDataContext(Functions.StrConnection)) { if (this.objDataContext.FleetModels.Where(x => x.Id != lgFleetModelsId && x.Model == strFleetModelsName && x.IsDeleted == false).Count() > 0) { return(true); } } return(false); } catch (Exception ex) { Functions.Write(ex, System.Reflection.MethodBase.GetCurrentMethod().Name, PageMaster.FleetModels, mySession.Current.UserId); return(false); } }
public DeleteFleetModelsResult DeleteFleetModels(string strFleetModelsIdList, long lgDeletedBy) { DeleteFleetModelsResult result = new DeleteFleetModelsResult(); try { using (TransactionScope scope = new TransactionScope()) { using (this.objDataContext = new FleetModelsDataContext(Functions.StrConnection)) { result = this.objDataContext.DeleteFleetModels(strFleetModelsIdList, lgDeletedBy, PageMaster.FleetModels).ToList().FirstOrDefault(); } scope.Complete(); } } catch (Exception ex) { Functions.Write(ex, System.Reflection.MethodBase.GetCurrentMethod().Name, PageMaster.FleetModels, mySession.Current.UserId); } return(result); }
public ClsFleetModels GetFleetModelsByFleetModelsId(long lgFleetModelsId) { ClsFleetModels objClsFleetModels = new ClsFleetModels(); try { using (this.objDataContext = new FleetModelsDataContext(Functions.StrConnection)) { GetFleetModelsByIdResult item = this.objDataContext.GetFleetModelsById(lgFleetModelsId).ToList().FirstOrDefault(); if (item != null) { objClsFleetModels.lgId = item.Id; objClsFleetModels.strFleetModelsName = item.FleetModelsName; } } } catch (Exception ex) { Functions.Write(ex, System.Reflection.MethodBase.GetCurrentMethod().Name, PageMaster.FleetModels, mySession.Current.UserId); } return(objClsFleetModels); }