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 Save()
{
bool isSaved = false;
int at = -1;
SqlTransaction tran = null;
SqlConnection conn = null;
try
{
conn = Connection.getConnection();
tran = conn.BeginTransaction();
isSaved = GRNServiceDAL.Insert(this, tran);
if (isSaved == true)
{
isSaved = false;
AuditTrailBLL objAt = new AuditTrailBLL();
at = objAt.saveAuditTrail(this, WFStepsName.GRNServiceAdd.ToString(), UserBLL.GetCurrentUser(), "Add GRN Service");
if (at == 1)
{
tran.Commit();
isSaved = true;
}
else
{
tran.Rollback();
}
}
}
catch (Exception ex)
{
tran.Rollback();
throw ex;
}
finally
{
if (tran != null)
{
tran.Dispose();
}
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
}
return(isSaved);
}
public List <GRNServiceBLL> GetByGRNId(Guid Id)
{
List <GRNServiceBLL> list = null;
List <WarehouseServicesBLL> listWS = null;
try
{
list = GRNServiceDAL.GetByGRNId(Id);
WarehouseServicesBLL objservice = new WarehouseServicesBLL();
listWS = objservice.GetServices();
if (list != null)
{
listWS = objservice.GetActiveServices();
if (listWS != null)
{
var x = from grnser in list
join wservice in listWS on grnser.ServiceId equals wservice.Id
select new { grnser.Id, grnser.GRNId, grnser.Quantity, grnser.Status, grnser.ServiceId, ServiceName = wservice.Name };
list = new List <GRNServiceBLL>();
foreach (var i in x)
{
GRNServiceBLL o = new GRNServiceBLL();
o.Id = i.Id;
o.GRNId = i.GRNId;
o.ServiceId = i.ServiceId;
o.ServiceName = i.ServiceName;
o.Status = i.Status;
o.Quantity = i.Quantity;
list.Add(o);
}
return(list);
}
else
{
throw new Exception("unable to get look up information.");
}
}
else
{
return(null);
}
}
catch (Exception ex)
{
throw ex;
}
}
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 SqlDataReader GetActiveByGRNId(Guid Id)
{
return(GRNServiceDAL.GetActiveByGRNId(Id));
}
