public void rejectdiscrepancy(int s)
{
discrepancy ac = (from a in lg.discrepancies
where a.discrepancyId == s
select a).SingleOrDefault();
ac.status = "Rejected";
lg.SaveChanges();
}
protected void Button2_Click(object sender, EventArgs e)
{
int s = Convert.ToInt32(Session["id"].ToString());
discrepancy ac = (from a in ctx.discrepancies
where a.discrepancyId == s
select a).SingleOrDefault();
ac.status = "Rejected";
ctx.SaveChanges();
}
public void addDiscrepancyItem(string itemName, string category, int qty, string supplier
, float price, string reason)
{
discrepancy d = new discrepancy();
d.amount = qty * price;
d.discrepancyId = df.generateID();
d.itemId = df.getItemID(itemName);
d.quantity = qty;
d.reason = reason;
d.status = "Added";
d.supplierId = supplier;
d.userId = "u1004";
df.addDiscrepancyItem(d);
}
public void approvediscrepancy(int s)
{
discrepancy ac = (from a in lg.discrepancies
where a.discrepancyId == s
select a).SingleOrDefault();
ac.status = "Approved";
var n = from a in lg.discrepancy_item
from b in lg.items
where a.itemId == b.itemId && a.discrepancyId == s
select new
{
b,
a.reportQty
};
foreach (var a in n.ToList())
{
a.b.balance = a.b.balance - a.reportQty;
}
lg.SaveChanges();
}
protected void addToDiscrepancyTable(String description, DateTime reportdate, String remark, String userId, int totalprice, int amount, String type)
{
int getitemId = getItemId(description);
discrepancy addDiscrepancy = new discrepancy();
addDiscrepancy.reportDate = reportdate;
addDiscrepancy.Remark = remark;
addDiscrepancy.userId = userId;
addDiscrepancy.totalPrice = totalprice;
addDiscrepancy.status = "Pending";
lg.discrepancies.Add(addDiscrepancy);
lg.SaveChanges();
discrepancy_item addDI = new discrepancy_item();
addDI.discrepancyId = addDiscrepancy.discrepancyId;
addDI.reportQty = amount;
addDI.type = type;
addDI.itemId = getitemId;
lg.discrepancy_item.Add(addDI);
lg.SaveChanges();
}
public void insertDiscrepancyGF(Discrepancy dis)
{
discrepancy d = new discrepancy();
d.discrepancyId = dis.DiscrepancyId;
d.itemId = dis.ItemId;
d.userId = dis.UserId;
d.quantity = dis.Qunatity;
d.supplierId = dis.SupplierId;
d.amount = dis.Amount;
d.reason = dis.Reason;
d.submitDate = dis.SubmitDate;
d.approveDate = dis.ApproveDate;
d.status = dis.Status;
d.rejectReason = dis.RejectReason;
ctx.discrepancies.Add(d);
ctx.SaveChanges();
UserFacade userFacade = new UserFacade();
List<User> userCollection;
if(dis.Amount>250)
{
userCollection= userFacade.getUsersWithRole("storeManager");
}
else
{
userCollection= userFacade.getUsersWithRole("storeSupervisor");
}
string subject = "New Discrepency Submitted.";
string bodyStart = "<HTML>"
+ "<HEAD>"
+ "</HEAD>"
+ "<BODY>"
+ "<BR/>"
+ "<P>Dear ";
string body = ",</P><BR/><P>A discrepency has been raised from your department.</P>";
body = body
+ "<BR/>"
+ "<a href=\"http://10.10.1.155/SSISWebApplication/WebPages/Discrepancy/ApproveDiscrepancyRequest\">Click this link to view the discrepency</a>"//TODO LINK
+ "<BR/>"
+ "<P>From,</P>"
+ "<P>SSIS.</P>"
+ "</BODY>"
+ "</HTML>";
NotifyUserController notifyUserController = new NotifyUserController();
foreach (User user in userCollection)
{
notifyUserController.sendEmail(user.Email, subject, bodyStart + user.UserName + body);
}
}
public void addDiscrepancyItem(discrepancy d)
{
em.discrepancies.Add(d);//Discrepancy(class) is in entity pool.
em.SaveChanges();
}
public void updateDiscrepancyItem(discrepancy d)
{
em.SaveChanges();
}
