public bool CancelGRN(Guid GRNId, string TrackingNo, RequestforApprovedGRNCancelationStatus status)
{
bool isSaved = false;
GRNBLL objGRN = new GRNBLL();
objGRN = objGRN.GetbyGRN_Number(GRNId);
GRNStatus GRNstatus = (GRNStatus)objGRN.Status;
if (status == RequestforApprovedGRNCancelationStatus.Cancelled)
{
GRNstatus = GRNStatus.Cancelled;
}
if (objGRN != null)
{
if (GRNstatus == GRNStatus.Cancelled)
{
isSaved = objGRN.Update(objGRN.GRN_Number, GRNstatus, objGRN, TrackingNo, DateTime.Now);
}
if (isSaved == true)
{
ECXWF.CMessage mess = WFTransaction.Request(TrackingNo);
WFTransaction.WorkFlowManager(TrackingNo, mess);
isSaved = true;
}
}
else
{
throw new Exception("Unable to find GRN");
}
return(isSaved);
}
protected void btnNext_Click(object sender, EventArgs e)
{
if (ViewState["vsTranNo"] != null)
{
ECXWF.CMessage msg = WFTransaction.Request(ViewState["vsTranNo"].ToString().Trim());
if (msg != null)
{
if (msg.Name == "AddVoucherInfo")
{
WFTransaction.WorkFlowManager(ViewState["vsTranNo"].ToString().Trim(), msg);
}
}
}
Response.Redirect("ListInbox.aspx");
}
protected void btnSearch_Click(object sender, EventArgs e)
{
string strTrackingNo = "";
strTrackingNo = this.txtTrackingNo.Text;
this.lblstatus.Text = "";
this.lblMessage.Text = "";
if (!(string.IsNullOrEmpty(strTrackingNo)))
{
try
{
this.lblstatus.Text = WFTransaction.GetMessage(strTrackingNo);
}
catch
{
this.lblMessage.Text = "Can't Find this tracking No.";
}
}
else
{
this.lblMessage.Text = "please enter Tracking No.";
}
}
protected void Button1_Click(object sender, EventArgs e)
{
WFTransaction.WorkFlowManager(this.hfTrackingNo.Value.ToString());
}
private string PageFactory(ECXWF.CMessage msg, string TranNo, object[] par)
{
if (Enum.GetNames(typeof(WorkflowTaskType)).Contains(msg.Name))
{
InitiateWorkflowTask(msg.Name);
}
if (msg.Name == "AddCommodityDepositeRequest")
{
WFTransaction.LoadVariables(msg.Name, TranNo);
return("AddCommodityDepositRequest.aspx");
}
else if (msg.Name == "AddDriverInformation")
{
WFTransaction.LoadVariables(msg.Name, TranNo);
return("AddDriverInformation.aspx?TranNo=" + TranNo);
}
else if (msg.Name == "AddVoucherInfo")
{
WFTransaction.LoadVariables(msg.Name, TranNo);
return("AddVoucherInformation.aspx?TranNo=" + TranNo);
}
else if (msg.Name == "GetSampleTicket")
{
return("GetSampleTicket.aspx");
}
else if (msg.Name == "AddSamplingResult")
{
WFTransaction.LoadVariables(msg.Name, TranNo);
return("AddSamplingResult.aspx?TranNo=" + TranNo);
}
else if (msg.Name == "GenerateGradingCode")
{
WFTransaction.LoadVariables(msg.Name, TranNo);
return("GenerateGradingCode.aspx");
}
else if (msg.Name == "AddGradingResult")
{
WFTransaction.LoadVariables(msg.Name, TranNo);
return("AddGradingResult.aspx?TranNo=" + TranNo);
}
else if (msg.Name == "GradingResultCA")
{
WFTransaction.LoadVariables(msg.Name, TranNo);
return("GradingResultClientAcceptance.aspx?TranNo=" + TranNo);
}
else if (msg.Name == "AddUnloadingInfo")
{
WFTransaction.LoadVariables(msg.Name, TranNo);
return("AddUnloadingInformation.aspx?TranNo=" + TranNo);
}
else if (msg.Name == "PreWeighTruck")
{
WFTransaction.LoadVariables(msg.Name, TranNo);
return("PreWeighTruck.aspx?TranNo=" + TranNo);
}
else if (msg.Name == "AddUnloadingInfo")
{
WFTransaction.LoadVariables(msg.Name, TranNo);
return("AddUnloadingInformation.aspx?TranNo=" + TranNo);
}
else if (msg.Name == "PostWeighTruck")
{
WFTransaction.LoadVariables(msg.Name, TranNo);
return("PostWeighTruck.aspx?TranNo=" + TranNo);
}
else if (msg.Name == "AddScalingInfo")
{
WFTransaction.LoadVariables(msg.Name, TranNo);
return("AddScalingInformation.aspx?TranNo=" + TranNo);
}
else if (msg.Name == "AddGRN")
{
WFTransaction.LoadVariables(msg.Name, TranNo);
return("AddGRN.aspx?TranNo=" + TranNo);
}
else if (msg.Name == "GRNAcceptance")
{
WFTransaction.LoadVariables(msg.Name, TranNo);
return("GRNAcceptance.aspx?TranNo=" + TranNo);
}
else if (msg.Name == "ClientAcceptance")
{
WFTransaction.LoadVariables(msg.Name, TranNo);
return("GRNAcceptance.aspx?TranNo=" + TranNo);
}
else if (msg.Name == "WarehouseManagerAppr")
{
WFTransaction.LoadVariables(msg.Name, TranNo);
return("ViewGRN.aspx?TranNo=" + TranNo);
}
else if (msg.Name == "WarehouseManagerApproval")
{
WFTransaction.LoadVariables(msg.Name, TranNo);
return("ViewGRN.aspx?TranNo=" + TranNo);
}
else if (msg.Name == "EditGRN")
{
WFTransaction.LoadVariables(msg.Name, TranNo);
return("ViewGRN.aspx?TranNo=" + TranNo);
}
else if (msg.Name == "EditGradeDispute")
{
WFTransaction.LoadVariables(msg.Name, TranNo);
return("EditGradeDispute.aspx?TranNo=" + TranNo);
}
else if (msg.Name == "ApproveReSampling")
{
WFTransaction.LoadVariables(msg.Name, TranNo);
return("EditReSampling.aspx?TranNo=" + TranNo);
}
else if (msg.Name == "OpenGRNForEdit")
{
WFTransaction.LoadVariables(msg.Name, TranNo);
return("OpenGRNEdit.aspx");
}
else if (msg.Name == "EditWHR")
{
WFTransaction.LoadVariables(msg.Name, TranNo);
return("ReCreateGRN.aspx");
}
else if (msg.Name == "CancelGRN" || msg.Name.Trim() == "ApproveCancelationRequest")
{
WFTransaction.LoadVariables(msg.Name, TranNo);
return("CancelGRN.aspx");
}
else if (msg.Name == "GetTrucksReadyForSam")
{
return("GetTrucksReadyForSampling.aspx");
}
else if (msg.Name == "ConfirmTrucksForSamp")
{
return("ConfirmTrucksForSampling.aspx");
}
else if (msg.Name == "Test")
{
return("Test1.aspx?Tran=" + TranNo);
}
else if (msg.Name.Trim() == "CodeSampRec")
{
WFTransaction.LoadVariables(msg.Name, TranNo);
return("ReceiveSampleCode.aspx");
}
else if (msg.Name.Trim() == "EditGradingResult")
{
WFTransaction.LoadVariables(msg.Name, TranNo);
return("EditGradingReceived.aspx?TrackingNo=" + TranNo.ToString());
}
else if (msg.Name.Trim() == "WHAppGRNEdit")
{
WFTransaction.LoadVariables(msg.Name, TranNo);
return("EditApprovedGRNEditRequest.aspx");
}
else if (msg.Name.Trim() == "OpenGRNForEdit")
{
WFTransaction.LoadVariables(msg.Name, TranNo);
return("OpenGRNEdit.aspx");
}
else if (msg.Name.Trim() == "UpdateGRNNo")
{
//GRN number edit
WFTransaction.LoadVariables(msg.Name, TranNo);
return("UpdateGRNNumber.aspx");
}
else if (msg.Name.Trim() == "UpdateClientNo")
{
//NoClient
WFTransaction.LoadVariables(msg.Name, TranNo);
string id = HttpContext.Current.Session["CommodityRequestId"].ToString();
return("EditCommodityDepositRequest.aspx?id=" + id);
}
else
{
return("");
}
}
protected void btnSearch_Click(object sender, EventArgs e)
{
#region co
//string taskNo = txtTaskNo.Text.Trim();
//if (taskNo != string.Empty)
//{
// XMLHelper objHelper = new XMLHelper(Session["Inboxpath"].ToString());
// InboxItems item = objHelper.SearchByInboxItemName(Session["WarehouseInboxItemName"].ToString());
// List<TransactionDetail> listDisplay = item.GetTransactions().Where(t => t.TrackNo == taskNo).ToList();
// if ("Select Trucks For Sampling" == Session["WarehouseInboxItemName"].ToString())
// {
// TransactionDetail obj = new TransactionDetail("", "");
// obj.DisplayName = "Select Trucks for Sampling";
// obj.TrackNo = "GetTrucksReadyForSam";
// listDisplay.RemoveAll(RemovePredicate);
// listDisplay.Add(obj);
// }
// else if ("Confirm Trucks For Sampling" == Session["WarehouseInboxItemName"].ToString())
// {
// TransactionDetail obj = new TransactionDetail("", "");
// obj.DisplayName = "Confirm Truks For Sampling";
// obj.TrackNo = "ConfirmTrucksForSamp";
// listDisplay.RemoveAll(RemovePredicate);
// listDisplay.Add(obj);
// }
// else if ("Assign Sampler".Trim() == Session["WarehouseInboxItemName"].ToString().Trim())
// {
// TransactionDetail obj = new TransactionDetail("", "");
// obj.DisplayName = "Assign Sampler";
// obj.TrackNo = "GetSampleTicket";
// listDisplay.RemoveAll(RemovePredicate);
// listDisplay.Add(obj);
// }
// this.gvDetail.DataSource = listDisplay;
// this.gvDetail.DataBind();
//}
#endregion
if (string.IsNullOrEmpty(txtTaskNo.Text))
{
msg.Text = "Please Provide Tracking No.";
return;
}
string strTR = txtTaskNo.Text.Trim();
ECXWF.ECXEngine eng = new WarehouseApplication.ECXWF.ECXEngine();
ECXWF.CMessage[] mess = null;
try
{
//eng.UnlockMessageByUser(Request.QueryString["TranNo"], "AddVoucherInformation", UserBLL.GetCurrentUser());
//eng.RemoveTransactionFromStack(Request.QueryString["TranNo"]);
mess = eng.Request(strTR, UserBLL.GetCurrentUser(), new string[] { WarehouseBLL.CurrentWarehouse.Location });
if (mess != null)
{
WFTransaction.UnlockTask(strTR);
List <TransactionDetail> lst = new List <TransactionDetail>(new TransactionDetail[] {
new TransactionDetail(strTR, strTR)
});
this.gvDetail.DataSource = lst;
this.gvDetail.DataBind();
}
else
{
msg.Text = "No Tracking number matchs the supplied criteria";
}
}
catch (Exception ex)
{
txtTaskNo.Text = "";
msg.Text = "Re-enter the Tracking No and Try Again";
//throw ex;
}
}
protected void btnComplete_Click(object sender, EventArgs e)
{
this.lblMessage.Text = "";
Nullable <Guid> Id = null;
string TransactionNo = "";
TransactionNo = Request.QueryString["TranNo"];
if (string.IsNullOrEmpty(TransactionNo))
{
return;
}
if (Session["CommodityRequestId"] == null)
{
CommodityDepositeRequestBLL objCDR = new CommodityDepositeRequestBLL();
objCDR = objCDR.GetCommodityDepositeDetailByTrackingNo(TransactionNo);
Id = objCDR.Id;
Session["CommodityRequestId"] = Id.ToString();
}
else
{
Id = new Guid(Session["CommodityRequestId"].ToString());
}
// if the Step is in Driver Info.
//if (WFTransaction.GetMessage(TransactionNo) == "AddDriverInformation")
//{
// WFTransaction.WorkFlowManager(TransactionNo);
//}
//Check if Driver Information is Added.
List <DriverInformationBLL> listDriverInfo = null;
DriverInformationBLL objDriverInfo = new DriverInformationBLL();
if (Session["CommodityRequestId"] != null)
{
Guid CdrId = new Guid(Session["CommodityRequestId"].ToString());
listDriverInfo = objDriverInfo.GetActiveDriverInformationByReceivigRequestId(CdrId);
if (listDriverInfo == null)
{
this.btnComplete.Enabled = false;
}
else
{
if (listDriverInfo.Count <= 0)
{
this.btnComplete.Enabled = false;
}
else
{
if (Id != null)
{
ECXWF.CMessage msg = (ECXWF.CMessage)HttpContext.Current.Session["msg"];
if (msg != null)
{
if (msg.Name == "AddDriverInformation")
{
WFTransaction.WorkFlowManager(TransactionNo);
Response.Redirect("ListInbox.aspx");
}
}
}
}
}
}
}
public static Nullable <Guid> GetRandomSamplingId(Guid WarehouseId)
{
Nullable <Guid> Id = null;
string strSql = "spGetDepositeRequestWaitingSampling";
SqlConnection conn = Connection.getConnection();
SqlParameter[] arPar = new SqlParameter[1];
List <SamplingBLL> list = null;
SqlDataReader reader;
try
{
arPar[0] = new SqlParameter("@WarehouseId", SqlDbType.UniqueIdentifier);
arPar[0].Value = WarehouseId;
String strId = "";
reader = SqlHelper.ExecuteReader(conn, CommandType.StoredProcedure, strSql, arPar);
if (reader.HasRows)
{
list = new List <SamplingBLL>();
while (reader.Read())
{
SamplingBLL objSampling = new SamplingBLL();
if (reader["ReceivigRequestId"] != DBNull.Value)
{
objSampling.Id = new Guid(reader["ReceivigRequestId"].ToString());
}
if (reader["TrackingNo"] != DBNull.Value)
{
objSampling.TrackingNo = reader["TrackingNo"].ToString();
}
list.Add(objSampling);
}
if (list.Count < 1)
{
return(null);
}
else
{
foreach (SamplingBLL o in list)
{
try
{
string strm = WFTransaction.GetMessage(o.TrackingNo);
if (strm.ToUpper() == "GetSampleTicket".ToUpper())
{
WFTransaction.UnlockTask(o.TrackingNo);
return(o.Id);
}
else
{
WFTransaction.UnlockTask(o.TrackingNo);
}
}
catch
{
}
}
}
}
else
{
return(null);
}
}
catch (NullReferenceException ex)
{
return(null);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (conn != null || conn.State == ConnectionState.Open)
{
conn.Close();
}
}
return(Id);
}
/// <summary>
///
/// </summary>
/// <param name="WarehouseId"></param>
/// <returns>Commodity Deposite Request</returns>
///
public static List <TrucksForSamplingBLL> GetRandomTrucksForSamplingId(Guid WarehouseId, int NumberOfTrucks)
{
List <TrucksForSamplingBLL> list = null;
string strSql = "spGetTrucksWaitingSampling";
SqlConnection conn = null;
SqlParameter[] arPar = new SqlParameter[2];
SqlDataReader reader = null;
arPar[0] = new SqlParameter("@WarehouseId", SqlDbType.UniqueIdentifier);
arPar[0].Value = WarehouseId;
arPar[1] = new SqlParameter("@top", SqlDbType.Int);
arPar[1].Value = NumberOfTrucks;
try
{
conn = Connection.getConnection();
reader = SqlHelper.ExecuteReader(conn, CommandType.StoredProcedure, strSql, arPar);
if (reader.HasRows)
{
list = new List <TrucksForSamplingBLL>();
int counter = 1;
while (reader.Read())
{
TrucksForSamplingBLL obj = new TrucksForSamplingBLL();
obj.WarehouseId = WarehouseId;
obj.ReceivigRequestId = new Guid(reader["Id"].ToString());
if (reader["DriverInformationId"] != DBNull.Value)
{
obj.DriverInformationId = new Guid(reader["DriverInformationId"].ToString());
}
else
{
obj.DriverInformationId = Guid.Empty;
}
obj.DateGenerated = DateTime.Now;
obj.SamplerInspectorId = UserBLL.GetCurrentUser();
obj.Status = TrucksForSamplingStatus.New;
obj.TrackingNo = reader["TrackingNo"].ToString();
obj.CreatedBy = UserBLL.GetCurrentUser();
obj.PlateNo = reader["PlateNumber"].ToString();
obj.TrailerPlateNo = reader["TrailerPlateNumber"].ToString();
if (obj.TrackingNo != "")
{
try
{
string strM = "";
strM = WFTransaction.GetMessage(obj.TrackingNo);
if (strM.ToUpper() == "GetTrucksReadyForSam".ToUpper())
{
if (counter <= NumberOfTrucks)
{
list.Add(obj);
counter++;
}
}
WFTransaction.UnlockTask(obj.TrackingNo);
}
catch
{
}
}
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
reader.Close();
if (conn != null)
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
}
}
return(list);
}
