public CommodityDepositeRequestBLL GetCommodityDepositeDetailByTrackingNo(string TrackingNo) { CommodityDepositRequest objCommDepReq = new CommodityDepositRequest(); DataSet dsResult = new DataSet(); dsResult = objCommDepReq.getCommodityDepositRequestByTrackingNo(TrackingNo); if (dsResult.Tables[0].Rows.Count > 0) { CommodityDepositeRequestBLL obj = new CommodityDepositeRequestBLL(); obj.Id = new Guid(dsResult.Tables[0].Rows[0]["Id"].ToString()); obj.ClientId = new Guid(dsResult.Tables[0].Rows[0]["ClientId"].ToString()); if (dsResult.Tables[0].Rows[0]["ProductionYear"] != DBNull.Value) { obj.ProductionYear = Convert.ToInt32(dsResult.Tables[0].Rows[0]["ProductionYear"].ToString()); } obj.DateTimeRecived = Convert.ToDateTime(dsResult.Tables[0].Rows[0]["DateTimeRecived"].ToString()); obj.TrackingNo = dsResult.Tables[0].Rows[0]["TransactionId"].ToString(); obj.WarehouseId = new Guid(dsResult.Tables[0].Rows[0]["WarehouseId"].ToString()); obj.CommodityId = new Guid(dsResult.Tables[0].Rows[0]["CommodityId"].ToString()); return(obj); } else { return(null); } }
/// <summary> /// Search Commodity deposite by TransqactionId /// </summary> /// <param name="trackingNo">The Transaction Id assiged and used by Traking no.</param> /// <returns></returns> public 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>(); list = CommodityDepositRequest.SearchCommodityDeposite(trackingNo, VoucherNo, Clientid, CommodityId, from, to); if (list != null) { List <CommodityDepositeRequestBLL> listMerged = new List <CommodityDepositeRequestBLL>(); for (int x = 0; x < list.Count; x++) { list[x].ClientName = ClientBLL.GetClinetNameById(list[x].ClientId); list[x].CommodityName = CommodityGradeBLL.GetCommodityById(list[x].CommodityId).Commodity; } return(list); } else { return(null); } }
/// <summary> /// A Method to insert Commodity Deposite request. /// </summary> /// <param name="transactionId"></param> /// <param name="clientId"></param> /// <param name="commodityId"></param> /// <param name="warehouseId"></param> /// <param name="reprsentativeId"></param> /// <param name="woredaId"></param> /// <param name="productionYear"></param> /// <param name="NumberOfBags"></param> /// <param name="dateTimeRecived"></param> /// <param name="weight"></param> /// <param name="remark"></param> /// <param name="status">Status of the CDR , 1- Apporved 0, Cancelled</param> /// <param name="createdBy">The user who created the Record </param> /// <returns>if Sucessfull returns True.</returns> public Nullable <Guid> AddCommodityDepositRequest(Guid TransactionTypeId) { // validate // 0-not saved Nullable <Guid> Id = null; SqlTransaction tran; SqlConnection conn = Connection.getConnection(); tran = conn.BeginTransaction(); CommodityDepositRequest ObjCommDepositeRequest = new CommodityDepositRequest(); string TransactionNo = String.Empty; int auditTrailStatus = -1; try { TransactionNo = WFTransaction.GetTransaction(TransactionTypeId, tran); if (string.IsNullOrEmpty(TransactionNo)) { throw new Exception("Unbale to Get Tracking No for Transaction Type " + TransactionTypeId); } this.TransactionId = TransactionNo; Id = ObjCommDepositeRequest.InsertCommodityDepositeRequest(this, tran); this.Id = (Guid)Id; if (Id != null) { AuditTrailBLL objAt = new AuditTrailBLL(); auditTrailStatus = objAt.saveAuditTrail(this, WFStepsName.AddArrival.ToString(), UserBLL.GetCurrentUser(), "Insert Arrival"); if (auditTrailStatus == -1) { if (TransactionNo != "") { WFTransaction.Remove(TransactionNo); } return(null); } else { HttpContext.Current.Session["TransactionNo"] = TransactionNo; tran.Commit(); return(Id); } } else { if (TransactionNo != "") { WFTransaction.Remove(TransactionNo); } tran.Rollback(); } } catch (Exception ex) { if (TransactionNo != "") { WFTransaction.Remove(TransactionNo); } tran.Rollback(); throw new Exception("TransactionNo -" + TransactionNo + "TransactionTypeId " + TransactionTypeId, ex); } finally { conn.Close(); tran.Dispose(); } return(Id); }
public bool EditCommodityDepositRequest(Guid ClientId, Guid commodityDepositRequestId, Guid commodityId, Guid representativeId, int productionYear, Guid woreda, float weight, int numberofBags, DateTime dateTimeRecived, string remark, int status, Guid lastModifiedBy, CommodityDepositeRequestBLL OldObject ) { int isSaved = 0; #region Validations //if (CommodityDepositRequestId == null) //{ // throw new Exception("Invalid Commodity Deposit Request Id"); //} //if (commodityId == null ) //{ // throw new Exception("Invalid Commodity Id"); //} //if (representativeId == null) //{ // throw new Exception("Invalid Representative Id"); //} //if (woreda == null) //{ // throw new Exception("Invalid Woreda"); //} //if (dateTimeRecived == null) //{ // throw new Exception("Invalid Date Time Recived"); //} //if (remark == null || remark == "") //{ // throw new Exception("Invalid Remark"); //} //if (status == null || status == "") //{ // throw new Exception("Invalid status"); //} //if (lastModifiedBy == null ) //{ // throw new Exception("Invalid last Modified by"); //} #endregion // has GRN on Rdit mood bool canBeEdited = false; canBeEdited = CommodityDepositeRequestBLL.isGRNEditable(commodityDepositRequestId); if (canBeEdited == false) { throw new GRNNotOnUpdateStatus("A GRN has already been created for this Deposit request, please request GRN the manger to edit this GRN."); } CommodityDepositeRequestBLL objEdit = new CommodityDepositeRequestBLL(); //NoClient objEdit = objEdit.GetCommodityDepositeDetailById(commodityDepositRequestId); string trNo = objEdit.TrackingNo; objEdit.Id = commodityDepositRequestId; objEdit.CommodityId = commodityId; objEdit.RepresentativeId = representativeId; objEdit.ProductionYear = productionYear; objEdit.WoredaId = woreda; objEdit.Weight = weight; objEdit.NumberofBags = numberofBags; objEdit.DateTimeRecived = dateTimeRecived; objEdit.Remark = remark; objEdit.Status = status; objEdit.LastModifiedBy = lastModifiedBy; objEdit.ClientId = ClientId; bool returnstatus = false; int atStatus = 0; SqlTransaction tran; SqlConnection conn = Connection.getConnection(); tran = conn.BeginTransaction(); try { isSaved = CommodityDepositRequest.UpdateCommodityDepositeRequest(objEdit, tran); if (isSaved == 0) { returnstatus = false; } else { //NoClient if (WFTransaction.GetMessage(trNo) == "UpdateClientNo") { if (objEdit.ClientId != Guid.Empty) { WFTransaction.UnlockTask(trNo); WarehouseApplication.ECXWF.CMessage msg = WFTransaction.Request(trNo); WFTransaction.WorkFlowManager(trNo, msg); } } AuditTrailBLL objAT = new AuditTrailBLL(); atStatus = objAT.saveAuditTrail(OldObject, objEdit, WFStepsName.ArrivalUpdate.ToString(), UserBLL.GetCurrentUser(), "Update Arrival"); if (atStatus == 1) { returnstatus = true; tran.Commit(); } } } catch { tran.Rollback(); } finally { tran.Dispose(); conn.Close(); } return(returnstatus); }
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; }