public DisbursementFacade()
{
ctx = new SSISDBEntities();
}
public PurchaseOrderReportEntityFacade()
{
entity = new SSISDBEntities();
sqlCon = new SqlConnection(ConfigurationManager.ConnectionStrings["SSISDBConnectionString"].ConnectionString);
}
public UserFacade()
{
ctx = new SSISDBEntities();
errorobj = new ErrorLog();
}
public LoginFacade()
{
entity = new SSISDBEntities();
}
public MenuFacade()
{
entity = new SSISDBEntities();
}
public void updateStock(string itemId, int stockQty)
{
try
{
//ctx.updateStockPro(itemId, stockQty);
using(SSISDBEntities ct = new SSISDBEntities())
{
item it = (from i in ct.items
where i.itemId == itemId
select i).FirstOrDefault();
int result = Convert.ToInt32(it.stockBalance) - stockQty;
if(result <0)
{
it.stockBalance = 0;
}
else
{
it.stockBalance = result;
}
ct.SaveChanges();
}
}
catch (Exception exception)
{
errorobj.WriteErrorLog("CatalogueFacade-updateStock():::" + exception.ToString());
}
}
public CatalogueFacade()
{
ctx = new SSISDBEntities();
errorobj = new ErrorLog();
}
public RequisitionFacade()
{
ctx = new SSISDBEntities();
errorobj = new ErrorLog();
}
public DepartmentFacade()
{
ctx = new SSISDBEntities();
errorobj = new ErrorLog();
}
