//protected void cboStatus_SelectedIndexChanged(object sender, EventArgs e)
//{
//Guid CommodityGradeId = Guid.Empty;
//try
//{
// CommodityGradeId = new Guid(this.cboCommodityGrade.SelectedValue.ToString());
//}
//catch
//{
// this.lblMsg.Text = "Please Select commodity Grade.";
// return;
//}
//if (CommodityGradeId != Guid.Empty)
//{
// GradingFactorBLL obj = new GradingFactorBLL();
// List<GradingFactorBLL> list = new List<GradingFactorBLL>();
// list = obj.GetGradingFactors(CommodityGradeId);
// this.gvGradingFactors.DataSource = list;
// this.gvGradingFactors.DataBind();
//}
//else
//{
// this.lblMsg.Text = "Please Select commodity Grade.";
// return;
//}
// }
private void LoadGrader()
{
Guid GradingId = Guid.Empty;
try
{
GradingId = new Guid(this.cboGradingCode.SelectedValue.ToString());
}
catch
{
this.lblMsg.Text = "Please Select Grading Code.";
return;
}
if (GradingId == Guid.Empty)
{
this.lblMsg.Text = "Please Select Grading Code.";
return;
}
GradingByBLL objGradeByBLL = new GradingByBLL();
List <GradingByBLL> list = new List <GradingByBLL>();
list = objGradeByBLL.GetByGradingId(GradingId);
this.cboGrader.Items.Clear();
this.cboGrader.Items.Add(new ListItem("Please Select Grader", ""));
if (list.Count > 0)
{
foreach (GradingByBLL i in list)
{
this.cboGrader.Items.Add(new ListItem(i.GraderName, i.Id.ToString()));
}
}
}
private void CoffeeCodingReport_ReportStart(object sender, EventArgs e)
{
Guid CommodityDepositeId = Guid.Empty;
Guid WoredaId = Guid.Empty;
GradingBLL objCode = new GradingBLL();
if (HttpContext.Current.Session["CodeReport"] != null)
{
objCode = (GradingBLL)HttpContext.Current.Session["CodeReport"];
}
else
{
throw new Exception("Session expired.");
}
if (objCode != null)
{
this.txtDateCoded.Text = objCode.DateCoded.ToString("dd MMM-yyyy");
this.txtCode.Text = objCode.GradingCode.ToString();
CommodityDepositeId = objCode.CommodityRecivingId;
}
if (CommodityDepositeId != Guid.Empty)
{
CommodityDepositeRequestBLL objCDR = new CommodityDepositeRequestBLL();
objCDR = objCDR.GetCommodityDepositeDetailById(CommodityDepositeId);
if (objCDR != null)
{
WoredaId = objCDR.WoredaId;
WoredaBLL objWoreda = new WoredaBLL();
objWoreda = objWoreda.GetWoredabyId(WoredaId);
if (objWoreda != null)
{
this.txtOrigin.Text = objWoreda.WoredaName;
}
}
}
this.txtDateGenerated.Text = DateTime.Now.ToString("dd MMM-yyyy");
conn = Connection.getConnection();
GradingByBLL objGradersReader = new GradingByBLL();
reader = objGradersReader.GetGradersByGradingIdDataReader(objCode.Id, conn);
}
protected void gvGrader_RowCommand(object sender, GridViewCommandEventArgs e)
{
this.lblMsg.Text = "";
int index = Convert.ToInt32(e.CommandArgument);
GridViewRow rw = this.gvGrader.Rows[index];
if (e.CommandName == "Remove")
{
List <GradingByBLL> list = new List <GradingByBLL>();
list = (List <GradingByBLL>)Session["Graders"];
GradingByBLL obj = new GradingByBLL();
obj = list[index];
this.cboGrader.AppendDataBoundItems = true;
this.cboGrader.Items.Add(new ListItem(obj.GraderName, obj.UserId.ToString()));
this.cboGrader.AppendDataBoundItems = false;
list.RemoveAt(index);
this.gvGrader.DataSource = list;
this.gvGrader.DataBind();
Session["Graders"] = list;
}
}
protected void gvCodeGenerated_RowCommand(object sender, GridViewCommandEventArgs e)
{
this.lblMsg.Text = "";
if (e.CommandName == "Print")
{
int index = Convert.ToInt32(e.CommandArgument);
GridViewRow rw = this.gvCodeGenerated.Rows[index];
Label lblId = (Label)rw.FindControl("lblId");
Guid Id = Guid.Empty;
try
{
Id = new Guid(lblId.Text);
if (Id != Guid.Empty)
{
GradingBLL objCodeReport = new GradingBLL();
objCodeReport = objCodeReport.GetById(Id);
Session["CodeReport"] = objCodeReport;
List <GradingByBLL> list = new List <GradingByBLL>();
GradingByBLL objGraders = new GradingByBLL();
list = objGraders.GetByGradingId(objCodeReport.Id);
GradingByCollection objGraderCollection = new GradingByCollection(list);
Session["GradersCodeReport"] = objGraderCollection;
StringBuilder sb = new StringBuilder();
sb.Append("<script>");
sb.Append("window.open('rptCoffeeCode.aspx");
sb.Append("', '', 'toolbar=0');");
sb.Append("</scri");
sb.Append("pt>");
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "ShowReport",
sb.ToString(), false);
}
}
catch (Exception ex)
{
throw ex;
}
}
}
protected void btnAddGrader_Click(object sender, EventArgs e)
{
this.lblMsg.Text = "";
List <GradingByBLL> list = new List <GradingByBLL>();
if (Session["Graders"] != null)
{
list = (List <GradingByBLL>)Session["Graders"];
}
//check Count Number of graders required.
GradingByBLL objgrader = new GradingByBLL();
objgrader.Id = Guid.NewGuid();
try
{
int index;
objgrader.GraderName = this.cboGrader.SelectedItem.ToString();
objgrader.UserId = new Guid(this.cboGrader.SelectedValue.ToString());
objgrader.IsSupervisor = this.chkIsSupervisor.Checked;
index = int.Parse(this.cboGrader.SelectedIndex.ToString());
list.Add(objgrader);
Session["Graders"] = list;
this.gvGrader.DataSource = list;
this.gvGrader.DataBind();
this.cboGrader.Items.RemoveAt(index);
this.cboGrader.SelectedIndex = -1;
if (this.chkIsSupervisor.Checked == true)
{
this.chkIsSupervisor.Checked = false;
}
}
catch
{
this.lblMsg.Text = "Please select Grader.";
}
}
public static bool InsertGraders(GradingByBLL obj, SqlTransaction tran)
{
string strSql = "spInsertGrader";
SqlParameter[] arPar = new SqlParameter[6];
arPar[0] = new SqlParameter("@Id", SqlDbType.UniqueIdentifier);
arPar[0].Value = obj.Id;
arPar[1] = new SqlParameter("@GradingId", SqlDbType.UniqueIdentifier);
arPar[1].Value = obj.GradingId;
arPar[2] = new SqlParameter("@UserId", SqlDbType.NVarChar, 50);
arPar[2].Value = obj.UserId;
arPar[3] = new SqlParameter("@Status", SqlDbType.Int);
arPar[3].Value = obj.Status;
arPar[4] = new SqlParameter("@isSupervisor", SqlDbType.Bit);
arPar[4].Value = obj.IsSupervisor;
arPar[5] = new SqlParameter("@CreatedBy", SqlDbType.UniqueIdentifier);
arPar[5].Value = obj.CreatedBy;
int AffectedRows = 0;
AffectedRows = SqlHelper.ExecuteNonQuery(tran, strSql, arPar);
if (AffectedRows == 1)
{
return(true);
}
else
{
throw new Exception("Adding Grader Record failed");
}
}
private void rptGRN_ReportStart(object sender, EventArgs e)
{
if (HttpContext.Current.Session["GRNIDPrint"] == null)
{
throw new Exception("Session expired");
}
Guid GRNId = Guid.Empty;
GRNId = new Guid(HttpContext.Current.Session["GRNIDPrint"].ToString());
Guid GradingId = Guid.Empty;
GRNBLL objGRN = new GRNBLL();
objGRN = objGRN.GetbyGRN_Number(GRNId);
GradingId = objGRN.GradingId;
this.lblGRN_No.Text = objGRN.GRN_Number;
this.lblClient.Text = ClientBLL.GetClinetNameById(objGRN.ClientId);
this.lblCommodityGrade.Text = CommodityGradeBLL.GetCommodityGradeNameById(objGRN.CommodityGradeId);
this.lblWarehouse.Text = WarehouseBLL.GetWarehouseNameById(objGRN.WarehouseId);
this.lblOriginalQuantity.Text = objGRN.OriginalQuantity.ToString();
this.lblNetWeight.Text = objGRN.NetWeight.ToString();
this.lblDateDeposited.Text = objGRN.DateDeposited.ToShortDateString();
this.lblTimeDeposited.Text = objGRN.DateDeposited.ToShortTimeString();
this.lblNoBags.Text = objGRN.TotalNumberOfBags.ToString();
//Bag Type
BagTypeBLL objBt = new BagTypeBLL();
objBt.GetBagTypeById(objGRN.BagTypeId);
lblBagType.Text = objBt.BagTypeName;
//Driver Information
List <DriverInformationBLL> list = null;
DriverInformationBLL objDI = new DriverInformationBLL();
list = objDI.GetActiveDriverInformationByReceivigRequestId(objGRN.CommodityRecivingId);
if (list != null)
{
string driverName = "";
string plateNo = "";
string driverLicense = "";
string licensceIssuedPlace = "";
foreach (DriverInformationBLL o in list)
{
if (driverName == "")
{
driverName = o.DriverName;
}
else
{
driverName += "," + o.DriverName;
}
if (plateNo == "")
{
if (String.IsNullOrEmpty(o.TrailerPlateNumber) != true)
{
plateNo = o.PlateNumber + "-" + o.TrailerPlateNumber;
}
else
{
plateNo = o.PlateNumber;
}
}
else
{
if (String.IsNullOrEmpty(o.TrailerPlateNumber) != true)
{
plateNo += " , " + o.PlateNumber + "-" + o.TrailerPlateNumber;
}
else
{
plateNo += " , " + o.PlateNumber;
}
}
if (driverLicense == "")
{
driverLicense = o.LicenseNumber;
}
else
{
driverLicense += " , " + o.LicenseNumber;
}
if (licensceIssuedPlace == "")
{
licensceIssuedPlace = o.LicenseIssuedPlace;
}
else
{
licensceIssuedPlace += " , " + o.LicenseIssuedPlace;
}
}
this.lblDriverName.Text = driverName;
this.lblPlateNo.Text = plateNo;
this.lblDriverLicense.Text = driverLicense;
this.lblPlaceIssued.Text = licensceIssuedPlace;
}
// Scaling
ScalingBLL objScaling = new ScalingBLL();
objScaling = objScaling.GetById(objGRN.ScalingId);
if (objScaling != null)
{
if (objScaling.WeigherId != null)
{
try
{
this.lblWeigherName.Text = UserRightBLL.GetUserNameByUserId(objScaling.WeigherId);
}
catch
{
}
}
}
// Sampler
SamplerBLL objSampler = new SamplerBLL();
objSampler = objSampler.GetActiveSamplingSupBySamplingId(objGRN.SamplingTicketId);
if (objSampler != null)
{
this.lblSampler.Text = UserRightBLL.GetUserNameByUserId(objSampler.SamplerId);
}
//Graders
GradingByBLL objGrader = new GradingByBLL();
this.lblGrader.Text = objGrader.GetSupGraderNameByGradingId(objGRN.GradingId);
if (objGRN.ApprovedBy != null)
{
try
{
this.lblApprovedBy.Text = UserRightBLL.GetUserNameByUserId(objGRN.ApprovedBy);
}
catch
{
}
}
if (objGRN.ApprovedTimeStamp != null)
{
this.lblDateAproved.Text = objGRN.ApprovedTimeStamp.ToShortDateString();
}
rpt = new rptGrading(GradingId);
rptGS = new rptGRNService(GRNId);
this.txtDateGenerated.Text = DateTime.Now.ToString();
ScalingBLL objSacling = new ScalingBLL();
objSacling = objSacling.GetById(objGRN.ScalingId);
if (objSacling != null)
{
this.lblScaleTicketNo.Text = objSacling.ScaleTicketNumber;
}
this.subReport1.Report = rpt;
this.subReport2.Report = this.rptGS;
}
public static List <GradingByBLL> GetSupervisorByGradingId(Guid Id)
{
List <GradingByBLL> list;
string strSql = "spGetSupervisorGraderByGradingId";
SqlParameter[] arPar = new SqlParameter[1];
SqlDataReader reader;
arPar[0] = new SqlParameter("@GradingId", SqlDbType.UniqueIdentifier);
arPar[0].Value = Id;
SqlConnection conn = Connection.getConnection();
if (conn == null || conn.State != ConnectionState.Open)
{
throw new Exception("Invalid database connection.");
}
try
{
reader = SqlHelper.ExecuteReader(conn, CommandType.StoredProcedure, strSql, arPar);
if (reader.HasRows)
{
list = new List <GradingByBLL>();
while (reader.Read())
{
GradingByBLL obj = new GradingByBLL();
obj.Id = new Guid(reader["Id"].ToString());
obj.GradingId = new Guid(reader["GradingId"].ToString());
obj.UserId = new Guid(reader["UserId"].ToString());
obj.Status = int.Parse(reader["Status"].ToString());
obj.IsSupervisor = bool.Parse(reader["isSupervisor"].ToString());
if (reader["CreatedBy"] != null)
{
try
{
obj.CreatedBy = new Guid(reader["CreatedBy"].ToString());
}
catch
{
}
}
if (reader["CreatedTimestamp"] != null)
{
try
{
obj.CreatedTimestamp = DateTime.Parse(reader["CreatedTimestamp"].ToString());
}
catch
{
}
}
if (reader["LastModifiedBy"] != null)
{
try
{
obj.LastModifiedBy = new Guid(reader["LastModifiedBy"].ToString());
}
catch
{
}
}
if (reader["LastModifiedTimestamp"] != null)
{
try
{
obj.LastModifiedTimestamp = DateTime.Parse(reader["LastModifiedTimestamp"].ToString());
}
catch
{
}
}
list.Add(obj);
}
return(list);
}
else
{
return(null);
}
}
catch (Exception e)
{
throw e;
}
finally
{
if (conn != null)
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
}
}
}
protected void btnGenerateCode_Click(object sender, EventArgs e)
{
bool isSaved = false;
this.lblMsg.Text = "";
string WarehouseNo;
try
{
WarehouseNo = UserBLL.GetCurrentWarehouseCode();
}
catch
{
this.lblMsg.Text = "No warehouse code,please try agian.";
return;
}
if (string.IsNullOrEmpty(WarehouseNo) == true)
{
this.lblMsg.Text = "No warehouse code,please try agian.";
return;
}
if (string.IsNullOrEmpty(this.cboSampleCode.SelectedItem.Text) == true)
{
this.lblMsg.Text = "Please if the sample code exists";
return;
}
string[] IdCollection = new string[3];
IdCollection = this.cboSampleCode.SelectedValue.Split('/');
Guid SamplingResultId = Guid.Empty;
Guid ReceivigRequestId = Guid.Empty;
try
{
SamplingResultId = new Guid(IdCollection[0].ToString());
ReceivigRequestId = new Guid(IdCollection[1].ToString());
}
catch
{
this.lblMsg.Text = "Please if the sample code exists";
return;
}
string TrackingNo = IdCollection[2].ToString();
DateTime DateCoded = DateTime.Parse(this.txtDateCodeGenrated.Text + " " + txtTimeArrival.Text);
GradingBLL objGrading = new GradingBLL();
if (SamplingResultId != Guid.Empty)
{
objGrading.SamplingResultId = SamplingResultId;
}
else
{
this.lblMsg.Text = "Please if the sample code exists";
return;
}
if (ReceivigRequestId != Guid.Empty)
{
objGrading.CommodityRecivingId = ReceivigRequestId;
}
else
{
this.lblMsg.Text = "Please if the sample code exists";
return;
}
objGrading.Status = GradingStatus.Coded;
objGrading.TrackingNo = TrackingNo;
objGrading.CreatedBy = UserBLL.GetCurrentUser();
objGrading.DateCoded = DateCoded;
List <GradingByBLL> list = new List <GradingByBLL>();
list = (List <GradingByBLL>)Session["Graders"];
if (list == null)
{
this.lblMsg.Text = "Please provide graders.";
return;
}
if (list.Count <= 0)
{
this.lblMsg.Text = "Please provide graders.";
return;
}
if (isSingleSupervisorGrader(list) == false)
{
return;
}
Guid CommodityId = Guid.Empty;
CommodityDepositeRequestBLL objCDR = new CommodityDepositeRequestBLL();
objCDR = objCDR.GetCommodityDepositeDetailById(ReceivigRequestId);
if (GradingByBLL.IsNumberofGraderAcceptable(list.Count, objCDR.CommodityId) == false)
{
this.lblMsg.Text = "The number of graders selected is less than the minimum required.";
return;
}
if (list == null || list.Count <= 0)
{
this.lblMsg.Text = "Please add graders before generating code.";
return;
}
if (this.hfTrackingNo.Value == "" || this.hfTrackingNo.Value == null)
{
this.lblMsg.Text = "An error has occured.";
return;
}
isSaved = objGrading.Add(WarehouseNo, this.hfTrackingNo.Value.ToString(), list);
if (isSaved == true)
{
// TODO Update a GridView dataBind and print the Coding Ticket.
this.lblMsg.Text = "Data Added Successfully.";
CommodityDepositeRequestBLL obj = new CommodityDepositeRequestBLL();
Session["Graders"] = null;
this.gvGrader.DataSource = null;
this.gvGrader.DataBind();
this.pnlGradingDetail.Visible = false;
this.btnGenerateCode.Visible = false;
LoadCode(objGrading.SamplingResultId);
}
else
{
this.lblMsg.Text = "Data can not be saved. Please check the data entered and try again.If the error persists, conatact the IT support.";
}
}
