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