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 ReCreateGRN()
{
bool isSaved = false;
SqlTransaction trans;
SqlConnection conn = new SqlConnection();
conn = Connection.getConnection();
trans = conn.BeginTransaction();
string TrakingNo = "";
TrakingNo = this.TrackingNo;
//RequestforEditGRNBLL objRequest = null;
this.Status = (int)GRNStatus.New;
//objRequest = RequestforEditGRNDAL.GetApprovedRequestByGRNID(this.Id);
//if (objRequest != null)
//{
// if (string.IsNullOrEmpty(objRequest.TrackingNo) == false)
// {
// TrakingNo = objRequest.TrackingNo;
// }
// else
// {
// throw new Exception("Unable to get GRN edit request data");
// }
//}
//else
//{
// throw new Exception("Unable to get GRN edit request data");
//}
try
{
isSaved = GRNDAL.ReCreate(this, trans);
if (isSaved == true)
{
WFTransaction.WorkFlowManager(TrakingNo);
}
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 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 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 List <GRNBLL> GetPendingGRNByTrackingNo(Guid Warehouseid, string TrackingNo)
{
if (this.WarehouseId == null)
{
throw new Exception("Invalid WarehouseId Exception");
}
try
{
List <GRNBLL> list = new List <GRNBLL>();
list = GRNDAL.GetGRNPendingCreationByTrackingNoByTrackingNo(Warehouseid, TrackingNo);
return(list);
}
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 bool CanCreateGRNforGradingId(Guid GradingId)
{
int count = -1;
count = GRNDAL.GetCountByGradingId(GradingId);
if (count == -1)
{
throw new IndeterminateGRNCountException("Can Not determine if a GRN is Created for this Code.");
}
else if (count > 0)
{
throw new MultipleGRNForSingleGradingCodeException();
}
else
{
return(true);
}
}
public List <GRNListBLL> Search(string GRN, string TrackingNo, Nullable <Guid> ClientId, Nullable <Guid> CommodityId, Nullable <Guid> CommoidtyClassId, Nullable <Guid> CommodityGradeId, Nullable <GRNStatus> Status, Nullable <DateTime> From, Nullable <DateTime> To)
{
List <GRNListBLL> lstGRNlist = null;
List <GRNBLL> GRNlist = new List <GRNBLL>();
// check search parameters are there.
if ((string.IsNullOrEmpty(GRN) == true) && (string.IsNullOrEmpty(TrackingNo) == true) && (ClientId == null) && (CommodityId == null) && (CommoidtyClassId == null) && (CommodityGradeId == null) && (Status == null) && (From == null) && (To == null))
{
throw (new NULLSearchParameterException("No Search parameter"));
}
GRNlist = GRNDAL.Search(GRN, TrackingNo, ClientId, CommodityId, CommodityClassId, CommodityGradeId, Status, From, To);
if (GRNlist != null)
{
if (GRNlist.Count > 0)
{
lstGRNlist = new List <GRNListBLL>();
GRNListBLL oblGRNList = new GRNListBLL();
foreach (GRNBLL o in GRNlist)
{
GRNListBLL obj = new GRNListBLL();
obj.Id = o.Id;
obj.GRN = o.GRN_Number;
obj.CommodityId = o.CommodityId;
obj.CommodityClassId = o.CommodityClassId;
obj.CommodityGradeId = o.CommodityGradeId;
obj.Status = (GRNStatus)o.Status;
obj.ClinetName = ClientBLL.GetClinetNameById(o.ClientId);
obj.OriginalQuantity = o.OriginalQuantity;
obj.DateDeposited = Convert.ToDateTime(o.DateDeposited.ToShortDateString());
lstGRNlist.Add(obj);
}
}
else
{
return(null);
}
}
return(lstGRNlist);
}
public bool HasGRN(string tableName, Guid Id)
{
int count = -1;
try
{
count = GRNDAL.HasGRN(tableName, Id);
if (count == 0)
{
return(false);
}
else
{
return(true);
}
}
catch
{
return(true);
}
}
public bool AllowGRNEdit(RequestforEditGRNStatus oldStatus, RequestforEditGRNBLL old)
{
//Update Status accordingly.
//Set GRN Status to On Edit
bool isSaved = false;
SqlConnection conn = null;
SqlTransaction tran = null;
try
{
conn = Connection.getConnection();
tran = conn.BeginTransaction();
isSaved = RequestforEditGRNDAL.Update(tran, this);
isSaved = GRNDAL.UpdateGRNStatus(this.GRN_Number, GRNStatus.OpenForEdit, tran);
if (this.Status == RequestforEditGRNStatus.Approved && oldStatus == RequestforEditGRNStatus.Approved)
{
// Update GRN Status to OpenForEdit
if (isSaved == true)
{
int at = -1;
AuditTrailBLL objat = new AuditTrailBLL();
at = objat.saveAuditTrail(old, this, WFStepsName.RequestforEditGRN.ToString(), UserBLL.GetCurrentUser(), "Open GRN for Edit");
if (at == 1)
{
WFTransaction.WorkFlowManager(this.TrackingNo);
tran.Commit();
}
else
{
tran.Rollback();
isSaved = false;
}
}
else
{
isSaved = false;
tran.Rollback();
}
}
else if (this.Status == RequestforEditGRNStatus.Cancelled)
{
WFTransaction.Close(this.TrackingNo);
isSaved = true;
}
}
catch (Exception ex)
{
tran.Rollback();
throw new Exception("Unable to update Data.", ex);
}
finally
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
if (tran != null)
{
tran.Dispose();
}
}
return(isSaved);
}
public String[] GetGRNNoBylistEditTrackingNo(string TrackingNo)
{
return(GRNDAL.GetGRNNoBylistEditTrackingNoForGRN(TrackingNo));
}
public bool IsEditableGRN(string whereClause)
{
return(GRNDAL.IsEditableGRN(whereClause));
}
public static bool IsEditableGRNByTrackingNo(string TrackingNo)
{
return(GRNDAL.IsEditableGRNByTrackingNo(TrackingNo));
}
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);
}
/// <summary>
/// Gets the net weight by deducting the tare
/// </summary>
/// <param name="GrossWeight"></param>
/// <param name="BagTypeId"></param>
/// <param name="NoBags"></param>
/// <returns></returns>
///
public Nullable <Guid> Add(List <GRNServiceBLL> listGRNService)
{
bool IsSaved = false;
bool canCreate = false;;
try
{
canCreate = this.CanCreateGRNforGradingId(this.GradingId);
}
catch (Exception ex)
{
throw ex;
}
if (canCreate == false)
{
return(null);
}
Nullable <Guid> id = null;
SqlTransaction tran;
string warehousecode;
warehousecode = WarehouseBLL.GetWarehouseCode(this.WarehouseId);
SqlConnection conn = new SqlConnection();
conn = Connection.getConnection();
tran = conn.BeginTransaction();
try
{
id = GRNDAL.InsertNewGRN(this, warehousecode, tran);
if (id != null)
{
if (listGRNService != null)
{
GRNServiceBLL objSer = new GRNServiceBLL();
IsSaved = objSer.Save((Guid)id, listGRNService, tran);
//Audit Trail Both GRN And GRN Service.
int at = -1;
AuditTrailBLL objAt = new AuditTrailBLL();
this.Id = (Guid)id;
at = objAt.saveAuditTrail(this, WFStepsName.AddGRN.ToString(), UserBLL.GetCurrentUser(), "Add New GRN");
if (at == 1)
{
IsSaved = true;
}
else
{
IsSaved = false;
}
}
else
{
IsSaved = true;
}
if (IsSaved == true)
{
WFTransaction.WorkFlowManager(this.TrackingNo);
tran.Commit();
}
else
{
tran.Rollback();
}
}
else
{
tran.Rollback();
}
}
catch (Exception ex)
{
tran.Rollback();
throw new Exception("Unable to update database.", ex);
}
finally
{
tran.Dispose();
conn.Close();
}
return(id);
}
public String[] GetGradingResultResultCodeBylistTrackingNo(string TrackingNo)
{
return(GRNDAL.GetParentCodeBylistTrackingNo(TrackingNo));
}
