protected void Page_Load(object sender, EventArgs e)
{
if (Page.IsPostBack == false)
{
this.Page.DataBind();
if (Session["SamplingId"] != null)
{
Guid Id = Guid.Empty;
Id = new Guid(Session["SamplingId"].ToString());
Session["SamplingId"] = null;
if (Id != Guid.Empty)
{
SamplingBLL obj = new SamplingBLL();
obj = obj.GetSampleDetail(Id);
obj.Id = Id;
if (obj != null)
{
this.lblSampleCode.Text = obj.SampleCode;
this.txtDateCodeGenrated.Text = obj.GeneratedTimeStamp.ToShortDateString();
this.txtTimeArrival.Text = obj.GeneratedTimeStamp.ToShortTimeString();
ViewState["SamplingId"] = Id;
CommodityDepositeRequestBLL objCDR = new CommodityDepositeRequestBLL();
objCDR = objCDR.GetCommodityDepositeDetailById(obj.ReceivigRequestId);
if (objCDR != null)
{
lblArrivalDate.Text = objCDR.DateTimeRecived.ToShortDateString();
}
}
}
}
}
}
private void LoadDepositeRequest(Guid commDepositeId)
{
CommodityDepositeRequestBLL objCDR = new CommodityDepositeRequestBLL();
objCDR = objCDR.GetCommodityDepositeDetailById(commDepositeId);
if (objCDR != null)
{
this.lblProductionYear.Text = objCDR.ProductionYear.ToString();
this.lblDateRecived.Text = objCDR.DateTimeRecived.ToString();
this.lblTrackingNo.Text = objCDR.TrackingNo;
this.hfReceivigRequestId.Value = commDepositeId.ToString();
this.hfWarehouseId.Value = objCDR.WarehouseId.ToString();
LoadClient(objCDR.ClientId);
Guid coffeeId = (Guid)WarehouseApplication.BLL.Utility.GetCommodityId("Coffee");
if (objCDR.CommodityId == coffeeId)
{
LoadVoucherInformation(commDepositeId);
ViewState["hasVoucher"] = true;
}
else
{
ViewState["hasVoucher"] = false;
}
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
bool isSaved = false;
Guid ClientId = Guid.Empty;
CommodityDepositeRequestBLL objOld = (CommodityDepositeRequestBLL)ViewState["CommDepOld"];
if (string.IsNullOrEmpty(this.ClientSelector1.ClientGUID.Value.ToString()))
{
ClientId = new Guid(this.hfClientId.Value.ToString());
}
else
{
ClientId = new Guid(this.ClientSelector1.ClientGUID.Value.ToString());
}
CommodityDepositeRequestBLL obj = new CommodityDepositeRequestBLL();
Guid CommDepId = new Guid(hfCommodityDepositeId.Value.ToString());
Guid CommdityId = new Guid(cboCommodity.SelectedValue.ToString());
Guid WoredaId = new Guid(cboWoreda.SelectedValue.ToString());
Guid RepId = Guid.NewGuid();
int Prodyear = int.Parse(cboProductionYear.SelectedValue.ToString());
float weight = 0;
if (txtWeight.Text != "")
{
weight = float.Parse(txtWeight.Text);
}
int NoBags = 0;
if (txtNumberOfBags.Text != "")
{
NoBags = int.Parse(this.txtNumberOfBags.Text);
}
DateTime dtRecivedDate = Convert.ToDateTime(dtDateTimeRecived.Text + " " + this.txtTimeArrival.Text);
string remark = this.txtRemark.Text;
int Status = int.Parse(this.cboStatus.SelectedValue.ToString());
int prodYear = int.Parse(cboProductionYear.SelectedValue.ToString());
try
{
isSaved = obj.EditCommodityDepositRequest(ClientId, CommDepId, CommdityId, RepId, Prodyear,
WoredaId, weight, NoBags, dtRecivedDate, remark, Status, UserBLL.GetCurrentUser(), objOld);
}
catch (GRNNotOnUpdateStatus ex)
{
this.lblmsg.Text = ex.msg;
return;
}
if (isSaved == true)
{
this.lblmsg.Text = "Data Updated Sucessfully";
LoadData(CommDepId);
}
else
{
this.lblmsg.Text = "Unable to Updated data.";
}
}
public static List <CommodityDepositeRequestBLL> SearchCommodityDeposite(string TrackingNo, string VoucherNo, Nullable <Guid> Clientid, Nullable <Guid> CommodityId, Nullable <DateTime> from, Nullable <DateTime> to)
{
List <CommodityDepositeRequestBLL> list = new List <CommodityDepositeRequestBLL>();
string strSql = SearchHelper(TrackingNo, VoucherNo, Clientid, CommodityId, from, to);
DataSet dsCommodityDepositeRequest = null;
SqlConnection conn = Connection.getConnection();
try
{
dsCommodityDepositeRequest = SqlHelper.ExecuteDataset(conn, CommandType.Text, strSql);
if (dsCommodityDepositeRequest.Tables[0].Rows.Count > 0)
{
for (int i = 0; dsCommodityDepositeRequest.Tables[0].Rows.Count > i; i++)
{
DataRow row;
row = dsCommodityDepositeRequest.Tables[0].Rows[i];
CommodityDepositeRequestBLL obj = new CommodityDepositeRequestBLL();
if (row["Id"] != null)
{
obj.Id = new Guid(row["Id"].ToString());
}
obj.TrackingNo = row["TransactionId"].ToString();
if (row["ClientId"] != null)
{
obj.ClientId = new Guid(row["ClientId"].ToString());
}
if (row["VoucherNo"] != null)
{
obj.VoucherNo = row["VoucherNo"].ToString();
}
if (row["CommodityId"] != null)
{
obj.CommodityId = new Guid(row["CommodityId"].ToString());
}
if (row["DateTimeRecived"] != null)
{
obj.DateTimeRecived = Convert.ToDateTime(row["DateTimeRecived"].ToString());
}
list.Add(obj);
}
return(list);
}
else
{
return(null);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Close();
}
}
protected void btnSearch_Click(object sender, EventArgs e)
{
List <CommodityDepositeRequestBLL> list = new List <CommodityDepositeRequestBLL>();
CommodityDepositeRequestBLL obj = new CommodityDepositeRequestBLL();
string strTrackingNo = this.txtTrackingNumber.Text;
string strVoucherNo = this.txtVoucherNo.Text;
Nullable <Guid> ClientId = null;
if (this.ClientSelector1.ClientGUID.Value.ToString() != "")
{
ClientId = new Guid(this.ClientSelector1.ClientGUID.Value.ToString());
}
Nullable <Guid> CommodityId = null;
if (this.cboCommodity.SelectedValue != "")
{
CommodityId = new Guid(this.cboCommodity.SelectedValue);
}
Nullable <DateTime> from = null;
if (this.dtFrom.Text != "")
{
from = Convert.ToDateTime(this.dtFrom.Text);
}
Nullable <DateTime> to = null;
if (this.dtTo.Text != "")
{
to = Convert.ToDateTime(this.dtTo.Text);
}
//Check at least one search parameter is provided.
if (strTrackingNo == "" && strVoucherNo == "" && ClientId == null && CommodityId == null && from == null && to == null)
{
this.lblMsg.Text = "Please provide at least one search Criteria";
return;
}
list = obj.SearchCommodityDeposite(strTrackingNo, strVoucherNo, ClientId, CommodityId, from, to);
ViewState["list"] = list;
if (list != null)
{
this.lblMsg.Text = "";
this.gvDepositeRequetsList.DataSource = list;
this.gvDepositeRequetsList.DataBind();
if (list.Count == 0)
{
lblMsg.Text = "No record found";
}
}
else
{
lblMsg.Text = "No record found";
}
}
private void LoadDepositeRequest(Guid commDepositeId)
{
CommodityDepositeRequestBLL objCDR = new CommodityDepositeRequestBLL();
objCDR = objCDR.GetCommodityDepositeDetailById(commDepositeId);
if (objCDR != null)
{
//this.lblProductionYear.Text = objCDR.ProductionYear.ToString();
this.lblDateRecived.Text = objCDR.DateTimeRecived.ToString();
this.lblTrackingNo.Text = objCDR.TrackingNo;
this.hfReceivigRequestId.Value = commDepositeId.ToString();
this.hfWarehouseId.Value = objCDR.WarehouseId.ToString();
LoadClient(objCDR.ClientId);
}
}
private void LoadCommodity()
{
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;
}
GradingBLL objGrading = new GradingBLL();
objGrading = objGrading.GetById(GradingId);
Guid CommodityReciveingRequestId = Guid.Empty;
if (objGrading != null)
{
CommodityReciveingRequestId = objGrading.CommodityRecivingId;
}
else
{
this.lblMsg.Text = "An error has occured please Try again.";
return;
}
if (CommodityReciveingRequestId != Guid.Empty)
{
CommodityDepositeRequestBLL objCommDepReq = new CommodityDepositeRequestBLL();
objCommDepReq = objCommDepReq.GetCommodityDepositeDetailById(CommodityReciveingRequestId);
if (objCommDepReq != null)
{
if (objCommDepReq.CommodityId != null)
{
this.cboCommodity_CascadingDropDown.ContextKey = objCommDepReq.CommodityId.ToString();
this.cboCommodity_CascadingDropDown.SelectedValue = objCommDepReq.CommodityId.ToString();
this.cboCommodity.SelectedValue = objCommDepReq.CommodityId.ToString();
LoadGradingFactors(objCommDepReq.CommodityId);
}
}
}
}
public static int UpdateCommodityDepositeRequest(CommodityDepositeRequestBLL objCommDepoReq, SqlTransaction tran)
{
int AffectedRows;
string strSql = "spEditCommodityDepositeRequest";
SqlParameter[] arPar = new SqlParameter[12];
arPar[0] = new SqlParameter("@CommodityDepositRequestId", SqlDbType.UniqueIdentifier);
arPar[0].Value = objCommDepoReq.Id;
arPar[1] = new SqlParameter("@Commodity", SqlDbType.UniqueIdentifier);
arPar[1].Value = objCommDepoReq.CommodityId;
arPar[2] = new SqlParameter("@RepresentativeId", SqlDbType.UniqueIdentifier);
arPar[2].Value = objCommDepoReq.RepresentativeId;
arPar[3] = new SqlParameter("@ProductionYear", SqlDbType.Int);
arPar[3].Value = objCommDepoReq.ProductionYear;
arPar[4] = new SqlParameter("@Woreda", SqlDbType.UniqueIdentifier);
arPar[4].Value = objCommDepoReq.WoredaId;
arPar[5] = new SqlParameter("@Weight", SqlDbType.Float);
arPar[5].Value = objCommDepoReq.Weight;
arPar[6] = new SqlParameter("@NumberofBags", SqlDbType.Int);
arPar[6].Value = objCommDepoReq.NumberofBags;
arPar[7] = new SqlParameter("@DateTimeRecived", SqlDbType.DateTime);
arPar[7].Value = objCommDepoReq.DateTimeRecived;
arPar[8] = new SqlParameter("@Remark", SqlDbType.Text);
arPar[8].Value = objCommDepoReq.Remark;
arPar[9] = new SqlParameter("@Status", SqlDbType.Int);
arPar[9].Value = objCommDepoReq.Status;
arPar[10] = new SqlParameter("@LastModifiedBy", SqlDbType.UniqueIdentifier);
arPar[10].Value = objCommDepoReq.LastModifiedBy;
arPar[11] = new SqlParameter("@ClientId", SqlDbType.UniqueIdentifier);
arPar[11].Value = objCommDepoReq.ClientId;
AffectedRows = SqlHelper.ExecuteNonQuery(tran, CommandType.StoredProcedure, strSql, arPar);
return(AffectedRows);
}
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 btnGenerateSampleTicket_Click(object sender, EventArgs e)
{
//
Nullable <Guid> Id;
Guid WarehouseId = UserBLL.GetCurrentWarehouse();
Guid Moistureid = Guid.Empty;
bool isMoisture = false;
string TransactionId = String.Empty;
Nullable <Guid> RecievingRequestId = null;
try
{
if (this.chkReSampling.Checked == false)
{
RecievingRequestId = SamplingBLL.GetRandomSample(WarehouseId);
isMoisture = false;
}
else
{
try
{
RecievingRequestId = SamplingBLL.GetRandomReSampling(WarehouseId, out Moistureid, out TransactionId);
}
catch (Exception ex)
{
this.lblMsg.Text = ex.Message;
}
isMoisture = true;
}
}
catch (Exception ex)
{
this.lblMsg.Text = ex.Message;
return;
}
if (RecievingRequestId == null)
{
this.lblMsg.Text = "There are no records Pending Sampling";
return;
}
Nullable <int> SerialNo = null;
SamplingBLL objSample = new SamplingBLL();
SerialNo = objSample.GetSerialNo(WarehouseId);
if (SerialNo == null)
{
throw new Exception("Inavlid Serial No. exception");
}
// Create sampling obect
SamplingBLL objSampling = new SamplingBLL();
objSampling.ReceivigRequestId = (Guid)RecievingRequestId;
objSampling.SamplingStatusId = SamplingStatus.Active;
objSampling.SerialNo = SamplingBLL.GetSerial(WarehouseId);
objSampling.WarehouseId = WarehouseId;
CommodityDepositeRequestBLL objCommDep = new CommodityDepositeRequestBLL();
objCommDep = objCommDep.GetCommodityDepositeDetailById((Guid)RecievingRequestId);
if (objCommDep != null)
{
if (string.IsNullOrEmpty(objCommDep.TrackingNo) == true)
{
this.lblMsg.Text = "Can not get Tracking Number.Please try again.";
return;
}
else
{
if (isMoisture == false)
{
objSampling.TrackingNo = objCommDep.TrackingNo;
}
else
{
objSampling.TrackingNo = TransactionId;
}
}
}
else
{
throw new Exception("Unable to get Arrival Information CommDepId=" + RecievingRequestId.ToString());
}
//Create Sampler
SamplerBLL objSampler = new SamplerBLL();
try
{
objSampler.SamplerId = new Guid(this.cboSampler.SelectedValue.ToString());
}
catch
{
this.lblMsg.Text = "Please select Sampler";
return;
}
objSampler.Status = SamplerStatus.Active;
Id = objSampling.InsertSample(objSampling, objSampler, isMoisture);
if (Id != null)
{
objSampling.Id = (Guid)Id;
string tran = "";
tran = SamplingBLL.GetTransactionNumber((Guid)RecievingRequestId);
Session["Sampler"] = objSampler;
Session["Sample"] = objSampling;
ScriptManager.RegisterStartupScript(this,
this.GetType(),
"ShowReport",
"<script type=\"text/javascript\">" +
string.Format("javascript:window.open(\"ReportSampleTicket.aspx?id={0}\", \"_blank\",\"height=400px,width=600px,top=0,left=0,resizable=yes,scrollbars=yes\");", Id.ToString()) +
"</script>",
false);
}
else
{
this.lblMsg.Text = "Data can not be saved.Please 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();
}
}
protected void btnComplete_Click(object sender, EventArgs e)
{
this.lblMessage.Text = "";
Nullable <Guid> Id = null;
string TransactionNo = "";
TransactionNo = Request.QueryString["TranNo"];
if (string.IsNullOrEmpty(TransactionNo))
{
return;
}
if (Session["CommodityRequestId"] == null)
{
CommodityDepositeRequestBLL objCDR = new CommodityDepositeRequestBLL();
objCDR = objCDR.GetCommodityDepositeDetailByTrackingNo(TransactionNo);
Id = objCDR.Id;
Session["CommodityRequestId"] = Id.ToString();
}
else
{
Id = new Guid(Session["CommodityRequestId"].ToString());
}
// if the Step is in Driver Info.
//if (WFTransaction.GetMessage(TransactionNo) == "AddDriverInformation")
//{
// WFTransaction.WorkFlowManager(TransactionNo);
//}
//Check if Driver Information is Added.
List <DriverInformationBLL> listDriverInfo = null;
DriverInformationBLL objDriverInfo = new DriverInformationBLL();
if (Session["CommodityRequestId"] != null)
{
Guid CdrId = new Guid(Session["CommodityRequestId"].ToString());
listDriverInfo = objDriverInfo.GetActiveDriverInformationByReceivigRequestId(CdrId);
if (listDriverInfo == null)
{
this.btnComplete.Enabled = false;
}
else
{
if (listDriverInfo.Count <= 0)
{
this.btnComplete.Enabled = false;
}
else
{
if (Id != null)
{
ECXWF.CMessage msg = (ECXWF.CMessage)HttpContext.Current.Session["msg"];
if (msg != null)
{
if (msg.Name == "AddDriverInformation")
{
WFTransaction.WorkFlowManager(TransactionNo);
Response.Redirect("ListInbox.aspx");
}
}
}
}
}
}
}
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.";
}
}
/// <summary>
/// InsertCommodityDepositeRequest
/// </summary>
/// <param name="objCommDepoReq"></param>
/// <returns>affected No</returns>
public Guid InsertCommodityDepositeRequest(CommodityDepositeRequestBLL objCommDepoReq, SqlTransaction tran)
{
string strSql = "spInsertCommodityDepositeRequest";
SqlParameter[] arPar = new SqlParameter[14];
arPar[0] = new SqlParameter("@TransactionId", SqlDbType.NVarChar, 50);
arPar[0].Value = objCommDepoReq.TransactionId;
arPar[1] = new SqlParameter("@ClientId", SqlDbType.UniqueIdentifier);
arPar[1].Value = objCommDepoReq.ClientId;
arPar[2] = new SqlParameter("@CommodityId", SqlDbType.UniqueIdentifier);
arPar[2].Value = objCommDepoReq.CommodityId;;
arPar[3] = new SqlParameter("@WarehouseId", SqlDbType.UniqueIdentifier);
arPar[3].Value = objCommDepoReq.WarehouseId;
arPar[4] = new SqlParameter("@RepresentativeId", SqlDbType.UniqueIdentifier);
arPar[4].Value = objCommDepoReq.RepresentativeId;
arPar[5] = new SqlParameter("@WoredaId", SqlDbType.UniqueIdentifier);
if (objCommDepoReq.WoredaId != Guid.Empty)
{
arPar[5].Value = objCommDepoReq.WoredaId;
}
else
{
arPar[5].Value = null;
}
arPar[6] = new SqlParameter("@productionYear", SqlDbType.Int);
if (objCommDepoReq.ProductionYear != 0)
{
arPar[6].Value = objCommDepoReq.ProductionYear;
}
else
{
arPar[6].Value = null;
}
arPar[7] = new SqlParameter("@Status", SqlDbType.Int);
arPar[7].Value = objCommDepoReq.Status;
arPar[8] = new SqlParameter("@CreatedBy", SqlDbType.UniqueIdentifier);
arPar[8].Value = objCommDepoReq.CreatedBy;
arPar[9] = new SqlParameter("@Remark", SqlDbType.Text);
arPar[9].Value = objCommDepoReq.Remark;
arPar[10] = new SqlParameter("@Weight", SqlDbType.Decimal);
arPar[10].Value = objCommDepoReq.Weight;
arPar[11] = new SqlParameter("@NumberofBags", SqlDbType.Int);
arPar[11].Value = objCommDepoReq.NumberofBags;
arPar[12] = new SqlParameter("@DateTimeRecived", SqlDbType.DateTime);
arPar[12].Value = objCommDepoReq.DateTimeRecived;
int AffectedRows;
arPar[13] = new SqlParameter("@CommodityDepositRequestId", SqlDbType.UniqueIdentifier);
arPar[13].Direction = ParameterDirection.Output;
try
{
AffectedRows = SqlHelper.ExecuteNonQuery(tran, CommandType.StoredProcedure, strSql, arPar);
}
catch (Exception ex)
{
throw new Exception("Can not update the database.", ex);
}
Guid CommodityDepositRequestId = new Guid();
CommodityDepositRequestId = (Guid)arPar[13].Value;
return(CommodityDepositRequestId);
}
private void LoadData(Guid Id)
{
//get The Id from the qs
//Get the Commodity deposite Request form.
CommodityDepositeRequestBLL objEdit = new CommodityDepositeRequestBLL();
CommodityDepositRequest objCommDepReq = new CommodityDepositRequest();
DataSet dsResult = new DataSet();
objEdit.Id = Id;
dsResult = objCommDepReq.getCommodityDepositRequestById(Id);
Guid ClientGuid = new Guid(dsResult.Tables[0].Rows[0]["ClientId"].ToString());
objEdit.ClientId = ClientGuid;
this.hfClientId.Value = ClientGuid.ToString();
this.txtNumberOfBags.Text = dsResult.Tables[0].Rows[0]["NumberofBags"].ToString();
objEdit.NumberofBags = int.Parse((dsResult.Tables[0].Rows[0]["NumberofBags"].ToString()));
float weight = float.Parse(dsResult.Tables[0].Rows[0]["Weight"].ToString());
if (weight == 0)
{
this.txtWeight.Text = "";
}
else
{
this.txtWeight.Text = dsResult.Tables[0].Rows[0]["Weight"].ToString();
}
objEdit.Weight = float.Parse(dsResult.Tables[0].Rows[0]["Weight"].ToString());
this.txtRemark.Text = dsResult.Tables[0].Rows[0]["Remark"].ToString();
objEdit.Remark = this.txtRemark.Text;
this.dtDateTimeRecived.Text = Convert.ToDateTime(dsResult.Tables[0].Rows[0]["DateTimeRecived"]).ToShortDateString();
this.txtTimeArrival.Text = Convert.ToDateTime(dsResult.Tables[0].Rows[0]["DateTimeRecived"]).ToLongTimeString();
objEdit.DateTimeRecived = Convert.ToDateTime((dsResult.Tables[0].Rows[0]["DateTimeRecived"]).ToString());
this.cboReprsentative.SelectedValue = dsResult.Tables[0].Rows[0]["RepresentativeId"].ToString();
objEdit.RepresentativeId = Guid.Empty;
if (dsResult.Tables[0].Rows[0]["WoredaId"] != DBNull.Value)
{
this.cboWoreda.SelectedValue = dsResult.Tables[0].Rows[0]["WoredaId"].ToString();
objEdit.WoredaId = new Guid(dsResult.Tables[0].Rows[0]["WoredaId"].ToString());
}
this.cboStatus.SelectedValue = dsResult.Tables[0].Rows[0]["Status"].ToString();
objEdit.Status = int.Parse(dsResult.Tables[0].Rows[0]["Status"].ToString());
//if (Convert.ToInt32((this.cboStatus.SelectedValue)) == 0 )
//{
// //this.btnEdit.Enabled = false;
//}
// Display the Client Id from this
// Id = dsResult.Tables[0].Rows[0]["ClientId"].ToString();
ECXLookUp.ECXLookup objLookUp = new WarehouseApplication.ECXLookUp.ECXLookup();
//Populate Drop down from server cboCommodity
this.cboCommodity.AppendDataBoundItems = true;
ECXLookUp.CCommodity[] objCommodity = objLookUp.GetActiveCommodities(WarehouseApplicationConfiguration.GetWorkingLanguage());
this.cboCommodity.DataSource = objCommodity;
this.cboCommodity.DataTextField = "Name";
this.cboCommodity.DataValueField = "UniqueIdentifier";
this.cboCommodity.DataBind();
this.cboCommodity.SelectedValue = dsResult.Tables[0].Rows[0]["CommodityId"].ToString();
objEdit.CommodityId = new Guid(dsResult.Tables[0].Rows[0]["CommodityId"].ToString());
//Populate Region
//ECXLookUp.CRegion[] objRegion = objLookUp.GetActiveRegions(WarehouseApplicationConfiguration.GetWorkingLanguage());
//this.cboRegion.DataSource = objRegion;
//this.cboRegion.DataTextField = "Name";
//this.cboRegion.DataValueField = "UniqueIdentifier";
//this.cboRegion.DataBind();
string SelectedWoreda = "";
SelectedWoreda = dsResult.Tables[0].Rows[0]["WoredaId"].ToString();
if (SelectedWoreda != "")
{
ECXLookUp.CWoreda objWoreda = objLookUp.GetWoreda(WarehouseApplicationConfiguration.GetWorkingLanguage(), new Guid(SelectedWoreda));
Guid SelectedZone = new Guid(objWoreda.ZoneUniqueIdentifier.ToString());
ECXLookUp.CZone objZoneSelected = objLookUp.GetZone(WarehouseApplicationConfiguration.GetWorkingLanguage(), SelectedZone);
Guid SelectedRegion = new Guid(objZoneSelected.RegionUniqueIdentifier.ToString());
this.cboRegion_CascadingDropDown.SelectedValue = SelectedRegion.ToString();
this.cboZone_CascadingDropDown.SelectedValue = SelectedZone.ToString();
this.cboWoreda_CascadingDropDown.SelectedValue = SelectedWoreda;
}
// Bind Clinet
ClientBLL objClient = new ClientBLL();
objClient = ClientBLL.GetClinet(ClientGuid);
if (objClient != null)
{
this.txtClient.Text = objClient.ClientName + " - " + objClient.ClientId;
this.txtClient.Enabled = false;
}
//Populate the Production Year
// set because we will not have Production year no latter than 2007
string strSelectedYear = dsResult.Tables[0].Rows[0]["ProductionYear"].ToString();
int currYear = int.Parse(ConfigurationSettings.AppSettings["CurrentEthiopianYear"]);
this.cboProductionYear.Items.Add(new ListItem("Please Select Production Year.", ""));
this.cboProductionYear.AppendDataBoundItems = true;
if (strSelectedYear != "")
{
if (int.Parse(strSelectedYear) < currYear - 2)
{
this.cboProductionYear.Items.Add(new ListItem(strSelectedYear, strSelectedYear));
}
}
for (int i = currYear - 2; i <= currYear; i++)
{
this.cboProductionYear.Items.Add(new ListItem(i.ToString(), i.ToString()));
}
this.cboProductionYear.SelectedValue = dsResult.Tables[0].Rows[0]["ProductionYear"].ToString();
if (dsResult.Tables[0].Rows[0]["ProductionYear"] != DBNull.Value)
{
objEdit.ProductionYear = int.Parse(dsResult.Tables[0].Rows[0]["ProductionYear"].ToString());
}
ViewState["CommDepOld"] = objEdit;
}
protected void btnSave_Click(object sender, EventArgs e)
{
this.lblMessage.Text = "";
if (this.btnSave.Text == "Save")
{
string TransactionNo = "";
Guid TransactionTypeId = Guid.Empty;
Guid CommodityGuid = Guid.Empty;
Guid ClientId, CommodityId, WarehouseId, CreatedBY;
Guid RepId, WoredaId;
DateTime DateTimeRecived;
float Weight;
int Year, NumberOfBags;
string Remark, TransactionId;
int Status; // Status - 1= new
Nullable <Guid> Id;
//NoClient
ClientId = new Guid(this.ClientSelector1.ClientGUID.Value.ToString());
try
{
ClientId = new Guid(this.ClientSelector1.ClientGUID.Value.ToString());
}
catch
{
this.lblMessage.Text = "Please Select Client";
return;
}
//NoClient
//Check if ClientId is Empty.
if (ClientId != Guid.Empty)
{
if (!(string.IsNullOrEmpty(this.cboCommodity.SelectedValue)))
{
CommodityGuid = new Guid(this.cboCommodity.SelectedValue);
try
{
TransactionTypeId = TransactionTypeProvider.GetTransactionTypeId(CommodityGuid);
}
catch (InvalidTransactionType ex)
{
this.lblMessage.Text = ex.msg;
return;
}
}
else
{
TransactionTypeId = TransactionTypeProvider.GetTransactionTypeId("RegularGrainTypeId");
}
}
else
{
TransactionTypeId = TransactionTypeProvider.GetTransactionTypeId(Guid.Empty);
}
Status = 1;// Approved Status
try
{
CommodityId = new Guid(this.cboCommodity.SelectedValue.ToString());
}
catch
{
this.lblMessage.Text = "Please Select Commodity";
return;
}
try
{
WarehouseId = new Guid(this.cboWarehouse.SelectedValue.ToString());// Should be Non selectable.
}
catch
{
this.lblMessage.Text = "Please Select Warehouse";
return;
}
try
{
WoredaId = new Guid(this.cboWoreda.SelectedValue.ToString());
}
catch
{
WoredaId = Guid.Empty;
}
try
{
Year = Convert.ToInt32(this.cboProductionYear.SelectedValue.ToString());
}
catch
{
Year = 0;
}
Remark = this.txtRemark.Text;
float.TryParse(this.txtWeight.Text, out Weight);
int.TryParse(this.txtNumberOfBags.Text, out NumberOfBags);
try
{
DateTimeRecived = Convert.ToDateTime(this.txtArrivalDate.Text + " " + this.txtTimeArrival.Text);
}
catch
{
this.lblMessage.Text = "Please enter the correct date time format.";
return;
}
// get from Workflow
TransactionId = TransactionNo;//WFTransaction.GetTransaction();
CreatedBY = UserBLL.GetCurrentUser();
//TO DO Remove this.
RepId = new Guid();
CommodityDepositeRequestBLL objSave = new CommodityDepositeRequestBLL();
objSave.ClientId = ClientId;
objSave.CommodityId = CommodityId;
objSave.WarehouseId = WarehouseId;
objSave.RepresentativeId = RepId;
objSave.WoredaId = WoredaId;
objSave.ProductionYear = Year;
objSave.NumberofBags = NumberOfBags;
objSave.DateTimeRecived = DateTimeRecived;
objSave.Weight = Weight;
objSave.Remark = Remark;
objSave.Status = Status;
objSave.CreatedBy = CreatedBY;
Id = objSave.AddCommodityDepositRequest(TransactionTypeId);
if (Id != null)
{
Session["CommodityRequestId"] = Id.ToString();
this.btnSave.CausesValidation = false;
this.lblMessage.Text = "Data Added Sucessfully.";
this.btnSave.Text = "Next";
//StringBuilder sb = new StringBuilder();
//sb.Append("<script>");
//sb.Append("window.open('ReportTrackingNumber.aspx");
//sb.Append("', '', '');");
//sb.Append("location.href='ListInbox.aspx';");
//sb.Append("</scri");
//sb.Append("pt>");
////Page.ClientScript.RegisterStartupScript(GetType(), "js", sb.ToString());
//ScriptManager.RegisterStartupScript(this, typeof(Page), "win", sb.ToString(), false);
//return;
////Response.Redirect("~/PageSwicther.aspx?TranNo=" + TransactionNo);
ScriptManager.RegisterStartupScript(this,
this.GetType(),
"ShowReport",
"<script type=\"text/javascript\">" +
string.Format("javascript:window.open(\"ReportTrackingNumber.aspx?id={0}\", \"_blank\",\"height=400px,width=600px,top=0,left=0,resizable=yes,scrollbars=yes\");", Guid.NewGuid()) +
"</script>",
false);
}
else
{
this.lblMessage.Text = "Error Saving Request!";
}
}
else
{
string trackingNo = Session["TransactionNo"].ToString();
Session["TransactionNo"] = null;
Response.Redirect("ListInbox.aspx");
}
}