//update RequestDetail with reqId and reqDet
public static RequestDetailVM UpdateReqDet(int reqId, RequestDetailVM reqDet)
{
RequestDetailVM ReqDetailVM = new RequestDetailVM();
using (SA46Team08ADProjectContext entities = new SA46Team08ADProjectContext())
{
RequestDetail updateReqDetail = entities.RequestDetails.Where(r => r.ReqId == reqId && r.ItemCode.Equals(reqDet.ItemCode)).First();
updateReqDetail.ReqId = reqId;
updateReqDetail.ItemCode = reqDet.ItemCode;
updateReqDetail.ReqQty = reqDet.ReqQty;
updateReqDetail.AwaitQty = reqDet.AwaitQty;
updateReqDetail.FulfilledQty = reqDet.FulfilledQty;
entities.SaveChanges();
List <RequestDetail> lst = entities.RequestDetails.ToList();
RequestDetail rd = lst[lst.Count - 1];
ReqDetailVM.ReqId = rd.ReqId;
ReqDetailVM.ItemCode = rd.ItemCode;
ReqDetailVM.ReqQty = rd.ReqQty;
ReqDetailVM.AwaitQty = rd.AwaitQty;
ReqDetailVM.FulfilledQty = rd.FulfilledQty;
}
return(ReqDetailVM);
}
// Submits request
protected void BtnSubmit_Click(object sender, EventArgs e)
{
submitList = new List <RequestDetailVM>();
foreach (ListViewItem item in lstShow.Items)
{
RequestDetailVM addItem = new RequestDetailVM();
Label lblReqId = (Label)item.FindControl("lblReqId");
addItem.ReqId = Convert.ToInt32(lblReqId.Text);
Label lblReqLineNo = (Label)item.FindControl("lblReqLineNo");
addItem.ReqLineNo = Convert.ToInt32(lblReqLineNo.Text);
Label lblItemCode = (Label)item.FindControl("lblItemCode");
addItem.ItemCode = lblItemCode.Text;
TextBox txtQty = (TextBox)item.FindControl("spnQty");
addItem.ReqQty = Convert.ToInt32(txtQty.Text);
Label lblDesc = (Label)item.FindControl("lblDescription");
addItem.Desc = lblDesc.Text;
addItem.AwaitQty = 0;
addItem.FulfilledQty = 0;
submitList.Add(addItem);
}
lstConfirm.DataSource = submitList;
lstConfirm.DataBind();
ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop", "openModal();", true);
}
//add RequestDetail with reqId and reqDet
public static RequestDetailVM AddReqDet(int reqId, RequestDetailVM reqDet)
{
RequestDetailVM request = new RequestDetailVM();
using (SA46Team08ADProjectContext entities = new SA46Team08ADProjectContext())
{
RequestDetail req = new RequestDetail();
req.ReqId = reqId;
request.ReqId = req.ReqId;
List <RequestDetail> rd = entities.RequestDetails.Where(x => x.ReqId == reqId).ToList();
if (rd.Count == 0)
{
req.ReqLineNo = 1;
}
else
{
req.ReqLineNo = rd[rd.Count - 1].ReqLineNo + 1;
}
request.ReqLineNo = req.ReqLineNo;
req.ItemCode = reqDet.ItemCode;
request.ItemCode = req.ItemCode;
req.ReqQty = reqDet.ReqQty;
request.ReqQty = req.ReqQty;
req.AwaitQty = reqDet.AwaitQty;
request.AwaitQty = req.AwaitQty;
req.FulfilledQty = reqDet.FulfilledQty;
request.FulfilledQty = req.FulfilledQty;
entities.RequestDetails.Add(req);
entities.SaveChanges();
}
return(request);
}
public HttpResponseMessage AddReqDet_reqId(int reqId, RequestDetailVM reqDetVM)
{
RequestDetailVM req = BusinessLogic.RequestDetailBL.AddReqDet(reqId, reqDetVM);
if (req == null)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
return(Request.CreateResponse(HttpStatusCode.OK, req));
}
public HttpResponseMessage AddReqDet(int empId, string itemCode, int reqQty, string status)
{
RequestDetailVM req = BusinessLogic.RequestDetailBL.AddReqDet(empId, itemCode, reqQty, status);
if (req == null)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
return(Request.CreateResponse(HttpStatusCode.OK, req));
}
public static bool AddToCart(int empId, string itemCode, int reqQty)
{
RequestDetailVM req = RequestDetailBL.AddReqDet(empId, itemCode, reqQty, "Unsubmitted");
if (req != null)
{
return(true);
}
return(false);
}
public static bool AddBookmark(int empId, string itemCode)
{
RequestDetailVM req = RequestDetailBL.AddReqDet(empId, itemCode, 1, "Bookmarked");
if (req != null)
{
return(true);
}
return(false);
}
public HttpResponseMessage UpdateReqDet(string reqId, RequestDetailVM reqDetVM)
{
int RepId = Convert.ToInt16(reqId);
RequestDetailVM req = BusinessLogic.RequestDetailBL.UpdateReqDet(RepId, reqDetVM);
if (req == null)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
return(Request.CreateResponse(HttpStatusCode.OK, req));
}
//get ReqDetList
public static List <RequestDetailVM> GetReqDetList(int reqId)
{
List <RequestDetailVM> reqDetlists = new List <RequestDetailVM>();
List <RequestDetail> lst = new List <RequestDetail>();
using (SA46Team08ADProjectContext entities = new SA46Team08ADProjectContext())
{
lst = entities.RequestDetails.Where(r => r.ReqId == reqId).ToList();
}
for (int i = 0; i < lst.Count; i++)
{
RequestDetailVM req = new RequestDetailVM();
req.ReqId = lst[i].ReqId;
req.ItemCode = lst[i].ItemCode;
req.ReqLineNo = lst[i].ReqLineNo;
req.ReqQty = lst[i].ReqQty;
req.AwaitQty = lst[i].AwaitQty;
req.FulfilledQty = lst[i].FulfilledQty;
reqDetlists.Add(req);
}
return(reqDetlists);
}
//add RequestDetail with empId , reqDet and status
public static RequestDetailVM AddReqDet(int empId, string itemCode, int reqQty, string status)
{
using (SA46Team08ADProjectContext entities = new SA46Team08ADProjectContext())
{
RequestDetailVM rvm = new RequestDetailVM();
if (status == "Unsubmitted")
{
List <RequestVM> requestlists = RequestBL.GetReq(empId, status);
RequestVM request = new RequestVM();
if (requestlists.Count == 0)
{
request = RequestBL.AddReq(empId, status);
}
else
{
request = requestlists[0];
}
int reqId = request.ReqId;
List <RequestDetail> rdList = entities.RequestDetails.Where(x => x.ReqId == reqId).ToList();
bool exist = false;
for (int i = 0; i < rdList.Count; i++)
{
if (rdList[i].ItemCode == itemCode)
{
exist = true;
rdList[i].ReqQty = rdList[i].ReqQty + reqQty;
entities.SaveChanges();
rvm.ReqId = rdList[i].ReqId;
rvm.ReqLineNo = rdList[i].ReqLineNo;
rvm.ItemCode = rdList[i].ItemCode;
rvm.ReqQty = rdList[i].ReqQty;
rvm.AwaitQty = rdList[i].AwaitQty;
rvm.FulfilledQty = rdList[i].FulfilledQty;
}
}
if (exist == false)
{
RequestDetail rd = new RequestDetail();
rd.ReqId = reqId;
rvm.ReqId = rd.ReqId;
if (rdList.Count == 0)
{
rd.ReqLineNo = 0;
}
else
{
rd.ReqLineNo = rdList[rdList.Count - 1].ReqLineNo + 1;
}
rvm.ReqLineNo = rd.ReqLineNo;
rd.ItemCode = itemCode;
rvm.ItemCode = rd.ItemCode;
rd.ReqQty = reqQty;
rvm.ReqQty = rd.ReqQty;
rd.AwaitQty = 0;
rvm.AwaitQty = rd.AwaitQty;
rd.FulfilledQty = 0;
rvm.FulfilledQty = rd.FulfilledQty;
entities.RequestDetails.Add(rd);
entities.SaveChanges();
}
}
else if (status == "Bookmarked")
{
List <RequestVM> requestlists = RequestBL.GetReq(empId, status);
RequestVM request = new RequestVM();
if (requestlists.Count == 0)
{
request = RequestBL.AddReq(empId, status);
}
else
{
request = requestlists[0];
}
int reqId = request.ReqId;
List <RequestDetail> rdList = entities.RequestDetails.Where(x => x.ReqId == reqId).ToList();
bool exist = false;
for (int i = 0; i < rdList.Count; i++)
{
if (rdList[i].ItemCode == itemCode)
{
exist = true;
rvm.ReqId = rdList[i].ReqId;
rvm.ReqLineNo = rdList[i].ReqLineNo;
rvm.ItemCode = rdList[i].ItemCode;
rvm.ReqQty = rdList[i].ReqQty;
rvm.AwaitQty = rdList[i].AwaitQty;
rvm.FulfilledQty = rdList[i].FulfilledQty;
}
}
if (exist == false)
{
RequestDetail rd = new RequestDetail();
rd.ReqId = reqId;
rvm.ReqId = rd.ReqId;
if (rdList.Count == 0)
{
rd.ReqLineNo = 0;
}
else
{
rd.ReqLineNo = rdList[rdList.Count - 1].ReqLineNo + 1;
}
rvm.ReqLineNo = rd.ReqLineNo;
rd.ItemCode = itemCode;
rvm.ItemCode = rd.ItemCode;
rd.ReqQty = 0;
rvm.ReqQty = rd.ReqQty;
rd.AwaitQty = 0;
rvm.AwaitQty = rd.AwaitQty;
rd.FulfilledQty = 0;
rvm.FulfilledQty = rd.FulfilledQty;
entities.RequestDetails.Add(rd);
entities.SaveChanges();
}
}
return(rvm);
}
}
