public DataTable GetPurchaseRecordById(string purchaseRecordId)
{
PurchaseToSCDAL purchaseRecord = new PurchaseToSCDAL();
try
{
LumexDBPlayer db = LumexDBPlayer.Start();
DataTable dt = purchaseRecord.GetPurchaseRecordById(purchaseRecordId, db);
db.Stop();
return dt;
}
catch (Exception)
{
throw;
}
finally
{
purchaseRecord = null;
}
}
public DataTable GetPurchaseRecordsListBySalesCenterDateRangeAndStatus(string salesCenterId, string fromDate, string toDate, string status)
{
PurchaseToSCDAL purchaseRecord = new PurchaseToSCDAL();
try
{
LumexDBPlayer db = LumexDBPlayer.Start();
DataTable dt = purchaseRecord.GetPurchaseRecordsListBySalesCenterDateRangeAndStatus(salesCenterId, fromDate, toDate, status, db);
db.Stop();
return dt;
}
catch (Exception)
{
throw;
}
finally
{
purchaseRecord = null;
}
}
public string SavePurchaseRecord(DataTable dtPrdList)
{
PurchaseToSCDAL purchaseRecord = new PurchaseToSCDAL();
try
{
LumexDBPlayer db = LumexDBPlayer.Start(true);
string Id = purchaseRecord.SavePurchaseRecord(this, dtPrdList, db);
db.Stop();
return Id;
}
catch (Exception)
{
throw;
}
finally
{
purchaseRecord = null;
dtPrdList = null;
}
}
public bool rejectPurchaseRecord(string salesCenterId, string purchaseRecordId)
{
PurchaseToSCDAL purchaseRecord = new PurchaseToSCDAL();
bool status = false;
try
{
LumexDBPlayer db = LumexDBPlayer.Start();
status = purchaseRecord.rejectPurchaseRecord(salesCenterId, purchaseRecordId, db);
db.Stop();
}
catch (Exception)
{
throw;
}
finally
{
purchaseRecord = null;
}
return status;
}
public DataTable GetPurchaseRecordsApprovalListBySalesCenter(string salesCenterId)
{
PurchaseToSCDAL purchaseRecord = new PurchaseToSCDAL();
try
{
LumexDBPlayer db = LumexDBPlayer.Start();
DataTable dt = purchaseRecord.GetPurchaseRecordsApprovalListBySalesCenter(salesCenterId, db);
db.Stop();
return dt;
}
catch (Exception)
{
throw;
}
finally
{
purchaseRecord = null;
}
}