public static bool ClientAcceptanceGradingResult(GradingResultBLL obj, SqlTransaction tran) { int AffectedRows = 0; string strSql = "spGradingResultClientAccptance"; SqlParameter[] arPar = new SqlParameter[7]; try { arPar[0] = new SqlParameter("@Id", SqlDbType.UniqueIdentifier); arPar[0].Value = obj.ID; arPar[1] = new SqlParameter("@Status", SqlDbType.Int); arPar[1].Value = obj.Status; arPar[2] = new SqlParameter("@ClientAcceptanceTimeStamp", SqlDbType.DateTime); arPar[2].Value = obj.ClientAcceptanceTimeStamp; arPar[3] = new SqlParameter("@LastModifiedBy", SqlDbType.UniqueIdentifier); arPar[3].Value = UserBLL.GetCurrentUser(); arPar[4] = new SqlParameter("@PreWeightQueueNo", SqlDbType.Int); arPar[4].Value = obj.PreWeightQueueNo; arPar[5] = new SqlParameter("@QueueNo", SqlDbType.Int); arPar[5].Value = obj.QueueNo; arPar[6] = new SqlParameter("@QueueDate", SqlDbType.DateTime); arPar[6].Value = obj.QueueDate; AffectedRows = SqlHelper.ExecuteNonQuery(tran, CommandType.StoredProcedure, strSql, arPar); return(AffectedRows == 1); } catch (Exception ex) { throw ex; } }
protected void btnSave_Click(object sender, EventArgs e) { bool isSaved = false; DateTime dt = Convert.ToDateTime(this.txtDateOfAcceptance.Text + " " + this.txtTimeodAcceptance.Text); GradingResultBLL objR = new GradingResultBLL(); Guid Id = new Guid(this.hfId.Value); int Status = -1; //Grading recived Status. GradingResultStatus GradingRecivedStatus; try { GradingRecivedStatus = (GradingResultStatus)int.Parse(this.cboGradingRecivedStatus.SelectedValue.ToString()); } catch { this.lblMsg.Text = "Grading Recived status is empty."; return; } try { Status = int.Parse(this.cboAcceptanceStatus.SelectedValue); } catch { this.lblMsg.Text = "Please Select Status."; return; } if (Status == -1) { this.lblMsg.Text = "Please Select Status."; return; } string preQueNo = ""; isSaved = objR.ClientAcceptance(Id, Status, GradingRecivedStatus, dt, out preQueNo); if (isSaved == true) { //if (objR.Status == GradingResultStatus.ClientAccepted) //{ if (preQueNo != "") { this.lblMsg.Text = "Data Updated Successfully - Pre Weight Queue No. is:" + preQueNo; return; } //} this.btnSave.Enabled = false; if (Session["CATranNo"] != null) { // Response.Redirect("ListInbox.aspx"); } //LoadData(); } else { this.lblMsg.Text = "Unable to Updat Data."; } }
public static GradingResultBLL GetApprovedGradingResultByCommdityDepositerequest(Guid Id) { string strSql = "GetApprovedGradingResultByCommdityDepositerequest"; GradingResultBLL obj; SqlDataReader reader; SqlConnection conn = new SqlConnection(); SqlParameter[] arPar = new SqlParameter[1]; arPar[0] = new SqlParameter("@Id", SqlDbType.UniqueIdentifier); arPar[0].Value = Id; try { conn = Connection.getConnection(); reader = SqlHelper.ExecuteReader(conn, CommandType.StoredProcedure, strSql, arPar); if (reader.HasRows) { obj = new GradingResultBLL(); if (reader.Read()) { obj.ID = new Guid(reader["Id"].ToString()); obj.GradingCode = reader["GradingCode"].ToString(); obj.GradingId = new Guid(reader["GradingId"].ToString()); obj.CommodityGradeId = new Guid(reader["CommodityGradeId"].ToString()); obj.Status = (GradingResultStatus)Convert.ToInt32(reader["status"]); obj.Remark = reader["status"].ToString(); obj.GradeRecivedTimeStamp = Convert.ToDateTime(reader["GradeRecivedTimestamp"].ToString()); obj.IsSupervisor = Convert.ToBoolean(reader["isSupervisor"]); obj.TrackingNo = reader["TransactionId"].ToString(); try { obj.ClientAcceptanceTimeStamp = Convert.ToDateTime(reader["ClientAcceptanceTimeStamp"].ToString()); } catch { } obj.GradingResult = (GradingResultStatus)Convert.ToInt32(reader["GradingResult"]); obj.CommodityDepositRequestId = new Guid(reader["CommodityDepositRequest"].ToString()); } conn.Close(); return(obj); } else { return(null); } } catch (Exception ex) { throw ex; } finally { if (conn != null && conn.State == ConnectionState.Open) { conn.Close(); } } }
public static Nullable <Guid> InsertGradingResult(GradingResultBLL obj, SqlTransaction tran) { string strSql = "spInsertGradingResult"; SqlParameter[] arPar = new SqlParameter[10]; try { arPar[0] = new SqlParameter("@GradingId", SqlDbType.UniqueIdentifier); arPar[0].Value = obj.GradingId; arPar[1] = new SqlParameter("@CommodityGradeId", SqlDbType.UniqueIdentifier); arPar[1].Value = obj.CommodityGradeId; arPar[2] = new SqlParameter("@Status", SqlDbType.Int); arPar[2].Value = (int)obj.Status; arPar[3] = new SqlParameter("@Remark", SqlDbType.Text); arPar[3].Value = obj.Remark; arPar[4] = new SqlParameter("@GradeRecivedTimestamp", SqlDbType.DateTime); arPar[4].Value = obj.GradeRecivedTimeStamp; arPar[5] = new SqlParameter("@isSupervisor", SqlDbType.Bit); arPar[5].Value = obj.IsSupervisor; arPar[6] = new SqlParameter("@CreatedBy", SqlDbType.UniqueIdentifier); arPar[6].Value = obj.CreatedBy; arPar[7] = new SqlParameter("@WarehouseId", SqlDbType.UniqueIdentifier); arPar[7].Value = obj.WarehouseId; arPar[8] = new SqlParameter("@id", SqlDbType.UniqueIdentifier); arPar[8].Value = obj.ID; arPar[9] = new SqlParameter("@ProductionYear", SqlDbType.Int); arPar[9].Value = obj.ProductionYear; Nullable <Guid> id = null; id = new Guid(SqlHelper.ExecuteScalar(tran, strSql, arPar).ToString()); if (id != null) { return(id); } else { return(null); } } catch (Exception ex) { throw new Exception("Can not insert Grading Result", ex); } }
public static List <GradingResultBLL> GetGradingResultSearch(String TrackingNo, string GradingCode) { string strSql = "spSearchGradingResult"; SqlConnection conn = new SqlConnection(); List <GradingResultBLL> list; SqlDataReader reader; SqlParameter[] arPar = new SqlParameter[3]; arPar[0] = new SqlParameter("@TransactionId", SqlDbType.NVarChar, 50); arPar[0].Value = TrackingNo; arPar[1] = new SqlParameter("@GradingCode", SqlDbType.NVarChar, 50); arPar[1].Value = GradingCode; arPar[2] = new SqlParameter("@WarehouseId", SqlDbType.UniqueIdentifier); arPar[2].Value = UserBLL.GetCurrentWarehouse(); try { conn = Connection.getConnection(); reader = SqlHelper.ExecuteReader(conn, CommandType.StoredProcedure, strSql, arPar); if (reader.HasRows) { list = new List <GradingResultBLL>(); while (reader.Read()) { GradingResultBLL obj = new GradingResultBLL(); obj.ID = new Guid(reader["Id"].ToString()); obj.CommodityGradeId = new Guid(reader["CommodityGradeId"].ToString()); obj.GradeRecivedTimeStamp = Convert.ToDateTime(reader["GradeRecivedTimestamp"].ToString()); obj.TrackingNo = reader["TransactionId"].ToString(); obj.IsSupervisor = Convert.ToBoolean(reader["isSupervisor"]); obj.Status = (GradingResultStatus)Convert.ToInt32(reader["status"]); obj.GradingResult = (GradingResultStatus)Convert.ToInt32(reader["GradingResult"]); list.Add(obj); } return(list); } else { return(null); } } catch (Exception ex) { throw ex; } finally { if (conn.State == ConnectionState.Open) { conn.Close(); } } }
private void LoadGrading(Guid GradingId) { GradingResultBLL objGrade = new GradingResultBLL(); objGrade = objGrade.GetApprovedGradingResultByGradingId(GradingId); if (objGrade != null) { this.hfCommodityGradeId.Value = objGrade.ID.ToString(); this.hfGradingId.Value = objGrade.GradingId.ToString(); this.lblCode.Text = objGrade.GradingCode.ToString(); this.lblCommodityGrade.Text = CommodityGradeBLL.GetCommodityGradeNameById(objGrade.CommodityGradeId); this.lblProductionYear.Text = objGrade.ProductionYear.ToString(); } }
protected void Page_Load(object sender, EventArgs e) { Nullable <Guid> GradingResultId = null; try { GradingResultId = new Guid(Request.QueryString.Get("id").ToString()); this.hfGradingResultId.Value = GradingResultId.ToString(); } catch { this.lblMsg.Text = "Invalid Id!"; } GradingResultBLL objGradingResult = new GradingResultBLL(); if (GradingResultId != null) { objGradingResult = objGradingResult.GetGradingResultById((Guid)GradingResultId); } if (objGradingResult == null) { this.lblMsg.Text = "Record can not be found!"; } // Get grading Code //this.txtGradingCode.Text = this.txtDateRecived.Text = objGradingResult.GradeRecivedTimeStamp.ToShortDateString(); this.txtTimeRecived.Text = objGradingResult.GradeRecivedTimeStamp.ToShortTimeString(); this.chkIsSupervisor.Checked = objGradingResult.IsSupervisor; this.txtRemark.Text = objGradingResult.Remark; this.cboStatus.SelectedIndex = (int)objGradingResult.Status; // //Load Control values. ////Loading Commodity. //ECXLookUp.ECXLookup objEcxLookUp = new WarehouseApplication.ECXLookUp.ECXLookup(); //ECXLookUp.CCommodityGrade[] objCC = objEcxLookUp.GetActiveCommodityGrades(new Guid("33673ac2-7888-42d5-9712-522941b3208c"), new Guid(ID.ToString())); //foreach (ECXLookUp.CCommodityGrade cc in objCC) //{ // this.cboCommodityGrade.Items.Add(new ListItem(cc.Name.ToString(),cc.UniqueIdentifier.ToString())); // if (cc.UniqueIdentifier == objGradingResult.ID) // { // CommodityClassId = new Guid(cc.CommodityClassUniqueIdentifier); // this.cboCommodityGrade.SelectedValue = objGradingResult.CommodityGradeId.ToString(); // } //} }
public static List <GradingResultBLL> GetAccpetedResultsPendingUnloadingByTrackingNo(Guid WarehouseId, string TrackingNo) { string strSql = "spGetClientAcceptedResultsPendingUnloadingByTrackingNo"; List <GradingResultBLL> list; SqlDataReader reader; SqlParameter[] arPar = new SqlParameter[2]; arPar[0] = new SqlParameter("@WarehouseId", SqlDbType.UniqueIdentifier); arPar[0].Value = WarehouseId; arPar[1] = new SqlParameter("@TrackingNo", SqlDbType.NVarChar, 50); arPar[1].Value = TrackingNo; SqlConnection conn = Connection.getConnection(); try { reader = SqlHelper.ExecuteReader(conn, CommandType.StoredProcedure, strSql, arPar); if (reader.HasRows) { list = new List <GradingResultBLL>(); while (reader.Read()) { GradingResultBLL obj = new GradingResultBLL(); obj.ID = new Guid(reader["Id"].ToString()); obj.GradingCode = reader["GradingCode"].ToString(); list.Add(obj); } reader.Close(); reader.Dispose(); return(list); } else { return(null); } } catch (Exception ex) { throw ex; } finally { if (conn.State == ConnectionState.Open) { conn.Close(); } } }
public static bool UpdateGradingResult(GradingResultBLL obj, SqlTransaction tran) { int AffectedRows = 0; string strSql = "spUpdateGradingResult"; SqlParameter[] arPar = new SqlParameter[8]; try { arPar[0] = new SqlParameter("@Id", SqlDbType.UniqueIdentifier); arPar[0].Value = obj.ID; arPar[1] = new SqlParameter("@CommodityGradeId", SqlDbType.UniqueIdentifier); arPar[1].Value = obj.CommodityGradeId; arPar[2] = new SqlParameter("@Status", SqlDbType.Int); arPar[2].Value = obj.Status; arPar[3] = new SqlParameter("@Remark", SqlDbType.Text); arPar[3].Value = obj.Remark; arPar[4] = new SqlParameter("@GradeRecivedTimestamp", SqlDbType.DateTime); arPar[4].Value = obj.GradeRecivedTimeStamp; arPar[5] = new SqlParameter("@isSupervisor", SqlDbType.Bit); arPar[5].Value = obj.IsSupervisor; arPar[6] = new SqlParameter("@LastModifiedBy", SqlDbType.UniqueIdentifier); arPar[6].Value = obj.LastModifiedBy; arPar[7] = new SqlParameter("@ProductionYear", SqlDbType.Int); arPar[7].Value = obj.ProductionYear; AffectedRows = SqlHelper.ExecuteNonQuery(tran, CommandType.StoredProcedure, strSql, arPar); return(AffectedRows == 1); } catch (Exception ex) { throw ex; } }
private void LoadPage() { //TODO Warehouse from security manager. Guid warehouseId = UserBLL.GetCurrentWarehouse(); List <GradingResultBLL> list = null; GradingResultBLL obj = new GradingResultBLL(); try { list = obj.GetAcceptedresultsPendingScaling(warehouseId); if (list != null || list.Count > 0) { int flag = -1; this.cboGradingCode.Items.Add(new ListItem("Please Select Code", "")); this.cboGradingCode.AppendDataBoundItems = true; foreach (GradingResultBLL o in list) { this.cboGradingCode.Items.Add(new ListItem(o.GradingCode.ToString(), o.CommodityDepositRequestId.ToString() + "/" + o.ID.ToString())); if (o.GradingCode == Session["AddScalingGradingCode"].ToString().Trim()) { flag = 0; this.cboGradingCode.SelectedValue = o.CommodityDepositRequestId.ToString() + "/" + o.ID.ToString(); } } if (flag == -1) { this.btnAdd.Enabled = false; } this.cboGradingCode.AppendDataBoundItems = false; } else { this.lblmsg.Text = "There are No records pending Scaling."; } } catch { this.lblmsg.Text = "An error occured,please check the data entered and try agian.If the error persists, contact IT Support."; } }
private void BindData() { GradingResultBLL objSearch = new GradingResultBLL(); this.list = objSearch.Search(this.txtTrackingNo.Text, this.txtGradingCode.Text); if (list != null) { if (list.Count <= 0) { this.lblMsg.Text = "No records Found."; return; } this.gvGradingResult.DataSource = this.list; this.gvGradingResult.DataBind(); } else { this.lblMsg.Text = "No records Found."; return; } }
private void loadGradingInfo() { //Displaay the commodity Grade. GradingResultBLL objGR = new GradingResultBLL(); objGR = objGR.GetGradingResultById(new Guid(this.hfGradingResultId.Value.ToString())); if (objGR != null) { CommodityGradeBLL oCG = CommodityGradeBLL.GetCommodityGrade(objGR.CommodityGradeId); ViewState["CommId"] = oCG.CommodityId.ToString(); this.lblCG.Text = oCG.GradeName; if (oCG.CommodityId == (Guid)Utility.GetCommodityId("Coffee")) { this.lblUnit.Text = "(KG)"; this.lblUnit1.Text = "(KG)"; } else { this.lblUnit.Text = "(Qtls)"; this.lblUnit1.Text = "(Qtls)"; } } }
private void GradingResultReport_ReportStart(object sender, EventArgs e) { if (HttpContext.Current.Session["rptGradingResultId"] == null) { throw new Exception("Session expired"); } else { Guid Id = Guid.Empty; Id = new Guid(HttpContext.Current.Session["rptGradingResultId"].ToString()); GradingResultBLL obj = new GradingResultBLL(); obj = obj.GetGradingResultById(Id); if (obj == null) { throw new Exception("Object Null"); } else { txtTrackingNo.Text = obj.TrackingNo; txtResultDate.Text = obj.GradeRecivedTimeStamp.ToString("dd MMM-yyyy"); txtCode.Text = obj.GradingCode.ToString(); if (obj.Status != GradingResultStatus.GeneralRequiementfail && obj.Status != GradingResultStatus.MoistureFailed) { txtGradeReceived.Text = CommodityGradeBLL.GetCommodityGradeNameById(obj.CommodityGradeId); } else if (obj.Status == GradingResultStatus.MoistureFailed) { txtGradeReceived.Text = "Moisture Failed"; } else if (obj.Status == GradingResultStatus.GeneralRequiementfail) { txtGradeReceived.Text = "General Requiement Fail"; } } } }
private void LoadDataAfterChange() { Guid Id; try { Id = new Guid(this.cboGradingCode.SelectedValue.ToString()); } catch { this.lblMsg.Text = "Please select Grading code"; return; } // get previous Grading. GradingResultBLL obj = new GradingResultBLL(); obj = obj.GetClientRejectedGradingResultByGradingId(Id); if (obj != null) { this.hfGradingResultId.Value = obj.ID.ToString(); this.hfPreviousGradingResult.Value = obj.CommodityGradeId.ToString(); this.lblPreviousGrade.Text = CommodityGradeBLL.GetCommodityGradeNameById(obj.CommodityGradeId); } }
private void BindUnloading() { try { Guid UnloadingId = new Guid(Request.QueryString["Id"].ToString()); this.hfUnloadingId.Value = UnloadingId.ToString(); UnloadingBLL obj = new UnloadingBLL(); CommodityGradeBLL objCommodityGrade = new CommodityGradeBLL(); obj.Id = UnloadingId; obj = obj.GetById(); if (obj != null) { this.lblGradingCode.Text = obj.GradingCode.ToString(); string CommodityGradeName = CommodityGradeBLL.GetCommodityGradeNameById(obj.CommodityGradeId); this.lblCommodityGrade.Text = CommodityGradeName; this.txtNumberOfBags.Text = obj.TotalNumberOfBags.ToString(); this.txtDateDeposited.Text = obj.DateDeposited.ToShortDateString(); this.cboStatus.SelectedValue = ((int)obj.Status).ToString(); ViewState["UnloadingCommGradeId"] = obj.CommodityGradeId; ViewState["totBagCount"] = obj.TotalNumberOfBags.ToString(); // Get Grading Id GradingResultBLL objGradingResult = new GradingResultBLL(); objGradingResult = objGradingResult.GetGradingResultById(obj.GradingResultId); if (objGradingResult != null) { GradingBLL objGrading = new GradingBLL(); objGrading = objGrading.GetById(objGradingResult.GradingId); if (objGrading != null) { SamplingResultBLL objSamplingResult = new SamplingResultBLL(); objSamplingResult = objSamplingResult.GetSamplingResultById(objGrading.SamplingResultId); if (objSamplingResult != null) { ViewState["SamplingNoBags"] = objSamplingResult.NumberOfBags; } else { this.lblmsg.Text = "An error has occured please try again.If the error persists contact the administrator"; return; } } else { this.lblmsg.Text = "An error has occured please try agin.If the error persists contact the administrator"; return; } } } //TODO :Remove the ff // this.cboStackNo.Items.Add(new ListItem("Stack No 1", "eaf7ebcc-f39a-4c7d-b855-1e5d5578dbcb")); //TODO Remove Comment Guid warehouseId = UserBLL.GetCurrentWarehouse(); // Loading shedby warehouse. ShedBLL shed = new ShedBLL(); List <ShedBLL> shedlist = new List <ShedBLL>(); shedlist = shed.GetActiveShedByWarehouseId(warehouseId); cboShed.Items.Add(new ListItem("Please select Shed", "")); if (shedlist.Count > 0) { foreach (ShedBLL o in shedlist) { cboShed.Items.Add(new ListItem(o.ShedNumber, o.Id.ToString())); } } else { this.btnAdd.Enabled = false; } GRNBLL objGRN = new GRNBLL(); string strE = " UnLoadingId='" + UnloadingId.ToString() + "' "; if (objGRN.IsEditableGRN(strE) == false) { this.btnAdd.Enabled = false; this.btnSave.Enabled = false; this.lblmsg.Text = "You can't edit this information as GRN has already been created using this Unloading Information."; } } catch (Exception ex) { throw ex; } }
private void selectedGradechanged(Guid Id) { GradingResultBLL obj = new GradingResultBLL(); obj = obj.GetGradingResultById(Id); this.cboGradingCode.Items.Add(new ListItem(obj.GradingCode.ToString(), obj.GradingCode.ToString())); this.cboGradingCode.SelectedValue = obj.GradingCode.ToString(); this. hfTrackingNo.Value = obj.TrackingNo; if (obj != null) { this.hfRecivingRequestId.Value = obj.CommodityDepositRequestId.ToString(); CommodityGradeBLL objCG = new CommodityGradeBLL(); string CGName; CGName = CommodityGradeBLL.GetCommodityGradeNameById(obj.CommodityGradeId); ViewState["UnloadingCommGradeId"] = obj.CommodityGradeId; this.lblCommodityGrade.Text = CGName; lblCADateTime.Text = ((DateTime)obj.ClientAcceptanceTimeStamp).ToShortDateString(); //try //{ // cmpSampGen.ValueToCompare = ((DateTime)obj.ClientAcceptanceTimeStamp).ToShortDateString(); //} //catch //{ // cmpSampGen.ValueToCompare = ((DateTime.Now).AddDays(-100)).ToShortDateString(); //} // Get Grading Id GradingBLL objGrading = new GradingBLL(); objGrading = objGrading.GetById(obj.GradingId); if (objGrading != null) { SamplingResultBLL objSamplingResult = new SamplingResultBLL(); objSamplingResult = objSamplingResult.GetSamplingResultById(objGrading.SamplingResultId); if (objSamplingResult != null) { ViewState["SamplingNoBags"] = objSamplingResult.NumberOfBags; } else { this.lblmsg.Text = "An error has occured please try agin.If the error persists contact the administrator"; return; } } else { this.lblmsg.Text = "An error has occured please try agin.If the error persists contact the administrator"; return; } } else { this.lblmsg.Text = "please select grading code and try again."; return; } //Load Commodity Grade Bags List <BagTypeBLL> list = new List <BagTypeBLL>(); BagTypeBLL objBagType = new BagTypeBLL(); list = objBagType.GetCommodityGradeBag(obj.CommodityGradeId); this.cboBagType.Items.Clear(); if (list != null) { if (list.Count > 0) { this.cboBagType.Items.Add(new ListItem("Please Select Bag Type", "")); foreach (BagTypeBLL i in list) { this.cboBagType.Items.Add(new ListItem(i.BagTypeName, i.Id.ToString())); } } } }
protected void btnSave_Click(object sender, EventArgs e) { this.lblMsg.Text = ""; if (this.cboCommodityGrade.SelectedValue != "") { if (this.chkRecivedGrade.Checked == false) { this.lblMsg.Text = "Grade Received is Not Checked."; this.lblMsg.ForeColor = System.Drawing.Color.Red; this.cboCommodityGrade.SelectedIndex = -1; this.cboCommodityClass.SelectedIndex = -1; loadData(); this.cboCommodityGrade.SelectedIndex = -1; this.cboCommodityGrade_CascadingDropDown.SelectedValue = ""; return; } } Nullable <float> totalValue = null; GradingResultStatus GenralReqiurmentStatus; GenralReqiurmentStatus = GradingResultStatus.Undertermined; List <GradingResultDetailBLL> list = new List <GradingResultDetailBLL>(); #region Checking GradingFactors foreach (GridViewRow row in this.gvGradingFactors.Rows) { GradingResultDetailBLL objResult = new GradingResultDetailBLL(); Guid GradingFactorId; string possibleValue; string dataType; string value; string FailPoint = string.Empty; int isMax = -1; // get the Id and the value. Label lblId = new Label(); try { lblId = row.FindControl("lblId") as Label; GradingFactorId = new Guid(lblId.Text); } catch (InvalidCastException) { this.lblMsg.Text = "An error has occured please try again.If the error persits contact the administrator."; return; } //Get Possible Values try { Label lblPossibleTypes = new Label(); lblPossibleTypes = (Label)row.FindControl("lblPossibleTypes"); possibleValue = lblPossibleTypes.Text; } catch { this.lblMsg.Text = "An error has occured please try again.If the error persits contact the administrator."; return; } // get DataType try { Label lblDataType = new Label(); lblDataType = (Label)row.FindControl("lblDataType"); dataType = lblDataType.Text; } catch (Exception ex) { throw ex; } // get Value. try { TextBox txtGradingFactorValue = new TextBox(); txtGradingFactorValue = (TextBox)row.FindControl("txtGradingFactorValue"); value = txtGradingFactorValue.Text; if (value == "" || value == String.Empty) { row.FindControl("lblEmpty").Visible = true; } } catch (Exception ex) { throw new Exception("An error has occured please try again.If the error persits contact the administrator.", ex); } // if it is a Genral req. try { Label lblFailPoint = new Label(); lblFailPoint = (Label)row.FindControl("lblFailPoint"); FailPoint = lblFailPoint.Text; } catch { } try { Label lblisMax = new Label(); lblisMax = (Label)row.FindControl("lblisMax"); if (string.IsNullOrEmpty(lblisMax.Text) != true) { try { isMax = GradingFactorBLL.ParseTextGradingResultStatus(lblisMax.Text); } catch { this.lblMsg.Text = "Invalid Grading Result Comparision.Please try again."; return; } } } catch { } //IsInTotalValue bool IsInTotalValue = false; try { Label lblisTotalValue = new Label(); lblisTotalValue = (Label)row.FindControl("lblisTotalValue"); if (string.IsNullOrEmpty(lblisTotalValue.Text) != true) { try { if (lblisTotalValue.Text == "True") { IsInTotalValue = true; } } catch { IsInTotalValue = false; } } } catch { } if (IsInTotalValue == true) { if (totalValue == null) { totalValue = 0; } totalValue += float.Parse(value); } //Check Data Type. if (value == "") { Label lblmessage; lblmessage = row.FindControl("lblEmpty") as Label; if (lblmessage != null) { lblmessage.Text = "*"; lblmessage.Visible = true; lblmessage.ForeColor = System.Drawing.Color.Red; } return; } else { if (DataValidationBLL.isDataValidForDataType(value, dataType) == false) { Label lblmessage; lblmessage = row.FindControl("lblEmpty") as Label; if (lblmessage != null) { lblmessage.Text = "Error in Data Type"; lblmessage.Visible = true; lblmessage.ForeColor = System.Drawing.Color.Red; } return; } } // check in possible Values if (DataValidationBLL.isExists(value, possibleValue) == false) { Label lblmessage; lblmessage = row.FindControl("lblEmpty") as Label; if (lblmessage != null) { lblmessage.Text = "Data Should Be one of the following: " + possibleValue; lblmessage.Visible = true; lblmessage.ForeColor = System.Drawing.Color.Red; } return; } objResult.GradingFactorId = GradingFactorId; objResult.RecivedValue = value; objResult.Status = GradingResultDetailStatus.Active; list.Add(objResult); Label lblmessage1; lblmessage1 = row.FindControl("lblEmpty") as Label; if (lblmessage1 != null) { lblmessage1.Text = ""; lblmessage1.Visible = false; } // Check if is a General requirment. GradingFactorBLL objGenralReqiurment = new GradingFactorBLL(); if (((GradingResultStatus)int.Parse(this.cboStatus.SelectedValue)) == GradingResultStatus.New || ((GradingResultStatus)int.Parse(this.cboStatus.SelectedValue)) == GradingResultStatus.Approved) { GenralReqiurmentStatus = objGenralReqiurment.GetGradingResultStatus(value, (FailPointComparsion)(isMax), FailPoint, dataType); } else { GenralReqiurmentStatus = (GradingResultStatus)int.Parse(this.cboStatus.SelectedValue); } } #endregion // Check if is a General requirment. if (((GradingResultStatus)int.Parse(this.cboStatus.SelectedValue)) == GradingResultStatus.New || ((GradingResultStatus)int.Parse(this.cboStatus.SelectedValue)) == GradingResultStatus.Approved) { GenralReqiurmentStatus = GradingResultStatus.Approved; } else { GenralReqiurmentStatus = (GradingResultStatus)int.Parse(this.cboStatus.SelectedValue); } //Get Commodity Grade Guid CommodityGradeId = Guid.Empty; if (this.chkRecivedGrade.Checked == true) { try { CommodityGradeId = new Guid(this.cboCommodityGrade.SelectedValue.ToString()); } catch { this.lblMsg.Text = "Please Select Commodity Grade."; return; } } //#region Checking Total Value ////Check Grading is OK //if (this.chkRecivedGrade.Checked == true) //{ // bool ValidGrade = false; // CommodityGradeFactorValueBLL objGradeFactorValueBLL = new CommodityGradeFactorValueBLL(); // objGradeFactorValueBLL = objGradeFactorValueBLL.GetActiveValueByCommodoityGradeId(CommodityGradeId); // GradingResultDetailBLL objGradingResultDetail = new GradingResultDetailBLL(); // if (totalValue != null) // { // string err = ""; // ValidGrade = objGradingResultDetail.PreInsertHasValidGradingResult((float)totalValue, CommodityGradeId, out err); // if (ValidGrade == false) // { // this.lblMsg.Text = err + " Total Value : " + totalValue.ToString(); // this.lblMsg.ForeColor = System.Drawing.Color.Red; // return; // } // } //} //#endregion Nullable <Guid> Id = null; GradingResultBLL obj = new GradingResultBLL(); try { obj.GradingId = new Guid(this.cboGradingCode.SelectedValue.ToString()); } catch { this.lblMsg.Text = "Please select Grading Code"; return; } obj.CommodityGradeId = CommodityGradeId; obj.IsSupervisor = this.isSupervisor.Checked; //obj.Status = (GradingResultStatus)Convert.ToInt32(this.cboStatus.SelectedValue); obj.Status = GenralReqiurmentStatus; obj.Remark = this.txtRemark.Text; if (this.cboProductionYear.SelectedValue.ToString() != "") { obj.ProductionYear = int.Parse(this.cboProductionYear.SelectedValue.ToString()); } try { obj.GradeRecivedTimeStamp = Convert.ToDateTime(this.txtDateRecived.Text + " " + this.txtTimeRecived.Text); } catch { this.lblMsg.Text = "Please check grade recieved date and try again"; return; } obj.CreatedBy = UserBLL.GetCurrentUser(); try { Id = obj.Add(list, obj.TrackingNo); } catch (Exception ex) { throw ex; } if (Id != null) { this.lblMsg.Text = "Result Added Successfully."; Session["GRID"] = Id.ToString(); string strTranNo = Session["AddGradingRecivedTranNo"].ToString(); Session["AddGradingRecivedTranNo"] = null; Response.Redirect("ListInbox.aspx"); } else { this.lblMsg.Text = "Data can not be added please check the form and try again.If the error persists contact the administrator."; } }
private void LoadData() { string str = ""; Guid Id; if (Session["GRID"] != null) { str = Session["GRID"].ToString(); } if (str == "") { this.lblMsg.Text = "Unable to load data please try again."; return; } try { Id = new Guid(str); this.hfId.Value = Id.ToString(); } catch (Exception ex) { throw new Exception("Unable to Update Data.", ex); } GradingResultBLL obj = new GradingResultBLL(); obj = obj.GetGradingResultById(Id); if (obj != null) { this.cboGradingRecivedStatus.SelectedValue = ((int)obj.Status).ToString(); } lblGradingReceivedDate.Text = obj.GradeRecivedTimeStamp.ToShortDateString(); cmpSampGen.ValueToCompare = obj.GradeRecivedTimeStamp.ToShortDateString(); if (obj.GradingCode != null) { this.lblGradeCode.Text = obj.GradingCode; } this.lblClient.Text = ""; string cg = ""; CommodityDepositeRequestBLL obCD = new CommodityDepositeRequestBLL(); obCD = obCD.GetCommodityDepositeDetailById(obj.CommodityDepositRequestId); ClientBLL objClient = new ClientBLL(); objClient = ClientBLL.GetClinet(obCD.ClientId); if (objClient != null) { this.lblClient.Text = objClient.ClientName; } else { this.lblMsg.Text = "Unable to load client Data."; } cg = CommodityGradeBLL.GetCommodityGradeNameById(obj.CommodityGradeId); this.lblCommodityGrade.Text = cg; if (((int)obj.Status == 3 || (int)obj.Status == 4) && obj.ClientAcceptanceTimeStamp != null) { this.cboAcceptanceStatus.SelectedValue = ((int)obj.Status).ToString(); DateTime dtCA = DateTime.Now; if (obj.ClientAcceptanceTimeStamp == null) { this.cboAcceptanceStatus.SelectedIndex = -1; } dtCA = (DateTime)obj.ClientAcceptanceTimeStamp; this.txtDateOfAcceptance.Text = dtCA.Date.ToShortDateString(); this.txtTimeodAcceptance.Text = dtCA.ToLongTimeString(); this.cboGradingRecivedStatus.SelectedValue = ((int)obj.GradingResult).ToString(); } }
public void LoadData() { string str = ""; try { ViewState["vsTrackingNo"] = Request.QueryString["TrackingNo"].ToString(); } catch { } if (Session["GRID"] != null) { str = Session["GRID"].ToString(); Session["GRID"] = null; } if (str == "") { this.lblMsg.Text = "Unable to Load data try again."; return; } Guid Id; try { Id = new Guid(str); ViewState["vsGradingResultId"] = Id; } catch (Exception ex) { throw ex; } if (Id != null) { GradingResultBLL obj = new GradingResultBLL(); obj = obj.GetGradingResultById(Id); try { this.hfId.Value = obj.ID.ToString(); } catch (InvalidCastException) { this.hfId.Value = ""; this.btnUpdate.Enabled = false; this.lblMsg.Text = "An error occured "; } catch (NullReferenceException) { this.hfId.Value = ""; this.btnUpdate.Enabled = false; this.lblMsg.Text = "An error occured "; } if (obj.GradingCode != null) { this.txtGradingCode.Text = obj.GradingCode.ToString(); } //Commodity Grade Populating LoadCommodityControls(obj.CommodityGradeId); //this.cboCommodityGrade.SelectedValue = obj.CommodityGradeId.ToString(); try { this.txtDateRecived.Text = obj.GradeRecivedTimeStamp.ToShortDateString(); } catch (NullReferenceException) { this.txtDateRecived.Text = ""; } catch (InvalidCastException) { this.txtDateRecived.Text = ""; } this.txtTimeRecived.Text = obj.GradeRecivedTimeStamp.ToLongTimeString(); try { this.isSupervisor.Checked = obj.IsSupervisor; } catch (NullReferenceException) { this.isSupervisor.Checked = false; } try { this.cboStatus.SelectedValue = obj.Status.ToString(); if (this.cboStatus.SelectedValue == GradingResultStatus.ClientAccepted.ToString()) { this.btnUpdate.Enabled = false; this.gvGradingFactors.Enabled = false; } } catch (NullReferenceException) { this.cboStatus.SelectedValue = ""; } this.txtRemark.Text = obj.Remark.ToString(); int currYear; currYear = int.Parse(ConfigurationSettings.AppSettings["CurrentEthiopianYear"]); this.cboProductionYear.Items.Add(new ListItem("Please Select Production Year.", "")); this.cboProductionYear.AppendDataBoundItems = true; bool isEthYearFound = false; int procYear = obj.ProductionYear; for (int i = currYear - 2; i <= currYear; i++) { this.cboProductionYear.Items.Add(new ListItem(i.ToString(), i.ToString())); if (isEthYearFound == false) { if (i == procYear) { this.cboProductionYear.SelectedValue = i.ToString(); isEthYearFound = true; } } } ViewState["vsProdYear"] = null; if (procYear != -1) { this.cboProductionYear.Items.Add(new ListItem(procYear.ToString(), procYear.ToString())); this.cboProductionYear.SelectedValue = procYear.ToString(); } ViewState["vsProdYear"] = procYear; //Load dataGrid GridDataBind(); } }
private void LoadTruckInformation() { if (this.cboGradingCode.SelectedValue.ToString() == "") { this.lblmsg.Text = "Please select Tracking No."; this.cboGradingCode.SelectedIndex = -1; return; } string str = this.cboGradingCode.SelectedValue.ToString(); string[] temp = new string[2]; temp = str.Split('/'); if (temp[0] == "" || temp[0] == null) { this.lblmsg.Text = "Please try agian."; this.cboGradingCode.SelectedIndex = -1; return; } Guid ReceivigRequestId; try { ReceivigRequestId = new Guid(temp[0].ToString()); } catch { this.lblmsg.Text = "Please try agian."; this.cboGradingCode.SelectedIndex = -1; return; } try { this.hfGradingResultId.Value = temp[1].ToString(); } catch { this.lblmsg.Text = "An error occured, please try agian."; this.cboGradingCode.SelectedIndex = -1; return; } this.hfReceivigRequestId.Value = ReceivigRequestId.ToString(); List <DriverInformationBLL> list = new List <DriverInformationBLL>(); DriverInformationBLL objTruck = new DriverInformationBLL(); list = objTruck.GetActiveDriverInformationByReceivigRequestId(ReceivigRequestId); this.gvDriverInformation.DataSource = list; this.gvDriverInformation.DataBind(); //Get detail gradingResult GradingResultBLL objGradingResult = new GradingResultBLL(); objGradingResult = objGradingResult.GetGradingResultById(new Guid(temp[1].ToString())); UnloadingBLL objUnloading = new UnloadingBLL(); objUnloading = objUnloading.GetApprovedUnloadingByGradingResultId(objGradingResult.ID); if (objUnloading != null) { this.lblDateUnloaded.Text = objUnloading.DateDeposited.ToShortDateString(); this.cmpSampGen.ValueToCompare = objUnloading.DateDeposited.ToShortDateString(); } this.hfTrackingNo.Value = objGradingResult.TrackingNo; }
private void LoadPage() { List <StackUnloadedBLL> list = new List <StackUnloadedBLL>(); ViewState["StackUnloaded"] = list; // load controls.' GradingResultBLL obj = new GradingResultBLL(); //TODO : change by warhouse id. Guid warehouseId = UserBLL.GetCurrentWarehouse(); //Loading Grading Results pending Unloading. this.cboGradingCode.Items.Clear(); List <GradingResultBLL> grdinglist = new List <GradingResultBLL>(); try { grdinglist = obj.GetAcceptedresultsPendingUnloading(warehouseId); } catch (Exception ex) { this.lblmsg.Text = ex.Message; } if (grdinglist != null) { if (grdinglist.Count > 0) { this.cboGradingCode.Items.Add(new ListItem("Please Select Code", "")); this.cboGradingCode.AppendDataBoundItems = true; this.cboGradingCode.DataSource = grdinglist; this.cboGradingCode.DataTextField = "GradingCode"; this.cboGradingCode.DataValueField = "Id"; this.cboGradingCode.DataBind(); this.cboGradingCode.AppendDataBoundItems = false; } else { this.lblmsg.Text = "There are no pending results awaiting Unloading."; } } else { this.lblmsg.Text = "There are no pending results awaiting Unloading."; } //TODO Remove Comment // Loading shedby warehouse. cboShed.Items.Clear(); ShedBLL shed = new ShedBLL(); List <ShedBLL> shedlist = new List <ShedBLL>(); shedlist = shed.GetActiveShedByWarehouseId(warehouseId); cboShed.Items.Add(new ListItem("Select Shed", "")); cboShed.AppendDataBoundItems = true; if (shedlist.Count > 0) { foreach (ShedBLL s in shedlist) { cboShed.Items.Add(new ListItem(s.ShedNumber, s.Id.ToString())); } cboShed.AppendDataBoundItems = false; this.btnSave.Enabled = true; } else { this.btnSave.Enabled = false; } }