public static List <Requisition> ListRequsitionWithPendingtoCollection()
{
using (LastADEntities ctx = new LastADEntities())
{
return(ctx.Requisitions.Where(x => x.Status.Equals("Waiting for Collection")).ToList <Requisition>());
}
}
private void BindGrid()
{
LastADEntities entities = new LastADEntities();
GridView1.DataSource = entities.ItemLists.ToList();
GridView1.DataBind();
}
public static List <RequDetail> GetRequDEtialbyID(int requisitionid)
{
using (LastADEntities ctx = new LastADEntities())
{
return(ctx.RequDetails.Where(p => p.RequId == requisitionid).ToList <RequDetail>());
}
}
public static List <ItemCategory> Listcategory()
{
using (LastADEntities ctx = new LastADEntities())
{
return(ctx.ItemCategories.ToList <ItemCategory>());
}
}
public static List <ItemList> GetitemListbyCatname(string Categoryname)
{
using (LastADEntities ctx = new LastADEntities())
{
return(ctx.ItemLists.Where(p => p.ItemCategory.CategoryName == Categoryname).ToList <ItemList>());
}
}
public static string Finditemidbyname(string name)
{
using (LastADEntities ctx = new LastADEntities())
{
return(ctx.ItemLists.Where(x => x.Description.Contains(name)).Select(y => y.ItemId).First());
}
}
protected void Button1_Click(object sender, EventArgs e)
{
LastADEntities entities = new LastADEntities();
List <PurchaseOrderDetail> pd = entities.PurchaseOrderDetails.Where(x => x.PurchaseOrderId == poid).ToList();
PurchaseOrder ppo = entities.PurchaseOrders.Where(x => x.PurchaseOrderId == poid).First();
foreach (PurchaseOrderDetail p in pd)
{
String id = p.ItemId;
int qty = Convert.ToInt16(p.Amount);
int qtyy = Convert.ToInt16(p.Quantity);
int balance = Convert.ToInt16(p.ItemList.Stock) + qtyy;
//DateTime entryday = Convert.ToDateTime(p.PurchaseOrder.DeliveryDate);
ppo.DeliveryDate = DateTime.Now;
Transaction t = new Transaction();
t.Balance = balance;
t.EntryDate = DateTime.Now;
t.ItemId = id;
t.Quantity = qtyy;
t.PurchaseOrderId = poid;
ItemList ii = new ItemList();
ii = entities.ItemLists.Find(id);
ii.Stock = balance;
entities.Transactions.Add(t);
entities.SaveChanges();
}
List <PurchaseOrder> po = POcontrol.GetPurchaseOrder();
GridView1.DataSource = po;
GridView1.DataBind();
GridView2.DataSource = "";
GridView2.DataBind();
}
protected void OnRowUpdating(object sender, GridViewUpdateEventArgs e)
{
GridViewRow row = GridView1.Rows[e.RowIndex];
int UserId = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Values[0]);
int RoleId = Int32.Parse((row.FindControl("DropDownList1") as DropDownList).SelectedValue);
DateTime stdate;
DateTime eddate;
try
{
stdate = (row.FindControl("Calendar1") as Calendar).SelectedDate;
eddate = (row.FindControl("Calendar2") as Calendar).SelectedDate;
using (LastADEntities entities = new LastADEntities())
{
Employee employee = entities.Employees.Where(p => p.UserId == UserId).First <Employee>();
employee.StartDate = stdate;
employee.EndDate = eddate;
entities.SaveChanges();
}
GridView1.EditIndex = -1;
BindGrid();
}
catch (Exception f)
{
f.ToString();
Response.Redirect("DelegateRep.aspx");
}
}
public static ItemList GetitemListbyItemId(string ItemId)
{
using (LastADEntities ctx = new LastADEntities())
{
return(ctx.ItemLists.Where(p => p.ItemId == ItemId).First());
}
}
public static List <Requisition> ListRequsitionWithWaitingForDelivery()
{
using (LastADEntities ctx = new LastADEntities())
{
return(ctx.Requisitions.Where(x => x.Status.Equals("Waiting for Delivery")).ToList <Requisition>());
}
}
public static List <ItemList> ListItemCategory(int catid)
{
using (LastADEntities entities = new LastADEntities())
{
return(entities.ItemLists.Where(p => p.CategoryId == catid).ToList <ItemList>());
}
}
public static List <RequDetail> GetOutStandingRequsitionDetail()
{
using (LastADEntities ctx = new LastADEntities())
{
return(ctx.RequDetails.Where(x => x.OutstandingQuantity != 0 && x.Requisition.Status.Equals("Waiting for Collection")).ToList <RequDetail>());
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Session["Requid"] == null)
{
Label2.Text = null;
}
else
{
Label2.Text = Session["Requid"].ToString();
}
if (Session["Requid"] != null)
{
int Requid = Int32.Parse(Session["Requid"].ToString());
//GridView1.DataSource = Business.GetRequDEtialbyID(Requid);
//GridView1.DataBind();
LastADEntities ctx = new LastADEntities();
var c = ctx.RequDetails.Where(x => x.RequId == Requid).Join(ctx.ItemLists, m => m.ItemId, f => f.ItemId, (m, f) => new { itemid = m.ItemId, name = f.Description, Quantity = m.RequestedQuantity }).ToList();
GridView2.DataSource = c;
GridView2.DataBind();
}
}
}
public static List <ItemCategory> ListCategory()
{
using (LastADEntities entities = new LastADEntities())
{
return(entities.ItemCategories.ToList <ItemCategory>());
}
}
public static List <ItemList> SearchItemById(string itemId)
{
using (LastADEntities entities = new LastADEntities())
{
return(entities.ItemLists.Where(p => p.ItemId == itemId).ToList <ItemList>());
}
}
public string ConfirmRequisition(List <WCF_RequisitionDetail> WRDS)
{
LastADEntities entities = new LastADEntities();
string end = "0";
int tok = Convert.ToInt16(WRDS.First().Requid);
try
{
//Employee employee = entities.Employees.Where(x => x.UserId == tok).First().Requisitions;
end = Business.Confrimrequ(WRDS);
}
catch (Exception e)
{
end = "-1";
}
if (end == "-1")
{
return(end);
}
return(Business.Confrimrequ(WRDS));
//StringBuilder stringBuilder = new StringBuilder();
//foreach(WCF_RequisitionDetail req in WRDS)
//{
// stringBuilder.Append(req.itemid);
//}
//return stringBuilder.ToString();
}
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
using (LastADEntities b = new LastADEntities())
{
//DropDownList2 options are dependent on the selected item in DropDownList1
if (DropDownList1.SelectedValue != "---Select---")
{
var dropdown2ds = b.ItemLists.Join(b.ItemCategories.Where(p => p.CategoryName == DropDownList1.SelectedValue), m => m.CategoryId, f => f.CategoryId,
(m, f) => new
{
ItemId = m.ItemId,
Description = m.Description,
}).ToList();
DropDownList2.DataTextField = "Description";
DropDownList2.DataValueField = "ItemId";
//DropDownList2.DataSource = dropdown2ds.Where(p => p.CategoryName == DropDownList1.SelectedValue).ToList();
DropDownList2.DataSource = dropdown2ds;
DropDownList2.DataBind();
}
else if (DropDownList1.SelectedValue == "---Select---")
{
DropDownList2.DataSource = null;
DropDownList2.Items.Clear();
}
}
}
public static List <Requisition> ListRequsitionFrombystatus(string status)
{
using (LastADEntities ctx = new LastADEntities())
{
return(ctx.Requisitions.Where(x => x.Status.Equals(status)).ToList <Requisition>());
}
}
public static ItemList FinditemobjByID(string itemId)
{
using (LastADEntities ctx = new LastADEntities())
{
return(ctx.ItemLists.Where(x => x.ItemId == itemId).First());
}
}
public static List <DisbursementListForSend> showDisbursementSeBy(int CpId)
{
LastADEntities entities = new LastADEntities();
List <int> list = Business.GetRequidWaitingForDelivery();
List <Transaction> tr = new List <Transaction>();
foreach (int id in list)
{
List <Transaction> trans = entities.Requisitions.Where(x => x.RequId == id).First().Transactions.ToList();
foreach (Transaction tran in trans)
{
tr.Add(tran);
}
}
var tt = tr.Where(p => p.Requisition.Employee.Department.CollectionPoint.CollectionPointId.Equals(CpId)).
Join(entities.Departments, m => m.Requisition.Employee.DepartmentCode, f => f.DepartmentCode,
(m, f) => new DisbursementListForDepa {
CollectionPoint = f.CollectionPoint.CollectionPointName, Description = m.ItemList.Description, Quantity = m.Quantity
}).ToList();
var dd = tt.GroupBy(x => x.Description).Select(y => new DisbursementListForSend {
Description = y.Key, Quantity = y.Sum(x => x.Quantity)
}).ToList();
return(dd);
}
public static String GetCollectionPointName(String DpCode)
{
using (LastADEntities ctx = new LastADEntities())
{
return(ctx.Departments.Where(x => x.DepartmentCode.Equals(DpCode)).First().CollectionPoint.CollectionPointName.ToString());
}
}
protected void OnRowEditing(object sender, GridViewEditEventArgs e)
{
GridView1.EditIndex = e.NewEditIndex;
//String ItemDesc = GridView1.SelectedRow.Cells[1].Text.ToString();
String itemid = GridView1.DataKeys[e.NewEditIndex].Values[0].ToString();
String name = Business.FindItemByID(itemid).First().Description.ToString();
Label11.Text = name;
String stock = Business.FindItemByID(itemid).First().Stock.ToString();
Label8.Text = stock;
var startdate = DateTime.Now.AddMonths(-6);
var today = DateTime.Now;
using (LastADEntities entities = new LastADEntities())
{
int itemlist = entities.PurchaseOrders
.Where(p => p.DeliveryDate > startdate && p.DeliveryDate < today)
.Join(entities.PurchaseOrderDetails.Where(x => x.ItemId == itemid), m => m.PurchaseOrderId, f => f.PurchaseOrderId,
(m, f) => new { f.ItemId }).Count();
Label9.Text = itemlist.ToString();
}
BindGrid();
}
public static List <ItemList> GetAllItemlist()
{
using (LastADEntities entities = new LastADEntities())
{
return(entities.ItemLists.ToList <ItemList>());
}
}
public static List <WCF_RequisitionDetailJoinItemList> RetrievalList()
{
LastADEntities ctx = new LastADEntities();
List <WCF_RequisitionDetailJoinItemList> list = ctx.RequDetails.Where(x => x.Requisition.Status.Equals("Waiting for Collection")).GroupBy(x => x.ItemId).
Select(y => (new { id = y.Key, quantity = y.Sum(x => x.OutstandingQuantity) }))
.Join(ctx.ItemLists, m => m.id, f => f.ItemId, (m, f) => new WCF_RequisitionDetailJoinItemList
{
itemid = m.id, itemname = f.Description, Quantity = m.quantity, uom = f.UOM, bin = f.Bin
})
.OrderBy(x => x.bin).ToList();
foreach (WCF_RequisitionDetailJoinItemList w in list)
{
int quantityneed = Business.GetTotalQtyNeeded(w.itemid);
w.RetrievalQuantity = Business.GetTotalQtyNeeded(w.itemid).ToString();
int?Stock = ctx.ItemLists.Where(x => x.ItemId.Equals(w.itemid)).Select(x => x.Stock).First();
if (Stock > quantityneed)
{
w.RetrievalQuantity = quantityneed.ToString();
}
else
{
w.RetrievalQuantity = Stock.ToString();
}
}
return(list);
}
public static List <PurchaseOrder> GetPurchaseOrder()
{
LastADEntities entities = new LastADEntities();
List <PurchaseOrder> po = entities.PurchaseOrders.Where(x => x.Transactions.Count() == 0).
OrderByDescending(p => p.PurchaseOrderId).ToList <PurchaseOrder>();
return(po);
}
public static List <RequDetail> RetriveReqOutstanding(int reqID)
{
using (LastADEntities ctx = new LastADEntities())
{
// retrive the requisition with outstanding amount
return(ctx.RequDetails.Where(x => x.RequDetailId == reqID).Where(y => y.OutstandingQuantity != 0).ToList <RequDetail>());
}
}
//public static void ChangeCollectionPoint(int id)
//{
// LastADEntities ctx = new LastADEntities();
// Department c = ctx.Departments.Where(x => x.CollectionPointId == id).First();
// c.CollectionPointId = id;
// ctx.SaveChanges();
//}
public static void ChangeCollectionPoint(int id, string dpcd)
{
LastADEntities ctx = new LastADEntities();
Department c = ctx.Departments.Where(x => x.DepartmentCode == dpcd).First();
c.CollectionPointId = id;
ctx.SaveChanges();
}
public static List <Transaction> showTransactionBy(string itemid)
{
LastADEntities entities = new LastADEntities();
List <Transaction> list = entities.Transactions.
Where(x => x.ItemId.Equals(itemid)).ToList();
return(list);
}
public String GetRoleID(String EmpId)
{
int id = Int32.Parse(EmpId);
using (LastADEntities ctx = new LastADEntities())
{
return(ctx.Employees.Where(x => x.UserId == id).First().RoleId.ToString());
}
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
LastADEntities ctx = new LastADEntities();
GridViewRow row = GridView1.Rows[e.RowIndex];
String c = (GridView1.DataKeys[e.RowIndex].Values[0]).ToString();
list2.Remove(c);
Response.Redirect("Add Stationary Confirmation.aspx");
}
