public CascadingDropDownNameValue[] GetActiveTruckModels(string knownCategoryValues, string category)
{
try
{
string TruckTypeID = "";
StringDictionary kv;
kv = CascadingDropDown.ParseKnownCategoryValuesString(knownCategoryValues);
if (!kv.ContainsKey("TruckType") || kv["TruckType"].ToString() == "")
{
throw new ArgumentException("Couldn't find selected Truck Type.");
}
TruckTypeID = kv["TruckType"];
List <CascadingDropDownNameValue> l = new List <CascadingDropDownNameValue>();
TruckModelBLL objTm = new TruckModelBLL();
List <TruckModelBLL> listTM = new List <TruckModelBLL>();
listTM = objTm.GetActiveTrucksByTypeId(new Guid(TruckTypeID));
foreach (TruckModelBLL o in listTM)
{
l.Add(new CascadingDropDownNameValue(o.TruckModelName, o.Id.ToString()));
}
return(l.ToArray());
}
catch (Exception ex)
{
throw ex;
}
}
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;
}
}
}
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[] GetTruckTypeModels(string knownCategoryValues, string category)
{
try
{
string[] categoryValues = knownCategoryValues.Split(':', ';');
Guid truckTypeId = new Guid(categoryValues[1]);
List <CascadingDropDownNameValue> l = new List <CascadingDropDownNameValue>();
TruckModelBLL objTm = new TruckModelBLL();
List <TruckModelBLL> listTM = new List <TruckModelBLL>();
listTM = objTm.GetActiveTrucksByTypeId(truckTypeId).OrderBy(tm => tm.TruckModelName).ToList();
foreach (TruckModelBLL o in listTM)
{
l.Add(new CascadingDropDownNameValue(o.TruckModelName, o.Id.ToString()));
}
return(l.ToArray());
}
catch (Exception ex)
{
throw ex;
}
}
public static List <TruckModelBLL> GetAll()
{
string strSql = "spGetAllTruckModel";
SqlDataReader reader;
SqlConnection conn = null;
List <TruckModelBLL> list;
try
{
conn = Connection.getConnection();
reader = SqlHelper.ExecuteReader(conn, CommandType.StoredProcedure, strSql);
if (reader.HasRows)
{
list = new List <TruckModelBLL>();
while (reader.Read())
{
TruckModelBLL obj = new TruckModelBLL();
if (reader["Id"] == DBNull.Value)
{
throw new InvalidIdException("Id Can't be null");
}
obj.Id = new Guid(reader["Id"].ToString());
obj.TruckTypeId = new Guid(reader["TruckTypeId"].ToString());
obj.TruckModelName = reader["TruckModelName"].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 != null)
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
}
}
return(null);
}
