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 static bool Save(TruckRegisterBLL obj, SqlTransaction tran)
{
string strSql = "spInsertTruckRegister";
SqlParameter[] arPar = new SqlParameter[6];
try
{
arPar[0] = new SqlParameter("@Id", SqlDbType.UniqueIdentifier);
arPar[0].Value = obj.Id;
arPar[1] = new SqlParameter("@TruckModelYearId", SqlDbType.UniqueIdentifier);
arPar[1].Value = obj.TruckModelYearId;
arPar[2] = new SqlParameter("@TruckNumber", SqlDbType.NVarChar, 50);
arPar[2].Value = obj.TruckNumber;
arPar[3] = new SqlParameter("@IsTrailer", SqlDbType.Bit);
arPar[3].Value = obj.IsTrailer;
arPar[4] = new SqlParameter("@Status", SqlDbType.Int);
arPar[4].Value = (int)obj.Status;
arPar[5] = new SqlParameter("@CreatedBy", SqlDbType.UniqueIdentifier);
arPar[5].Value = obj.CreatedBy;
int Affeccted = -1;
Affeccted = SqlHelper.ExecuteNonQuery(tran, CommandType.StoredProcedure, strSql, arPar);
if (Affeccted == 1)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
throw new Exception("Can not insert Grading Result", ex);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
this.lblMessage.Text = "";
bool isSaved = false;
// Save the Driver Information.
DriverInformation objDriverInfo = new DriverInformation();
Guid CommodityDepositRequestId = new Guid(this.CommodityDepositRequestId.Value.ToString());
Guid CreatedBy = UserBLL.GetCurrentUser();
if (this.txtRemark.Text == null)
{
this.txtRemark.Text = String.Empty;
}
Guid TruckRegisterId = Guid.Empty;
if (txtPlateNo.Text != "")
{
//Registering Truck
TruckRegisterBLL objTruckRegister = new TruckRegisterBLL();
objTruckRegister.IsTrailer = false;
if (cboModelYear.SelectedValue.ToString() != "")
{
objTruckRegister.TruckModelYearId = new Guid(cboModelYear.SelectedValue.ToString());
}
else
{
this.lblMessage.Text = "Please Select Truck Model Year.";
return;
}
objTruckRegister.TruckNumber = txtPlateNo.Text;
objTruckRegister.Status = TruckStatus.Active;
objTruckRegister.Add();
}
if (txtTrailerPlateNo.Text != "")
{
//Registering Truck
TruckRegisterBLL objTrailerTruckRegister = new TruckRegisterBLL();
objTrailerTruckRegister.IsTrailer = true;
if (cboTrailerModelYear.SelectedValue.ToString() != "")
{
objTrailerTruckRegister.TruckModelYearId = new Guid(cboTrailerModelYear.SelectedValue.ToString());
}
else
{
this.lblMessage.Text = "Please Select Trailer Model Year.";
return;
}
objTrailerTruckRegister.TruckNumber = txtTrailerPlateNo.Text;
objTrailerTruckRegister.Status = TruckStatus.Active;
objTrailerTruckRegister.Add();
}
DriverInformationBLL obj = new DriverInformationBLL(CommodityDepositRequestId, this.txtDriverName.Text,
this.txtLicenseNo.Text, this.txtPlaceIssued.Text, this.txtPlateNo.Text, this.txtTrailerPlateNo.Text,
1, this.txtRemark.Text, CreatedBy);
try
{
isSaved = obj.SaveDriverInformation();
}
catch (DuplicateDriverInformationException ex)
{
this.lblMessage.Text = ex.msg;
return;
}
catch (Exception ex)
{
throw ex;
}
if (isSaved == true)
{
this.lblMessage.Text = "Record Added Successfully";
this.btnSave.Enabled = false;
ClearForm();
this.CommodityDepositRequestId.Value = CommodityDepositRequestId.ToString();
BindData(CommodityDepositRequestId);
}
else
{
this.lblMessage.Text = "Unable to Add the data please check the form and try agian.";
}
ToggleNext();
}
public static TruckRegisterBLL GetByTruckNumber(string TruckNumber, bool isTrailer)
{
TruckRegisterBLL obj = null;
string strSql = "spGetTruckRegisterByTruckNumber";
SqlConnection conn = null;
SqlDataReader reader;
SqlParameter[] arPar = new SqlParameter[2];
try
{
arPar[0] = new SqlParameter("@TruckNumber", SqlDbType.NVarChar, 50);
arPar[0].Value = TruckNumber;
arPar[1] = new SqlParameter("@IsTrailer", SqlDbType.Bit);
arPar[1].Value = isTrailer;
conn = Connection.getConnection();
reader = SqlHelper.ExecuteReader(conn, CommandType.StoredProcedure, strSql, arPar);
if (reader.HasRows)
{
reader.Read();
obj = new TruckRegisterBLL();
if (reader["Id"] != DBNull.Value)
{
obj.Id = new Guid(reader["Id"].ToString());
}
obj.TruckModelYearId = new Guid(reader["TruckModelYearId"].ToString());
obj.TruckNumber = reader["TruckNumber"].ToString();
if (reader["IsTrailer"] != DBNull.Value)
{
obj.IsTrailer = bool.Parse(reader["IsTrailer"].ToString());
}
else
{
obj.IsTrailer = false;
}
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.CreatedTimestamp = DateTime.Parse(reader["LastModifiedTimestamp"].ToString());
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (conn != null)
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
}
}
return(obj);
}
