public bool Add()
{
bool issaved = false;
SqlTransaction tran = null;
SqlConnection conn = null;
try
{
this.Id = Guid.NewGuid();
conn = Connection.getConnection();
tran = conn.BeginTransaction();
issaved = StackDAL.InsertStack(this, tran);
if (issaved == true)
{
int at = -1;
AuditTrailBLL objAt = new AuditTrailBLL();
at = objAt.saveAuditTrail(this, WFStepsName.Stack.ToString(), UserBLL.GetCurrentUser(), "Add Stack");
if (at == 1)
{
tran.Commit();
issaved = true;
}
else
{
tran.Rollback();
issaved = false;
}
}
else
{
tran.Rollback();
issaved = false;
}
}
catch (Exception ex)
{
tran.Rollback();
issaved = false;
throw ex;
}
finally
{
if (tran != null)
{
tran.Dispose();
}
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
}
return(issaved);
}
public List <StackBLL> GetActiveStackbyShedId(Guid shedId)
{
List <StackBLL> list = new List <StackBLL>();
StackBLL obj = new StackBLL();
try
{
List <StackBLL> dalList = StackDAL.GetActiveStackByShed(shedId);
if (dalList != null)
{
list.AddRange(dalList);
}
}
catch (Exception ex)
{
throw new Exception("Unable to get Stack", ex);
}
return(list);
}
public List <StackBLL> GetActiveStackbyShedId(Guid shedId, Guid CommodityGrade,
int productionYear)
{
List <StackBLL> list = new List <StackBLL>();
StackBLL obj = new StackBLL();
try
{
List <StackBLL> dalList = StackDAL.GetActiveStackByShed(shedId);
if (dalList != null)
{
list = (from s in dalList where s.CommodityGradeid == CommodityGrade && s.ProductionYear == productionYear select s).ToList();
//list.AddRange(dalList);
}
}
catch (Exception ex)
{
throw new Exception("Unable to get Stack", ex);
}
return(list);
}
public List <StackBLL> Search(Nullable <Guid> ShedId, Nullable <Guid> CommodityGradeId, String StackNumber)
{
List <StackBLL> list = new List <StackBLL>();
list = StackDAL.Search(ShedId, CommodityGradeId, StackNumber);
try
{
if (list != null)
{
list = MergeWithCommodityGrade(list);
}
else
{
return(null);
}
}
catch (Exception ex)
{
throw ex;
}
return(list);
}
