public static List <TruckTypeBLL> GetAll() { string strSql = "spGetAllTruckType"; SqlDataReader reader; SqlConnection conn = null; List <TruckTypeBLL> list; try { conn = Connection.getConnection(); reader = SqlHelper.ExecuteReader(conn, CommandType.StoredProcedure, strSql); if (reader.HasRows) { list = new List <TruckTypeBLL>(); while (reader.Read()) { TruckTypeBLL obj = new TruckTypeBLL(); if (reader["Id"] == DBNull.Value) { throw new InvalidIdException("Id Can't be null"); } obj.Id = new Guid(reader["Id"].ToString()); obj.TruckTypeName = reader["TruckTypeName"].ToString(); obj.Status = (TruckStatus)(int.Parse(reader["Status"].ToString())); if (reader["CreatedBy"] != DBNull.Value) { obj.CreatedBy = new Guid(reader["CreatedBy"].ToString()); } if (reader["CreatedTimestamp"] != DBNull.Value) { obj.CreatedTimestamp = DateTime.Parse(reader["CreatedTimestamp"].ToString()); } if (reader["LastModifiedBy"] != DBNull.Value) { obj.LastModifiedBy = new Guid(reader["LastModifiedBy"].ToString()); } if (reader["LastModifiedTimestamp"] != DBNull.Value) { obj.LastModifiedTimestamp = DateTime.Parse(reader["LastModifiedTimestamp"].ToString()); } list.Add(obj); } return(list); } } catch (Exception ex) { throw ex; } finally { if (conn.State == ConnectionState.Open) { conn.Close(); } } return(null); }
protected void FindTruckRegistration(string truckNo, bool isTrailer) { ((TruckInfo)SubscriberData).TruckTypeId = Guid.Empty; ((TruckInfo)SubscriberData).TruckModelId = Guid.Empty; ((TruckInfo)SubscriberData).TruckModelYearId = Guid.Empty; ((TruckInfo)SubscriberData).IsNew = false; TruckRegisterBLL obj = null; if (truckNo.Trim() != string.Empty) { obj = new TruckRegisterBLL().GetTruckInfoByTruckNumber(truckNo, isTrailer); } if (obj != null) { TruckModelYearBLL objTMY = new TruckModelYearBLL(); objTMY = objTMY.GetbyId(obj.TruckModelYearId); if (objTMY != null) { ((TruckInfo)SubscriberData).TruckModelYearId = objTMY.Id; TruckModelBLL objTM = new TruckModelBLL(); objTM = objTM.GetbyId(objTMY.TruckModelId); if (objTM != null) { ((TruckInfo)SubscriberData).TruckModelId = objTM.Id; TruckTypeBLL objTT = new TruckTypeBLL(); objTT = objTT.GetbyId(objTM.TruckTypeId); if (objTT != null) { ((TruckInfo)SubscriberData).TruckTypeId = objTT.Id; } } } } else { ((TruckInfo)SubscriberData).IsNew = true; } foreach (Control subscriber in Subscribers) { if (subscriber == null) { continue; } switch (subscriber.ID) { case "cddExtender_TruckTypeId": ((CascadingDropDown)subscriber).SelectedValue = (((TruckInfo)SubscriberData).TruckTypeId.ToString()); break; case "cddExtender_TruckModelId": ((CascadingDropDown)subscriber).SelectedValue = (((TruckInfo)SubscriberData).TruckModelId.ToString()); break; case "cddExtender_TruckModelYearId": ((CascadingDropDown)subscriber).SelectedValue = (((TruckInfo)SubscriberData).TruckModelYearId.ToString()); break; } } }
private static int TruckTypeComp(TruckTypeBLL ltt, TruckTypeBLL rtt) { if (ltt == null) { if (rtt == null) { return(0); } else { return(1); } } else { if (rtt == null) { return(-1); } else { return(ltt.TruckTypeName.CompareTo(rtt.TruckTypeName)); } } }
public CascadingDropDownNameValue[] GetAllTruckType(string knownCategoryValues, string category) { List <CascadingDropDownNameValue> l = new List <CascadingDropDownNameValue>(); TruckTypeBLL objTruckType = new TruckTypeBLL(); List <TruckTypeBLL> list = new List <TruckTypeBLL>(); list = objTruckType.GetAllTrucksTypes(); foreach (TruckTypeBLL o in list) { l.Add(new CascadingDropDownNameValue(o.TruckTypeName.ToString(), o.Id.ToString())); } return(l.ToArray()); }
protected void txtTrailerPlateNo_TextChanged(object sender, EventArgs e) { ViewState["TrailerRegisterId"] = null; Nullable <Guid> TruckTypeId, TruckModelId; TruckTypeId = null; TruckModelId = null; TruckRegisterBLL obj = new TruckRegisterBLL(); obj = obj.GetTruckInfoByTruckNumber(this.txtTrailerPlateNo.Text, true); if (obj != null) { TruckModelYearBLL objTMY = new TruckModelYearBLL(); objTMY = objTMY.GetbyId(obj.TruckModelYearId); if (objTMY != null) { TruckModelBLL objTM = new TruckModelBLL(); objTM = objTM.GetbyId(objTMY.TruckModelId); if (objTM != null) { TruckTypeBLL objTT = new TruckTypeBLL(); objTT = objTT.GetbyId(objTM.TruckTypeId); TruckModelId = objTM.Id; if (objTT != null) { TruckTypeId = objTT.Id; } } } if (TruckTypeId != null) { this.cboTruckType2_CascadingDropDown1.SelectedValue = TruckTypeId.ToString(); } if (TruckModelId != null) { this.cboTrailerModel_CascadingDropDown2.SelectedValue = TruckModelId.ToString(); } if (obj.TruckModelYearId != null) { this.cboTrailerModelYear_CascadingDropDown3.SelectedValue = obj.TruckModelYearId.ToString(); } this.cboTruckModel.Enabled = false; ViewState["TrailerRegisterId"] = obj.Id.ToString(); }// Big if }
public CascadingDropDownNameValue[] GetTruckType(string knownCategoryValues, string category) { try { List <CascadingDropDownNameValue> l = new List <CascadingDropDownNameValue>(); TruckTypeBLL objTT = new TruckTypeBLL(); List <TruckTypeBLL> listTT = new List <TruckTypeBLL>(); listTT = objTT.GetActiveTrucksTypes().OrderBy(tt => tt.TruckTypeName).ToList(); foreach (TruckTypeBLL o in listTT) { l.Add(new CascadingDropDownNameValue(o.TruckTypeName, o.Id.ToString())); } return(l.ToArray()); } catch (Exception ex) { throw ex; } }
//private CachedDictionary<ECXLookUp.CNIDType> nidTypeLookup = new CachedDictionary<ECXLookUp.CNIDType>( // delegate(ECXLookUp.CNIDType nidType) // { // return nidType.Name; // }, // delegate(object key) // { // return null; // }, // delegate() // { // ECXLookUp.ECXLookup ecxLookup = new WarehouseApplication.ECXLookUp.ECXLookup(); // ECXLookUp.CNIDType[] nidTypes = ecxLookup.GetActiveNIDTypes(BLL.Utility.GetWorkinglanguage()); // List<KeyValuePair<object, WarehouseApplication.ECXLookUp.CNIDType>> kvps = new List<KeyValuePair<object, WarehouseApplication.ECXLookUp.CNIDType>>(); // foreach (ECXLookUp.CNIDType nidType in nidTypes) // { // kvps.Add(new KeyValuePair<object, WarehouseApplication.ECXLookUp.CNIDType>(nidType.Id, nidType)); // } // return kvps; // }); //private Dictionary<object, string> shedLookup = new Dictionary<object,string>(); //private Dictionary<object, string> stackLookup = new Dictionary<object,string>(); //private CachedDictionary<BagTypeBLL> bagTypeLookup = new CachedDictionary<BagTypeBLL>( // delegate(BagTypeBLL bagType) // { // return bagType.BagTypeName; // }, // delegate(object key) // { // return BagTypeBLL.GetBagType((Guid)key); // }, // delegate() // { // List<KeyValuePair<object, BagTypeBLL>> kvps = new List<KeyValuePair<object, BagTypeBLL>>(); // foreach (BagTypeBLL bagType in BagTypeBLL.GetAllBagTypes()) // { // kvps.Add(new KeyValuePair<object, BagTypeBLL>(bagType.Id, bagType)); // } // return kvps; // }); //private WarehouseBLL currentWareHouse = new WarehouseBLL() { // Code = "102", // WarehouseId = new Guid("fa0a52e8-9308-4d5e-b323-88ca5ba232ed") //}; #region ILookupSource Members public IDictionary <object, string> GetLookup(string lookupName) { try { Dictionary <object, string> lookup = new Dictionary <object, string>(); switch (lookupName) { case "CommodityGrade": return(new CachedDictionary <CommodityGradeBLL>( delegate(CommodityGradeBLL commodityGrade) { return commodityGrade.GradeName; }, delegate(object key) { return CommodityGradeBLL.GetCommodityGrade((Guid)key); }, delegate() { List <KeyValuePair <object, CommodityGradeBLL> > kvps = new List <KeyValuePair <object, CommodityGradeBLL> >(); foreach (CommodityGradeBLL commodityGrade in CommodityGradeBLL.GetAllCommodityDetail()) { kvps.Add(new KeyValuePair <object, CommodityGradeBLL>(commodityGrade.CommodityGradeId, commodityGrade)); } return kvps; })); case "Client": return(new CachedDictionary <ClientBLL>( clientLookup, delegate(ClientBLL client) { return client.ClientName; }, delegate(object key) { return ClientBLL.GetClinet((Guid)key); })); case "ClientId": return(new CachedDictionary <ClientBLL>( clientLookup, delegate(ClientBLL client) { return client.ClientId; }, delegate(object key) { return ClientBLL.GetClinet((Guid)key); })); case "Warehouse": return(new CachedDictionary <WarehouseBLL>( warehouseLookup, delegate(WarehouseBLL warehouse) { return warehouse.WarehouseName; }, delegate(object key) { return WarehouseBLL.GetById((Guid)key); })); case "WarehouseManager": return(new CachedDictionary <string>( delegate(string warehouseManager) { return warehouseManager; }, delegate(object key) { //return UserRightBLL.GetUsersWithRight("WHPWM").Find(u => u.UserId == (Guid)key).FullName; return UserRightBLL.GetUserNameByUserId((Guid)key); })); case "NIDType": //ICollection<object> keys = nidTypeLookup.Keys; //return nidTypeLookup; List <NIDTypeBLL> nidTypes = NIDTypeBLL.GetAllNIDTypes(); nidTypes.ForEach(nidType => lookup.Add(nidType.Id, nidType.Name)); break; case "VerifyingClerk": //return GetWorkersLookup("VerifyingClerk"); UserRightBLL.GetUsersWithRight("VerifyingClerk").ForEach(user => lookup.Add(user.UserId, user.FullName)); break; case "InventoryController": //return GetWorkersLookup("InventoryController"); UserRightBLL.GetUsersWithRight("InventoryController").ForEach(user => lookup.Add(user.UserId, user.FullName)); break; case "Loader": //return GetWorkersLookup("Loader"); UserRightBLL.GetUsersWithRight("Loader").ForEach(user => lookup.Add(user.UserId, user.FullName)); break; case "Weigher": //return GetWorkersLookup("Weigher"); UserRightBLL.GetUsersWithRight("Weigher").ForEach(user => lookup.Add(user.UserId, user.FullName)); break; case "Sampler": //return GetWorkersLookup("Sampler"); UserRightBLL.GetUsersWithRight("Sampler").ForEach(user => lookup.Add(user.UserId, user.FullName)); break; case "Grader": //return GetWorkersLookup("Grader"); UserRightBLL.GetUsersWithRight("Grader").ForEach(user => lookup.Add(user.UserId, user.FullName)); break; case "Gatekeeper": //return GetWorkersLookup("Gatekeeper"); UserRightBLL.GetUsersWithRight("Gatekeeper").ForEach(user => lookup.Add(user.UserId, user.FullName)); break; case "Inspector": //return GetWorkersLookup("Gatekeeper"); UserRightBLL.GetUsersWithRight("WHPCT").ForEach(user => lookup.Add(user.UserId, user.FullName)); break; case "BagType": foreach (BagTypeBLL bagType in BagTypeBLL.GetAllBagTypes()) { lookup.Add(bagType.Id, bagType.BagTypeName); } break; case "BagWeight": foreach (BagTypeBLL bagType in BagTypeBLL.GetAllBagTypes()) { lookup.Add(bagType.Id, bagType.Tare.ToString()); } break; case "CurrentWarehouse": lookup.Add("Id", WarehouseBLL.CurrentWarehouse.WarehouseId.ToString()); lookup.Add("WarehouseCode", WarehouseBLL.CurrentWarehouse.Code); //lookup.Add("WarehouseManagerId", currentWareHouse.WarehouseId.ToString()); //lookup.Add("WarehouseManagerName", ""); break; case "CurrentUser": lookup.Add("Id", UserBLL.GetCurrentUser().ToString()); lookup.Add("Name", UserBLL.GetName(UserBLL.GetCurrentUser())); break; case "WorkerStatus": lookup.Add(0, "Status 1"); lookup.Add(1, "Status 2"); break; case "EmployeeRole": lookup.Add(WorkType.GINGrading, "0e604921-ee27-4406-97ce-846b47b1cd75"); lookup.Add(WorkType.GINLoading, "0e604921-ee27-4406-97ce-846c47b1cd75"); lookup.Add(WorkType.GINSampling, "0e604921-ee27-4406-97ce-84db47b1cd75"); lookup.Add(WorkType.GINScaling, "0e604921-ee27-4406-97ce-846e47b1cd75"); break; case "Shed": foreach (ShedBLL shed in new ShedBLL().GetActiveShedByWarehouseId(WarehouseBLL.CurrentWarehouse.WarehouseId)) { lookup.Add(shed.Id, shed.ShedNumber); } break; case "Stack": foreach (Guid shedId in GetLookup("Shed").Keys) { foreach (StackBLL stack in new StackBLL().GetActiveStackbyShedId(shedId)) { lookup.Add(stack.Id, stack.StackNumber); } } break; case "TruckType": lookup.Add(Guid.Empty, "Not Registred"); TruckTypeBLL objTT = new TruckTypeBLL(); List <TruckTypeBLL> list = objTT.GetActiveTrucksTypes(); list.Sort(TruckTypeComp); list.ForEach(tt => lookup.Add(tt.Id, tt.TruckTypeName)); break; } lookup.OrderBy(lkup => lkup.Value); return(lookup); } catch (Exception ex) { throw new Exception(string.Format("Item not found for the {0} lookup.", lookupName), ex); } }