public bool save(List <GradingFactorGroupDetailBLL> list, SqlTransaction tran, Guid GroupId)
{
bool isSaved = false;
isSaved = GradingFactorGroupDetailDAL.save(list, tran, GroupId);
if (isSaved == true)
{
isSaved = false;
//Create audit Trail
int At = -1;
AuditTrailBLL objAt = new AuditTrailBLL();
string Str = "New Id - [";
foreach (GradingFactorGroupDetailBLL o in list)
{
Str += o.Id.ToString() + " , ";
}
Str += " ] ";
At = objAt.saveAuditTrailStringFormat("New Record-Grading Factor Group detail", Str, WFStepsName.GradingFactorGroupAd.ToString(), UserBLL.GetCurrentUser(), "Grading Factor Detail");
if (At == 1)
{
isSaved = true;
}
else
{
isSaved = false;
}
}
return(isSaved);
}
public bool UpdateGRNNumber(Guid Id, String oldSystemGRNNumber, string newSystemGRNNumber, string TrackingNo)
{
bool isSaved = true;
SqlTransaction trans;
SqlConnection conn = new SqlConnection();
conn = Connection.getConnection();
trans = conn.BeginTransaction();
try
{
isSaved = GRNDAL.UpDateGRNNumber(Id, oldSystemGRNNumber, newSystemGRNNumber, trans);
if (isSaved == true)
{
int at = -1;
AuditTrailBLL objAt = new AuditTrailBLL();
if (TrackingNo != "-1")
{
WFTransaction.WorkFlowManager(TrackingNo);
}
at = objAt.saveAuditTrailStringFormat("New System:GRN_Number = " + newSystemGRNNumber, "Old System :GRN_Number = " + oldSystemGRNNumber, "GRN No. Update ", UserBLL.GetCurrentUser(), WFStepName.UpdateGRNNo.ToString());
if (at == 1)
{
trans.Commit();
return(true);
}
else
{
trans.Rollback();
return(false);
}
}
else
{
trans.Rollback();
return(false);
}
}
catch (Exception ex)
{
trans.Rollback();
throw ex;
}
finally
{
if (trans != null)
{
trans.Dispose();
}
if (conn != null)
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
}
}
return(isSaved);
}
public bool ClientAcceptance(string GRN_number, DateTime AccptedTimeStamp, bool CAStatus, string TrackingNo, GRNStatus prevStatus)
{
bool isSaved = false;
SqlTransaction trans;
SqlConnection conn = new SqlConnection();
conn = Connection.getConnection();
trans = conn.BeginTransaction();
int status;
if (CAStatus == true)
{
status = 4;
}
else
{
status = 5;
}
try
{
isSaved = GRNDAL.ClientAcceptance(GRN_number, AccptedTimeStamp, CAStatus, status, trans);
if (isSaved == true)
{
int At = -1;
AuditTrailBLL objAt = new AuditTrailBLL();
string oldVal = "(GRNNo-" + GRN_number + ") , (Status-" + prevStatus.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)
{
WFTransaction.WorkFlowManager(TrackingNo);
}
else
{
isSaved = false;
}
}
if (isSaved == true)
{
trans.Commit();
trans.Dispose();
conn.Close();
return(true);
}
}
catch (Exception ex)
{
trans.Rollback();
trans.Dispose();
conn.Close();
throw ex;
}
return(false);
}
public bool Add(List <GradingResultDetailBLL> list, SqlTransaction trans, Nullable <Guid> Id)
{
bool isSaved = false;
if (Id == null)
{
trans.Rollback();
trans.Dispose();
return(false);
}
try
{
string str = "Grading Factors(";
foreach (GradingResultDetailBLL obj in list)
{
obj.GradingResultId = (Guid)Id;
obj.Id = Guid.NewGuid();
isSaved = GradingResultDetailDAL.InsertGradingResultDetail(obj, trans);
if (isSaved == false)
{
throw new Exception("Unable to insert Grading Factor Values");
}
else
{
str += "[Id-" + obj.Id.ToString() + " ,GradingResultId-" + obj.GradingResultId.ToString() +
" ,GradingFactorId-" + obj.GradingFactorId.ToString() + " , RecivedValue-" + obj.RecivedValue.ToString() +
" , Status-" + obj.Status.ToString() + ", CreateBy-" + UserBLL.GetCurrentUser() + "];";
}
}
str += ")";
isSaved = true;
AuditTrailBLL objAt = new AuditTrailBLL();
int at = -1;
at = objAt.saveAuditTrailStringFormat(str, "New data Added", WFStepName.AddGradingResult.ToString(), UserBLL.GetCurrentUser(), "Add Grading Factor Values");
if (at != 1)
{
isSaved = false;
throw new Exception("Unbale to add Audit Trail-Grading Factor Value.");
}
else
{
isSaved = true;
}
}
catch (Exception ex)
{
throw ex;
}
return(isSaved);
}
public bool Cancel(Guid Id)
{
bool isSaved = false;
SqlTransaction tran = null;
SqlConnection conn = null;
int at = -1;
try
{
conn = Connection.getConnection();
tran = conn.BeginTransaction();
isSaved = GRNServiceDAL.Cancel(Id, tran);
if (isSaved == true)
{
AuditTrailBLL objAt = new AuditTrailBLL();
at = objAt.saveAuditTrailStringFormat("[Id=" + Id.ToString() + ",Status=Active]", "[Id=" + Id.ToString() + ",Status=Cancelled]", WFStepsName.GRNServiceCancel.ToString(), UserBLL.GetCurrentUser(), "Cancel GRN service");
if (at == 1)
{
tran.Commit();
isSaved = true;
}
else
{
tran.Rollback();
isSaved = false;
}
}
else
{
tran.Rollback();
return(false);
}
}
catch (Exception ex)
{
tran.Rollback();
throw ex;
}
finally
{
if (tran != null)
{
tran.Dispose();
}
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
}
return(isSaved);
}
public bool Inactive(Guid Id)
{
bool isSaved = false;
SqlTransaction tran = null;
SqlConnection conn = null;
conn = Connection.getConnection();
tran = conn.BeginTransaction();
try
{
isSaved = CommodityGradingFactorDAL.Inactive(Id, tran);
if (isSaved == true)
{
int At = -1;
AuditTrailBLL objAt = new AuditTrailBLL();
At = objAt.saveAuditTrailStringFormat("", Id.ToString() + " - Staus set to Canceled", WFStepsName.CommmodityGradingFactor.ToString(), UserBLL.GetCurrentUser(), "Cancel Comm. Grading factor");
if (At == 1)
{
isSaved = true;
}
else
{
isSaved = false;
}
}
else
{
tran.Rollback();
}
if (isSaved == true)
{
tran.Commit();
}
else
{
tran.Rollback();
}
return(isSaved);
}
catch (Exception ex)
{
tran.Rollback();
throw ex;
}
finally
{
}
}
public bool Save(Guid GRNId, List <GRNServiceBLL> list, SqlTransaction tran)
{
bool isSaved = false;
int at = -1;
try
{
isSaved = GRNServiceDAL.Insert(GRNId, list, tran);
if (isSaved == true)
{
isSaved = false;
string strAt = "GRN service [";
foreach (GRNServiceBLL o in list)
{
strAt += "(Id=" + o.Id.ToString() + ", ";
strAt += "ServiceId=" + o.ServiceId.ToString() + ", ";
strAt += "Quantity=" + o.Quantity.ToString() + ", ";
strAt += "Status=" + o.Status.ToString() + " );";
}
strAt += "]";
AuditTrailBLL objAt = new AuditTrailBLL();
at = objAt.saveAuditTrailStringFormat(strAt, "New data Added", WFStepsName.GRNServiceAdd.ToString(), UserBLL.GetCurrentUser(), " Add GRN service ");
if (at != 1)
{
isSaved = false;
}
else
{
isSaved = true;
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
}
return(isSaved);
}
public bool Add(SqlTransaction tran, List <StackUnloadedBLL> list, Guid Id)
{
if (list != null && list.Count > 0)
{
string strAt = "Stack Unloaded ";
foreach (StackUnloadedBLL o in list)
{
o.UnloadingId = Id;
if (StackUnloadedDAL.InsertStackUnloaded(o, tran) == false)
{
return(false);
}
else
{
UpdateInventory(o.StackId, o.NumberOfbags, 0, tran);
strAt += "[ ";
strAt += "(Id-" + o.Id.ToString() + ") , ";
strAt += "(UnloadingId-" + o.UnloadingId.ToString() + ") , ";
strAt += "(StackId-" + o.StackId.ToString() + "), ";
strAt += "(NumberOfBags-" + o.NumberOfbags.ToString() + "), ";
strAt += "(Status-" + o.Status.ToString() + "), ";
strAt += "(UnloadedBy-" + o.UserId.ToString() + "), ";
strAt += "(Remark-" + o.Remark.ToString() + "), ";
strAt += "(CreatedBy-" + o.CreatedBy.ToString() + ") ";
strAt += " ]";
}
}
int at = -1;
AuditTrailBLL objAt = new AuditTrailBLL();
at = objAt.saveAuditTrailStringFormat("New Data Added", strAt, WFStepsName.AddUnloadingInfo.ToString(), UserBLL.GetCurrentUser(), "Add statck Unloaded");
if (at == 1)
{
return(true);
}
else
{
return(false);
}
}
else
{
return(false);
}
}
//oublic Functions
public bool Add(Guid Id, List <GradingByBLL> list, SqlTransaction tran)
{
if (list.Count > 0)
{
try
{
string strAt = "";
foreach (GradingByBLL i in list)
{
bool isSaved = false;
i.GradingId = Id;
isSaved = GradingByDAL.InsertGraders(i, tran);
if (isSaved == false)
{
return(false);
}
else
{
strAt += "[(Id-" + i.Id.ToString() + "),(GradingId-" + i.GradingId.ToString() + "),(UserId-" +
i.UserId.ToString() + "),(Status-" + i.Status.ToString() + "),(isSupervisor-" + isSupervisor.ToString() + "),(CreatedBy"
+ UserBLL.GetCurrentUser().ToString() + ")] ; ";
}
}
int at = -1;
AuditTrailBLL objAt = new AuditTrailBLL();
at = objAt.saveAuditTrailStringFormat("New Data added", strAt, WFStepsName.GenerateGradingCode.ToString(), UserBLL.GetCurrentUser(), "Add Grader");
if (at == 1)
{
return(true);
}
else
{
return(false);
}
}
catch
{
new Exception("Unable to Add Graders.");
}
}
return(false);
}
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);
}
public Boolean UpdateManagerApproval(SamplingResultBLL oldObj)
{
// TODO : Check Sampling is Completed - check if Code is generated.
bool isSaved = false;
SqlTransaction tran = null;
SqlConnection conn = null;
AuditTrailBLL objat = new AuditTrailBLL();
int at = -1;
try
{
conn = Connection.getConnection();
tran = conn.BeginTransaction();
this.LastModifiedBy = UserBLL.GetCurrentUser();
isSaved = SamplingResultDAL.UpdateManagerApproval(this, tran);
if (isSaved == true)
{
if (oldObj == null)
{
throw new Exception("Invalid Old object-UpdateManagerApproval Method.");
}
string strOld = "(Id-" + oldObj.Id.ToString() + ")," + "(Status-" + oldObj.Status.ToString() + "),(LastModifiedBy-" + oldObj.LastModifiedBy.ToString() + ")";
string strNew = "(Id-" + this.Id.ToString() + ")," + "(Status-" + this.Status.ToString() + "),(LastModifiedBy-" + this.LastModifiedBy.ToString() + ")";
strNew += "(ManagerApprovalRemark-" + this.ManagerApprovalRemark + "),(LastModifiedTimestamp-" + this.LastModifiedTimestamp.ToString() + ")";
at = objat.saveAuditTrailStringFormat(strOld, strNew, WFStepsName.EditSamplingResult.ToString(), UserBLL.GetCurrentUser(), "Edit Sampling Result");
if (at == 1)
{
if ((oldObj.Status == SamplingResultStatus.New) && (this.Status == SamplingResultStatus.Approved))
{
ECXWF.CMessage mess = WFTransaction.Request(this.TrackingNo);
HttpContext.Current.Session["msg"] = mess;
if (mess.Name.Trim().ToUpper() == "AddSamplingResult".ToUpper())
{
WFTransaction.WorkFlowManager(this.TrackingNo);
}
else
{
throw new Exception("The Task has already been done.");
}
}
else if ((oldObj.Status == SamplingResultStatus.New) && (this.Status == SamplingResultStatus.Cancelled))
{
ECXWF.CMessage mess = WFTransaction.Request(this.TrackingNo);
HttpContext.Current.Session["msg"] = mess;
if (mess.Name.Trim().ToUpper() == "AddSamplingResult".ToUpper())
{
WFTransaction.Close(this.TrackingNo);
}
else
{
throw new Exception("The Task has already been done.");
}
}
}
else
{
objat.RoleBack();
tran.Rollback();
isSaved = false;
}
if (at == 1)
{
tran.Commit();
}
else
{
isSaved = false;
tran.Rollback();
}
}
return(isSaved);
}
catch (Exception ex)
{
if (at == 1)
{
objat.RoleBack();
}
tran.Rollback();
throw ex;
}
finally
{
tran.Dispose();
conn.Close();
}
}
public bool Confirm(List <TrucksForSamplingBLL> list)
{
SqlTransaction tran;
SqlConnection conn;
conn = Connection.getConnection();
tran = conn.BeginTransaction();
//List<MesseageTracking> msgList = new List<MesseageTracking>();
//msgList = (List<MesseageTracking>)HttpContext.Current.Session["msgList"];
try
{
bool isSaved = false;
foreach (TrucksForSamplingBLL obj in list)
{
if (obj.Status == TrucksForSamplingStatus.Confirmed)
{
ECXWF.CMessage msg = null;
try
{
msg = WFTransaction.Request(obj.TrackingNo.ToString().Trim());
}
catch
{
msg = null;
}
if (msg != null)
{
if (msg.Name.Trim().ToUpper() == "ConfirmTrucksForSamp".ToUpper().Trim())
{
isSaved = TrucksForSamplingDAL.UpdateConfirmation(obj, tran);
if (isSaved == true)
{
string strNew = "(Id=" + obj.Id.ToString() + "),(Status-" + obj.Status.ToString() + "),(Remark-" + obj.Remark.ToString() + "),(LastModifiedBy-" + UserBLL.GetCurrentUser().ToString() + "),(LastModifiedTimeStamp-" + DateTime.Now.ToString() + ")";
int at = -1;
AuditTrailBLL objAt = new AuditTrailBLL();
at = objAt.saveAuditTrailStringFormat("Truck Ready For Sampling Confirmed", strNew, WFStepsName.ConfirmTrucksForsamp.ToString(), UserBLL.GetCurrentUser(), "Confirm Trucks for sampling");
if (at == 1)
{
#region depricatedcode
//var xmsg = (from c in msgList
// where c.trackingNo == obj.TrackingNo
// select c.message).Single();
//ECXWF.CMessage msg = (ECXWF.CMessage)xmsg;
//foreach (MesseageTracking i in msgList)
//{
// if (i.trackingNo.Trim().ToUpper() == obj.TrackingNo.Trim().ToUpper())
// {
// msg = i.message;
// }
//}
//if (msg == null)
//{
// throw new Exception("Invalid Message Exception");
//}
#endregion
WFTransaction.WorkFlowManager(obj.TrackingNo.Trim(), msg);
}
else
{
isSaved = false;
}
}
else
{
isSaved = false;
}
}
else
{
WFTransaction.UnlockTask(obj.TrackingNo.Trim());
}
}
}
else
{
TrucksMissingOnSamplingBLL objTM = new TrucksMissingOnSamplingBLL();
objTM.Id = Guid.NewGuid();
objTM.TrucksForSamplingId = obj.Id;
objTM.DateTimeReported = DateTime.Now;
objTM.Remark = obj.Remark;
objTM.Status = TrucksMissingOnSamplingStatus.New;
objTM.CreatedBy = UserBLL.GetCurrentUser();
objTM.CreatedTimestamp = DateTime.Now;
objTM.WarehouseId = UserBLL.GetCurrentWarehouse();
objTM.TrackingNo = obj.TrackingNo;
isSaved = objTM.Save(tran);
}
if (isSaved == false)
{
tran.Rollback();
return(false);
}
}
tran.Commit();
}
catch (Exception ex)
{
tran.Rollback();
throw ex;
}
finally
{
tran.Dispose();
conn.Close();
}
return(true);
}
public bool UpdateGradingResult(List <GradingResultDetailBLL> list, Nullable <Guid> Id, string TrackingNo)
{
bool isSaved = false;
SqlConnection conn = Connection.getConnection();
SqlTransaction tran = conn.BeginTransaction();
this.WarehouseId = UserBLL.GetCurrentWarehouse();
if (Id != null)
{
try
{
this.ID = (Guid)Id;
if (GradingResultDAL.InactivateGradingResultDetails(this.ID, tran) == true)
{
int at = -1;
AuditTrailBLL objAt = new AuditTrailBLL();
string strNew = "(Grading Result Id -" + this.ID.ToString() + "),(LastModifiedby-" + UserBLL.GetCurrentUser().ToString() + "),(LastModifiedTimeStamp-" + DateTime.Now.ToString() + ")";
at = objAt.saveAuditTrailStringFormat("Grading Factor Details Cancelled", strNew, WFStepsName.EditGradingResultDet.ToString(), UserBLL.GetCurrentUser(), "Cancel Grading Result Detail");
if (at == -1)
{
tran.Rollback();
isSaved = false;
}
else
{
GradingResultBLL objGR = new GradingResultBLL();
objGR = objGR.GetGradingResultById(this.ID);
if (GradingResultDAL.UpdateGradingResult(this, tran) == true)
{
AuditTrailBLL objAtGR = new AuditTrailBLL();
at = objAtGR.saveAuditTrail(objGR, this, WFStepsName.EditGradingResult.ToString(), UserBLL.GetCurrentUser(), "Updating Grading Result");
if (at == -1)
{
tran.Rollback();
isSaved = false;
return(isSaved);
}
GradingResultDetailBLL objDetail = new GradingResultDetailBLL();
isSaved = objDetail.Add(list, tran, Id);
if (isSaved == true)
{
//Request
ECXWF.CMessage msg = WFTransaction.Request(TrackingNo);
if (msg != null)
{
if (msg.Name == "EditGradingResult")
{
WFTransaction.WorkFlowManager(TrackingNo, msg);
}
}
}
if (isSaved == false)
{
tran.Rollback();
isSaved = false;
}
else
{
tran.Commit();
isSaved = true;
}
}
else
{
tran.Rollback();
isSaved = false;
}
}
}
else
{
tran.Rollback();
isSaved = false;
}
}
catch (Exception ex)
{
tran.Rollback();
throw ex;
}
finally
{
tran.Dispose();
conn.Close();
}
}
return(isSaved);
}