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; } } }
public CascadingDropDownNameValue[] GetTruckTypeModelYears(string knownCategoryValues, string category) { string[] categoryValues = knownCategoryValues.Split(':', ';'); Guid truckModelId = new Guid(categoryValues[1]); List <CascadingDropDownNameValue> l = new List <CascadingDropDownNameValue>(); TruckModelYearBLL objTm = new TruckModelYearBLL(); List <TruckModelYearBLL> listTM = new List <TruckModelYearBLL>(); listTM = objTm.GetActiveTruckModelYearByModelId(truckModelId).OrderBy(tmy => tmy.ModelYearName).ToList(); foreach (TruckModelYearBLL o in listTM) { l.Add(new CascadingDropDownNameValue(o.ModelYearName, 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[] GetAllTruckModelYear(string knownCategoryValues, string category) { string ModelId = ""; StringDictionary kv; kv = CascadingDropDown.ParseKnownCategoryValuesString(knownCategoryValues); if (!kv.ContainsKey("ModelId") || kv["ModelId"].ToString() == "") { throw new ArgumentException("Couldn't find selected Truck Type."); } ModelId = kv["ModelId"]; List <CascadingDropDownNameValue> l = new List <CascadingDropDownNameValue>(); TruckModelYearBLL objTm = new TruckModelYearBLL(); List <TruckModelYearBLL> listTM = new List <TruckModelYearBLL>(); listTM = objTm.GetAllTrucksByModelId(new Guid(ModelId)); foreach (TruckModelYearBLL o in listTM) { l.Add(new CascadingDropDownNameValue(o.ModelYearName, o.Id.ToString())); } return(l.ToArray()); }
public static List <TruckModelYearBLL> GetAll() { string strSql = "spGetAllTruckModelYear"; SqlDataReader reader; SqlConnection conn = null; List <TruckModelYearBLL> list; try { conn = Connection.getConnection(); reader = SqlHelper.ExecuteReader(conn, CommandType.StoredProcedure, strSql); if (reader.HasRows) { list = new List <TruckModelYearBLL>(); while (reader.Read()) { TruckModelYearBLL obj = new TruckModelYearBLL(); if (reader["Id"] == DBNull.Value) { throw new InvalidIdException("Id Can't be null"); } obj.Id = new Guid(reader["Id"].ToString()); obj.TruckModelId = new Guid(reader["TruckModelId"].ToString()); obj.ModelYearName = reader["ModelYearName"].ToString(); obj.Status = (TruckStatus)reader["Status"]; if (reader["ModelWeight"] != DBNull.Value) { obj.ModelWeight = float.Parse((reader["ModelWeight"]).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 != null) { if (conn.State == ConnectionState.Open) { conn.Close(); } } } return(null); }