public void LoadSamplingRealtedData(Guid SamplingResultId, DateTime RecivedDateTime) { ReSamplingBLL obj = new ReSamplingBLL(); obj = ReSamplingDAL.GetSamplingRelatedDataBySamplingResultId(SamplingResultId); this.SamplingId = obj.SamplingId; this.SamplingResultId = obj.SamplingResultId; this.ReceivigRequestId = obj.ReceivigRequestId; this.DateTimeRequested = RecivedDateTime; }
public ReSamplingBLL GetByTrackingNo(string TrackingNo) { try { return(ReSamplingDAL.GetByTrackingNo(TrackingNo)); } catch { throw new Exception("An error has occured please try again.if the error persists contact the adminstrator"); } }
public ReSamplingBLL GetById(Guid Id) { try { return(ReSamplingDAL.GetById(Id)); } catch { throw new Exception("An error has occured please try again.if the error persists contact the adminstrator"); } }
public List <ReSamplingBLL> GetPendingResampling(Guid WarehouseId) { List <ReSamplingBLL> list = new List <ReSamplingBLL>(); try { list = ReSamplingDAL.GetMoistureFailedSamples(WarehouseId); return(list); } catch (Exception ex) { throw new Exception("An Error Has Occured Please Try Again.If the error Persists contact The Administrator", ex); } }
public List <ReSamplingBLL> Search(string TrackingNo, Nullable <int> previousSampleCode, Nullable <DateTime> from, Nullable <DateTime> to, Nullable <ReSamplingStatus> status) { try { return(ReSamplingDAL.Search(TrackingNo, previousSampleCode, from, to, status)); } catch (NULLSearchParameterException ex) { throw new Exception("Please Provide Search Parameter", ex); } catch (Exception ex) { throw new Exception("An Error has occured please try again.if the error persists Contact the administrator", ex); } }
public bool isUnique(Guid SamplingResultId) { int count = -1; try { count = ReSamplingDAL.GetCountBySamplingResult(SamplingResultId); } catch { throw new Exception("Unable to get Count"); } if (count == 0) { return(true); } else { return(false); } }
public bool Save() { SqlTransaction trans; Guid TransactionTypeId = Guid.Empty; string TransactionNo = ""; SqlConnection conn; conn = Connection.getConnection(); trans = conn.BeginTransaction(); bool isSaved = false;; try { try { TransactionTypeId = TransactionTypeProvider.GetTransactionTypeId("CoffeeResample"); } catch { throw new Exception("Unable to get Transaction Type.Please contact the Administrator"); } try { TransactionNo = WFTransaction.GetTransaction(TransactionTypeId, trans); this.TrackingNo = TransactionNo; } catch { throw new Exception("Unable to get Tracking Nunber.Please contact the Administrator"); } //entered as New. this.Status = ReSamplingStatus.New; this.Id = Guid.NewGuid(); isSaved = ReSamplingDAL.Insert(this, trans); if (isSaved == true) { int at = -1; AuditTrailBLL objAt = new AuditTrailBLL(); at = objAt.saveAuditTrail(this, WFStepsName.AddReSamplingRequest.ToString(), UserBLL.GetCurrentUser(), "Add Re-sampling Request"); if (at == 1) { trans.Commit(); return(true); } else { trans.Rollback(); return(false); } } else { return(false); } } catch (Exception ex) { if (trans != null) { trans.Rollback(); } throw new Exception("An Error Has occured please try Again.If the error persists Contact Administrator", ex); } finally { trans.Dispose(); if (conn != null) { if (conn.State == System.Data.ConnectionState.Open) { conn.Close(); } } } }
public bool Update() { bool isSaved = false; SqlTransaction trans; SqlConnection conn = new SqlConnection(); conn = Connection.getConnection(); trans = conn.BeginTransaction(); ReSamplingBLL objold = new ReSamplingBLL(); objold = objold.GetById(this.Id); if (objold == null) { throw new Exception("Invalid Old Value exception"); } try { isSaved = ReSamplingDAL.Update(this, trans); if (isSaved == true) { int at = -1; AuditTrailBLL objAt = new AuditTrailBLL(); at = objAt.saveAuditTrail(objold, this, WFStepsName.EditResampling.ToString(), UserBLL.GetCurrentUser(), "Update Resampling"); if (at == 1) { if (this.Status == ReSamplingStatus.Approved) { WFTransaction.WorkFlowManager(this.TrackingNo); } else if (this.Status == ReSamplingStatus.Cancelled) { WFTransaction.Close(this.TrackingNo); } trans.Commit(); return(true); } else { trans.Commit(); return(false); } } else { trans.Rollback(); return(false); } } catch (Exception ex) { trans.Rollback(); throw new Exception("Unable to Update Data", ex); } finally { trans.Dispose(); if (conn.State == System.Data.ConnectionState.Open) { conn.Close(); } } }
public String[] GetReGradingRequestbyTrackingNo(string TrackingNo) { return(ReSamplingDAL.GetReGradingRequestbyTrackingNo(TrackingNo)); }