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);
}
