public WarehouseRecieptBLL(GRNBLL obj)
{
this.GRNId = obj.Id;
this.GRNNumber = obj.GRN_Number;
this.CommodityGradeId = obj.CommodityGradeId;
this.WarehouseId = obj.WarehouseId;
this.BagTypeId = obj.BagTypeId;
//ToDO Remove
this.BagTypeId = new Guid();
this.VoucherId = obj.VoucherId;
this.UnloadingId = obj.UnLoadingId;
this.ScalingId = obj.ScalingId;
this.GradingId = obj.GradingId;
this.SampleTicketId = obj.SamplingTicketId;
this.DateDeposited = obj.DateDeposited;
this.DateApproved = obj.ApprovedTimeStamp;
this.GRN_Status = obj.Status;
//TODO - Get New
this.GrossWeight = obj.GrossWeight;
this.NetWeight = obj.NetWeight;
this.OriginalQuantity = obj.OriginalQuantity;
this.CurrentQuantity = obj.CurrentQuantity;
//TODO - Determine
this.DepositTypeId = new Guid();
this.Source = 1;
this.NetWeightAdjusted = this.NetWeight;
this.CreatedBy = UserBLL.GetCurrentUser();
this.CreatedTimestamp = DateTime.Now;
//To Remove
this.LastModifiedBy = UserBLL.GetCurrentUser();
this.LastModifiedTimestamp = DateTime.Now;
this.ClientId = obj.ClientId;
this.NoBags = obj.TotalNumberOfBags;
this.GRNType = obj.GRNTypeId;
this.ProductionYear = obj.ProductionYear;
this.ClientId = obj.ClientId;
this.BagTypeId = obj.BagTypeId;
this.ConsignmentType = obj.ConsignmentType;
this.RawValue = obj.RawValue;
this.CupValue = obj.CupValue;
if (obj.TotalValue <= 100)
{
this.TotalValue = obj.TotalValue;
}
else//>100 for speciallity coffee
{
this.TotalValue = obj.CupValue;
}
this.Woreda = obj.Woreda;
this.Shade = obj.Shade;
this.IsTracable = obj.IsTracable;
this.CarPlateNumber = obj.TruckPlateNumber;
this.TrailerPlateNumber = obj.TrailerPlateNumber;
this.ProcessingCenter = obj.ProcessingCenter;
this.ArrivalCert = obj.ArrivalCert;
}
public GRNBLL GetWarehouseReciptByGRNNumber(string GRNNumber)
{
GRNBLL objGrn = new GRNBLL();
DataRow dr;
try
{
dr = ECX.DataAccess.SQLHelper.getDataRow(conn, "Get_WarehouseReceiptRelatedByGRNNumber", GRNNumber);//GetGRN_Report_New
objGrn.CommodityRecivingId = new Guid(dr["ArrivalID"].ToString());
objGrn.Id = new Guid(dr["GRNID"].ToString());
objGrn.GRN_Number = dr["GRNNumber"].ToString();
objGrn.CommodityGradeId = new Guid(dr["CommodityGradeID"].ToString());
objGrn.WarehouseId = new Guid(dr["WarehouseID"].ToString());
objGrn.BagTypeId = new Guid(dr["BagTypeID"].ToString());
objGrn.GradingId = new Guid(dr["GradingID"].ToString());
objGrn.DateDeposited = DateTime.Parse(dr["DateDeposited"].ToString());
//objGrn.ApprovedTimeStamp=DateTime.Parse(dr["ApprovedTimeStamp"].ToString());
objGrn.ApprovedTimeStamp = DateTime.Now;
objGrn.Status = 4;// int.Parse(dr["GRNStatus"].ToString());
objGrn.GrossWeight = float.Parse(dr["GrossWeight"].ToString());
objGrn.NetWeight = float.Parse(dr["NetWeight"].ToString());
objGrn.OriginalQuantity = float.Parse(dr["OriginalQuantity"].ToString());
objGrn.CurrentQuantity = float.Parse(dr["CurrentQuantity"].ToString());
objGrn.HalfBagWeight = decimal.Parse(dr["HalfBagWeight"].ToString());
objGrn.NetWeightWithHalfBagWeight = decimal.Parse(dr["NetWeightWithHalfBagWeight"].ToString());
objGrn.ClientId = new Guid(dr["ClientID"].ToString());
objGrn.TotalNumberOfBags = int.Parse(dr["TotalNumberOfBags"].ToString());
objGrn.ProductionYear = int.Parse(dr["ProductionYear"].ToString());
//this.DepositTypeId = new Guid();
//NetWeight as NetWeightAdjested, ???
//objGrn.Source = 1;
//NetWeight as NetWeightAdjested, ???
objGrn.CreatedBy = UserBLL.GetCurrentUser();
objGrn.CreatedTimestamp = DateTime.Now;
objGrn.LastModifiedBy = UserBLL.GetCurrentUser();
objGrn.LastModifiedTimestamp = DateTime.Now;
objGrn.GRNTypeId = new Guid("03a15f0a-5cc0-4a10-9751-983b4a002665");
objGrn.VoucherId = Guid.Empty;
objGrn.ScalingId = Guid.Empty;
objGrn.UnLoadingId = Guid.Empty;
objGrn.SamplingTicketId = Guid.Empty;
}
catch (Exception ex)
{
throw new Exception(ex.Message.ToString());
}
return(objGrn);
}
public GRNBLL ApprovedGRNCancelGetbyByTrackingNo(string TrackingNo)
{
GRNBLL obj = new GRNBLL();
try
{
obj = GRNDAL.GetGRNbyGRNApprovedGRNCancelByTrackingNo(TrackingNo);
return(obj);
}
catch (Exception ex)
{
throw ex;
}
}
public GRNBLL GetbyGRN_Number(Guid GRN_number)
{
GRNBLL obj = new GRNBLL();
try
{
obj = GRNDAL.GetGRNbyGRN_Number(GRN_number);
return(obj);
}
catch (Exception ex)
{
throw ex;
}
}
public GRNBLL GetbyByTrackingNo(string TrackingNo)
{
GRNBLL obj = new GRNBLL();
try
{
obj = GRNDAL.GetGRNbyTrackingNo(TrackingNo);
if (obj == null)
{
obj = GRNDAL.GetGRNbyGRNEditTrackingNo(TrackingNo);
}
return(obj);
}
catch (Exception ex)
{
throw ex;
}
}
public WarehouseRecieptBLL(GRNBLL obj)
{
this.GRNId = obj.Id;
this.GRNNumber = obj.GRN_Number;
this.CommodityGradeId = obj.CommodityGradeId;
this.WarehouseId = obj.WarehouseId;
this.BagTypeId = obj.BagTypeId;
//ToDO Remove
this.BagTypeId = new Guid();
this.VoucherId = obj.VoucherId;
this.UnloadingId = obj.UnLoadingId;
this.ScalingId = obj.ScalingId;
this.GradingId = obj.GradingId;
this.SampleTicketId = obj.SamplingTicketId;
this.DateDeposited = obj.DateDeposited;
this.DateApproved = obj.ApprovedTimeStamp;
this.GRN_Status = obj.Status;
//TODO - Get New
this.GrossWeight = obj.GrossWeight;
this.NetWeight = obj.NetWeight;
this.OriginalQuantity = obj.OriginalQuantity;
this.CurrentQuantity = obj.CurrentQuantity;
this.NetWeightWithHalfBagWeight = obj.NetWeightWithHalfBagWeight;
this.HalfBagWeight = obj.HalfBagWeight;
//TODO - Determine
this.DepositTypeId = new Guid();
this.Source = 1;
this.NetWeightAdjusted = this.NetWeight;
this.CreatedBy = UserBLL.GetCurrentUser();
this.CreatedTimestamp = DateTime.Now;
//To Remove
this.LastModifiedBy = UserBLL.GetCurrentUser();
this.LastModifiedTimestamp = DateTime.Now;
this.ClientId = obj.ClientId;
this.NoBags = obj.TotalNumberOfBags;
this.GRNType = obj.GRNTypeId;
this.ProductionYear = obj.ProductionYear;
this.ClientId = obj.ClientId;
this.BagTypeId = obj.BagTypeId;
}
private static List <TransactionDetail> getDislayName(string[] TranArr, string FlowName, string StepName)
{
string str = "";
List <TransactionDetail> list;
for (int i = 0; i < TranArr.Count(); i++)
{
if (i < TranArr.Count() - 1)
{
str += "'" + TranArr[i].ToString() + "' ,";
}
else
{
str += "'" + TranArr[i].ToString() + "'";
}
}
list = new List <TransactionDetail>();
if (StepName == WFStepName.AddSamplingResult.ToString())
{
SamplingBLL objSampling = new SamplingBLL();
if (FlowName.Trim().ToUpper() == "WRCM".ToUpper())
{
TranArr = objSampling.GetMixedSamplingCodeBylistTrackingNo(str);
}
else
{
TranArr = objSampling.GetSamplingCodeBylistTrackingNo(str);
}
if (TranArr != null)
{
for (int x = 0; x < TranArr.Count(); x++)
{
string[] temp = TranArr[x].Split('*');
list.Add(new TransactionDetail(temp[0].Trim(), temp[1].Trim()));
}
}
return(list);
}
else if (StepName == WFStepName.GenerateGradingCode.ToString())
{
SamplingResultBLL objSampling = new SamplingResultBLL();
TranArr = objSampling.GetSamplingResultCodeBylistTrackingNo(str);
if (TranArr != null)
{
if (TranArr != null)
{
for (int x = 0; x < TranArr.Count(); x++)
{
string[] temp = TranArr[x].Split('*');
list.Add(new TransactionDetail(temp[0].Trim(), temp[1].Trim()));
}
}
}
// regrading
GradingDisputeBLL objGradeDispute = new GradingDisputeBLL();
TranArr = objGradeDispute.GetReGradingRequestbyTrackingNo(str);
if (TranArr != null)
{
if (TranArr != null)
{
for (int x = 0; x < TranArr.Count(); x++)
{
string[] temp = TranArr[x].Split('*');
list.Add(new TransactionDetail(temp[0].Trim(), temp[1].Trim()));
}
}
}
return(list);
}
else if (StepName == WFStepName.AddGradingResult.ToString())
{
GradingBLL objSampling = new GradingBLL();
TranArr = objSampling.GetGradingResultCodeBylistTrackingNo(str);
if (TranArr != null)
{
for (int x = 0; x < TranArr.Count(); x++)
{
string[] temp = TranArr[x].Split('*');
list.Add(new TransactionDetail(temp[0].Trim(), temp[1].Trim()));
}
}
return(list);
}
else if (StepName == WFStepName.GradingResultCA.ToString())
{
GradingBLL objSampling = new GradingBLL();
TranArr = objSampling.GetGradingResultCodeBylistTrackingNo(str);
if (TranArr != null)
{
for (int x = 0; x < TranArr.Count(); x++)
{
string[] temp = TranArr[x].Split('*');
list.Add(new TransactionDetail(temp[0].Trim(), temp[1].Trim()));
}
}
return(list);
}
else if (StepName == WFStepName.PreWeighTruck.ToString() || StepName == WFStepName.AddUnloadingInfo.ToString())
{
GradingResultBLL obj = new GradingResultBLL();
TranArr = obj.GetGradingResultResultCodeBylistTrackingNo(str);
if (TranArr != null)
{
for (int x = 0; x < TranArr.Count(); x++)
{
string[] temp = TranArr[x].Split('*');
list.Add(new TransactionDetail(temp[0].Trim(), temp[1].Trim()));
}
}
return(list);
}
else if (StepName == WFStepName.PostWeighTruck.ToString() || StepName == WFStepName.AddScalingInfo.ToString())
{
//TODO _ check hwewe
//post Weight que No.
GradingResultBLL obj = new GradingResultBLL();
TranArr = obj.GetGradingResultResultCodeBylistTrackingNo(str);
if (TranArr != null)
{
for (int x = 0; x < TranArr.Count(); x++)
{
string[] temp = TranArr[x].Split('*');
list.Add(new TransactionDetail(temp[0].Trim(), temp[1].Trim()));
}
}
return(list);
}
else if (StepName == WFStepName.AddGRN.ToString())
{
GRNBLL obj = new GRNBLL();
TranArr = obj.GetGradingResultResultCodeBylistTrackingNo(str);
if (TranArr != null)
{
for (int x = 0; x < TranArr.Count(); x++)
{
string[] temp = TranArr[x].Split('*');
list.Add(new TransactionDetail(temp[0].Trim(), temp[1].Trim()));
}
}
return(list);
}
else if (StepName == WFStepName.GRNAcceptance.ToString() && FlowName == "WHEditAppGRN")
{
GRNBLL obj = new GRNBLL();
TranArr = obj.GetGRNNoBylistEditTrackingNo(str);
if (TranArr != null)
{
for (int x = 0; x < TranArr.Count(); x++)
{
string[] temp = TranArr[x].Split('*');
list.Add(new TransactionDetail(temp[0].Trim(), temp[1].Trim()));
}
}
return(list);
}
else if (StepName == WFStepName.GRNAcceptance.ToString() && FlowName != "WHEditAppGRN")
{
GRNBLL obj = new GRNBLL();
TranArr = obj.GetGRNNoBylistTrackingNo(str);
if (TranArr != null)
{
for (int x = 0; x < TranArr.Count(); x++)
{
string[] temp = TranArr[x].Split('*');
list.Add(new TransactionDetail(temp[0].Trim(), temp[1].Trim()));
}
}
return(list);
}
//Update GRN
else if (StepName == WFStepName.UpdateGRNNo.ToString())
{
GRNBLL obj = new GRNBLL();
TranArr = obj.GetGRNNoBylistTrackingNo(str);
if (TranArr != null)
{
for (int x = 0; x < TranArr.Count(); x++)
{
string[] temp = TranArr[x].Split('*');
list.Add(new TransactionDetail(temp[0].Trim(), temp[1].Trim()));
}
}
return(list);
}
else if (StepName == WFStepName.WarehouseManagerAppr.ToString() && FlowName == "WHEditAppGRN")
{
GRNBLL obj = new GRNBLL();
TranArr = obj.GetGRNNoBylistEditTrackingNo(str);
if (TranArr != null)
{
for (int x = 0; x < TranArr.Count(); x++)
{
string[] temp = TranArr[x].Split('*');
list.Add(new TransactionDetail(temp[0].Trim(), temp[1].Trim()));
}
}
return(list);
}
else if (StepName == WFStepName.EditGRN.ToString() || StepName == WFStepName.WarehouseManagerAppr.ToString())
{
GRNBLL obj = new GRNBLL();
TranArr = obj.GetGRNNoBylistTrackingNo(str);
if (TranArr != null)
{
for (int x = 0; x < TranArr.Count(); x++)
{
string[] temp = TranArr[x].Split('*');
list.Add(new TransactionDetail(temp[0].Trim(), temp[1].Trim()));
}
}
return(list);
}
else if (StepName == WFStepsName.EditGradingResult.ToString())
{
string strTr;
GradingDisputeBLL objGrDisp = new GradingDisputeBLL();
TranArr = objGrDisp.GetReGradingRequestbyTrackingNo(str);
if (TranArr != null)
{
for (int x = 0; x < TranArr.Count(); x++)
{
string[] temp = TranArr[x].Split('*');
list.Add(new TransactionDetail(temp[0].Trim(), temp[1].Trim()));
}
}
return(list);
}
else if (StepName.ToUpper().Trim() == "CodeSampRec".ToUpper().Trim())
{
GradingBLL objSampling = new GradingBLL();
TranArr = objSampling.GetGradingResultCodeBylistTrackingNo(str);
if (TranArr != null)
{
for (int x = 0; x < TranArr.Count(); x++)
{
string[] temp = TranArr[x].Split('*');
list.Add(new TransactionDetail(temp[0].Trim(), temp[1].Trim()));
}
}
return(list);
}
else
{
for (int x = 0; x < TranArr.Count(); x++)
{
list.Add(new TransactionDetail(TranArr[x].Trim(), TranArr[x].Trim()));
}
return(list);
}
}
public bool Update(string GRN_number, GRNStatus Status, GRNBLL objGRN, string TrackingNo, DateTime ManagerApprovedDateTime)
{
bool isSaved = false;
SqlTransaction trans;
SqlConnection conn = new SqlConnection();
conn = Connection.getConnection();
trans = conn.BeginTransaction();
GRNStatus PreviousStatus;
PreviousStatus = (GRNStatus)objGRN.Status;
if (objGRN == null)
{
throw new Exception("Unable to Load GRN Data");
}
else
{
if (objGRN.Id == null || objGRN.Id == Guid.Empty)
{
throw new Exception("Invalid Grading Information ");
}
}
GradingBLL objGrading = new GradingBLL();
objGrading = objGrading.GetById(objGRN.GradingId);
objGrading.TrackingNo = TrackingNo;
if (Status != GRNStatus.Cancelled)
{
if (objGrading == null)
{
throw new Exception("Unable to Load GRN Data");
}
else
{
if (objGrading.TrackingNo == "")
{
throw new Exception("Unable to Load GRN Data");
}
else
{
TrackingNo = objGrading.TrackingNo;
}
}
}
try
{
if (Status == GRNStatus.ManagerApproved)
{
isSaved = GRNDAL.SetGRNStatus(GRN_number, Status, trans, ManagerApprovedDateTime);
if (isSaved == true)
{
int At = -1;
AuditTrailBLL objAt = new AuditTrailBLL();
string oldVal = "(GRNNo-" + GRN_number + ") , (Status-" + PreviousStatus.ToString() + ")";
string NewVal = "(GRNNo-" + GRN_number + ") , (Status-" + Status.ToString() + ")";
At = objAt.saveAuditTrailStringFormat(oldVal, NewVal, WFStepName.EditGRN.ToString(), UserBLL.GetCurrentUser(), "Change GRN Status");
if (At == 1)
{
WarehouseRecieptBLL objWarehouseReciept = new WarehouseRecieptBLL(objGRN);
if (objWarehouseReciept.Save() == true)
{
WFTransaction.WorkFlowManager(TrackingNo);
isSaved = true;
}
else
{
isSaved = false;
}
}
else
{
isSaved = false;
}
}
else
{
isSaved = false;
}
}
else if (Status == GRNStatus.Cancelled)
{
//Canceling Update
isSaved = false;
isSaved = GRNDAL.SetGRNStatus(GRN_number, Status, trans, ManagerApprovedDateTime);
if (isSaved == true)
{
int At = -1;
AuditTrailBLL objAt = new AuditTrailBLL();
string oldVal = "(GRNNo-" + GRN_number + ") , (Status-" + PreviousStatus.ToString() + ")";
string NewVal = "(GRNNo-" + GRN_number + ") , (Status-" + Status.ToString() + ")";
At = objAt.saveAuditTrailStringFormat(oldVal, NewVal, WFStepName.EditGRN.ToString(), UserBLL.GetCurrentUser(), "Change GRN Status");
if (At == 1)
{
ECXWF.CMessage msg = WFTransaction.Request(TrackingNo);
if (msg == null)
{
throw new Exception("Unable to get WF Data.");
}
else if (msg.Name.Trim() == "EditGRN")
{
WFTransaction.WorkFlowManager(TrackingNo, msg);
isSaved = true;
}
}
}
}
else
{
isSaved = false;
}
#region Depricatedcode
//// Cancel Implemented by web service.
//if (Status == GRNStatus.Cancelled)
//{
// WarehouseRecieptBLL objWarehouseReciept = new WarehouseRecieptBLL();
// isSaved = GRNDAL.UpdateGRN(GRN_number, Status, trans);
// if (isSaved == true)
// {
// //isSaved = objWarehouseReciept.Cancel(this.Id);
// if (isSaved == true)
// {
// int At = -1;
// AuditTrailBLL objAt = new AuditTrailBLL();
// string oldVal = "(GRNNo-" + GRN_number + ") , (Status-" + PreviousStatus.ToString() + ")";
// string NewVal = "(GRNNo-" + GRN_number + ") , (Status-" + Status.ToString() + ")";
// At = objAt.saveAuditTrailStringFormat(oldVal, NewVal, WFStepName.EditGRN.ToString(), UserBLL.GetCurrentUser(), "Change GRN Status");
// if (At == 1)
// {
// isSaved = true;
// }
// else
// {
// isSaved = false;
// }
// }
// }
// else
// {
// throw new Exception("Unable to Cancel GRN.");
// }
// if (isSaved == true)
// {
// WFTransaction.WorkFlowManager(TrackingNo);
// }
//}
#endregion
if (isSaved == true)
{
trans.Commit();
trans.Dispose();
conn.Close();
return(true);
}
else
{
trans.Rollback();
trans.Dispose();
conn.Close();
}
}
catch (Exception ex)
{
trans.Rollback();
throw ex;
}
finally
{
trans.Dispose();
conn.Close();
}
return(false);
}
private static bool isGRNEditable(Guid CommodityDepositeId)
{
GRNBLL objGRN = new GRNBLL();
return(objGRN.IsEditableGRN("CommodityRecivingId='" + CommodityDepositeId.ToString() + "'"));
}
public static void LoadVariables(string msg, string TrackingNo)
{
TrackingNo = TrackingNo.Trim();
if (msg.Trim() == WFStepsName.AddDriverInformation.ToString())
{
CommodityDepositeRequestBLL objCDR = new CommodityDepositeRequestBLL();
objCDR = objCDR.GetCommodityDepositeDetailByTrackingNo(TrackingNo);
if (objCDR != null)
{
HttpContext.Current.Session["CommodityRequestId"] = objCDR.Id;
}
else
{
throw new Exception("Can't load page variables,please try again.");
}
}
else if (msg.Trim() == WFStepsName.AddVoucherInfo.ToString())
{
CommodityDepositeRequestBLL objCDR = new CommodityDepositeRequestBLL();
objCDR = objCDR.GetCommodityDepositeDetailByTrackingNo(TrackingNo);
if (objCDR != null)
{
HttpContext.Current.Session["CommodityRequestId"] = objCDR.Id;
}
else
{
throw new Exception("Can't load page variables,please try again.");
}
}
else if (msg.Trim() == WFStepsName.AddDriverInformation.ToString())
{
CommodityDepositeRequestBLL objCDR = new CommodityDepositeRequestBLL();
objCDR = objCDR.GetCommodityDepositeDetailByTrackingNo(TrackingNo);
if (objCDR != null)
{
HttpContext.Current.Session["CommodityRequestId"] = objCDR.Id;
}
else
{
throw new Exception("Can't load page variables,please try again.");
}
}
else if (msg.Trim() == WFStepsName.AddVoucherInfo.ToString())
{
CommodityDepositeRequestBLL objCDR = new CommodityDepositeRequestBLL();
objCDR = objCDR.GetCommodityDepositeDetailByTrackingNo(TrackingNo);
if (objCDR != null)
{
HttpContext.Current.Session["CommodityRequestId"] = objCDR.Id;
}
else
{
throw new Exception("Can't load page variables,please try again.");
}
}
else if (msg.Trim() == WFStepsName.GetSampleTicket.ToString())
{
}
else if (msg.Trim() == WFStepsName.AddSamplingResult.ToString())
{
List <SamplingBLL> list = new List <SamplingBLL>();
SamplingBLL obj = new SamplingBLL();
list = obj.GetSamplesPenndingResultByTrackingNo(UserBLL.GetCurrentWarehouse(), TrackingNo);
if (list != null)
{
if (list.Count == 1)
{
obj = list[0];
HttpContext.Current.Session["SamplingReasultAddId"] = obj.Id;
}
}
}
else if (msg.Trim() == WFStepsName.AddSampleCoding.ToString())
{
//SamplingResultBLL obj = new SamplingResultBLL();
//obj = obj.GetSamplesResultsPendingCodingByTrackingNo(UserBLL.GetCurrentWarehouse(), TrackingNo);
//if (obj != null)
//{
// if (string.IsNullOrEmpty(obj.TrackingNo) != true)
// {
// HttpContext.Current.Session["GenerateCodeSampleId"] = obj.Id;
// }
// else
// {
// throw new Exception("Unable to get Record");
// }
//}
SamplingResultBLL objGrading = new SamplingResultBLL();
objGrading = objGrading.GetSamplesResultsPendingCodingByTrackingNo(UserBLL.GetCurrentWarehouse(), TrackingNo);
if (objGrading != null)
{
if (string.IsNullOrEmpty(objGrading.TrackingNo) != true)
{
HttpContext.Current.Session["GradingCodeId"] = objGrading.SamplingResultCode;
}
}
}
else if (msg.Trim() == WFStepsName.GenerateGradingCode.ToString())
{
SamplingResultBLL objGrading = new SamplingResultBLL();
objGrading = objGrading.GetSamplesResultsPendingCodingByTrackingNo(UserBLL.GetCurrentWarehouse(), TrackingNo);
if (objGrading != null)
{
if (string.IsNullOrEmpty(objGrading.TrackingNo) != true)
{
HttpContext.Current.Session["GradingCodeId"] = objGrading.SamplingResultCode;
HttpContext.Current.Session["GradingCodeTrackingNo"] = TrackingNo.ToString();
}
}
}
else if (msg.Trim() == WFStepsName.CodeSampRec.ToString())
{
GradingBLL objGrading = new GradingBLL();
List <GradingBLL> list = new List <GradingBLL>();
list = objGrading.GetGradingsPendingCodeReceivingByTrackingNo(UserBLL.GetCurrentWarehouse(), TrackingNo);
if (list != null)
{
if (list.Count == 1)
{
objGrading = list[0];
HttpContext.Current.Session["CodeSampleRecivedGradingId"] = objGrading.Id;
}
}
}
else if (msg.Trim() == WFStepsName.AddGradingResult.ToString())
{
GradingBLL objGrading = new GradingBLL();
List <GradingBLL> list = new List <GradingBLL>();
list = objGrading.GetGradingsPendingResultByTrackingNo(UserBLL.GetCurrentWarehouse(), TrackingNo);
if (list != null)
{
if (list.Count == 1)
{
objGrading = list[0];
HttpContext.Current.Session["GradingRecivedGradingId"] = objGrading.Id;
}
}
}
else if (msg.Trim() == WFStepsName.GradingResultCA.ToString())
{
GradingResultBLL objGrading = new GradingResultBLL();
objGrading = objGrading.GetGradingResultByTrackingNo(TrackingNo);
if (objGrading != null)
{
if (objGrading.ID != null)
{
HttpContext.Current.Session["GRID"] = objGrading.ID;
}
}
}
else if (msg.Trim() == WFStepsName.PreWeighTruck.ToString())
{
GradingResultBLL objGrading = new GradingResultBLL();
List <GradingResultBLL> list = new List <GradingResultBLL>();
list = objGrading.GetAcceptedresultsPendingUnloadingByTrackingNo(UserBLL.GetCurrentWarehouse(), TrackingNo);
if (list != null)
{
if (list.Count == 1)
{
objGrading = list[0];
HttpContext.Current.Session["AddUnLoadingId"] = objGrading.ID;
HttpContext.Current.Session["AddUnLoadingIdGradingCode"] = objGrading.GradingCode;
}
}
}
else if (msg.Trim() == WFStepsName.AddUnloadingInfo.ToString())
{
GradingResultBLL objGrading = new GradingResultBLL();
List <GradingResultBLL> list = new List <GradingResultBLL>();
list = objGrading.GetAcceptedresultsPendingUnloadingByTrackingNo(UserBLL.GetCurrentWarehouse(), TrackingNo);
if (list != null)
{
if (list.Count == 1)
{
objGrading = list[0];
HttpContext.Current.Session["AddUnLoadingId"] = objGrading.ID;
HttpContext.Current.Session["AddUnLoadingIdGradingCode"] = objGrading.GradingCode;
}
}
}
else if (msg.Trim() == WFStepsName.PostWeighTruck.ToString())
{
GradingResultBLL objGrading = new GradingResultBLL();
List <GradingResultBLL> list = new List <GradingResultBLL>();
list = objGrading.GetAcceptedresultsPendingScalingByTrackingNo(UserBLL.GetCurrentWarehouse(), TrackingNo);
if (list != null)
{
if (list.Count == 1)
{
objGrading = list[0];
HttpContext.Current.Session["AddScalingGradingCode"] = objGrading.GradingCode;
}
}
}
else if (msg.Trim() == WFStepsName.AddScalingInfo.ToString())
{
GradingResultBLL objGrading = new GradingResultBLL();
List <GradingResultBLL> list = new List <GradingResultBLL>();
list = objGrading.GetAcceptedresultsPendingScalingByTrackingNo(UserBLL.GetCurrentWarehouse(), TrackingNo);
if (list != null)
{
if (list.Count == 1)
{
objGrading = list[0];
HttpContext.Current.Session["AddScalingGradingCode"] = objGrading.GradingCode;
}
}
}
// ADD GRN
else if (msg.Trim() == WFStepsName.AddGRN.ToString())
{
GradingResultBLL objGrading = new GradingResultBLL();
objGrading = objGrading.GetGradingResultByTrackingNo(TrackingNo);
if (objGrading != null)
{
if (objGrading.ID != null)
{
HttpContext.Current.Session["GRNID"] = TrackingNo; // objGrading.ID;
}
}
}
else if (msg.Trim() == WFStepsName.GRNAcceptance.ToString())
{
GRNBLL objGRN = new GRNBLL();
objGRN = objGRN.GetbyByTrackingNo(TrackingNo);
if (objGRN != null)
{
if (objGRN.Id != null)
{
HttpContext.Current.Session["GRNID"] = objGRN.Id;
}
else
{
throw new Exception("Invalid GRN Id");
}
}
}
else if (msg.Trim() == WFStepsName.ClientAcceptance.ToString())
{
RequestforEditGRNBLL objGRN = new RequestforEditGRNBLL();
objGRN = objGRN.GetByTrackingNo(TrackingNo);
if (objGRN != null)
{
if (objGRN.Id != null)
{
HttpContext.Current.Session["GRNID"] = objGRN.GRNId;
}
else
{
throw new Exception("Invalid GRN Id");
}
}
}
//Update GRN
else if (msg.Trim() == WFStepsName.UpdateGRNNo.ToString())
{
GRNBLL objGRN = new GRNBLL();
objGRN = objGRN.GetbyByTrackingNo(TrackingNo);
if (objGRN != null)
{
if (objGRN.GRN_Number != null)
{
HttpContext.Current.Session["GRNIDUpdateGRNNo"] = objGRN.Id;
HttpContext.Current.Session["TrackingNoUpdateGRNNo"] = TrackingNo;
}
}
}
else if (msg.Trim() == WFStepsName.EditGRN.ToString())
{
GRNBLL objGRN = new GRNBLL();
objGRN = objGRN.GetbyByTrackingNo(TrackingNo);
if (objGRN != null)
{
if (objGRN.GRN_Number != null)
{
HttpContext.Current.Session["GRNID"] = objGRN.Id;
HttpContext.Current.Session["GRNTrackingNo"] = TrackingNo;
}
}
}
else if (msg.Trim() == WFStepsName.WarehouseManagerAppr.ToString())
{
RequestforEditGRNBLL objGRN = new RequestforEditGRNBLL();
objGRN = objGRN.GetByTrackingNo(TrackingNo);
if (objGRN != null)
{
if (objGRN.Id != null)
{
HttpContext.Current.Session["GRNID"] = objGRN.GRNId;
HttpContext.Current.Session["GRNTrackingNo"] = TrackingNo;
}
else
{
throw new Exception("Invalid GRN Id");
}
}
}
else if (msg.Trim() == WFStepsName.EditGradeDispute.ToString())
{
GradingDisputeBLL objGradeDispute = new GradingDisputeBLL();
objGradeDispute = objGradeDispute.GetByTransactionNo(TrackingNo);
if (objGradeDispute != null)
{
if (objGradeDispute.Id != null)
{
HttpContext.Current.Session["EditGradeDisputeId"] = objGradeDispute.Id;
}
}
}
else if (msg.Trim() == WFStepsName.ApproveReSampling.ToString())
{
ReSamplingBLL objReSampling = new ReSamplingBLL();
objReSampling = objReSampling.GetByTrackingNo(TrackingNo);
if (objReSampling != null)
{
if (objReSampling.Id != null)
{
HttpContext.Current.Session["ResamplingEdit"] = objReSampling.Id;
}
}
}
else if (msg.Trim() == WFStepsName.WHAppGRNEdit.ToString())
{
RequestforEditGRNBLL obj = new RequestforEditGRNBLL();
obj = obj.GetByTrackingNo(TrackingNo);
if (obj != null)
{
if (obj.Id != null)
{
HttpContext.Current.Session["GRNEditRequestId"] = obj.Id;
}
}
}
else if (msg.Trim() == WFStepsName.OpenGRNForEdit.ToString())
{
RequestforEditGRNBLL obj = new RequestforEditGRNBLL();
obj = obj.GetByTrackingNo(TrackingNo);
if (obj != null)
{
if (obj.Id != null)
{
HttpContext.Current.Session["OpenGRNEditId"] = obj.Id;
}
}
}
else if (msg.Trim() == WFStepsName.EditWHR.ToString().Trim())
{
RequestforEditGRNBLL obj = new RequestforEditGRNBLL();
obj = obj.GetByTrackingNo(TrackingNo);
if (obj != null)
{
if (obj.GRNId != null)
{
HttpContext.Current.Session["ReCreateGRNID"] = obj.GRNId;
HttpContext.Current.Session["ReCreateGRNTrackingNo"] = TrackingNo;
}
}
}
else if (msg.Trim() == "ApproveCancelationRequest".ToString().Trim() || (msg.Trim() == "CancelGRN"))
{
RequestforApprovedGRNCancelationBLL obj = new RequestforApprovedGRNCancelationBLL();
obj = obj.GetByTrackingNo(TrackingNo);
if (obj != null)
{
if (obj.GRNId != null)
{
HttpContext.Current.Session["CancelGRNTrackingNo"] = TrackingNo;
HttpContext.Current.Session["GRNID"] = obj.GRNId;
}
}
}
else if (msg.Trim() == WFStepsName.EditGradingResult.ToString().Trim())
{
GradingResultBLL objGradingResult = new GradingResultBLL();
HttpContext.Current.Session["GRID"] = null;
objGradingResult = objGradingResult.GetGradingResultByTrackingNo(TrackingNo.Trim());
if (objGradingResult != null)
{
HttpContext.Current.Session["GRID"] = objGradingResult.ID.ToString();
}
else
{
objGradingResult = new GradingResultBLL();
objGradingResult = objGradingResult.GetGradingResultByTrackingNoForGradeDispute(TrackingNo.Trim());
if (objGradingResult != null)
{
HttpContext.Current.Session["GRID"] = objGradingResult.ID.ToString();
}
}
}
else if (msg.Trim() == "UpdateClientNo")
{
//NoClient
CommodityDepositeRequestBLL objCDR = new CommodityDepositeRequestBLL();
objCDR = objCDR.GetCommodityDepositeDetailByTrackingNo(TrackingNo);
if (objCDR != null)
{
HttpContext.Current.Session["CommodityRequestId"] = objCDR.Id;
}
else
{
throw new Exception("Can't load page variables,please try again.");
}
}
}
