public bool Save(SqlTransaction tran)
{
bool isSaved = false;
try
{
isSaved = TrucksMissingOnSamplingDAL.Insert(this, tran);
if (isSaved == true)
{
int at = -1;
AuditTrailBLL objAt = new AuditTrailBLL();
at = objAt.saveAuditTrail(this, WFStepsName.ConfirmTrucksForsamp.ToString(), UserBLL.GetCurrentUser(), "Missing On Confirmation");
if (at != 1)
{
isSaved = false;
}
}
}
catch (Exception ex)
{
throw ex;
}
return(isSaved);
}
public bool UpdateStatus()
{
bool isSaved = false;
SqlTransaction tran = null;
SqlConnection conn = null;
int at = -1;
try
{
TrucksMissingOnSamplingBLL objNew = new TrucksMissingOnSamplingBLL();
TrucksMissingOnSamplingBLL objOld = TrucksMissingOnSamplingDAL.GetById(this.Id);
objNew = objOld.Copy(objOld);
objNew.Id = this.Id;
objNew.Status = this.Status;
conn = Connection.getConnection();
tran = conn.BeginTransaction();
isSaved = TrucksMissingOnSamplingDAL.SetStatus(objNew.Id, objNew.Status, tran);
if (isSaved == true)
{
AuditTrailBLL objAt = new AuditTrailBLL();
at = objAt.saveAuditTrail(objNew, objOld, WFStepsName.TrucksMissingForSamp.ToString(), UserBLL.GetCurrentUser(), "Update Status Missing Traucks");
if (at == 1)
{
tran.Commit();
}
else
{
tran.Rollback();
isSaved = false;
}
}
else
{
isSaved = false;
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (tran != null)
{
tran.Dispose();
}
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
}
return(isSaved);
}
public List <TrucksMissingOnSamplingBLL> GetAbsentTrucks(Guid Warehouseid)
{
return(TrucksMissingOnSamplingDAL.GetAbsentTrucks(Warehouseid));
}
