public void LoadSamplingRealtedData(Guid SamplingResultId, DateTime RecivedDateTime)
{
ReSamplingBLL obj = new ReSamplingBLL();
obj = ReSamplingDAL.GetSamplingRelatedDataBySamplingResultId(SamplingResultId);
this.SamplingId = obj.SamplingId;
this.SamplingResultId = obj.SamplingResultId;
this.ReceivigRequestId = obj.ReceivigRequestId;
this.DateTimeRequested = RecivedDateTime;
}
public bool Update()
{
bool isSaved = false;
SqlTransaction trans;
SqlConnection conn = new SqlConnection();
conn = Connection.getConnection();
trans = conn.BeginTransaction();
ReSamplingBLL objold = new ReSamplingBLL();
objold = objold.GetById(this.Id);
if (objold == null)
{
throw new Exception("Invalid Old Value exception");
}
try
{
isSaved = ReSamplingDAL.Update(this, trans);
if (isSaved == true)
{
int at = -1;
AuditTrailBLL objAt = new AuditTrailBLL();
at = objAt.saveAuditTrail(objold, this, WFStepsName.EditResampling.ToString(), UserBLL.GetCurrentUser(), "Update Resampling");
if (at == 1)
{
if (this.Status == ReSamplingStatus.Approved)
{
WFTransaction.WorkFlowManager(this.TrackingNo);
}
else if (this.Status == ReSamplingStatus.Cancelled)
{
WFTransaction.Close(this.TrackingNo);
}
trans.Commit();
return(true);
}
else
{
trans.Commit();
return(false);
}
}
else
{
trans.Rollback();
return(false);
}
}
catch (Exception ex)
{
trans.Rollback();
throw new Exception("Unable to Update Data", ex);
}
finally
{
trans.Dispose();
if (conn.State == System.Data.ConnectionState.Open)
{
conn.Close();
}
}
}
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.");
}
}
}
