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); }