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 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 Boolean UpdateManagerApproval(SamplingResultBLL oldObj) { // TODO : Check Sampling is Completed - check if Code is generated. bool isSaved = false; SqlTransaction tran = null; SqlConnection conn = null; AuditTrailBLL objat = new AuditTrailBLL(); int at = -1; try { conn = Connection.getConnection(); tran = conn.BeginTransaction(); this.LastModifiedBy = UserBLL.GetCurrentUser(); isSaved = SamplingResultDAL.UpdateManagerApproval(this, tran); if (isSaved == true) { if (oldObj == null) { throw new Exception("Invalid Old object-UpdateManagerApproval Method."); } string strOld = "(Id-" + oldObj.Id.ToString() + ")," + "(Status-" + oldObj.Status.ToString() + "),(LastModifiedBy-" + oldObj.LastModifiedBy.ToString() + ")"; string strNew = "(Id-" + this.Id.ToString() + ")," + "(Status-" + this.Status.ToString() + "),(LastModifiedBy-" + this.LastModifiedBy.ToString() + ")"; strNew += "(ManagerApprovalRemark-" + this.ManagerApprovalRemark + "),(LastModifiedTimestamp-" + this.LastModifiedTimestamp.ToString() + ")"; at = objat.saveAuditTrailStringFormat(strOld, strNew, WFStepsName.EditSamplingResult.ToString(), UserBLL.GetCurrentUser(), "Edit Sampling Result"); if (at == 1) { if ((oldObj.Status == SamplingResultStatus.New) && (this.Status == SamplingResultStatus.Approved)) { ECXWF.CMessage mess = WFTransaction.Request(this.TrackingNo); HttpContext.Current.Session["msg"] = mess; if (mess.Name.Trim().ToUpper() == "AddSamplingResult".ToUpper()) { WFTransaction.WorkFlowManager(this.TrackingNo); } else { throw new Exception("The Task has already been done."); } } else if ((oldObj.Status == SamplingResultStatus.New) && (this.Status == SamplingResultStatus.Cancelled)) { ECXWF.CMessage mess = WFTransaction.Request(this.TrackingNo); HttpContext.Current.Session["msg"] = mess; if (mess.Name.Trim().ToUpper() == "AddSamplingResult".ToUpper()) { WFTransaction.Close(this.TrackingNo); } else { throw new Exception("The Task has already been done."); } } } else { objat.RoleBack(); tran.Rollback(); isSaved = false; } if (at == 1) { tran.Commit(); } else { isSaved = false; tran.Rollback(); } } return(isSaved); } catch (Exception ex) { if (at == 1) { objat.RoleBack(); } tran.Rollback(); throw ex; } finally { tran.Dispose(); conn.Close(); } }
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); }
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 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(); } }
public Nullable <Guid> Add(List <GradingResultDetailBLL> list, string TrackingNo) { bool isSaved = false; if (this.IsSupervisor == true) { int count = 1; count = GradingResultDAL.GetNumberofSupervisorResults(this.GradingId); if (count > 0) { throw new Exception("Multiple Supervisor Grading result exception."); } } Nullable <Guid> Id = null; SqlConnection conn = Connection.getConnection(); SqlTransaction tran = conn.BeginTransaction(); this.WarehouseId = UserBLL.GetCurrentWarehouse(); this.ID = Guid.NewGuid(); this.CreatedBy = UserBLL.GetCurrentUser(); this.CreatedTimestamp = DateTime.Now; try { Id = (Guid)GradingResultDAL.InsertGradingResult(this, tran); if (Id != null) { // add audit trail int At = -1; AuditTrailBLL objAt = new AuditTrailBLL(); At = objAt.saveAuditTrail(this, WFStepsName.AddGradingResult.ToString(), UserBLL.GetCurrentUser(), "Add Grading result"); if (At == 1) { GradingResultDetailBLL objDetail = new GradingResultDetailBLL(); isSaved = objDetail.Add(list, tran, Id); if (isSaved == true) { isSaved = true; } else { if (At == 1) { objAt.RoleBack(); isSaved = false; } } if (isSaved == true) { GradingBLL objGrading = new GradingBLL(); objGrading = objGrading.GetById(this.GradingId); if (objGrading == null) { throw new Exception("Invalid Code.Please try again"); } else { if (string.IsNullOrEmpty(objGrading.TrackingNo) == true) { throw new Exception("Invalid Code.Please try again"); } } if (this.Status == GradingResultStatus.MoistureFailed || this.Status == GradingResultStatus.GeneralRequiementfail) { // Client Should Be Informed of the Grading Result. // WFTransaction.Close(objGrading.TrackingNo); WFTransaction.WorkFlowManager(objGrading.TrackingNo); } else { WFTransaction.WorkFlowManager(objGrading.TrackingNo); } HttpContext.Current.Session["AddGradingRecivedTranNo"] = objGrading.TrackingNo; } } else { isSaved = false; } } if (isSaved == true) { tran.Commit(); return(Id); } else { isSaved = false; tran.Rollback(); return(null); } } catch (Exception ex) { tran.Rollback(); throw ex; } finally { tran.Dispose(); conn.Close(); } }
//oct-18-2011 //update empty voucher entry error public bool Save(Guid DepositRequestId, string VoucherNo, Guid CoffeeTypeId, string SpecificArea, int NumberofBags, int NumberOfPlomps, int NumberOfPlompsTrailer, string CertificateNo, Guid CreatedBy, int Status, string TrackingNo) { SqlTransaction tran; bool isSaved = false; //get Tracking No. CommodityDepositeRequestBLL oC = new CommodityDepositeRequestBLL(); oC = oC.GetCommodityDepositeDetailById(DepositRequestId); TrackingNo = oC.TrackingNo; VoucherInformationBLL obj = new VoucherInformationBLL(); obj.DepositRequestId = DepositRequestId; obj.VoucherNo = VoucherNo; obj.CoffeeTypeId = CoffeeTypeId; obj.SpecificArea = SpecificArea; obj.NumberofBags = NumberofBags; obj.NumberOfPlomps = NumberOfPlomps; obj.NumberOfPlompsTrailer = NumberOfPlompsTrailer; obj.CertificateNo = CertificateNo; obj.CreatedBy = CreatedBy; obj.Status = Status; Voucher objSave = new Voucher(); SqlConnection conn = Connection.getConnection(); tran = conn.BeginTransaction(); AuditTrailBLL objAt = new AuditTrailBLL(); int AtSaved = -1; try { Guid VoucherId = Guid.Empty; VoucherId = objSave.InsertVoucherInformation(obj, tran); if (VoucherId == Guid.Empty) { isSaved = false; } else { obj.Id = VoucherId; if (objAt.saveAuditTrail(obj, WFStepsName.NewVoucherInfo.ToString(), UserBLL.GetCurrentUser(), "Insert Voucher") == 1) { AtSaved = 1; string msgFromWF = ""; msgFromWF = WFTransaction.GetMessage(TrackingNo); if (msgFromWF == "AddVoucherInfo") { WFTransaction.WorkFlowManager(TrackingNo); WFTransaction.UnlockTask(TrackingNo); HttpContext.Current.Session["msg"] = null; } tran.Commit(); isSaved = true; } else { tran.Rollback(); isSaved = false; } } } catch (Exception ex) { tran.Rollback(); if (AtSaved == 1) { objAt.RoleBack(); } throw ex; } finally { conn.Close(); tran.Dispose(); } return(isSaved); }
public Nullable <Guid> InsertSample(SamplingBLL objSampling, SamplerBLL objSampler, bool isMoisture) { bool issaved = false; SqlConnection conn = null; SqlTransaction trans = null; int at = -1; Nullable <Guid> DepositeRequestId = null; try { conn = Connection.getConnection(); trans = conn.BeginTransaction(); //using (TransactionScope scope = new TransactionScope()) //{ DepositeRequestId = new Guid(SamplingDAL.InsertSample(objSampling, trans).ToString()); if (DepositeRequestId == null) { trans.Rollback(); return(null); //throw new Exception("Invalid Sample Id."); } objSampling.Id = (Guid)DepositeRequestId; AuditTrailBLL objAt = new AuditTrailBLL(); at = objAt.saveAuditTrail(objSampling, WFStepsName.AddSampleCoding.ToString(), UserBLL.GetCurrentUser(), "Get Sample Ticket"); if (at == 1) { at = -1; objSampler.SampleingTicketId = (Guid)DepositeRequestId; objSampler.Id = Guid.NewGuid(); issaved = SamplerDAL.InsertSampler(objSampler, trans); if (issaved == true) { HttpContext.Current.Session["msg"] = null; WFTransaction.UnlockTask(objSampling.TrackingNo); ECXWF.CMessage mess = WFTransaction.Request(objSampling.TrackingNo); HttpContext.Current.Session["msg"] = mess; if (mess.Name.Trim() == "GetSampleTicket".Trim()) { WFTransaction.WorkFlowManager(objSampling.TrackingNo); trans.Commit(); } else { objAt.RoleBack(); trans.Rollback(); DepositeRequestId = null; } } else { objAt.RoleBack(); trans.Rollback(); DepositeRequestId = null; } } else { trans.Rollback(); DepositeRequestId = null; throw new Exception("Unable to log Audit Trail"); } // scope.Complete(); // } } catch (Exception ex) { trans.Rollback(); DepositeRequestId = null; throw ex; } finally { trans.Dispose(); conn.Close(); } return(DepositeRequestId); }
public bool SaveDriverInformation() { bool isValid, isDuplicate = false; bool isSaved = false; AuditTrailBLL objAt = new AuditTrailBLL(); DriverInformationBLL objDriverInfoBLL = new DriverInformationBLL(this.ReceivigRequestId, this.DriverName, this.LicenseNumber, this.LicenseIssuedPlace, this.PlateNumber, this.TrailerPlateNumber, this.Status, this.Remark, this.CreatedBy); //TODO : Check status is not cancelled //isDuplicate = this.isDuplicate(this.ReceivigRequestId, this.LicenseIssuedPlace, this.LicenseIssuedPlace); //if (isDuplicate == true) //{ //throw new DuplicateDriverInformationException("This driver information has already been added"); //} isValid = this.isValidForSave(objDriverInfoBLL); if (isValid == true) { SqlTransaction tran; SqlConnection conn = Connection.getConnection(); tran = conn.BeginTransaction(); try { DriverInformation objDriverInfoDAL = new DriverInformation(); Guid DriverInformationId = Guid.Empty; DriverInformationId = objDriverInfoDAL.InsertDriverInformation(objDriverInfoBLL, tran); if (DriverInformationId == Guid.Empty) { tran.Rollback(); isSaved = false; } else { objDriverInfoBLL.Id = DriverInformationId; if (objAt.saveAuditTrail(objDriverInfoBLL, WFStepsName.AddDriverInformation.ToString(), UserBLL.GetCurrentUser(), "Add New Driver Information") == -1) { tran.Rollback(); isSaved = false; } else { tran.Commit(); isSaved = true; } } conn.Close(); } catch (Exception e) { tran.Rollback(); objAt.RoleBack(); throw e; } finally { tran.Dispose(); conn.Close(); } } else { return(false); } return(isSaved); }
public bool Add() { int At = -1; bool isSaved = false; SqlConnection conn = new SqlConnection(); SqlTransaction tran; conn = Connection.getConnection(); tran = conn.BeginTransaction(); AuditTrailBLL objAt = new AuditTrailBLL(); try { string TrackingNo = ""; TrackingNo = WFTransaction.GetTransaction("ApprovedGRNCancel", tran); this.Id = Guid.NewGuid(); this.TrackingNo = TrackingNo; this.CreatedBy = UserBLL.GetCurrentUser(); this.CreatedTimestamp = DateTime.Now; isSaved = RequestforApprovedGRNCancelationDAL.save(tran, this); isSaved = WarehouseRecieptBLL.RequestCancel(this.GRNId, TrackingNo, this.Remark); if (isSaved == true) { At = objAt.saveAuditTrail(this, WFStepsName.CancelGRN.ToString(), UserBLL.GetCurrentUser(), "Add Approved GRN Cancelation Request"); if (At == 1) { tran.Commit(); } else { isSaved = false; } } else { isSaved = false; } if (isSaved != true) { if (TrackingNo != "") { WFTransaction.Close(TrackingNo); } tran.Rollback(); if (At == 1) { objAt.RoleBack(); } } } catch (Exception ex) { tran.Rollback(); if (At == 1) { objAt.RoleBack(); } throw new Exception("Unable to Add New record", ex); } finally { tran.Dispose(); if (conn.State == ConnectionState.Open) { conn.Close(); } conn.Dispose(); } return(isSaved); }