public void ReqNo(int eid1)
{
var genReqNo = (from grn1 in ad.Requests where grn1.RequestStatus == "NEW" && grn1.RequestByEmployeeID == eid1 select grn1).ToList();
if (genReqNo.Count > 0)
{
int reqno = genReqNo[0].RequestID;
using (var ctxt = new ADProjectSA40Team4Entities())
{
lk:
var x = (from y in ctxt.RequestDetails
where y.RequestID == reqno
select y).FirstOrDefault();
if (x != null)
{
ctxt.RequestDetails.Remove(x);
ctxt.SaveChanges();
goto lk;
}
var x1 = (from y1 in ctxt.Requests
where y1.RequestID == reqno
select y1).FirstOrDefault();
ctxt.Requests.Remove(x1);
ctxt.SaveChanges();
}
}
}
public void UpdReqStat(int tran)
{
Request trt = ad.Requests.Single(tid => tid.RequestID == tran);
trt.RequestStatus = "EDIT";
ad.SaveChanges();
}
public bool DeleteItem(string IID, int RTID)
{
using (var ctx = new ADProjectSA40Team4Entities())
{
var x = (from y in ctx.RequestDetails
where y.RequestedItem == IID && y.RequestID == RTID
select y).FirstOrDefault();
ctx.RequestDetails.Remove(x);
ctx.SaveChanges();
var xe = (from y in ctx.RequestDetails
where y.RequestID == RTID
select y).ToList();
if (xe.Count < 1)
{
var x1 = (from y1 in ctx.Requests
where y1.RequestID == RTID
select y1).FirstOrDefault();
ctx.Requests.Remove(x1);
ctx.SaveChanges();
return(true);
}
else
{
return(false);
}
}
}
public int updateDisburse(string deptid, string empid1)
{
int empid = Convert.ToInt32(empid1);
var ddptg = (from odr in ad.Requests
where odr.RequestStatus == "Alloted" && odr.RequestByDepartmentID == deptid
select odr).ToList();
foreach (var qin in ddptg)
{
var outstand = (from ot in ad.RequestDetails where ot.RequestID == qin.RequestID && ot.RequestedQty != ot.ReceivedQty select ot).ToList();
if (outstand.Count > 0)
{
Request reqout = new Request
{
RequestStatus = "NEW",
RequestByDepartmentID = qin.RequestByDepartmentID,
RequestByEmployeeID = empid
};
ad.Requests.Add(reqout);
try
{
ad.SaveChanges();
}
catch (Exception tye)
{
Console.WriteLine(tye);
}
var genReqNo = (from grn1 in ad.Requests where grn1.RequestStatus == "NEW" && grn1.RequestByEmployeeID == empid && grn1.RequestByDepartmentID == qin.RequestByDepartmentID select grn1).ToList();
int reqnoutstand = genReqNo[0].RequestID;
EmpNewRequest outstandnewreq = new EmpNewRequest();
foreach (var outstandvar in outstand)
{
int qtyoutstand = (int)(outstandvar.RequestedQty - outstandvar.ReceivedQty);
outstandnewreq.AddItem(reqnoutstand, outstandvar.RequestedItem, qtyoutstand);
}
outstandnewreq.AddOutStandingReqNo(reqnoutstand);
}
var all12 = from a12 in ad.Requests where a12.RequestID == qin.RequestID select a12;
Request req = all12.First();
req.RequestStatus = "Disbursed";
req.ReceivedDate = System.DateTime.Now.Date;
try
{
ad.SaveChanges();
}
catch (Exception tye)
{
Console.WriteLine(tye);
return(0);
}
}
return(1);
}
public dynamic GetReqNo(string dptid1, int eid1)
{
var genReqNo = (from grn1 in ad.Requests where grn1.RequestStatus == "NEW" && grn1.RequestByEmployeeID == eid1 select grn1).ToList();
if (genReqNo.Count > 0)
{
return(genReqNo);
}
else
{
Request req = new Request
{
RequestStatus = "NEW",
RequestByDepartmentID = dptid1,
RequestByEmployeeID = eid1
};
ad.Requests.Add(req);
try
{
ad.SaveChanges();
}
catch (Exception tye)
{
Console.WriteLine(tye);
}
var genReqNo1 = (from grn1 in ad.Requests where grn1.RequestStatus == "NEW" && grn1.RequestByEmployeeID == eid1 select grn1).ToList();
return(genReqNo1);
}
}
public void UpdateCollectionPt(string dep, int trancptid)
{
using (TransactionScope ts = new TransactionScope())
{
Department dcpt = (from ftg in ad.Departments where ftg.DepartmentID == dep select ftg).SingleOrDefault();
dcpt.CollectionPointID = trancptid;
ad.SaveChanges();
ts.Complete();
}
}
public void DeleteReqNo(int tran)
{
using (var ctxt = new ADProjectSA40Team4Entities())
{
lk:
var x = (from y in ctxt.RequestDetails
where y.RequestID == tran
select y).FirstOrDefault();
if (x != null)
{
ctxt.RequestDetails.Remove(x);
ctxt.SaveChanges();
goto lk;
}
var x1 = (from y1 in ctxt.Requests
where y1.RequestID == tran
select y1).FirstOrDefault();
ctxt.Requests.Remove(x1);
ctxt.SaveChanges();
}
}
public int NewRaiseAdj(int eid1)
{
int req = 0;
var genAdjNo = (from gadrn1 in ad.Adjustments where gadrn1.AdjustmentStatus == "NEW" && gadrn1.AdjustedByEmployeeID == eid1 select gadrn1).ToList();
if (genAdjNo.Count > 0)
{
req = genAdjNo[0].AdjustmentID;
}
else
{
Adjustment areq = new Adjustment
{
AdjustmentStatus = "NEW",
AdjustedByEmployeeID = eid1
};
ad.Adjustments.Add(areq);
try
{
ad.SaveChanges();
}
catch (Exception tye)
{
Console.WriteLine(tye);
}
var raisead = (from graise1 in ad.Adjustments where graise1.AdjustmentStatus == "NEW" && graise1.AdjustedByEmployeeID == eid1 select graise1).ToList();
req = raisead[0].AdjustmentID;
}
return(req);
}
public void RaisePurchaseControlOrder(DataTable dt2, int employeid, DateTime date)
{
int req = 0;
DataTable dt = new DataTable();
dt = dt2;
int supid = Convert.ToInt32(dt.Rows[0]["supplierid"]);
PurchaseOrder poentry = new PurchaseOrder
{
PurchaseStatus = "NEW",
SupplierID = supid,
EmployeeID = employeid
};
ad.PurchaseOrders.Add(poentry);
ad.SaveChanges();
for (int f = 0; f < dt.Rows.Count; f++)
{
like:
var genReqNo = (from grn1 in ad.PurchaseOrders where grn1.PurchaseStatus == "NEW" && grn1.SupplierID == supid && grn1.EmployeeID == employeid select grn1).ToList();
if (genReqNo.Count > 0)
{
req = genReqNo[0].PurchaseOrderID;
if (Convert.ToInt32(dt.Rows[f]["supplierid"]) == supid)
{
PurchaseOrderDetail reqd = new PurchaseOrderDetail
{
PurchaseOrderID = req,
ItemID = Convert.ToString(dt.Rows[f]["itemid"]),
OrderQty = Convert.ToInt32(dt.Rows[f]["suggestedqty"]),
ReceivedQty = 0
};
ad.PurchaseOrderDetails.Add(reqd);
try
{
ad.SaveChanges();
}
catch (Exception tye)
{
Console.WriteLine(tye);
}
if ((f + 1) < dt.Rows.Count)
{
supid = Convert.ToInt32(dt.Rows[f + 1]["supplierid"]);
}
}
}
else
{
PurchaseOrder poentry2 = new PurchaseOrder
{
PurchaseStatus = "NEW",
SupplierID = supid,
EmployeeID = employeid
};
ad.PurchaseOrders.Add(poentry2);
ad.SaveChanges();
goto like;
}
}
like2:
var genReqNo2 = (from grn1 in ad.PurchaseOrders where grn1.PurchaseStatus == "NEW" && grn1.EmployeeID == employeid select grn1).ToList();
if (genReqNo2.Count > 0)
{
int reqtid = genReqNo2[0].PurchaseOrderID;
PurchaseOrder addreq = (from c in ad.PurchaseOrders where c.PurchaseOrderID == reqtid select c).SingleOrDefault(); //ad.Requests.Single(rid => rid.RequestID == reqtid);
addreq.PurchaseStatus = "Pending";
addreq.OrderDate = System.DateTime.Now.Date;
addreq.ExpectedDeliveryDate = date;
try
{
ad.SaveChanges();
//sendmail(reqtid);
}
catch (Exception tye)
{
Console.WriteLine(tye);
}
goto like2;
}
}