private void SetCatalogData()
{
List <IDataIdentifier> ids = null;
try
{
IDataFilter filter = SearchConditionSelector1.DataFilter;
foreach (DataFilterParameter parameter in filter.Parameters)
{
filter.SetCondition(SearchConditionSelector1[parameter.Name]);
}
ids = GINProcessBLL.SearchGINProcess(filter);
}
catch
{
ids = new List <IDataIdentifier>();
}
string buffer = string.Empty;
foreach (IDataIdentifier identifier in ids)
{
buffer += identifier.Preview.DocumentElement.InnerXml;
}
string ginProcessSet = "<?xml version=\"1.0\" encoding=\"utf-8\"?> <Catalog>" + buffer + "</Catalog>";
xdsGINProcessSource.Data = ginProcessSet;
gvPickupNotice.DataBind();
}
public System.Data.SqlClient.SqlTransaction GINApproved(Guid truckId)
{
IGINProcess originalGIN = new GINProcessBLL(currentGINProcess.GINProcessInformation.TransactionId);
SqlTransaction transaction = currentGINProcess.GINApproved(truckId);
var ginChanges = (from oGIN in originalGIN.GINProcessInformation.Trucks
join cGIN in currentGINProcess.GINProcessInformation.Trucks
on oGIN.TruckId equals cGIN.TruckId
where oGIN.TruckId == truckId
select new object[] { oGIN, cGIN, AuditTrailWrapper.ExistingRecord });
try
{
AuditTrailWrapper atw = new AuditTrailWrapper(AuditTrailWrapper.GINApproval, "GIN Process");
atw.AddChange(ginChanges.ToArray());
if (!atw.Save())
{
transaction.Rollback();
throw new Exception("Failed to save audit trail!");
}
}
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
return(transaction);
}
public System.Data.SqlClient.SqlTransaction SaveTruckRegistration()
{
IGINProcess originalGIN = new GINProcessBLL(currentGINProcess.GINProcessInformation.TransactionId);
SqlTransaction transaction = currentGINProcess.SaveTruckRegistration();
//ConfirmNoConcurrency(Trucks, Loads, Weight)
//newly added trucks
var newTrucks = (from cTruck in currentGINProcess.GINProcessInformation.Trucks
where !(from oTruck in originalGIN.GINProcessInformation.Trucks select oTruck.TruckId).Contains(cTruck.TruckId)
select new object[] { null, cTruck, AuditTrailWrapper.NewRecord });
//existing trucks
var existingTrucks = (from cTruck in currentGINProcess.GINProcessInformation.Trucks
join oTruck in originalGIN.GINProcessInformation.Trucks on cTruck.TruckId equals oTruck.TruckId
select new object[] { oTruck, cTruck, AuditTrailWrapper.ExistingRecord });
//deleted trucks
var deletedTrucks = (from oTruck in originalGIN.GINProcessInformation.Trucks
where !(from cTruck in currentGINProcess.GINProcessInformation.Trucks select cTruck.TruckId).Contains(oTruck.TruckId)
select oTruck);
try
{
AuditTrailWrapper atw = new AuditTrailWrapper(AuditTrailWrapper.TruckRegistration, newTrucks.ToArray(), "PUN Process");
atw.AddChange(existingTrucks.ToArray());
if (!atw.Save())
{
transaction.Rollback();
throw new Exception("Failed to save audit trail!");
}
}
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
return(transaction);
}
public System.Data.SqlClient.SqlTransaction SaveGIN(Guid truckId, System.Data.SqlClient.SqlTransaction transaction)
{
IGINProcess originalGIN = new GINProcessBLL(currentGINProcess.GINProcessInformation.TransactionId);
currentGINProcess.SaveGIN(truckId, transaction);
//ConfirmNoConcurrency(GIN)
var ginChanges = (from oGIN in originalGIN.GINProcessInformation.Trucks
join cGIN in currentGINProcess.GINProcessInformation.Trucks
on oGIN.TruckId equals cGIN.TruckId
where oGIN.TruckId == truckId
select new object[] { oGIN, cGIN, AuditTrailWrapper.ExistingRecord });
try
{
AuditTrailWrapper atw = new AuditTrailWrapper(AuditTrailWrapper.TruckLoading, ginChanges.ToArray(), "GIN Process");
if (!atw.Save())
{
transaction.Rollback();
throw new Exception("Failed to save audit trail!");
}
}
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
return(transaction);
}
public System.Data.SqlClient.SqlTransaction SaveTruck(GINTruckInfo truck, System.Data.SqlClient.SqlTransaction transaction)
{
IGINProcess originalGIN = new GINProcessBLL(currentGINProcess.GINProcessInformation.TransactionId);
currentGINProcess.SaveTruck(truck, transaction);
//ConfirmNoConcurrency(Truck, Load, Weight)
var truckChanges = (from oTruck in originalGIN.GINProcessInformation.Trucks
where oTruck.TruckId == truck.TruckId
select new object[] { oTruck, truck, AuditTrailWrapper.ExistingRecord });
try
{
AuditTrailWrapper atw = new AuditTrailWrapper(AuditTrailWrapper.TruckRegistration, truckChanges.ToArray(), "GIN Process");
if (!atw.Save())
{
transaction.Rollback();
throw new Exception("Failed to save audit trail!");
}
}
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
return(transaction);
}
protected void Page_Load(object sender, EventArgs e)
{
ginLookup = GINProcessBLL.StaticLookupSource;
SearchConditionSelector1.LookupSource = ginLookup;
if (!IsPostBack)
{
SearchConditionSelector1.DataFilter = GINProcessBLL.GetCatalogFilter("CompleteFilterSet");
}
SetCatalogData();
}
public System.Data.SqlClient.SqlTransaction SaveScaling(Guid truckId)
{
IGINProcess originalGIN = new GINProcessBLL(currentGINProcess.GINProcessInformation.TransactionId);
SqlTransaction transaction = currentGINProcess.SaveScaling(truckId);
//ConfirmNoConcurrency(Truck)
var truckChanges = (from oTruck in originalGIN.GINProcessInformation.Trucks
join cTruck in currentGINProcess.GINProcessInformation.Trucks
on oTruck.TruckId equals cTruck.TruckId
where oTruck.TruckId == truckId
select new object[] { oTruck, cTruck, AuditTrailWrapper.ExistingRecord });
GINTruckInfo origTruck = (GINTruckInfo)truckChanges.Single()[0];
GINTruckInfo currTruck = (GINTruckInfo)truckChanges.Single()[1];
try
{
AuditTrailWrapper atw = new AuditTrailWrapper(AuditTrailWrapper.TruckWeighing, truckChanges.ToArray(), "GIN Process");
atw.AddChange(origTruck.GIN, currTruck.GIN, AuditTrailWrapper.ExistingRecord);
atw.AddChange(origTruck.Weight, currTruck.Weight, AuditTrailWrapper.ExistingRecord);
//newly added returned bags and added bags
var newRBs = (from cRB in currTruck.Weight.ReturnedBags
where !(from oRB in origTruck.Weight.ReturnedBags select oRB.TruckId).Contains(cRB.ReturnedBagsId)
select new object[] { null, cRB, AuditTrailWrapper.NewRecord });
atw.AddChange(newRBs.ToArray());
//existing returned bags and added bags
var existingRBs = (from oRB in origTruck.Weight.ReturnedBags
join cRB in currTruck.Weight.ReturnedBags
on oRB.ReturnedBagsId equals cRB.ReturnedBagsId
select new object[] { oRB, cRB, AuditTrailWrapper.ExistingRecord });
atw.AddChange(existingRBs.ToArray());
if (!atw.Save())
{
transaction.Rollback();
throw new Exception("Failed to save audit trail!");
}
}
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
return(transaction);
}
private void SetCatalogData()
{
List <IDataIdentifier> ids = null;
try
{
IDataFilter filter = SearchConditionSelector1.DataFilter;
foreach (DataFilterParameter parameter in filter.Parameters)
{
if (parameter.Name == "WarehouseId")
{
filter.SetCondition(
new DataFilterCondition(
parameter, FilterConditionType.Comparison,
string.Empty, ginLookup.GetLookup("CurrentWarehouse")["Id"]));
}
else
{
filter.SetCondition(SearchConditionSelector1[parameter.Name]);
}
}
ids = GINProcessBLL.SearchGIN(filter);
}
catch
{
ids = new List <IDataIdentifier>();
}
string buffer = string.Empty;
foreach (IDataIdentifier identifier in ids)
{
buffer += identifier.Preview.DocumentElement.InnerXml;
}
string ginProcessSet = "<?xml version=\"1.0\" encoding=\"utf-8\"?> <Catalog>" + buffer + "</Catalog>";
xdsGINSource.Data = ginProcessSet;
gvGIN.DataBind();
}
public System.Data.SqlClient.SqlTransaction AbortGINProcess()
{
IGINProcess originalGIN = new GINProcessBLL(currentGINProcess.GINProcessInformation.TransactionId);
SqlTransaction transaction = currentGINProcess.AbortGINProcess();
try
{
AuditTrailWrapper atw = new AuditTrailWrapper(AuditTrailWrapper.GINAbortion, "PUN Process");
atw.AddChange(originalGIN.GINProcessInformation, currentGINProcess.GINProcessInformation, AuditTrailWrapper.ExistingRecord);
if (!atw.Save())
{
transaction.Rollback();
throw new Exception("Failed to save audit trail!");
}
}
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
return(transaction);
}
public static void InitiateTask(string msg, string transactionId)
{
WorkflowTaskType workflowTask = (WorkflowTaskType)Enum.Parse(typeof(WorkflowTaskType), msg);
if (workflowTask == WorkflowTaskType.VerifyPUN)
{
PageDataTransfer confirmationTransfer = new PageDataTransfer(HttpContext.Current.Request.ApplicationPath + "/PickupNoticeAcknowledged.aspx");
confirmationTransfer.RemoveAllData();
GINProcessWrapper.RemoveGINProcessInformation();
confirmationTransfer.TransferData["TransactionId"] = transactionId;
confirmationTransfer.TransferData["IsGINTransaction"] = false;
confirmationTransfer.TransferData["ReturnPage"] = HttpContext.Current.Request.ApplicationPath + "/ListInbox.aspx";
confirmationTransfer.Navigate();
}
else if (workflowTask == WorkflowTaskType.ConfirmInventory)
{
PageDataTransfer confirmationTransfer = new PageDataTransfer(HttpContext.Current.Request.ApplicationPath + "/VerifyGINAvailability.aspx");
confirmationTransfer.RemoveAllData();
GINProcessWrapper.RemoveGINProcessInformation();
confirmationTransfer.TransferData["TransactionId"] = transactionId;
confirmationTransfer.TransferData["IsGINTransaction"] = false;
confirmationTransfer.TransferData["ReturnPage"] = HttpContext.Current.Request.ApplicationPath + "/ListInbox.aspx";
confirmationTransfer.Navigate();
}
else if (workflowTask == WorkflowTaskType.RegisterTrucks)
{
PageDataTransfer confirmationTransfer = new PageDataTransfer(HttpContext.Current.Request.ApplicationPath + "/TruckRegistration.aspx");
confirmationTransfer.RemoveAllData();
GINProcessWrapper.RemoveGINProcessInformation();
confirmationTransfer.TransferData["TransactionId"] = transactionId;
confirmationTransfer.TransferData["IsGINTransaction"] = false;
confirmationTransfer.TransferData["ReturnPage"] = HttpContext.Current.Request.ApplicationPath + "/ListInbox.aspx";
confirmationTransfer.Navigate();
}
else if (workflowTask == WorkflowTaskType.ApproveGINEditingRequest)
{
PageDataTransfer agerTransfer = new PageDataTransfer(HttpContext.Current.Request.ApplicationPath + "/ApproveGINEditRequest.aspx");
agerTransfer.RemoveAllData();
GINEditingRequest ger = GINProcessBLL.GetGINEditingRequest(transactionId);
agerTransfer.TransferData["GINEditingRequest"] = ger;
agerTransfer.TransferData["TransactionId"] = ger.OldTransactionId;
agerTransfer.TransferData["IsGINTransaction"] = true;
agerTransfer.TransferData["WorkflowTask"] = workflowTask;
agerTransfer.TransferData["ReturnPage"] = HttpContext.Current.Request.ApplicationPath + "/ListInbox.aspx";
agerTransfer.Navigate();
}
else if ((workflowTask == WorkflowTaskType.GINPreWeighTruck) ||
(workflowTask == WorkflowTaskType.LoadTruck) ||
(workflowTask == WorkflowTaskType.GINPostWeighTruck) ||
(workflowTask == WorkflowTaskType.GenerateGIN) ||
(workflowTask == WorkflowTaskType.RecordClientResponse) ||
(workflowTask == WorkflowTaskType.ApproveGIN) ||
(workflowTask == WorkflowTaskType.LeftCompound))
{
PageDataTransfer loadDataTransfer = null;
switch (workflowTask)
{
case WorkflowTaskType.GINPreWeighTruck:
loadDataTransfer = new PageDataTransfer(HttpContext.Current.Request.ApplicationPath + "/TruckLoading.aspx");
break;
case WorkflowTaskType.LoadTruck:
loadDataTransfer = new PageDataTransfer(HttpContext.Current.Request.ApplicationPath + "/TruckLoading.aspx");
break;
case WorkflowTaskType.GINPostWeighTruck:
loadDataTransfer = new PageDataTransfer(HttpContext.Current.Request.ApplicationPath + "/TruckScaling.aspx");
break;
case WorkflowTaskType.GenerateGIN:
loadDataTransfer = new PageDataTransfer(HttpContext.Current.Request.ApplicationPath + "/TruckScaling.aspx");
break;
case WorkflowTaskType.RecordClientResponse:
loadDataTransfer = new PageDataTransfer(HttpContext.Current.Request.ApplicationPath + "/ClientAcknowledgeGIN.aspx");
break;
case WorkflowTaskType.ApproveGIN:
loadDataTransfer = new PageDataTransfer(HttpContext.Current.Request.ApplicationPath + "/ApproveGIN.aspx");
break;
case WorkflowTaskType.LeftCompound:
loadDataTransfer = new PageDataTransfer(HttpContext.Current.Request.ApplicationPath + "/TruckLeftCompound.aspx");
break;
}
loadDataTransfer.RemoveAllData();
GINProcessWrapper.RemoveGINProcessInformation();
loadDataTransfer.TransferData["TransactionId"] = transactionId;
loadDataTransfer.TransferData["IsGINTransaction"] = true;
loadDataTransfer.TransferData["WorkflowTask"] = workflowTask;
loadDataTransfer.TransferData["ReturnPage"] = HttpContext.Current.Request.ApplicationPath + "/ListInbox.aspx";
loadDataTransfer.Navigate();
}
}
