private GradingModel SetGrading()
{
Boolean Isnormaldeposit = true;
if (RdBtndeposit.Checked != true)
{
Isnormaldeposit = false;
}
int gradingResultStatus = ((Dictionary <string, int>)ViewState["FGs"])[drpCommodityFactorGroup.SelectedValue];
//eg. General Requirement Fail Sesame status = 3
GradingModel gm = new GradingModel();
gm.ID = new Guid(ViewState["GradingResultID"].ToString()); // new Guid(ViewState[GradingConstants.GradingID.ToString()].ToString());
Guid gFGID = new Guid(drpCommodityFactorGroup.SelectedValue);
gm.GradingResultStatusID = gradingResultStatus;
gm.GradingFactorGroupID = gFGID;
if ((int)GradingResultStatus.AcceptableResult == gradingResultStatus)//for moisture fail
{
gm.GradingFactorGroupID = gFGID;
gm.GradingResultStatusID = (int)GradingResultStatus.AcceptableResult;
gm.TotalValue = 0;
gm.GradeRecived = drpGrade.SelectedItem.Text;
gm.ProductionYear = int.Parse(drpProductionYear.Text);
gm.CommodityClassID = new Guid(drpCommodityClass.SelectedValue);
gm.Isnormaldeposit = Isnormaldeposit;
}
gm.NumberofSeparations = 1;/*By default the separation(segrigation) number is one*/
gm.GradeRecivedDateTime = DateTime.Parse(txtDateRecived.Text + " " + txtTimeRecived.Text);
gm.ResultCreatedBy = BLL.UserBLL.CurrentUser.UserId;
gm.LastModifiedBy = BLL.UserBLL.CurrentUser.UserId;
GradingDetail gd;
decimal gradingValue = 0;
//bool ValueForsemi_wased =false;
//bool ValueForUnderScreen =false;
int?classificationNo = 1;
ViewState["ClassificatonMsg"] = null;
foreach (GridViewRow gr in gvGradingFactors1.Rows)
{
GradingResultControlNew grc = ((GradingResultControlNew)gr.FindControl("ResultInputControl"));
if (!grc.validate())
{
Messages1.SetMessage("The grading factor '" + ((Label)gr.FindControl("lblGradingFactorName")).Text + "' has invalid Value! " +
grc.errorMessage,
Messages.MessageType.Error);
return(null);
}
gd = new GradingDetail(gm);
gd.ID = Guid.NewGuid();
gd.GradingsID = gm.ID;
gd.GradingFactorID = new Guid(((Label)gr.FindControl("lblId")).Text);
gd.ReceivedValue = grc.Value;
gd.Status = 1;
gm.addGradingDetail(gd);
TextBox isInTotal = ((TextBox)gr.FindControl("txtIsInTotalValue"));
gradingValue = 0;
bool canAddToTotal = false;
if (decimal.TryParse(grc.Value.ToString(), out gradingValue) &&/*we need the value after the loop even if not added to total value*/
bool.TryParse(isInTotal.Text, out canAddToTotal) && canAddToTotal)
{
gm.TotalValue += gradingValue;
}
if (!gd.IsValid())
{
Messages1.SetMessage("The grading factor" + ((Label)gr.FindControl("lblGradingFactorName")).Text + " " + gd.ErrorMessage,
Messages.MessageType.Error);
return(null);
}
/*Check for semi-washed, under screen and Moisture Content factor values*/
decimal limit = -1;
string value = ((Label)gr.FindControl("lblIsSemiWashedFactor")).Text;
if (bool.Parse(value) && grc.Value.ToString().ToLower() == "yes")//for semi-washed case
{
classificationNo *= 3;
if (ViewState["ClassificatonMsg"] != null)
{
ViewState.Add("ClassificatonMsg", ViewState["ClassificatonMsg"].ToString() + ", Semi-washed");
}
else
{
ViewState.Add("ClassificatonMsg", "Semi-washed");
}
}
value = ((Label)gr.FindControl("lblIsUnderScreenFactor")).Text;
if (bool.Parse(value) && decimal.TryParse(((Label)gr.FindControl("lblUnderScreenLimit")).Text, out limit) &&
limit > 0 && gradingValue < limit) //for under screen case
{
classificationNo *= 5;
if (ViewState["ClassificatonMsg"] != null)
{
ViewState.Add("ClassificatonMsg", ViewState["ClassificatonMsg"].ToString() + ", Under Screen");
}
else
{
ViewState.Add("ClassificatonMsg", "Under Screen");
}
}
value = ((Label)gr.FindControl("lblIsType")).Text;
if (bool.Parse(value) && decimal.TryParse(grc.Value, out limit))//for non coffee case
{
classificationNo *= int.Parse(grc.Value);
if (ViewState["ClassificatonMsg"] != null)
{
ViewState.Add("ClassificatonMsg", ViewState["ClassificatonMsg"].ToString() + ", " + grc.Text);
}
else
{
ViewState.Add("ClassificatonMsg", grc.Text);
}
}
//Moisture Content factor values
value = ((Label)gr.FindControl("lblIsMoistureContentFactor")).Text;
//string expvalue = "";
//expvalue = ((Label)gr.FindControl("MoistureContentLimitexp")).Text;
limit = -1;
if (bool.Parse(value) && decimal.TryParse(((Label)gr.FindControl("lblMoistureContentLimit")).Text, out limit) &&
limit > 0) //for moisture content case
{
string MFFactorGroup = ((Label)gr.FindControl("lblMoistureFailFactorGroup")).Text;
if (gradingValue > limit && !gm.GradingFactorGroupID.ToString().Equals(MFFactorGroup.Trim()))
{
Messages1.SetMessage("Value entered for moisture content is above range " + limit.ToString() +
"! The grading must be considered with factor group 'Moisture Fail'!",
Messages.MessageType.Error);
return(null);
}
else if (gradingValue <= limit && gm.GradingFactorGroupID.ToString().Equals(MFFactorGroup.Trim()))
{
Messages1.SetMessage("The grading factor moisture content is set with in the limit " + limit.ToString() +
"! The grading MUST NOT be considered with factor group 'Moisture Fail'!",
Messages.MessageType.Error);
return(null);
}
}
}
//gm.IsSemiWashed = ValueForsemi_wased;
//gm.IsUnderScreen = ValueForUnderScreen;
if (classificationNo > 1)
{
gm.ClassificationNo = classificationNo;
}
/*we expect only one factor for segrigation request
* i.e. number of segrigations the grading value will take this value from above*/
if ((int)GradingResultStatus.SegrigationRequested == gradingResultStatus)
{
gm.NumberofSeparations = Convert.ToInt32(gradingValue);
}
if (!gm.IsValidForGradingResult())
{
Messages1.SetMessage(gm.ErrorMessage, Messages.MessageType.Error);
return(null);
}
return(gm);
}
protected void Page_Load(object sender, EventArgs e)
{
// DataTable dt = new DataTable();
ActiveReport rpt = null;
if (Session["ReportType"].ToString() == "PreArrival")
{
BLL.PreArrival objPreArrival = new BLL.PreArrival();
DataTable dt = objPreArrival.PopulatePreArrival(new Guid(Session["CommodityRequestId"].ToString()));
rpt = new rptTrackingReport();
rpt.DataSource = dt;
WebViewer1.Report = rpt;
Session["CommodityRequestId"] = null;
WebViewer1.Width = 600;
WebViewer1.Height = 400;
}
if (Session["ReportType"].ToString() == "GRN")
{
rpt = new rptGRNnew();
GRN_BL objGrnBl = new GRN_BL();
DataTable dt = objGrnBl.GetGRNReport(new Guid(Session["GRNId_GRN"].ToString()));
rpt.DataSource = dt;
WebViewer1.Report = rpt;
}
if (Session["ReportType"].ToString() != "DoNuthing")
{
if (Session["ReportType"].ToString() == "PUN")
{
rpt = new rptPUNReport();
rpt.DataSource = GINBussiness.PickupNoticeModel.PrintPUN(Session["PUNID"].ToString());
}
else if (Session["ReportType"].ToString() == "GIN")
{
rpt = new rptGINReport();
Session["GINID"] = ((GINModel)Session["GINMODEL"]).ID;
rpt.DataSource = GINBussiness.PickupNoticeModel.PrintGIN(Convert.ToBoolean(Session["EditModePrint"]), new Guid(Session["GINID"].ToString()));
}
else if (Session["ReportType"].ToString() == "PSA")
{
//----------Updated START ------ NOV 27 2013
// if it is redirected from search page
string statusx = "Unapproved PSA";
if (Request.QueryString["GINID"] == null)
{
rpt = new rptPSAReport(statusx);
Session["GINPSAID"] = ((GINModel)Session["GINMODEL"]).ID;
rpt.DataSource = GINBussiness.PickupNoticeModel.PrintPSA(new Guid(Session["GINPSAID"].ToString()));
}
else
{
statusx = (Convert.ToInt16(Request.QueryString["ST"]) % 11 == 0) ? "Approved" : "Unapproved PSA";
rpt = new rptPSAReport(statusx);
if (statusx.Equals("Approved"))
{
rpt.DataSource = GINBussiness.PickupNoticeModel.PrintPSA_Approved(new Guid(Request.QueryString["GINID"]));
}
else
{
rpt.DataSource = GINBussiness.PickupNoticeModel.PrintPSA(new Guid(Request.QueryString["GINID"]));
}
}
//----------Updated End ------ NOV 27 2013
}
else if (Session["ReportType"].ToString() == "ExpierdList")
{
rpt = new rptPickupNoticeExpiredList();
DataTable dt = new DataTable();
dt = PickupNoticeModel.SearchExpieredList(UserBLL.GetCurrentWarehouse(), Convert.ToDateTime(Session["ExpirationDateFrom"]), Convert.ToDateTime(Session["ExpirationDateTo"]));
if (dt.Rows.Count > 0)
{
rpt.DataSource = dt;
}
else
{
return;
}
}
else if (Session["ReportType"].ToString() == "ExpierdListAdmin")
{
rpt = new rptPickupNoticeExpiredList();
DataTable dt = new DataTable();
dt = PickupNoticeModel.SearchExpieredListAdmin(Convert.ToDateTime(Session["ExpirationDateFrom"]), Convert.ToDateTime(Session["ExpirationDateTo"]));
if (dt.Rows.Count > 0)
{
rpt.DataSource = dt;
}
else
{
return;
}
}
else if (Session["ReportType"].ToString() == "GINApproval")
{
rpt = new rptGINApproval();
rpt.DataSource = GINBussiness.GINModel.PrintGINApprovalReport(UserBLL.GetCurrentWarehouse(), new Guid(Session["SelectedLIC"].ToString()));
WebViewer1.Report = rpt;
rpt.PageSettings.Margins.Top = 0;
}
else if (Session["ReportType"].ToString() == "SampleTicket")
{
//rpt = new rptSampleTicketCoffeeNew();
//rpt.DataSource = SamplingBussiness.SamplingModel.GetSampleTicketReport(new Guid(Session["SampleId"].ToString()));
rpt = new rptSampleTicketCoffeeNew();
rpt.DataSource = SamplingBussiness.SamplingModel.GetSampleTicketReport(new Guid(Session["SampleId"].ToString()));
}
else if (Session["ReportType"].ToString() == "GradingResult")
{
rpt = new rptResultReport();
rpt.DataSource = GradingModel.GradingResultreport(Session["GradingCode"].ToString());
}
else if (Session["ReportType"].ToString() == "GradingResultNoDeposit")
{
rpt = new rptInspectionTestResult();
rpt.DataSource = GradingModel.GetInspectionTestResult(Session["GradingCode"].ToString(), UserBLL.GetCurrentWarehouse());
}
else if (Session["ReportType"].ToString() == "GradingCode")
{
rpt = new rptGenerate();
DataTable dt = new DataTable();
dt = GradingModel.printCode(new Guid(Session["GenerateCode"].ToString()), new Guid(Session["VoucherCommodityTypeID"].ToString()), new Guid(Session["CommodityID"].ToString()));
rpt.DataSource = dt;
}
else if (Session["ReportType"].ToString() == "GradingResultForSegrigation")
{
rpt = new Report.rptSegrigationGradingReport();
rpt.DataSource = GradingModel.GradingResultreportForSegrigation(Session["GradingCode"].ToString());
}
if (Session["ReportType"].ToString() != "GINApproval")
{
rpt.PageSettings.Margins.Top = 0;
rpt.PageSettings.Margins.Left = 0.4f;
rpt.PageSettings.Margins.Right = 0.4f;
WebViewer1.Report = rpt;
//rpt.Run(false);
//Response.ContentType = "application/pdf";
//Response.AddHeader("content-disposition", "inline; filename=MyPDF.PDF");
//// Create the PDF export object
//PdfExport pdf = new PdfExport();
//// Create a new memory stream that will hold the pdf output
//System.IO.MemoryStream memStream = new System.IO.MemoryStream();
//// Export the report to PDF:
//pdf.Export(rpt.Document, memStream);
//// Write the PDF stream out
//Response.BinaryWrite(memStream.ToArray());
//// Send all buffered content to the client
//Response.End();
}
}
}
private void PopulateGradeResult(string gradeResultCode)
{
GradingModel gradingResult = GradingModel.GetGradingInformationByGradingCode(gradeResultCode);
ViewState.Add("EditMode", true);
ViewState["GradingResultID"] = gradingResult.ID;
lblGradingCodeValue.Text = gradingResult.GradingCode;
lblCodeGeneratedDateValue.Text = gradingResult.DateTimeCoded.ToShortDateString();
lblCodeGeneratedTimeValue.Text = gradingResult.DateTimeCoded.ToShortTimeString();
lblGraderCupperValue.Text = BLL.UserBLL.GetName(gradingResult.UserId);
txtCommodity.Text = gradingResult.CommodityName;
if (gradingResult.CommodityID == null)
{
Messages1.SetMessage("Please specify the commodity in Arrival form to continue!");
return;
}
ViewState.Add(GradingConstants.CommodityId.ToString(), gradingResult.CommodityID.ToString());
ViewState.Add(GradingConstants.IsNonCoffee.ToString(),
!ConfigurationManager.AppSettings["CoffeeId"].ToUpper().Trim().Equals(gradingResult.CommodityID.ToString().ToUpper().Trim()));
ViewState.Add(GradingConstants.WeradaId.ToString(), gradingResult.WoredaID.ToString());
ViewState.Add(GradingConstants.GradingID.ToString(), gradingResult.ID);
ViewState.Add(GradingConstants.CommodityTypeID.ToString(), gradingResult.VoucherCommodityTypeID);
txtDateRecived.Text = gradingResult.GradeRecivedDateTime.ToShortDateString();
txtTimeRecived.Text = gradingResult.GradeRecivedDateTime.ToShortTimeString();
if (gradingResult.ClientAcceptanceTimeStamp >= gradingResult.GradeRecivedDateTime)
{
ViewState.Add("ClientAcceptanceTimeStamp", gradingResult.ClientAcceptanceTimeStamp);
}
if (gradingResult.ProductionYear > 0)
{
drpProductionYear.SelectedValue = gradingResult.ProductionYear.ToString();
}
//FillCommodityClass(drpCommodityClass, CommodityID, WeradaID, null);
FillCommodityClass(drpCommodityClass, CommodityID, null, null);
//assuming if woreda is not known the woredaID field in arrival will be null or empty guid
if (WeradaID != null && Guid.Empty != WeradaID && CommodityTypeID != illegalCommodityTypeID)
{
FillCommodityFactorGroup(drpCommodityFactorGroup, null, CommodityID.Value, WeradaID);
drpCommodityFactorGroup.SelectedValue = gradingResult.GradingFactorGroupID.ToString();
//drpCommodityFactorGroup_SelectedIndexChanged("ForUpdate", null);
onCommodityFactorGroupChange(true, gradingResult.CommodityClassID.ToString());
drpCommodityClass.SelectedValue = gradingResult.CommodityClassID.ToString();
}
else
{
lblComodityClass.Visible = drpCommodityClass.Visible = true;
lblComodityClass.Enabled = drpCommodityClass.Enabled = true;
drpCommodityClass.SelectedValue = gradingResult.CommodityClassID.ToString();
drpCommodityClass_SelectedIndexChanged("ForUpdate", null);
drpCommodityFactorGroup.SelectedValue = gradingResult.GradingFactorGroupID.ToString();
drpCommodityFactorGroup_SelectedIndexChanged(null, null);
}
if (gradingResult.GradeRecived != null)
{
drpGrade.SelectedValue = gradingResult.GradeRecived.ToString();
}
if (gradingResult.GRNCreated || gradingResult.NewSampleCodeGenerated ||
(gradingResult.GradingResultStatusID == (int)GradingResultStatus.SegrigationRequested && gradingResult.GradingsStatusID > 0))
{
drpCommodityClass.Enabled = drpCommodityFactorGroup.Enabled = drpGrade.Enabled = false;
chkChangeClass.Enabled = false;
rfvdrpGrade.Enabled = false;
gvGradingFactors1.Enabled = false;
txtDateRecived.Enabled = txtTimeRecived.Enabled = false;
drpProductionYear.Enabled = false;
btnSave.Enabled = false;
btnCancel.Enabled = false;
string toolTip = "GRN processed grade result can't be edited!";
btnSave.ToolTip = drpCommodityClass.ToolTip = drpCommodityFactorGroup.ToolTip = drpGrade.ToolTip =
gvGradingFactors1.ToolTip = toolTip;
}
}
private void onCommodityFactorGroupChange(bool?ForUpdate, string GclassValue)
{
Messages1.ClearMessage();
gvGradingFactors1.DataSource = new DataTable();
gvGradingFactors1.DataBind();
drpGrade.Items.Clear();
drpGrade.DataSource = new DataTable();
drpGrade.DataBind();
if (drpCommodityFactorGroup.SelectedIndex > 0)
{
bool woradaknown = !(WeradaID == null || Guid.Empty == WeradaID || CommodityTypeID == illegalCommodityTypeID);
int gradingResultStatus = ((Dictionary <string, int>)ViewState["FGs"])[drpCommodityFactorGroup.SelectedValue];
if ((int)GradingResultStatus.AcceptableResult != gradingResultStatus)
{
drpGrade.Enabled = false;
rfvdrpGrade.Enabled = false;
drpProductionYear.Enabled = false;
rfvdrpProductionYear.Enabled = false;
drpCommodityClass.SelectedIndex = -1;
rfvdrpCommodityClass.Enabled = false;
//drpCommodityClass.Enabled = false;
}
else
{
drpGrade.Enabled = true;
rfvdrpGrade.Enabled = true;
rfvdrpProductionYear.Enabled = true;
drpProductionYear.Enabled = true;
if (CommodityID == new Guid("37d28859-5579-436b-98c8-2bf28bd413be"))
{
woradaknown = false;
}
if (woradaknown)
{
//FillCommodityClass(drpCommodityClass, null,
// WeradaID,
// new Guid(drpCommodityFactorGroup.SelectedValue));
//if (((DataTable)drpCommodityClass.DataSource).Rows.Count > 0)
// drpCommodityClass.SelectedIndex = 1;
if (!chkChangeClass.Checked)
{
//if (IsNonCoffee != null && IsNonCoffee.Value)
DataTable dt = GradingModel.GetCommodityClass(null, WeradaID, new Guid(drpCommodityFactorGroup.SelectedValue));
if (GclassValue == null || dt.Select("ClassID ='" + GclassValue + "'").Count() > 0)
{
FillCommodityClass(drpCommodityClass, null, WeradaID, new Guid(drpCommodityFactorGroup.SelectedValue));
}
if (dt.Rows.Count > 0)
{
//if (drpCommodityClass.Items.Count == 2)// || (IsNonCoffee == null || !IsNonCoffee.Value))//
if (dt.Rows.Count == 1)// || (IsNonCoffee == null || !IsNonCoffee.Value))
{
if (GclassValue == null)
{
//DataTable dt = GradingModel.GetCommodityClass(null, WeradaID, new Guid(drpCommodityFactorGroup.SelectedValue));
drpCommodityClass.SelectedValue = dt.Rows[0]["ClassID"].ToString();
}
else
{
drpCommodityClass.SelectedValue = GclassValue;
}
drpCommodityClass.Enabled = false;
rfvdrpCommodityClass.Enabled = false;
}
else
{
if (ForUpdate == null || !ForUpdate.Value)
{
drpCommodityClass.SelectedIndex = 0;
}
else if (GclassValue != null)
{
drpCommodityClass.SelectedValue = GclassValue;
}
drpCommodityClass.Enabled = true;
rfvdrpCommodityClass.Enabled = true;
}
}
else
{
Messages1.SetMessage("Class with the factor group and woreda was not found");
}
}
}
if (drpCommodityClass.SelectedIndex > 0)
{
FillCommodityGrade(drpGrade, new Guid(drpCommodityFactorGroup.SelectedValue),
new Guid(drpCommodityClass.SelectedValue));
}
}
FillCommodityFactor(new Guid(drpCommodityFactorGroup.SelectedValue));
}
}
