public List <SelectListItem> GetAllTripReasonForDropDown() { List <SelectListItem> lstTripReason = new List <SelectListItem>(); try { using (this.objDataContext = new TripReasonDataContext(Functions.StrConnection)) { lstTripReason.Add(new SelectListItem { Text = "--Select--", Value = string.Empty }); List <GetTripReasonAllResult> lstTripReasonResult = this.objDataContext.GetTripReasonAll().ToList(); if (lstTripReasonResult != null && lstTripReasonResult.Count > 0) { foreach (var item in lstTripReasonResult) { lstTripReason.Add(new SelectListItem { Text = item.TripReasonName, Value = item.Id.ToString() }); } } } } catch (Exception ex) { Functions.Write(ex, System.Reflection.MethodBase.GetCurrentMethod().Name, PageMaster.TripReason, mySession.Current.UserId); } return(lstTripReason); }
public long SaveTripReason(ClsTripReason objSave) { try { using (TransactionScope scope = new TransactionScope()) { using (this.objDataContext = new TripReasonDataContext(Functions.StrConnection)) { var result = this.objDataContext.InsertOrUpdateTripReason(objSave.lgId, objSave.strTripReasonName, mySession.Current.UserId, PageMaster.TripReason).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.TripReason, mySession.Current.UserId); return(0); } }
public List <GetTripReasonAllResult> GetTripReasonAll() { try { using (this.objDataContext = new TripReasonDataContext(Functions.StrConnection)) { List <GetTripReasonAllResult> lstTripReasonAll = this.objDataContext.GetTripReasonAll().ToList(); return(lstTripReasonAll); } } catch (Exception ex) { Functions.Write(ex, System.Reflection.MethodBase.GetCurrentMethod().Name, PageMaster.TripReason, mySession.Current.UserId); return(null); } }
public List <SearchTripReasonResult> SearchTripReason(int inRow, int inPage, string strSearch, string strSort) { try { using (this.objDataContext = new TripReasonDataContext(Functions.StrConnection)) { List <SearchTripReasonResult> lstSearchTripReason = this.objDataContext.SearchTripReason(inRow, inPage, strSearch, strSort).ToList(); return(lstSearchTripReason); } } catch (Exception ex) { Functions.Write(ex, System.Reflection.MethodBase.GetCurrentMethod().Name, PageMaster.TripReason, mySession.Current.UserId); return(null); } }
public bool IsTripReasonExists(long lgTripReasonId, string strTripReasonName) { try { using (this.objDataContext = new TripReasonDataContext(Functions.StrConnection)) { if (this.objDataContext.TripReason.Where(x => x.Id != lgTripReasonId && x.TripReasonName == strTripReasonName && x.IsDeleted == false).Count() > 0) { return(true); } } return(false); } catch (Exception ex) { Functions.Write(ex, System.Reflection.MethodBase.GetCurrentMethod().Name, PageMaster.TripReason, mySession.Current.UserId); return(false); } }
public DeleteTripReasonResult DeleteTripReason(string strTripReasonIdList, long lgDeletedBy) { DeleteTripReasonResult result = new DeleteTripReasonResult(); try { using (TransactionScope scope = new TransactionScope()) { using (this.objDataContext = new TripReasonDataContext(Functions.StrConnection)) { result = this.objDataContext.DeleteTripReason(strTripReasonIdList, lgDeletedBy, PageMaster.TripReason).ToList().FirstOrDefault(); } scope.Complete(); } } catch (Exception ex) { Functions.Write(ex, System.Reflection.MethodBase.GetCurrentMethod().Name, PageMaster.TripReason, mySession.Current.UserId); } return(result); }
public ClsTripReason GetTripReasonByTripReasonId(long lgTripReasonId) { ClsTripReason objClsTripReason = new ClsTripReason(); try { using (this.objDataContext = new TripReasonDataContext(Functions.StrConnection)) { GetTripReasonByIdResult item = this.objDataContext.GetTripReasonById(lgTripReasonId).ToList().FirstOrDefault(); if (item != null) { objClsTripReason.lgId = item.Id; objClsTripReason.strTripReasonName = item.TripReasonName; } } } catch (Exception ex) { Functions.Write(ex, System.Reflection.MethodBase.GetCurrentMethod().Name, PageMaster.TripReason, mySession.Current.UserId); } return(objClsTripReason); }