/// <summary> /// if a total value exists for a Commodity grade it will update else it will create a new one /// </summary> /// <returns></returns> public bool Update(CommodityGradeTotalValueBLL oldObject) { SqlTransaction tran = null; SqlConnection conn = Connection.getConnection(); bool isSaved = false; try { tran = conn.BeginTransaction(); if (CommodityGradeTotalValueDAL.Update(this, tran) == true) { // take audit trail int at = -1; AuditTrailBLL objAt = new AuditTrailBLL(); if (oldObject != null) { at = objAt.saveAuditTrail(oldObject, this, WFStepsName.CommodityGradeTotalValue.ToString(), UserBLL.GetCurrentUser(), "Update CGTV"); } else { at = objAt.saveAuditTrail(this, WFStepsName.CommodityGradeTotalValue.ToString(), UserBLL.GetCurrentUser(), "Add CGTV"); } if (at == 1) { tran.Commit(); return(true); } else { tran.Rollback(); return(false); } } else { return(isSaved); } } catch (Exception ex) { tran.Rollback(); throw ex; } finally { if (tran != null) { tran.Dispose(); } if (conn != null && conn.State == ConnectionState.Open) { conn.Close(); } } return(false); }
public bool Add(SqlTransaction tran) { int at = -1; AuditTrailBLL objAt = new AuditTrailBLL(); try { if (StackUnloadedDAL.InsertStackUnloaded(this, tran) == true) { at = objAt.saveAuditTrail(this, WFStepsName.AddUnloadingInfo.ToString(), UserBLL.GetCurrentUser(), "Add statck Unloaded"); if (at == 1) { return(true); } } else { return(false); } } catch (Exception ex) { throw ex; } return(false); }
public bool Save(SqlTransaction tran) { bool isSaved = false; try { isSaved = TrucksMissingOnSamplingDAL.Insert(this, tran); if (isSaved == true) { int at = -1; AuditTrailBLL objAt = new AuditTrailBLL(); at = objAt.saveAuditTrail(this, WFStepsName.ConfirmTrucksForsamp.ToString(), UserBLL.GetCurrentUser(), "Missing On Confirmation"); if (at != 1) { isSaved = false; } } } catch (Exception ex) { throw ex; } return(isSaved); }
public bool Update() { bool issaved = false; SqlTransaction tran = null;; SqlConnection conn = null; conn = Connection.getConnection(); UnloadingBLL objOld = new UnloadingBLL(); objOld = objOld.GetById(this.Id); if (objOld == null) { throw new Exception("Null Old Value Exception"); } try { conn = Connection.getConnection(); tran = conn.BeginTransaction(); if (UnloadingDAL.UpdateUnloading(this, tran) == true) { int at = -1; AuditTrailBLL objAt = new AuditTrailBLL(); at = objAt.saveAuditTrail(objOld, this, WFStepsName.EditUnloading.ToString(), UserBLL.GetCurrentUser(), "Edit Unloading"); if (at == 1) { tran.Commit(); issaved = true; } else { tran.Rollback(); issaved = false; } } else { tran.Rollback(); issaved = false; } } catch { tran.Rollback(); throw new Exception("Unable to Update the record."); } finally { if (tran != null) { tran.Dispose(); } if (conn.State == ConnectionState.Open) { conn.Dispose(); } } return(issaved); }
public bool Add() { bool isSaved = false; SqlConnection conn = new SqlConnection(); SqlTransaction tran; conn = Connection.getConnection(); tran = conn.BeginTransaction(); try { string TrackingNo = ""; TrackingNo = WFTransaction.GetTransaction("WHEditAppGRN", tran); this.TrackingNo = TrackingNo; this.Id = Guid.NewGuid(); isSaved = RequestforEditGRNDAL.save(tran, this); if (isSaved == true) { int At = -1; AuditTrailBLL objAt = new AuditTrailBLL(); At = objAt.saveAuditTrail(this, WFStepsName.RequestforEditGRN.ToString(), UserBLL.GetCurrentUser(), "Add Approved GRN Edit"); if (At == 1) { tran.Commit(); } else { tran.Rollback(); } } else { if (TrackingNo != "") { WFTransaction.Close(TrackingNo); } tran.Rollback(); } } catch (Exception ex) { tran.Rollback(); throw new Exception("Unable to Add New record", ex); } finally { tran.Dispose(); if (conn.State == ConnectionState.Open) { conn.Close(); } conn.Dispose(); } return(isSaved); }
public Boolean Update() { // TODO : Check Sampling is Completed - check if Code is generated. int count = 0; bool isSaved = false; SqlTransaction tran = null; SqlConnection conn = null; SamplingResultBLL objSamplingResultold = new SamplingResultBLL(); objSamplingResultold = objSamplingResultold.GetSamplingResultById(this.Id); if (objSamplingResultold == null) { throw new Exception("Null Old Value Exception"); } try { conn = Connection.getConnection(); tran = conn.BeginTransaction(); count = SamplingResultDAL.GetNumberofSupervisorResults(this.Id); if (count > 0) { throw new Exception("A supervisor result with new or Approved already exists."); } else { isSaved = SamplingResultDAL.UpdateSamplingResult(this, tran); if (isSaved == true) { int at = -1; AuditTrailBLL objat = new AuditTrailBLL(); objat.saveAuditTrail(objSamplingResultold, this, WFStepsName.EditSamplingResult.ToString(), UserBLL.GetCurrentUser(), "Edit Sampling Result"); if (at == 1) { tran.Commit(); } else { isSaved = false; tran.Rollback(); } } return(isSaved); } } catch (Exception ex) { tran.Rollback(); throw ex; } finally { tran.Dispose(); conn.Close(); } }
public bool Add() { bool issaved = false; SqlTransaction tran = null; SqlConnection conn = null; try { this.Id = Guid.NewGuid(); conn = Connection.getConnection(); tran = conn.BeginTransaction(); issaved = StackDAL.InsertStack(this, tran); if (issaved == true) { int at = -1; AuditTrailBLL objAt = new AuditTrailBLL(); at = objAt.saveAuditTrail(this, WFStepsName.Stack.ToString(), UserBLL.GetCurrentUser(), "Add Stack"); if (at == 1) { tran.Commit(); issaved = true; } else { tran.Rollback(); issaved = false; } } else { tran.Rollback(); issaved = false; } } catch (Exception ex) { tran.Rollback(); issaved = false; throw ex; } finally { if (tran != null) { tran.Dispose(); } if (conn.State == ConnectionState.Open) { conn.Close(); } } return(issaved); }
public bool Save(List <GradingFactorGroupDetailBLL> list) { bool issaved = false; SqlTransaction tran = null; SqlConnection conn = null; int At = -1; try { conn = Connection.getConnection(); tran = conn.BeginTransaction(); this.Id = Guid.NewGuid(); this.CreatedBy = UserBLL.GetCurrentUser(); issaved = GradingFactorGroupDAL.Save(this, tran); if (issaved == true) { issaved = false; GradingFactorGroupDetailBLL objGFD = new GradingFactorGroupDetailBLL(); issaved = objGFD.save(list, tran, this.Id); AuditTrailBLL objAt = new AuditTrailBLL(); At = objAt.saveAuditTrail(this, WFStepsName.GradingFactorGroupAd.ToString(), UserBLL.GetCurrentUser(), "Add Grading Factor Group "); if (At == 1) { tran.Commit(); } else { tran.Rollback(); } } else { tran.Rollback(); } } catch (Exception ex) { tran.Rollback(); throw ex; } finally { if (tran != null) { tran.Dispose(); } if (conn.State == ConnectionState.Open) { conn.Close(); } } return(issaved); }
public bool UpdateStatus() { bool isSaved = false; SqlTransaction tran = null; SqlConnection conn = null; int at = -1; try { TrucksMissingOnSamplingBLL objNew = new TrucksMissingOnSamplingBLL(); TrucksMissingOnSamplingBLL objOld = TrucksMissingOnSamplingDAL.GetById(this.Id); objNew = objOld.Copy(objOld); objNew.Id = this.Id; objNew.Status = this.Status; conn = Connection.getConnection(); tran = conn.BeginTransaction(); isSaved = TrucksMissingOnSamplingDAL.SetStatus(objNew.Id, objNew.Status, tran); if (isSaved == true) { AuditTrailBLL objAt = new AuditTrailBLL(); at = objAt.saveAuditTrail(objNew, objOld, WFStepsName.TrucksMissingForSamp.ToString(), UserBLL.GetCurrentUser(), "Update Status Missing Traucks"); if (at == 1) { tran.Commit(); } else { tran.Rollback(); isSaved = false; } } else { isSaved = false; } } catch (Exception ex) { throw ex; } finally { if (tran != null) { tran.Dispose(); } if (conn.State == ConnectionState.Open) { conn.Close(); } } return(isSaved); }
public bool EditDriverInformation(DriverInformationBLL objEdit) { //check if it has a GRN not in Edit mood. if (isGRNEditable(this.ReceivigRequestId) == false) { throw new GRNNotOnUpdateStatus(" This Information can't up updated because the GRN is not on Edit status"); } bool isSaved = false; SqlTransaction tran; SqlConnection Conn = Connection.getConnection(); tran = Conn.BeginTransaction(); int AtStatus = -1; try { DriverInformation objDriverInfoDAL = new DriverInformation(); isSaved = objDriverInfoDAL.UpdateDriverInformation(this, tran); if (isSaved == true) { string AppMode = WFStepsName.EditDriverInfo.ToString(); AuditTrailBLL objAt = new AuditTrailBLL(); AtStatus = objAt.saveAuditTrail(this, objEdit, AppMode, UserBLL.GetCurrentUser(), "DriverInformationUpdate"); if (AtStatus == 1 || AtStatus == 0) { tran.Commit(); } else { tran.Rollback(); } } } catch (Exception ex) { tran.Rollback(); ErrorLogger.Log(ex); return(false); } if (AtStatus == 1 || AtStatus == 0) { return(true); } else { return(false); } }
public bool Update() { bool isSaved = false; SqlConnection conn = null; SqlTransaction tran = null; RequestforApprovedGRNCancelationBLL objEdit = new RequestforApprovedGRNCancelationBLL(); objEdit = objEdit.GetById(Id); try { conn = Connection.getConnection(); tran = conn.BeginTransaction(); isSaved = RequestforApprovedGRNCancelationDAL.Update(tran, this); if (isSaved == true) { string AppMode = Utility.GetApplicationName() + " - AppGRNCancel"; AuditTrailBLL objAT = new AuditTrailBLL(); if (objAT.saveAuditTrail(objEdit, this, AppMode, UserBLL.GetCurrentUser(), "Update-ApprovedGRNCancelRequest") == 1) { tran.Commit(); } else { tran.Rollback(); return(false); } } else { tran.Rollback(); return(false); } } catch (Exception ex) { tran.Rollback(); throw new Exception("Unable to update Data.", ex); } finally { if (conn.State == ConnectionState.Open) { conn.Close(); } if (tran != null) { tran.Dispose(); } } return(isSaved); }
public bool Update() { bool isSaved = false; SqlConnection conn = null; SqlTransaction tran = null; ScalingBLL objScaling = new ScalingBLL(); objScaling = objScaling.GetById(this.Id); if (objScaling == null) { throw new Exception("Null Old Value Exception"); } try { conn = Connection.getConnection(); tran = conn.BeginTransaction(); isSaved = ScalingDAL.Update(this, tran); if (isSaved == true) { int at = -1; AuditTrailBLL objat = new AuditTrailBLL(); at = objat.saveAuditTrail(objScaling, this, WFStepsName.EditScaling.ToString(), UserBLL.GetCurrentUser(), "Update Scaling Information"); if (at == 1) { tran.Commit(); } else { isSaved = false; tran.Rollback(); } } } catch (Exception ex) { throw new Exception("An Error has ccured please try again. If the error persists Contact the Administrator", ex); } finally { if (tran != null) { tran.Dispose(); } if (conn.State == ConnectionState.Open) { conn.Close(); } } return(isSaved); }
public bool Update(SqlTransaction tran) { bool isSaved = false; try { // old object StackUnloadedBLL oldobj = new StackUnloadedBLL(); oldobj = oldobj.GetById(this.Id); AuditTrailBLL objAt = new AuditTrailBLL(); int at = -1; if (oldobj.Status == this.Status) { return(true); } if (oldobj.Status == StackUnloadedStatus.New && this.Status == StackUnloadedStatus.Cancelled) { UpdateInventory(this.StackId, (-1 * this.NumberOfbags), 0, tran); } else if (oldobj.Status == StackUnloadedStatus.New && this.Status == StackUnloadedStatus.Cancelled) { UpdateInventory(this.StackId, this.NumberOfbags, 0, tran); } isSaved = StackUnloadedDAL.UpdateStackUnloaded(this, tran); if (isSaved == true) { at = objAt.saveAuditTrail(oldobj, this, WFStepsName.EditUnloading.ToString(), UserBLL.GetCurrentUser(), "Edit Unloading"); if (at == 1) { isSaved = true; } else { isSaved = false; } } else { isSaved = false; } } catch (Exception ex) { throw ex; } return(isSaved); }
public bool Save() { bool isSaved = false; SqlTransaction tran = null; SqlConnection conn = null; try { conn = Connection.getConnection(); tran = conn.BeginTransaction(); isSaved = CommodityGradingFactorDAL.Save(this, tran); if (isSaved == true) { isSaved = false; AuditTrailBLL objAt = new AuditTrailBLL(); int at = -1; at = objAt.saveAuditTrail(this, WFStepsName.CommmodityGradingFactor.ToString(), UserBLL.GetCurrentUser(), " Add Comm. Grading Factors "); if (at == 1) { isSaved = true; } } if (isSaved == true) { tran.Commit(); } else { tran.Rollback(); } return(isSaved); } catch (Exception ex) { tran.Rollback(); throw ex; } finally { if (tran != null) { tran.Dispose(); } if (conn.State == ConnectionState.Open) { conn.Close(); } } }
public bool Edit(GradingDisputeBLL objOld) { bool isSaved = false; SqlConnection conn; SqlTransaction tran; conn = Connection.getConnection(); tran = conn.BeginTransaction(); try { isSaved = GradingDisputeDAL.UpdateGradingDisputeBLL(this, tran); if (isSaved == true) { //Update the WF step after cheking the status is set to approved. if (this.Status == 2) { WFTransaction.WorkFlowManager(this.TrackingNo); HttpContext.Current.Session["EditGradeDisputeTranNo"] = this.TrackingNo; } else if (this.Status == 3) { HttpContext.Current.Session["EditGradeDisputeTranNo"] = this.TrackingNo; } AuditTrailBLL ATobj = new AuditTrailBLL(); ATobj.saveAuditTrail(objOld, this, WFStepsName.EditGradeDispute.ToString(), UserBLL.GetCurrentUser(), "Edit Grade Dispute"); tran.Commit(); tran.Dispose(); conn.Close(); return(true); } else { tran.Rollback(); tran.Dispose(); conn.Close(); return(false); } } catch (Exception ex) { tran.Rollback(); tran.Dispose(); conn.Close(); throw ex; } }
public bool Add( ) { SqlTransaction tran; SqlConnection conn = new SqlConnection(); conn = Connection.getConnection(); tran = conn.BeginTransaction(); int at = -1; AuditTrailBLL objAt = new AuditTrailBLL(); try { conn = Connection.getConnection(); if (StackUnloadedDAL.InsertStackUnloaded(this, tran) == true) { at = objAt.saveAuditTrail(this, WFStepsName.AddUnloadingInfo.ToString(), UserBLL.GetCurrentUser(), "Add statck Unloaded"); if (at == 1) { tran.Commit(); tran.Dispose(); conn.Close(); return(true); } } else { tran.Rollback(); tran.Dispose(); return(false); } } catch { tran.Rollback(); tran.Dispose(); if (at == 1) { objAt.RoleBack(); } return(false); } return(false); }
public bool SaveNew() { bool isSaved = false; this.CreatedBy = UserBLL.GetCurrentUser(); if ((string.IsNullOrEmpty(this.TruckPlateNo) != true) && (string.IsNullOrEmpty(this.TrailerPlateNo) == true)) { this.hasTrailer = TruckHasTrailerType.TruckOnly; } else if ((string.IsNullOrEmpty(this.TruckPlateNo) == true) && (string.IsNullOrEmpty(this.TrailerPlateNo) != true)) { this.hasTrailer = TruckHasTrailerType.TrailerOnly; } else if ((string.IsNullOrEmpty(this.TruckPlateNo) != true) && (string.IsNullOrEmpty(this.TrailerPlateNo) != true)) { this.hasTrailer = TruckHasTrailerType.TruckTrailer; } else if ((string.IsNullOrEmpty(this.TruckPlateNo) == true) && (string.IsNullOrEmpty(this.TrailerPlateNo) == true)) { throw new Exception("Truck Plate No. And Trailer Plate No. Are Both Empty"); } this.Status = TruckWeightStatus.Active; //THE FOLLOWING METHOD ADDED BY SINISHAW isSaved = TruckWeightDAL.InsertNew(this); AuditTrailBLL objAt = new AuditTrailBLL(); int at = -1; if (isSaved == true) { at = objAt.saveAuditTrail(this, WFStepsName.RegisterTruckWeight.ToString(), UserBLL.GetCurrentUser(), "Scaling Information"); if (at == 1) { isSaved = true; } else { isSaved = false; } } return(isSaved); }
public bool Update(GradingFactorBLL oldGF) { bool isSaved = false; SqlTransaction tran = null; SqlConnection conn = null; try { conn = Connection.getConnection(); tran = conn.BeginTransaction(); isSaved = GradingFactorDAL.Update(this, tran); int At = -1; if (isSaved == true) { AuditTrailBLL objAT = new AuditTrailBLL(); At = objAT.saveAuditTrail(this, oldGF, WFStepsName.GradingFactorUpdate.ToString(), UserBLL.GetCurrentUser(), "Update Grading Factor"); } if (At == 1) { tran.Commit(); return(true); } else { tran.Rollback(); return(false); } } catch (Exception ex) { tran.Rollback(); throw new Exception("Unable to saved reocrd", ex); } finally { tran.Dispose(); if (conn.State == ConnectionState.Open) { conn.Close(); } } }
public bool UpdateEach(Guid Id, string Value) { //get the old SqlTransaction tran; SqlConnection conn = Connection.getConnection(); bool isSaved = false; GradingResultDetailBLL objOld = GradingResultDetailDAL.GetGradingResultDetailById(Id); GradingResultDetailBLL objNew = objOld; objNew.RecivedValue = Value; tran = conn.BeginTransaction(); try { isSaved = GradingResultDetailDAL.UpdateGradingResultDetailEach(Id, Value, tran); AuditTrailBLL objAt = new AuditTrailBLL(); int x = objAt.saveAuditTrail(objOld, objNew, Utility.GetApplicationName(), UserBLL.GetCurrentUser(), "Update Grading factorValue"); if (x == 1 && isSaved == true) { tran.Commit(); } else if (isSaved == true && x == -1) { tran.Rollback(); isSaved = false; objAt.RoleBack(); } } catch (Exception ex) { tran.Rollback(); throw ex; } finally { tran.Dispose(); conn.Close(); } return(isSaved); }
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); }
public bool Add(string WarehouseNo, string TrackingNo, List <GradingByBLL> list) { //Utility.LogException(new Exception(TrackingNo.ToString())); SqlTransaction trans; SqlConnection conn = Connection.getConnection(); bool isSaved = false; trans = conn.BeginTransaction(); try { SamplingResultBLL obj = new SamplingResultBLL(); obj = obj.GetSamplingResultById(this.SamplingResultId); //Tod Do if the code is from Regrading then the Tracking Number should change. string TranNoGradedispute = ""; TranNoGradedispute = TrackingNo; //if not from regrading. if (TranNoGradedispute == "") { throw new Exception("Unable to get Tracking Number."); } this.Id = Guid.NewGuid(); this.GradingCode = GetRandomCode(WarehouseNo); // TODO - Complete Work flow intgeration. //this.TrackingNo = TranNoGradedispute; this.TrackingNo = TrackingNo; isSaved = GradingDAL.InsertGrading(this, trans); if (isSaved == true) { // add Graders. GradingByBLL objGradingBy = new GradingByBLL(); isSaved = objGradingBy.Add(this.Id, list, trans); if (isSaved == false) { throw new CodeGenerationException("Can Not generarte Grading Code Exception"); } else { int at = -1; AuditTrailBLL objAt = new AuditTrailBLL(); at = objAt.saveAuditTrail(this, WFStepName.GenerateGradingCode.ToString(), UserBLL.GetCurrentUser(), "Get Grading Code"); if (at == 1) { isSaved = true; } else { isSaved = false; } } } else { throw new CodeGenerationException("Can Not generarte Grading Code Exception"); } if (isSaved == true) { HttpContext.Current.Session["msg"] = WFTransaction.Request(TrackingNo); WFTransaction.WorkFlowManager(TrackingNo); trans.Commit(); } return(isSaved); } catch (Exception ex) { trans.Rollback(); throw ex; } finally { trans.Dispose(); conn.Close(); } }
public bool Add(List <StackUnloadedBLL> list) { Nullable <Guid> Id = null; int Count = 1; Count = UnloadingDAL.GetNumberofUnloadingByGradeingResultId(this.GradingResultId); if (Count == 0) { SqlTransaction tran; SqlConnection conn = new SqlConnection(); conn = Connection.getConnection(); tran = conn.BeginTransaction(); try { Id = UnloadingDAL.InsertUnloadingInformation(this, tran); if (Id == null) { tran.Rollback(); conn.Close(); return(false); } else { // add the Stack information this.Id = (Guid)Id; StackUnloadedBLL stackObj = new StackUnloadedBLL(); bool isSavedList = false; isSavedList = stackObj.Add(tran, list, (Guid)Id); if (isSavedList == true) { int at = -1; AuditTrailBLL objAt = new AuditTrailBLL(); at = objAt.saveAuditTrail(this, WFStepsName.AddUnloadingInfo.ToString(), UserBLL.GetCurrentUser(), "Add Unloading Information"); if (at == 1) { isSavedList = true; } else { isSavedList = false; } } if (isSavedList == true) { WFTransaction.WorkFlowManager(this.TrackingNo); } if (isSavedList == true) { tran.Commit(); return(true); } else { tran.Rollback(); return(false); } } } catch (Exception ex) { throw ex; } finally { tran.Dispose(); conn.Close(); } } else { return(false); } }
public bool Update() { bool isSaved = false; SqlConnection conn = null; SqlTransaction tran = null; RequestforEditGRNBLL objEdit = new RequestforEditGRNBLL(); objEdit = objEdit.GetById(Id); AuditTrailBLL objAt = new AuditTrailBLL(); try { conn = Connection.getConnection(); tran = conn.BeginTransaction(); isSaved = RequestforEditGRNDAL.Update(tran, this); if (isSaved == true) { string AppMode = WFStepsName.EditAppGRN.ToString(); if (objAt.saveAuditTrail(objEdit, this, AppMode, UserBLL.GetCurrentUser(), "Update-ApprovedGRNCancelRequest") == 1) { if (objEdit.Status == RequestforEditGRNStatus.New && this.Status == RequestforEditGRNStatus.Approved) { WFTransaction.WorkFlowManager(this.TrackingNo); } else if (objEdit.Status == RequestforEditGRNStatus.New && this.Status == RequestforEditGRNStatus.Approved) { WFTransaction.Close(this.TrackingNo); } tran.Commit(); return(true); } else { tran.Rollback(); return(false); } } else { tran.Rollback(); return(false); } } catch (Exception ex) { tran.Rollback(); throw new Exception("Unable to update Data.", ex); } finally { if (conn.State == ConnectionState.Open) { conn.Close(); } if (tran != null) { tran.Dispose(); } } }
public bool AllowGRNEdit(RequestforEditGRNStatus oldStatus, RequestforEditGRNBLL old) { //Update Status accordingly. //Set GRN Status to On Edit bool isSaved = false; SqlConnection conn = null; SqlTransaction tran = null; try { conn = Connection.getConnection(); tran = conn.BeginTransaction(); isSaved = RequestforEditGRNDAL.Update(tran, this); isSaved = GRNDAL.UpdateGRNStatus(this.GRN_Number, GRNStatus.OpenForEdit, tran); if (this.Status == RequestforEditGRNStatus.Approved && oldStatus == RequestforEditGRNStatus.Approved) { // Update GRN Status to OpenForEdit if (isSaved == true) { int at = -1; AuditTrailBLL objat = new AuditTrailBLL(); at = objat.saveAuditTrail(old, this, WFStepsName.RequestforEditGRN.ToString(), UserBLL.GetCurrentUser(), "Open GRN for Edit"); if (at == 1) { WFTransaction.WorkFlowManager(this.TrackingNo); tran.Commit(); } else { tran.Rollback(); isSaved = false; } } else { isSaved = false; tran.Rollback(); } } else if (this.Status == RequestforEditGRNStatus.Cancelled) { WFTransaction.Close(this.TrackingNo); isSaved = true; } } catch (Exception ex) { tran.Rollback(); throw new Exception("Unable to update Data.", ex); } finally { if (conn.State == ConnectionState.Open) { conn.Close(); } if (tran != null) { tran.Dispose(); } } return(isSaved); }
/// <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 Boolean Add(List <SamplingResultBLL> list, Guid SamplingId) { if (list == null) { throw new Exception("No sampling Result to save."); } SamplingBLL objSampling = new SamplingBLL(); objSampling = objSampling.GetSampleDetail(SamplingId); if (objSampling == null) { throw new Exception("Invalid Tracking No.Plase Tray Again."); } if (String.IsNullOrEmpty(objSampling.TrackingNo) == true) { throw new Exception("Invalid Tracking No.Plase Tray Again."); } string OldTrackingNo = String.Empty; int count = 0; count = list.Count; bool isSaved = false; SqlTransaction tran = null; SqlConnection conn = null; List <string> tranlist = new List <string>(); try { conn = Connection.getConnection(); tran = conn.BeginTransaction(); foreach (SamplingResultBLL i in list) { if (count == 1) { i.Id = Guid.NewGuid(); i.TrackingNo = objSampling.TrackingNo; i.ResultReceivedDateTime = this.ResultReceivedDateTime; i.IsPlompOk = this.IsPlompOk; if (this.IsPlompOk == true) { i.Status = SamplingResultStatus.Approved; } else { i.Status = SamplingResultStatus.New; } isSaved = SamplingResultDAL.InsertSamplingResult(i, tran); int at = -1; if (isSaved == true) { AuditTrailBLL objAt = new AuditTrailBLL(); at = objAt.saveAuditTrail(i, WFStepsName.AddSamplingResult.ToString(), UserBLL.GetCurrentUser(), "Add Sampling Result"); if (at == 1) { if (i.Status == SamplingResultStatus.Approved) { WFTransaction.WorkFlowManager(objSampling.TrackingNo); } } else { tran.Rollback(); isSaved = false; } } } else if (count > 1) { //Close previous Tracking No. OldTrackingNo = objSampling.TrackingNo; Guid TransactionTypeId = Guid.Empty; i.ResultReceivedDateTime = this.ResultReceivedDateTime; try { TransactionTypeId = TransactionTypeProvider.GetTransactionTypeId("RegularCoffeeMixed"); } catch (InvalidTransactionType ex) { throw new Exception("Can Not open Mixed Transaction Type please Contact the Administrator.", ex); } string tranNo = WFTransaction.GetTransaction(TransactionTypeId, tran); if (string.IsNullOrEmpty(tranNo) == true) { throw new Exception("Can Not get Transaction Number please Contact the Administrator."); } else { i.Id = Guid.NewGuid(); i.TrackingNo = tranNo; i.IsPlompOk = this.IsPlompOk; i.ResultReceivedDateTime = this.ResultReceivedDateTime; tranlist.Add(tranNo); isSaved = SamplingResultDAL.InsertSamplingResult(i, tran); int at = -1; if (i.IsPlompOk == true) { i.Status = SamplingResultStatus.Approved; } else { i.Status = SamplingResultStatus.New; } if (i.Status == SamplingResultStatus.Approved) { //Move One Step ECXWF.CMessage mess = null; mess = WFTransaction.Request(tranNo); if (mess == null) { throw new Exception("Can Not get Message for the Tracking No."); } else { if (WFStepName.AddSamplingResult.ToString().Trim().ToUpper() == mess.Name.Trim().ToUpper()) { WFTransaction.WorkFlowManager(tranNo, mess); } else { throw new Exception("Can Not get Message for the Tracking No."); } } } AuditTrailBLL objAt = new AuditTrailBLL(); at = objAt.saveAuditTrail(i, WFStepsName.AddSamplingResult.ToString(), UserBLL.GetCurrentUser(), "Add Sampling Result"); if (at == -1) { isSaved = false; break; } if (isSaved == false) { break; } } } } if (string.IsNullOrEmpty(OldTrackingNo) != true) { if ((isSaved == true) && (list.Count > 0)) { WFTransaction.Close(OldTrackingNo); } } if (isSaved == true) { tran.Commit(); return(true); } else { tran.Rollback(); return(false); } } catch (Exception ex) { RemoveTransaction(tranlist); tran.Rollback(); throw ex; } finally { if (tran != null) { tran.Dispose(); } if (conn.State == ConnectionState.Open) { conn.Close(); } } }
public bool UpdateSampleCodeReceived() { //check necessary data is Suplied. if ((this.Id == null) && (this.Id == Guid.Empty)) { throw new Exception("Invalid Parameter"); } if (IsCodeReceivedAtLab == null) { throw new Exception("Invalid Parameter,IsCodeReceivedAtLab Can't be null"); } if (CodeReceivedTimeStamp == null) { throw new Exception("Invalid Parameter, CodeReceivedTimeStamp Can't be null"); } bool isSaved = false; SqlTransaction tran = null; SqlConnection conn = null; int at = -1; AuditTrailBLL objAT = new AuditTrailBLL(); try { conn = Connection.getConnection(); tran = conn.BeginTransaction(); isSaved = GradingDAL.UpdateSampleCodeReceived(this.Id, (bool)this.IsCodeReceivedAtLab, (DateTime)this.CodeReceivedTimeStamp, this.LabTechRemark, tran); if (isSaved == true) { isSaved = false; at = objAT.saveAuditTrail(this, WFStepsName.CodeSampRec.ToString(), UserBLL.GetCurrentUser(), "Receive Sample Code"); WFTransaction.WorkFlowManager(this.TrackingNo); if (at == -1) { isSaved = false; } } if (isSaved == true) { tran.Commit(); } else { tran.Rollback(); } // update the Database } catch (Exception ex) { if (at != -1) { objAT.RoleBack(); } tran.Rollback(); throw ex; } finally { if (tran != null) { tran.Dispose(); } if (conn != null) { if (conn.State == ConnectionState.Open) { conn.Close(); } } } return(isSaved); }
public static List <TrucksForSamplingBLL> GetRandomSample(Guid WarehouseId, int NumberOfTrucks) { List <TrucksForSamplingBLL> list = null; List <TrucksForSamplingBLL> listAll = null; List <TrucksForSamplingBLL> filteredList = new List <TrucksForSamplingBLL>(); list = TrucksForSamplingDAL.GetRandomSamplingIdWithin2Hours(WarehouseId, NumberOfTrucks); if (list == null) { list = new List <TrucksForSamplingBLL>(); } if (list.Count < NumberOfTrucks) { int numberofRandomRequired = 0; numberofRandomRequired = NumberOfTrucks - list.Count; listAll = TrucksForSamplingDAL.GetRandomTrucksForSamplingId(WarehouseId, NumberOfTrucks * 3); if (listAll != null) { if (listAll.Count <= numberofRandomRequired) { foreach (TrucksForSamplingBLL i in listAll) { list.Add(i); } } else { while (list.Count < NumberOfTrucks) { System.Random rnd = new Random(); int myRnd = rnd.Next(0, numberofRandomRequired); list.Add(listAll[myRnd]); } } } } if (list != null) { } else { list = TrucksForSamplingDAL.GetRandomTrucksForSamplingId(WarehouseId, NumberOfTrucks); } bool isSaved = false; SqlTransaction tran; SqlConnection connect = Connection.getConnection(); tran = connect.BeginTransaction(); AuditTrailBLL objAt = new AuditTrailBLL(); if (list == null) { return(null); } try { int i = 0; foreach (TrucksForSamplingBLL obj in list) { if (string.IsNullOrEmpty(obj.TrackingNo) == true) { break; } bool curSaved = false; obj.Id = Guid.NewGuid(); WFTransaction.UnlockTask(obj.TrackingNo); ECXWF.CMessage msg = WFTransaction.Request(obj.TrackingNo); if (msg == null) { // list.RemoveAt(i); } else { if (msg.Name == "GetTrucksReadyForSam") { curSaved = TrucksForSamplingDAL.InsertTruksForSampling(obj, tran); if (curSaved == true) { int at = -1; at = objAt.saveAuditTrail(obj, WFStepsName.GetTrucksReadyForSam.ToString(), UserBLL.GetCurrentUser(), "Add Trucks For sampling"); if (at == 1) { curSaved = true; } else { curSaved = false; } } if (curSaved == true) { // ECXWF.CMessage msg = WFTransaction.Request(obj.TrackingNo); if (msg != null) { if (msg.Name != "GetTrucksReadyForSam") { isSaved = false; throw new Exception("Invalid Task"); } else { HttpContext.Current.Session["msg"] = msg; WFTransaction.WorkFlowManager(obj.TrackingNo); filteredList.Add(obj); } } else { objAt.RoleBack(); //list.RemoveAt(i); } } else { // list.RemoveAt(i); } if (isSaved == false) { if (i == 0) { isSaved = curSaved; } else { isSaved = false; } } else { isSaved = curSaved; } i++; } else { // list.RemoveAt(i); } } } if (isSaved == true) { tran.Commit(); } else { filteredList = null; tran.Rollback(); } } catch (Exception ex) { objAt.RoleBack(); tran.Rollback(); filteredList = null; throw ex; } finally { tran.Dispose(); connect.Close(); } return(filteredList); }
/// <summary> /// Gets the net weight by deducting the tare /// </summary> /// <param name="GrossWeight"></param> /// <param name="BagTypeId"></param> /// <param name="NoBags"></param> /// <returns></returns> /// public Nullable <Guid> Add(List <GRNServiceBLL> listGRNService) { bool IsSaved = false; bool canCreate = false;; try { canCreate = this.CanCreateGRNforGradingId(this.GradingId); } catch (Exception ex) { throw ex; } if (canCreate == false) { return(null); } Nullable <Guid> id = null; SqlTransaction tran; string warehousecode; warehousecode = WarehouseBLL.GetWarehouseCode(this.WarehouseId); SqlConnection conn = new SqlConnection(); conn = Connection.getConnection(); tran = conn.BeginTransaction(); try { id = GRNDAL.InsertNewGRN(this, warehousecode, tran); if (id != null) { if (listGRNService != null) { GRNServiceBLL objSer = new GRNServiceBLL(); IsSaved = objSer.Save((Guid)id, listGRNService, tran); //Audit Trail Both GRN And GRN Service. int at = -1; AuditTrailBLL objAt = new AuditTrailBLL(); this.Id = (Guid)id; at = objAt.saveAuditTrail(this, WFStepsName.AddGRN.ToString(), UserBLL.GetCurrentUser(), "Add New GRN"); if (at == 1) { IsSaved = true; } else { IsSaved = false; } } else { IsSaved = true; } if (IsSaved == true) { WFTransaction.WorkFlowManager(this.TrackingNo); tran.Commit(); } else { tran.Rollback(); } } else { tran.Rollback(); } } catch (Exception ex) { tran.Rollback(); throw new Exception("Unable to update database.", ex); } finally { tran.Dispose(); conn.Close(); } return(id); }
public bool ClientAcceptance(Guid Id, int Status, GradingResultStatus GradeRecivedStatatus, Nullable <DateTime> ClientAccpetedTimeStamp, out string strQueueNo) { DateTime dt; GradingResultBLL objUpdate = new GradingResultBLL(); objUpdate.ID = Id; objUpdate.Status = (GradingResultStatus)Status; try { dt = (DateTime)ClientAccpetedTimeStamp; } catch { throw new Exception("Invalid Client Acceptance Date."); } objUpdate.ClientAcceptanceTimeStamp = ClientAccpetedTimeStamp; // Get Queue No. DateTime currDate = DateTime.Today; Guid WarehouseId = UserBLL.GetCurrentWarehouse(); string Code = currDate.Day.ToString() + currDate.Year.ToString().Substring(2, 2); int? QueueNo = null; int? PreWeightQueueNo = null; try { GradingResultDAL.GetQueueNumber(Code, WarehouseId, currDate, out QueueNo, out PreWeightQueueNo); if (QueueNo == null || PreWeightQueueNo == null) { throw new Exception("Can not get queue number"); } } catch { new Exception("Can not get queue number."); } objUpdate.QueueDate = currDate; objUpdate.QueueNo = (int)QueueNo; strQueueNo = PreWeightQueueNo.ToString(); objUpdate.PreWeightQueueNo = (int)PreWeightQueueNo; bool isSaved = false; SqlTransaction tran; SqlConnection conn = Connection.getConnection(); tran = conn.BeginTransaction(); GradingResultBLL objGradingResult = new GradingResultBLL(); objGradingResult = objGradingResult.GetGradingResultById(Id, tran); AuditTrailBLL objAt = new AuditTrailBLL(); int At = -1; try { isSaved = GradingResultDAL.ClientAcceptanceGradingResult(objUpdate, tran); if (objAt.saveAuditTrail(objGradingResult, objUpdate, WFStepsName.ClientAcceptance.ToString(), UserBLL.GetCurrentUser(), "Grading Result Client Respose") == 1) { isSaved = true; At = 1; } string TranNo; TranNo = objGradingResult.TrackingNo; if (string.IsNullOrEmpty(TranNo) == true) { tran.Rollback(); if (At == 1) { objAt.RoleBack(); } isSaved = false; } else { if ((int)GradingResultStatus.ClientAccepted == Status && (GradeRecivedStatatus == GradingResultStatus.New || GradeRecivedStatatus == GradingResultStatus.Approved)) { WFTransaction.WorkFlowManager(TranNo); HttpContext.Current.Session["CATranNo"] = TranNo; } else { WFTransaction.Close(TranNo); //Create a new Grading Dispute task or General reqiurment fail. } } if (isSaved == true) { tran.Commit(); return(true); } else { tran.Rollback(); objAt.RoleBack(); HttpContext.Current.Session["CATranNo"] = null; return(false); } } catch (Exception ex) { tran.Rollback(); if (At == 1) { objAt.RoleBack(); } throw ex; } finally { tran.Dispose(); conn.Close(); } }