//Approve
protected void btnApprove_Click(object sender, EventArgs e)
{
//change status in "Request"
var req = context.Requests.SingleOrDefault(x => x.request_id == selectReqId);
req.current_status = "Approved";
req.rejected_reason = tbReason.Text;
//change status in "Request Event"
var requestDetailIds = from r in context.Requests
join de in context.Request_Details on selectReqId equals de.request_id
select de.request_detail_id;
List <int> reqDetails = requestDetailIds.ToList();
int[] detAry = reqDetails.ToArray();
for (int i = 0; i < detAry.Length; i++)
{
changeAppStatusEvent(detAry[i]);
}
lbAppRej.Text = "Successfully Approved!";
_sendEmail(true, User.Identity.Name, req);
context.SaveChanges();
Response.Redirect("ViewPending.aspx");
}
protected void OnRowUpdating(object sender, GridViewUpdateEventArgs e)
{
GridViewRow row = GridView1.Rows[e.RowIndex];
string categoryName = (row.FindControl("DropDownList1") as DropDownList).SelectedItem.Text;
string description = (row.FindControl("TextBox2") as TextBox).Text;
//int curQty = Convert.ToInt32((row.FindControl("TextBox6") as TextBox).Text);
int reorderLevel = Convert.ToInt32((row.FindControl("TextBox3") as TextBox).Text);
int reorderQuantity = Convert.ToInt32((row.FindControl("TextBox4") as TextBox).Text);
string unitOfMeasure = (row.FindControl("TextBox5") as TextBox).Text;
string itemCode = (row.FindControl("Label1") as Label).Text;
//int categoryID = Convert.ToInt32((row.FindControl("Label9") as Label).Text);
var result1 = entities.Stock_Inventory.SingleOrDefault(x => x.item_code == itemCode);
// result1.current_qty = curQty;
result1.reorder_level = reorderLevel;
result1.reorder_qty = reorderQuantity;
result1.unit_of_measure = unitOfMeasure;
result1.item_description = description;
entities.SaveChanges();
Category c = entities.Categories.Where(x => x.cat_name == categoryName).First();
result1.cat_id = c.cat_id;
//var result2 = entities.Categories.SingleOrDefault(x => x.cat_id == categoryID);
//result2.cat_name = categoryName;
//entities.SaveChanges();
GridView1.EditIndex = -1;
this.BindGrid();
(row.FindControl("DropDownList1") as DropDownList).Visible = false;
}
protected void Voucher_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Approve")
{
int rowIndex = Convert.ToInt32(e.CommandArgument);
HiddenField itemNumerHdden = (HiddenField)GridVoucherRequest.Rows[rowIndex].FindControl("LblVoucherId");
int voucherId = Convert.ToInt32(itemNumerHdden.Value);
Voucher_Request voucher_request = ssisEntities.Voucher_Request.Where(x => x.Voucher_ID == voucherId).First();
voucher_request.Status = SSISConstants.APPROVED;
int qty = Convert.ToInt32(voucher_request.Quantity);
voucher_request.Stationery_Catalogue.Total_Quantity = voucher_request.Stationery_Catalogue.Total_Quantity + qty;
ssisEntities.SaveChanges();
populateVoucherRequests();
}
else if (e.CommandName == "Reject")
{
int rowIndex = Convert.ToInt32(e.CommandArgument);
HiddenField itemNumerHdden = (HiddenField)GridVoucherRequest.Rows[rowIndex].FindControl("LblVoucherId");
int voucherId = Convert.ToInt32(itemNumerHdden.Value);
Voucher_Request voucher_request = ssisEntities.Voucher_Request.Where(x => x.Voucher_ID == voucherId).First();
voucher_request.Status = SSISConstants.REJECTED;
ssisEntities.SaveChanges();
populateVoucherRequests();
}
}
public void AddPurchaseOrder(CustomPOViewModel cpvm, HttpSessionStateBase session)
{
foreach (KeyValuePair <string, string> pair in cpvm.PoList)
{
PurchaseOrder po = new PurchaseOrder();
{
po.poId = pair.Value;
po.supplierId = pair.Key;
po.storeClerk = session["EmployeeID"].ToString();
po.orderDate = DateTime.Today;
po.remark = "Pending";
}
db.PurchaseOrders.Add(po);
db.SaveChanges();
}
for (int i = 0; i < cpvm.Pvm.Count; i++)
{
PurchaseOrderDetail pod = new PurchaseOrderDetail();
{
//pod.id is auto generated
pod.poId = cpvm.Pvm[i].PoId;
pod.itemId = cpvm.Pvm[i].ItemId;
pod.quantity = cpvm.Pvm[i].SQuantity;
pod.price = cpvm.Pvm[i].Price;
}
db.PurchaseOrderDetails.Add(pod);
db.SaveChanges();
}
}
public static int Add_Voucher_Request(Voucher_Request voucher_request)
{
ssisEntities.Voucher_Request.Add(voucher_request);
int result = ssisEntities.SaveChanges();
return(result);
}
public HttpResponseMessage CreateRequisition([FromBody] Requisition requisition)
{
db.Requisitions.Add(requisition);
db.SaveChanges();
var resp = new HttpResponseMessage(HttpStatusCode.OK);
return(resp);
}
public string CreateAdjustmentVoucher(AdjustmentVoucherViewModel avvm)
{
//ItemInventoryLocation - 1 - StockQty, 2 - DisburseQty, 3 - AdjustQty (not used)
decimal totalAdjAmt = 0M;
//Initiate Adjustment entry
Adjustment adjustment = new Adjustment();
adjustment.voucherId = avvm.voucherID;
adjustment.clerk = new string(avvm.clerkIDName.Where(Char.IsDigit).ToArray());
adjustment.supervisor = new string(avvm.supervisorIDName.Where(Char.IsDigit).ToArray());
adjustment.date = avvm.voucherDate;
adjustment.status = "Submitted";
foreach (AdjustmentVoucherViewModelDetail avvmd in avvm.itemList)
{
AdjustmentDetail adjustmentDetail = new AdjustmentDetail();
Inventory inventory = db.Inventories.Find(avvmd.itemID);
//edit Adj detail
adjustmentDetail.itemId = avvmd.itemID;
adjustmentDetail.quantity = avvmd.itemQty;
adjustmentDetail.voucherId = avvm.voucherID;
if (avvmd.itemInventoryLocation == 1)
{
//Adj inventory
inventory.storeQuantity = avvmd.itemQty < 0 ? inventory.storeQuantity - Math.Abs(avvmd.itemQty) : inventory.storeQuantity + avvmd.itemQty;
inventory.adjQuantity -= avvmd.itemQty;
avvmd.remark += (" Adjusted Item code : " + avvmd.itemID + " Qty : " + avvmd.itemQty + " from StoreQty");
}
else if (avvmd.itemInventoryLocation == 2)
{
inventory.disburseQuantity += avvmd.itemQty < 0 ? inventory.disburseQuantity - Math.Abs(avvmd.itemQty) : inventory.disburseQuantity + avvmd.itemQty;
inventory.adjQuantity -= avvmd.itemQty;
avvmd.remark += (" Adjusted Item code : " + avvmd.itemID + " Qty : " + avvmd.itemQty + " from DisburseQty");
}
string supplier = db.Catalogues.Find(avvmd.itemID).firstSupplier;
decimal itemPrice = db.SupplierQuotations.Where(x => x.itemId == avvmd.itemID && x.supplierId == supplier).First().price;
totalAdjAmt += (itemPrice * avvmd.itemQty);
adjustmentDetail.remark = avvmd.remark;
db.AdjustmentDetails.Add(adjustmentDetail);
}
avvm.needAuthority = totalAdjAmt > 250M ? true : false;
avvm.status = "Submitted";
//Set need authority (Logic - if need manager approval, set manager id - else null)
adjustment.needAuthority = avvm.needAuthority == true ? new string(avvm.managerIDName.Where(Char.IsDigit).ToArray()) : null;
adjustment.adjustmentValue = totalAdjAmt;
db.Adjustments.Add(adjustment);
db.SaveChanges();
EmailBusinessLogic emailBizLogic = new EmailBusinessLogic();
string receipient = avvm.needAuthority == true ? adjustment.needAuthority : adjustment.supervisor;
string sender = adjustment.clerk;
string linkref = "http://" + ConstantsConfig.linkrefURLPartial + "/Adjustment/AdjustmentDetail?adjustmentID=" + avvm.voucherID;
emailBizLogic.SendEmail("submitAdj", receipient, sender, null, null, linkref);
return(adjustment.voucherId);
}
public bool SetAuthorisedPerson(string authperson, string startdate, string enddate, HttpSessionStateBase session)
{
if (authperson is null || startdate is null || enddate is null)
{
session["MessageBack"] = "Please enter all necessary fields";
return(false);
}
string[] emplist = (string[])session["AuthEmployeeList"];
if (!emplist.Contains(authperson))
{
session["MessageBack"] = "No such employee (" + authperson + ") in this department";
return(false);
}
DateTime startDate = new DateTime();
DateTime endDate = new DateTime();
DateTime.TryParse(startdate, out startDate);
DateTime.TryParse(enddate, out endDate);
DateTime compareDate = DateTime.Now.Date;
if (startDate < compareDate || endDate < compareDate)
{
session["MessageBack"] = "Please ensure both start date (" + startdate + ") and end date (" + enddate + ") are not earlier the date today (" + compareDate.ToString() + ")";
return(false);
}
if (startDate > endDate)
{
session["MessageBack"] = "Your selected start date " + startdate + "is earlier than your selected end date " + enddate;
return(false);
}
session["MessageBack"] = "";
string deptid = session["DepartmentID"].ToString();
DeptCollectionDetail deptDetails = db.DeptCollectionDetails.Where(x => x.departmentId == deptid).First();
string newempID = new string(authperson.Where(Char.IsDigit).ToArray());
string username = session["Username"].ToString();
string password = session["Password"].ToString();
string statusMessage = WebAccessSetAuthorisedPerson(username, password, newempID);
if (statusMessage == "Success")
{
deptDetails.authorisedPerson = newempID;
deptDetails.validDateStart = startDate;
deptDetails.validDateEnd = endDate;
}
else
{
return(false);
}
db.SaveChanges();
EmailBusinessLogic emailBizLogic = new EmailBusinessLogic();
string sender = session["EmployeeID"].ToString();
string receipient = newempID;
emailBizLogic.SendEmail("assignAuth", receipient, sender, null, null, null);
return(true);
}
protected void btn_add_new_suppl_Click(object sender, EventArgs e)
{
String Name = tbx_name.Text;
String iD = tbx_id.Text;
String Address = tbx_address.Text;
int num = Convert.ToInt32(tbx_contactno.Text);
String Cname = tbx_cntctname.Text;
int fno = Convert.ToInt32(tbx_fax.Text);
String GST = tbx_gst.Text;
String Remark = tbx_remark.Text;
try
{
using (SSISEntities entity = new SSISEntities())
{
Supplier sup = new Supplier
{
Supplier_ID = iD,
Supplier_Name = Name,
Address = Address,
Contact_Number = num,
Contact_Name = Cname,
Fax_Number = fno,
GST_Number = GST,
Remarks = Remark
};
entity.Suppliers.Add(sup);
entity.SaveChanges();
foreach (ListItem item in ListBox1.Items)
{
if (item.Selected)
{
string ItemNumber = item.Value;
Supplier_Item si = new Supplier_Item
{
Supplier_ID = iD,
Item_Number = ItemNumber
};
entity.Supplier_Item.Add(si);
entity.SaveChanges();
}
}
}
}
catch
{
lblexcep.Text = "Supplier ID already Exist.Please try with different Id.";
lblexcep.BackColor = System.Drawing.Color.Red;
lblexcep.ForeColor = System.Drawing.Color.White;
lblexcep.Visible = true;
}
Response.Redirect("~/com.ssis.PurchaseDepartmentRepresentative/MaintainSupplierInformation.aspx");
}
protected void btnAddtoStock_Click(object sender, EventArgs e)
{
int total = Convert.ToInt32(lblqty.Text.ToString());
int oldtotal = Convert.ToInt32(iteminfo.Total_Quantity);
total = total + oldtotal;
iteminfo.Total_Quantity = total;
model.SaveChanges();
btnAddtoStock.Enabled = false;
}
public ActionResult Create([Bind(Include = "supplierId,gstNumber,supplierName,contactName,phone,faxNumber,address")] Supplier supplier)
{
if (ModelState.IsValid)
{
db.Suppliers.Add(supplier);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(supplier));
}
public ActionResult Create([Bind(Include = "itemId,category,description,unitOfMeasure,reorderQuantity,reorderLevel,firstSupplier,secondSupplier,thirdSupplier,bin,quantityInUnit")] Catalogue catalogue)
{
if (ModelState.IsValid)
{
db.Catalogues.Add(catalogue);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.firstSupplier = new SelectList(db.Suppliers, "supplierId", "gstNumber", catalogue.firstSupplier);
ViewBag.secondSupplier = new SelectList(db.Suppliers, "supplierId", "gstNumber", catalogue.secondSupplier);
ViewBag.thirdSupplier = new SelectList(db.Suppliers, "supplierId", "gstNumber", catalogue.thirdSupplier);
ViewBag.itemId = new SelectList(db.Inventories, "itemId", "itemId", catalogue.itemId);
return(View(catalogue));
}
protected void btnSubmitAll_Click(object sender, EventArgs e)
{
// Get all the models
List<GenerateDisbursementViewModel> list = Session[SESSION_COLLECTION_PT_LIST] as List<GenerateDisbursementViewModel>;
// Convert to ids and items to retrieve
var listByRequestIds = list
.SelectMany(sm => sm.RequestIds
.Select(s => new { RequestId = s, sm.ItemCode, sm.Include, sm.CollectionPtId }))
.Where(w => w.Include)
.GroupBy(k => k.RequestId, v => v.ItemCode);
using (SSISEntities context = new SSISEntities())
{
foreach (var request in listByRequestIds)
{
FacadeFactory.getRequestMovementService(context).moveFromRetrievedToDisbursing(request.Key, request.ToList(), User.Identity.Name);
}
context.SaveChanges();
}
_sendEmail(User.Identity.Name, list.Select(s => s.DeptCode).Distinct().ToList());
Response.Redirect(Request.Url.ToString(), false);
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
using (SSISEntities ctx = new SSISEntities())
{
//Revert role of current nominated employee
int depRep = (int)ctx.Departments.Where(x => x.Department_Head == deptHeadId).Select(x => x.Department_Representative).First();
User u = ctx.Users.Where(x => x.UserId == depRep).First();
if (u.RoleId == 3)
{
u.RoleId = 3;
}
else
{
u.RoleId = 1;
}
//Assign new rep / collection point
int newRep = Int32.Parse(ddlDepartmentRep.SelectedValue);
Department d = ctx.Departments.Where(x => x.Department_Head == deptHeadId).First();
User r = ctx.Users.Where(x => x.UserId == newRep).First();
d.Department_Representative = newRep;
d.CollectionPoint_ID = Int32.Parse(rblCollectionPoint.SelectedValue);
if (r.RoleId == 3)
{
r.RoleId = 3;
}
else
{
r.RoleId = 2;
}
ctx.SaveChanges();
}
ShowMessage("Collection details updated successfully", MessageType.Success);
}
public static int AddStationeryRequistion(Stationery_Requisition stationery_request)
{
ssisEntities.Stationery_Requisition.Add(stationery_request);
int result = ssisEntities.SaveChanges();
return(result);
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
int id = e.RowIndex;
HiddenField supIdHidden = (HiddenField)GridView1.Rows[id].FindControl("SupplierID");
SSISEntities entityContext = new SSISEntities();
Guid guid = Guid.NewGuid();
Random random = new Random();
int key = random.Next();
String Item_Number = DropDownList2.SelectedValue.Trim();
String ItemID = entityContext.Stationery_Catalogue.Where(x => x.Description == Item_Number).Select(z => z.Item_Number).First();
// Remove from grid and supplier-item tables
Supplier_Item si = entityContext.Supplier_Item.Where(x => x.Supplier_ID == supIdHidden.Value && x.Item_Number == ItemID).First();
entityContext.Supplier_Item.Remove(si);
entityContext.SaveChanges();
loadData();
// Response.Redirect("MaintainSupplierInformation.aspx");
}
protected void SubmitButton_Click(object sender, EventArgs e)
{
string SupplierName = tb_supplierName.Text;
string ContactName = tb_contactName.Text;
string ContactNum = tb_contactNum.Text;
string FaxNum = tb_faxNum.Text;
string Address = tb_address.Text;
string Gst = tb_gst.Text;
supplier_code = Request.QueryString["supplier"];
Supplier s = context.Suppliers.Where(x => x.supplier_id == supplier_code).First();
s.name = SupplierName;
s.contact_name = ContactName;
s.contact_num = ContactNum;
s.fax_num = FaxNum;
s.address = Address;
s.gst_reg_num = Gst;
context.SaveChanges();
Response.Redirect("~/Views/StoreClerk/viewsupplierList.aspx");
}
protected void btnSendInvoice_Click(object sender, EventArgs e)
{
orderdetail.Status = "Purchased";
model.SaveChanges();
btnSendInvoice.Enabled = false;
Response.Redirect("Store_PurchaseDeptOrderSucessfully.aspx");
}
public void RedoRankingsForTenderList()
{
// Get all items for this year
// Group by item code
// For each item code, sort its contents by price
// With the sorted, rank in order 1, 2, 3
// Save changes
using (SSISEntities context = new SSISEntities())
{
// For all item codes that are not set, go and add things to stuff
int currentYear = DateTime.Now.Year;
var groups = context.Tender_List_Details
.Where(w => w.Tender_List.tender_date.Year == currentYear)
.GroupBy(x => x.item_code)
.ToList();
foreach (var group in groups)
{
var sorted = group.OrderBy(o => o.price).ToList();
int rank = 1;
foreach (var item in sorted)
{
item.rank = rank;
rank++;
}
}
context.SaveChanges();
}
}
protected void SubmitButton_Click(object sender, EventArgs e)
{
string SupplierId = tb_supplierId.Text;
string SupplierName = tb_supplierName.Text;
string ContactName = tb_contactName.Text;
string ContactNum = tb_contactNum.Text;
string FaxNum = tb_faxNum.Text;
string Address = tb_address.Text;
string Gst = tb_gst.Text;
using (SSISEntities entities = new SSISEntities())
{
Supplier s = new Supplier();
s.supplier_id = SupplierId;
s.name = SupplierName;
s.contact_name = ContactName;
s.contact_num = ContactNum;
s.fax_num = FaxNum;
s.address = Address;
s.gst_reg_num = Gst;
s.deleted = "N";
entities.Suppliers.Add(s);
entities.SaveChanges();
}
Response.Redirect("~/Views/StoreClerk/ViewSupplierList.aspx");
}
protected void btnSave_Click(object sender, EventArgs e)
{
//save/update changed collection point & representative in database
int selectColPoint = ddlCollectPoint.SelectedIndex;
string repFullName = ddlRepName.SelectedItem.ToString();
if (selectColPoint == 0 || repFullName.Equals("Select---"))
{
lbDDLError1.Text = "Please select the required field!";
}
else
{
//show Full Name- save username
Dept_Registry depReg = context.Dept_Registry.SingleOrDefault(x => x.fullname == repFullName);
string repUserName = depReg.username;
var result = context.Departments.SingleOrDefault(c => c.name == sdept.name);
result.rep_user = repUserName;
result.collection_point = selectColPoint;
context.SaveChanges();
lbDDLError1.Text = "Sucessfully Save!";
_sendEmail(User.Identity.Name, repUserName);
}
}
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "remove")
{
using (SSISEntities ctx = new SSISEntities())
{
//Revert role of current nominated employee
int depAutPerson = Convert.ToInt32(ctx.Departments.Where(x => x.Department_Head == dhhid).Select(x => x.Department_Authorized_Person).First());
Department dep = ctx.Departments.Where(x => x.Department_Head == dhhid).First();
User u = ctx.Users.Where(x => x.UserId == depAutPerson).First();
if (dep.Department_Representative == depAutPerson)
{
u.RoleId = 2;
}
else
{
u.RoleId = 1;
}
dep.Department_Authorized_Person = 0;
ctx.SaveChanges();
}
this.BindGrid();
Session["notiCheck"] = true;
Response.Redirect(Request.RawUrl);
}
}
protected void btnSetRanks_Click(object sender, EventArgs e)
{
// Get all items
// Group by item code
// For each item code, sort its contents by price
// With the sorted, rank in order 1, 2, 3
// Save changes
using (SSISEntities context = new SSISEntities())
{
// For all item codes that are not set, go and add things to stuff
var groups = context.Tender_List_Details.GroupBy(x => x.item_code).ToList();
foreach (var group in groups)
{
var sorted = group.OrderBy(o => o.price).ToList();
int rank = 1;
foreach (var item in sorted)
{
item.rank = rank;
rank++;
}
}
context.SaveChanges();
}
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
Label id = GridView1.Rows[e.RowIndex].FindControl("lblDepOrdId") as Label;
TextBox rtQty = GridView1.Rows[e.RowIndex].FindControl("txt_rtQty") as TextBox;
int depOrdId = Int32.Parse(id.Text);
int qtyUpdated = Int32.Parse(rtQty.Text);
Department_Orders depOrd = ent.Department_Orders.Where(x => x.Department_Orders_ID == depOrdId).First();
depOrd.Return_Quantity = qtyUpdated;
ent.SaveChanges();
GridView1.EditIndex = -1;
bindData();
}
public HttpResponseMessage PostAdjustment(Adjustment adjustment)
{
db.Adjustments.Add(adjustment);
db.SaveChanges();
var resp = new HttpResponseMessage(HttpStatusCode.OK);
return(resp);
}
public HttpResponseMessage PostRequisitionDetail([FromBody] RequisitionDetail req)
{
db.RequisitionDetails.Add(req);
db.SaveChanges();
var resp = new HttpResponseMessage(HttpStatusCode.OK);
return(resp);
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
using (SSISEntities ctx = new SSISEntities())
{
Department d = ctx.Departments.Where(x => x.Department_Representative == deptRepId).First();
d.CollectionPoint_ID = Int32.Parse(rblCollectionPoint.SelectedValue);
ctx.SaveChanges();
}
ShowMessage("Collection details updated successfully", MessageType.Success);
}
protected void btnGo_Click(object sender, EventArgs e)
{
using (SSISEntities context = new SSISEntities())
{
// For all item codes that are not set, go and add things to stuff
var details = context.Tender_List_Details.GroupBy(x => x.item_code).ToList();
var existingItemCodes = details.Select(s => s.Key);
var otherItemCodes = context.Stock_Inventory.Select(s => s.item_code).ToList();
foreach (var item in existingItemCodes)
{
otherItemCodes.Remove(item);
}
// otherItemCodes has been filtered
Random r = new Random();
List <int> tenderYearIds = context.Tender_List.Select(x => x.tender_year_id).ToList();
foreach (var item in otherItemCodes)
{
int toRemove = r.Next(0, 4);
List <int> filteredTenderYearIds = tenderYearIds.ToList();
// select 3 supplier ids
filteredTenderYearIds.RemoveAt(toRemove);
// add a newdetail for each of the supplier ids, with each a random price
double price = r.NextDouble() * 2 + 0.2d;
foreach (int tenderYeadId in filteredTenderYearIds)
{
// add a new tenderListDetail
Tender_List_Details newDetail = new Tender_List_Details();
decimal priceChange = (decimal)((r.NextDouble() * 0.4) - 0.2);
decimal newPrice = ((decimal)price) + priceChange;
newDetail.price = newPrice;
newDetail.rank = 0;
newDetail.tender_year_id = tenderYeadId;
newDetail.item_code = item;
newDetail.deleted = "N";
context.Tender_List_Details.Add(newDetail);
}
}
context.SaveChanges();
}
}
protected void btnApprove_Click(object sender, EventArgs e)
{
Department_Orders depOrder;
string itemID;
SSISEntities model = new SSISEntities();
Stationery_Requisition reqToAdd = model.Stationery_Requisition.Where(x => x.Requisition_ID == id).First();
Employee emp = model.Employees.Where(x => x.Id == reqToAdd.User_ID).First();
string depId = model.Departments.Where(x => x.Department_ID == emp.Department_ID).Select(x => x.Department_ID).First();
foreach (Requisition_Items req in reqToAdd.Requisition_Items)
{
itemID = req.Item_ID;
var result = model.Department_Orders.Where(x => x.Item_ID == itemID && x.Department_ID == depId).SingleOrDefault();
if (result == null)
{
Department_Orders deptOrder = new Department_Orders();
deptOrder.Department_ID = depId;
deptOrder.Item_ID = itemID;
deptOrder.Requisition_Date = reqToAdd.Requisition_Date;
deptOrder.Requisition_Quantity = req.Quantity;
deptOrder.Fulfilled_Quantity = 0;
deptOrder.IOU_Quantity = 0;
deptOrder.Return_Quantity = 0;
model.Department_Orders.Add(deptOrder);
//reqToAdd.Status = "Processed";
model.SaveChanges();
//string script = "alert('Successfully Added to Retriveal List');";
//ClientScript.RegisterClientScriptBlock(this.GetType(), "Successfully Added to Retriveal List", script, true);
}
else
{
depOrder = result;
depOrder.Requisition_Quantity = depOrder.Requisition_Quantity + req.Quantity;
model.SaveChanges();
}
Response.Redirect("~/com.ssis.storeclerk/Store_ListofRequisitionForms.aspx");
}
}
public HttpResponseMessage PostAdjustmentDetail(IEnumerable <AdjustmentDetail> ad)
{
foreach (AdjustmentDetail adt in ad)
{
db.AdjustmentDetails.Add(adt);
db.SaveChanges();
}
var resp = new HttpResponseMessage(HttpStatusCode.OK);
return(resp);
}
