public ActionResult SubmitToSupervisor([Bind(Include = "Id,Message")] EmpInbox eInbox)
        {
            if (ModelState.IsValid)
            {
                var    Message    = Request.Form["message"];
                int    year       = Convert.ToInt32(Request.Form["year"]);
                int    mont       = Convert.ToInt32(Request.Form["month"]);
                int    EMP_ID     = Convert.ToInt32(Request.Form["emp_id"]);
                int    EMP_Sup_Id = Convert.ToInt32(Request.Form["emp_sup_id"]);
                double EmpPhoneNo = Convert.ToDouble(Request.Form["empphoneno"]);
                eInbox.CreatedDate    = DateTime.Now;
                eInbox.ModifiedDate   = DateTime.Now;
                eInbox.EmployeeId     = EMP_ID;
                eInbox.year           = year;
                eInbox.month          = mont;
                eInbox.FromId         = EMP_ID;
                eInbox.EmpPhoneNumber = EmpPhoneNo;
                eInbox.ToId           = EMP_Sup_Id;
                eInbox.Message        = Message;
                eInbox.MessageStatus  = 1;
                eInbox.SupStatus      = 1;
                db.MyEmpInbox.Add(eInbox);

                db.SaveChanges();
                //return RedirectToAction("Index");
                return(View("~/Views/Inbox/BillsSubmitSuccess.cshtml"));
            }

            return(View(eInbox));
        }
        public ActionResult DeleteConfirmed(int id)
        {
            EmpInbox empInbox = db.MyEmpInbox.Find(id);

            db.MyEmpInbox.Remove(empInbox);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
 public ActionResult Edit([Bind(Include = "Id,EmployeeId,FromId,ToId,Message,MessageStatus,CreatedDate,ModifiedDate")] EmpInbox empInbox)
 {
     if (ModelState.IsValid)
     {
         db.Entry(empInbox).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     return(View(empInbox));
 }
        // GET: Inbox/Delete/5
        public ActionResult Delete(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            EmpInbox empInbox = db.MyEmpInbox.Find(id);

            if (empInbox == null)
            {
                return(HttpNotFound());
            }
            return(View(empInbox));
        }
        /**
         * Resubmit message
         */
        public ActionResult ResubmitMessage(int?inbox_id)
        {
            if (inbox_id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            EmpInbox eInbox = db.MyEmpInbox.Find(inbox_id);

            if (eInbox == null)
            {
                return(HttpNotFound());
            }

            return(View(eInbox));
        }
        public ActionResult ResubmitBill([Bind(Include = "Id,Message")] EmpInbox eInbox)
        {
            if (ModelState.IsValid)
            {
                eInbox.SupStatus    = 4;
                eInbox.ModifiedDate = DateTime.Now;
                db.MyEmpInbox.Attach(eInbox);
                db.Entry(eInbox).Property(x => x.SupStatus).IsModified    = true;
                db.Entry(eInbox).Property(x => x.Message).IsModified      = true;
                db.Entry(eInbox).Property(x => x.ModifiedDate).IsModified = true;
                db.SaveChanges();
                return(PartialView("~/Views/Inbox/ResubmitBillSuccess.cshtml"));
            }

            return(View(eInbox));
        }
        public ActionResult RejectBill([Bind(Include = "Id,Message")] EmpInbox eInbox)
        {
            if (ModelState.IsValid)
            {
                eInbox.SupStatus    = 3;
                eInbox.ModifiedDate = DateTime.Now;
                db.MyEmpInbox.Attach(eInbox);
                db.Entry(eInbox).Property(x => x.SupStatus).IsModified    = true;
                db.Entry(eInbox).Property(x => x.Message).IsModified      = true;
                db.Entry(eInbox).Property(x => x.ModifiedDate).IsModified = true;
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }

            return(View(eInbox));
        }
        public ActionResult ApproveBill(int?inbox_id)
        {
            if (inbox_id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            EmpInbox eInbox = db.MyEmpInbox.Find(inbox_id);

            if (eInbox == null)
            {
                return(HttpNotFound());
            }

            var UserName   = User.Identity.Name;
            var TrimedUser = UserName.TrimStart("UNOCHA\\".ToCharArray());
            var myNumber   = db.MyEmployeeContext.FirstOrDefault(u => u.UserName.Equals(TrimedUser, StringComparison.CurrentCultureIgnoreCase));

            if (myNumber != null)
            {
                if (myNumber.Id != eInbox.ToId)
                {
                    return(HttpNotFound());
                }
                eInbox.SupStatus    = 2;
                eInbox.ModifiedDate = DateTime.Now;
                db.MyEmpInbox.Attach(eInbox);
                db.Entry(eInbox).Property(x => x.SupStatus).IsModified    = true;
                db.Entry(eInbox).Property(x => x.ModifiedDate).IsModified = true;
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }
            else
            {
                return(HttpNotFound());
            }
        }