public List<requisition> getPendingRequisitionEmployee(User u)
{
var t = (from a in luse.requisitions
where a.userId == u.UserId && a.status.Trim() == "Pending"
select a).ToList();
return t;
}
public List<requisition> getPreRequisition(User u)
{
var t = (from x in luse.requisitions
where x.status == "Approved"
select x).ToList();
return t;
}
public List<requisition> getPendingRequisition(User u)
{
var t = (from x in luse.requisitions
where x.status == "Pending"
select x).ToList();
return t;
}
public List<collectionPoint> getCollectionPointTime(User u)
{
var t = (from x in luse.collectionPoints
select x
).ToList();
return t;
}
public List<user> getAllEmployee(User u)
{
var t = (from x in luse.users
where x.departmentId == u.DepartmentId
select x).ToList();
return t;
}
public void mailNotificationCollectionPoint(User u, string collectionP, string deptid)
{
var t = (from x in luse.users
where x.roleId == 4 || x.departmentId == u.DepartmentId
select x).ToList();
var r = (from x in luse.users
from y in luse.departments
where x.userId == u.UserId && x.departmentId == y.departmentId
select y.deptName
).First().Trim();
string name = u.Name;
string from = "*****@*****.**";
string to = "*****@*****.**";
string content = "<strong>Delegate Information: <strong> <br> Dear All,<br>" + "Our Collection Point has been changed as " + collectionP + ". FYI." + "<br><br> Regards," + u.Name;
MailMessage messge = new MailMessage(from, to);
foreach (user u2 in t)
{
messge.To.Add(u2.email);
}
messge.Body = content;
messge.Subject = "Notification: Collection Point changed for Department " + r; //change and use session
messge.IsBodyHtml = true;
messge.Priority = MailPriority.High;
SmtpClient client = new SmtpClient();
client.Host = "smtp.live.com";
client.Credentials = new NetworkCredential("*****@*****.**", "ibm1990324");
client.EnableSsl = true;
client.Send(messge);
messge.Attachments.Dispose();
}
public void mailNotification(string dt0, string dt1, User u,string newname)
{
var t = (from x in luse.users
where x.roleId == 4 || x.departmentId == u.DepartmentId
select x).ToList();
var r = (from x in luse.users
from y in luse.departments
where x.userId == u.UserId && x.departmentId == y.departmentId
select y.deptName
).First().Trim();
string startDate = dt0;
string endDate = dt1;
string name = u.Name;
string from = "*****@*****.**";
string to = "*****@*****.**";
string content = "<strong>Delegate Information: <strong> <br> Dear All,<br>" + newname + ", will take my responsibility to approve requisition from our department between" + dt0 + " and " + dt1 + "<br><br> Regards," + u.Name;
MailMessage messge = new MailMessage(from, to);
foreach (user u2 in t)
{
messge.To.Add(u2.email);
}
messge.Body = content;
messge.Subject = "Notification: Delegation changed of " +r; //change and use session
messge.IsBodyHtml = true;
messge.Priority = MailPriority.High;
SmtpClient client = new SmtpClient();
client.Host = "smtp.live.com";
client.Credentials = new NetworkCredential("*****@*****.**", "ibm1990324");
client.EnableSsl = true;
client.Send(messge);
messge.Attachments.Dispose();
}
protected void Button1_Click(object sender, EventArgs e)
{
u = (User)Session["UserEntity"];
sclist2 = (List<ShoppingItem>)Session["sclist"];
rnrc.addRequisitionController(u, sclist2);
Label1.Text = "add success";
}
public List<requisition> getAllRequisitionEmployee(User u)
{
var t = (from a in luse.requisitions
where a.userId == u.UserId
select a).ToList();
return t;
}
protected void Button1_Click(object sender, EventArgs e)
{
u = (User)Session["UserEntity"];
sclist2 = (List<ShoppingItem>)Session["sclist"];
rnrc.addRequisitionController(u, sclist2);
Label1.Text = "Requisition has been created successfuly.";
Button1.Enabled = false;
}
public void getdisbusementDetails(User u, int p)
{
Label1.Text = "Disbursement List ID: " + Request.Params["did"];
contacName.Text = "Contact Person: " + vpdc.getDetailDisbursementList(u,p).First().ContacName;
address.Text = "Collection Point: " + vpdc.getDetailDisbursementList(u,p).First().Address;
time.Text = "Collection Time: " + vpdc.getDetailDisbursementList(u,p).First().Time;
Labelflag.Text = "Collection Date: " + vpdc.getDetailDisbursementList(u, p).First().CollectionDate.ToShortDateString();
GridView1.DataSource = vpdc.getDetailDisbursementList(u,p);
GridView1.DataBind();
}
public void changeCollectionPoint(User u, string collectionP)
{
var t = (from x in luse.departments
where x.departmentId == u.DepartmentId
select x).First();
var y = (from r in luse.collectionPoints
where r.address == collectionP
select r).First();
t.collectionPointId = y.collectionPointId;
luse.SaveChanges();
}
public List<realmessage> getAllmessage(User u)
{
var msg = (from x in luse.requisitions
where x.status_dept == "Pending" && x.departmentId == u.DepartmentId
select new realmessage
{
MSG1 = x.requisitionId,
Msgdatetime = x.requestDate,
Status = x.status
}
).ToList();
return msg;
}
protected void Page_Load(object sender, EventArgs e)
{
u = (User)Session["UserEntity"];
if (vpdc.getHisDisbursementList(u).Count() == 0)
{
Label1.Text = "There is no history disbursement list..";
}
else
{
GridView1.DataSource = vpdc.getHisDisbursementList(u);
GridView1.DataBind();
}
}
public void confirmOperation(DataTable Data,User u)
{
for (int i = 0; i < Data.Rows.Count; i++)
{
String category = Data.Rows[i].ItemArray[0].ToString();
String description = Data.Rows[i].ItemArray[1].ToString();
int amount = Convert.ToInt32(Data.Rows[i].ItemArray[2]);
String unit = Data.Rows[i].ItemArray[3].ToString();
String type = Data.Rows[i].ItemArray[4].ToString();
String remark = Data.Rows[i].ItemArray[5].ToString();
DateTime reportdate = DateTime.Now;
addToDiscrepancyTable(description, reportdate, remark, u.UserId, 50, amount, type);
}
}
protected void Page_Load(object sender, EventArgs e)
{
u = (User)Session["UserEntity"];
//var N = from a in lu.requisitions
// where a.userId == u.UserId && a.status.Trim() == "Pending"
// select new
// {
// RequisitionDate = a.requestDate,
// Status = a.status,
// Rid = a.requisitionId
// };
GridView1.DataSource = vcrc.PendingPastRequisition(u);
GridView1.DataBind();
}
public void confirmOperation2(List<discrepancyDetailEntityMobile> ddem, User u)
{
for (int i = 0; i < ddem.Count; i++)
{
String category = ddem[i].categoryName;
String description = ddem[i].description;
int amount = ddem[i].balance;
String unit = ddem[i].unit;
String type = ddem[i].type;
String remark = ddem[i].Remark;
DateTime reportdate = DateTime.Now;
addToDiscrepancyTable(description, reportdate, remark, u.UserId, 50, amount, type);
}
}
protected void Page_Load(object sender, EventArgs e)
{
u = (User)Session["UserEntity"];
if (vprc.getPreRequisition(u).Count() == 0)
{
head.Text = "There is no Current Requsition at this moment.";
//RejectBtn.Visible = false;
//ApproveBtn.Visible = false;
}
else
{
GridView2.DataSource = vprc.getPreRequisition(u);
GridView2.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
u = (User)Session["UserEntity"];
if (cdlc.getDisbursementList(u).Count() == 0)
{
Label1.Text = "Current Disbursementlist has not been generated yet..";
confirmBtn.Visible = false;
}
else
{
Label1.Text = "Current Week Disbursement List";
contacName.Text = "Contact Person: " + cdlc.getDisbursementList(u).First().ContacName;
address.Text ="Collection Point: " + cdlc.getDisbursementList(u).First().Address;
time.Text ="Collection Time: " + cdlc.getDisbursementList(u).First().Time;
colldate.Text = "Collection Date: " + cdlc.getDisbursementList(u).First().CollectionDate.ToShortDateString();
GridView1.DataSource = cdlc.getDisbursementList(u);
GridView1.DataBind();
}
}
public void addRequisition(User u, List<ShoppingItem> sclist)
{
requisition re = new requisition();
re.departmentId = u.DepartmentId;
re.userId = u.UserId;
re.rejectReason = null;
re.status_dept = "Pending";
re.requestDate = DateTime.Now;
luse.requisitions.Add(re);
luse.SaveChanges();
for (int i = 0; i < sclist.Count; i++) {
requsiiton_item reItem = new requsiiton_item();
reItem.requisitionId = re.requisitionId;
reItem.itemId = sclist[i].ItemId;
reItem.requestQty = sclist[i].Amount;
luse.requsiiton_item.Add(reItem);
luse.SaveChanges();
}
checkItemAvailable(re.requisitionId);
}
protected void Page_Load(object sender, EventArgs e)
{
//User userbean = (User)Session["UserEntity"];
//head.Text = "Hello," + userbean.Name;
u = (User)Session["UserEntity"];
if (vrc.getPendingRequisition(u).Count() == 0)
{
flag.Text = "There is no Current Requsition at this moment.";
//RejectBtn.Visible = false;
//ApproveBtn.Visible = false;
}
else
{
GridView1.DataSource = vrc.getPendingRequisition(u);
GridView1.DataBind();
}
}
public void confirmDisbursement(User u)
{
try
{
var data = (from x in cntx.items
from y in cntx.disbursements
from z in cntx.disbursement_item
where y.disbursementId == z.disbursementId && x.itemId == z.itemId && y.status == "WaitingCollection" && y.departmentId == u.DepartmentId
select y).ToList();
foreach(disbursement x2 in data){
var update = (from x in cntx.disbursements
where x.disbursementId == x2.disbursementId
select x).FirstOrDefault();
update.status = "Completed";
}
cntx.SaveChanges();
}
catch (Exception e)
{
}
}
public void getAllEmployee(User u)
{
GridEmp.DataSource = dac.getAllEmployee(u);
GridEmp.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Object o = pdController.getCategory();
dropdownlist_category.DataSource = o;
dropdownlist_category.DataBind();
}
u = (User)Session["UserEntity"];
if (ViewState["Data"] != null)
{
GridViewBind(this.Gv1, ViewState["Data"] as DataTable);
}
else
{
Data.Columns.Add("Cposition");
Data.Columns.Add("UserName");
Data.Columns.Add("JanCount");
Data.Columns.Add("Count");
Data.Columns.Add("FebCount");
Data.Columns.Add("remark");
GridViewBind(this.Gv1, Data);
ViewState["Data"] = Data;
}
Data = ViewState["Data"] as DataTable;
if (Data.Rows.Count > 0)
{
for (int i = 0; i < Data.Rows.Count; i++)
{
//这里应该存一个唯一键 来记录索引
//添加这个索引是为了后面删除和更新很方便的找到
ht.Add(i + 1, i);
}
}
}
public List<DisbursementList> getHisDisbursementList(User u)
{
return df.getHisDisbursementList(u);
}
public List<DisbursementList> getDetailDisbursementList(User u, int p)
{
return df.getHisDetailDisbursementList(u,p);
}
public void confirmRceive(User u)
{
df.confirmDisbursement(u);
}
public List<user> getAllEmployee(User u)
{
return uf.getAllEmployee(u);
}
//
public void formorder(User u)
{
var n = from a in ctx.items
where (a.balance < a.reorderlevel) && (a.status == "stockout")
from c in ctx.item_supplier
where a.itemId == c.itemId
from b in ctx.suppliers
where b.supplierId == c.supplierId && (c.priority == 1)
select b;
var d = from a in ctx.items
where (a.balance < a.reorderlevel) && (a.status == "stockout")
from c in ctx.item_supplier
where a.itemId == c.itemId
from b in ctx.suppliers
where b.supplierId == c.supplierId && (c.priority == 1)
select c;
List<supplier> s = n.ToList();
List<item_supplier> ls = d.ToList();
foreach (supplier x in s)
{
purchase po = new purchase();
po.supplierId = x.supplierId;
po.purchaseDate = DateTime.Today.Date;
po.userId = u.UserId;
po.expectedDeliveryDate = DateTime.Today.Date.AddDays(14);
po.status = "waiting";
ctx.purchases.Add(po);
ctx.SaveChanges();
foreach (item_supplier i in ls)
{
if (i.supplierId == x.supplierId)
{
var y = from a in ctx.items
where a.itemId == i.itemId
select a;
item item = y.SingleOrDefault();
item.status = "ordering";
purchase_item pitem = new purchase_item();
pitem.purchaseId = po.purchaserId;
pitem.itemId = i.itemId.Value;
pitem.requestQty = item.reorderlevel;
pitem.supplierid = po.supplierId;
ctx.purchase_item.Add(pitem);
ctx.SaveChanges();
}
}
}
}
public List<requisition> AllPastRequisition(User u)
{
return refacade.getAllRequisitionEmployee(u);
}