public ActionResult Create([Bind(Include="tftID,tftName,accountNo,createdDate,createdUser,modifiedDate,modifiedUser")] typeFinanceTransaction typefinancetransaction) { if (acm.cekSession() == false) return RedirectToAction("Logout", "Account"); lvm = Session["sessionUserLogin"] as LoginViewModel.userLogin; if (acm.cekValidation(Url.Action().ToString()) == false && lvm.isAdmin == false) return RedirectToAction("NotAuthorized", "Account", new { menu = Url.Action().ToString() }); ViewBag.ddlTft = DDLTypeFinanceTransaction(""); ViewBag.ddlAccount = new SelectList(db.chartOfAccounts.Where(x => x.levelID == 3).Select(x => new { x.id, accountName = "[" + x.accountNo + "] " + x.accountName }), "id", "accountName"); if (ModelState.IsValid) { lvm = Session["sessionUserLogin"] as LoginViewModel.userLogin; try { using (TransactionScope ts = new TransactionScope()) { typefinancetransaction.createdDate = DateTime.Now; typefinancetransaction.createdUser = lvm.userID; db.typeFinanceTransactions.Add(typefinancetransaction); db.SaveChanges(); ts.Complete(); } return RedirectToAction("Index"); } catch(Exception exc) { string a = exc.Message; } } return View(typefinancetransaction); }
public ActionResult Create(level level) { if (acm.cekSession() == false) return RedirectToAction("Logout", "Account"); lvm = Session["sessionUserLogin"] as LoginViewModel.userLogin; if (acm.cekValidation(Url.Action().ToString()) == false && lvm.isAdmin == false) return RedirectToAction("NotAuthorized", "Account", new { menu = Url.Action().ToString() }); if (ModelState.IsValid) { lvm = Session["sessionUserLogin"] as LoginViewModel.userLogin; level.createdUser = lvm.userID; level.createdDate = DateTime.Now; db.levels.Add(level); db.SaveChanges(); if (level.levelID > 0) { //harusnya kesini return RedirectToAction("Edit", "Level", new { id = level.levelID }); } else { return RedirectToAction("Index"); } } return View(level); }
// GET: /EmployeeClaimMedical/ public ActionResult Index() { if (acm.cekSession() == false) return RedirectToAction("Logout", "Account"); loadDefault(string.Empty); lvm = Session["sessionUserLogin"] as LoginViewModel.userLogin; return View(db.employeeClaimMedicals.Where(x=>x.employeeID==lvm.employeeId).ToList()); }
public async Task<ActionResult> loadDetail(DateTime startDate, DateTime endDate) { if (acm.cekSession() == false) return RedirectToAction("Logout", "Account"); lvm = Session["sessionUserLogin"] as LoginViewModel.userLogin; if (acm.cekValidation(Url.Action().ToString()) == false && lvm.isAdmin == false) return RedirectToAction("NotAuthorized", "Account", new { menu = Url.Action().ToString() }); ViewBag.linkAction = "?startDate=" + startDate.ToString() + "&endDate=" + endDate.ToString(); string strConnection = conDB.conString;// System.Configuration.ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString; using (SqlCommand cmd = new SqlCommand()) { using (SqlDataAdapter da = new SqlDataAdapter()) { DataTable ds = new DataTable(); cmd.CommandText = "sp_reportAttendanceSummary"; cmd.Connection = new SqlConnection(strConnection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@startDate", startDate); cmd.Parameters.AddWithValue("@endDate", endDate); da.SelectCommand = cmd; da.Fill(ds); foreach (IDataParameter param in cmd.Parameters) { if (param.Value == null) param.Value = DBNull.Value; } //if (ds.Rows.Count > 0) ViewBag.detail = ds; } } List<string> periodAttendance = new List<string>(); DateTime dateStarted = startDate; int yearStartPeriod = startDate.Year; int monthStartPeriod = startDate.Month; for (int i = 0; i <= ((endDate - startDate).TotalDays); i++ ) { periodAttendance.Add(dateStarted.ToString("dd-MMM-yyyy")); if(DateTime.DaysInMonth(yearStartPeriod, monthStartPeriod) == dateStarted.Day) dateStarted = new DateTime(dateStarted.Year, dateStarted.Month, 1).AddMonths(1); else dateStarted = dateStarted.AddDays(1); } ViewBag.AttendancePeriod = periodAttendance; string sql = string.Empty; sql += "SELECT * FROM dbo.v_employee WHERE resignDate IS NULL"; DataTable dtEmployee = conDB.executeReader(sql); ViewBag.dtEmployee = dtEmployee; ViewBag.typeAbsensi = db.typeAbsensis.ToList(); return PartialView("ReportSummaryAttendance_PartialPage"); }
// GET: /Vendor/ public ActionResult Index() { if (acm.cekSession() == false) return RedirectToAction("Logout", "Account"); lvm = Session["sessionUserLogin"] as LoginViewModel.userLogin; if (acm.cekValidation(Url.Action().ToString()) == false && lvm.isAdmin == false) return RedirectToAction("NotAuthorized", "Account", new { menu = Url.Action().ToString() }); return View(db.vendors.ToList()); }
// GET: /MenuValidation/Create public ActionResult Create() { if (acm.cekSession() == false) return RedirectToAction("Logout", "Account"); lvm = Session["sessionUserLogin"] as LoginViewModel.userLogin; if (acm.cekValidation(Url.Action().ToString()) == false && lvm.isAdmin == false) return RedirectToAction("NotAuthorized", "Account", new { menu = Url.Action().ToString() }); ViewBag.MenuParent = cm.ddlMenuParent(string.Empty); ViewBag.menuExclusive = cm.ddlMenuValidationExclusive(""); var menuAssign = db.Menus.Where(m => m.menuIsActive == true && m.menuLink != null) // && m.menuParent != 30 && m.menuID != 30) .ToList(); ViewBag.userID = new SelectList(db.Users.Where(m => m.isActive == true && m.userID != "admin").ToList(), "userID", "userName"); var modelMenu = new menuValidation(); for(int i=0;i<menuAssign.Count;i++) { var editor = new menuValidation.SelectMenuAuthorize() { Id = Convert.ToInt32(menuAssign[i].menuID.ToString()), menuSelected = false, Name = menuAssign[i].menuName.ToString() }; modelMenu.MenuAuth.Add(editor); } ViewData["menuGeneral"] = modelMenu.MenuAuth.OrderBy(x=>x.Name).ToList(); #region checkBoxUser var modelUser = new user(); var tempUser = db.Users.Where(x => x.userID != "admin" && x.isActive == true).ToList(); foreach (var a in tempUser) { var editor = new user.SelectActionUser() { userId = a.userID, userSelected = false, userName = a.userName }; modelUser.userCheckBox.Add(editor); } ViewData["userAssign"] = modelUser.userCheckBox.OrderBy(x => x.userName).ToList(); #endregion //var ax = new SelectList(db.Menus.Where(m => m.menuIsActive == true && m.menuLink != null), "menuID", "menuName"); //List<SelectListItem> categoryList = new List<SelectListItem>(); //foreach(var a in ax.ToList()) //{ // categoryList.Add(new SelectListItem { Text = a.Text, Value = a.Value }); //} //model.CategoryItems = categoryList; return View(); }
// GET: /Bank/Create public ActionResult Create() { if (acm.cekSession() == false) return RedirectToAction("Logout", "Account"); lvm = Session["sessionUserLogin"] as LoginViewModel.userLogin; if (acm.cekValidation(Url.Action().ToString()) == false && lvm.isAdmin == false) return RedirectToAction("NotAuthorized", "Account", new { menu = Url.Action().ToString() }); ViewBag.coa = new SelectList((db.chartOfAccounts.Where(x => x.levelID == 3 && x.accountName.Contains("bank")).Select(x => new { x.id, x.accountName}).OrderBy(x => x.accountName)), "id", "accountName"); return View(); }
public async Task<ActionResult> ApprovalProcess(string act, string id) { lvm = Session["sessionUserLogin"] as LoginViewModel.userLogin; purchaseRequestHeader model = db.purchaseRequestHeaders.Find(id); model.approvedStatus = act == "approved" ? true : false; model.approvedDate = DateTime.Now; model.approvedBy = lvm.userID; db.Entry(model).State = EntityState.Modified; db.SaveChanges(); return RedirectToAction("Index", "PurchaseRequestHeader"); }
// GET: /Bank/ public ActionResult Index() { if (acm.cekSession() == false) return RedirectToAction("Logout", "Account"); lvm = Session["sessionUserLogin"] as LoginViewModel.userLogin; if (acm.cekValidation(Url.Action().ToString()) == false && lvm.isAdmin == false) return RedirectToAction("NotAuthorized", "Account", new { menu = Url.Action().ToString() }); ViewData["coa"] = db.chartOfAccounts.Where(x => x.levelID == 3 && x.accountName.Contains("bank")).ToList(); return View(db.banks.ToList()); }
// GET: /GroupEmail/ public ActionResult Index() { if (acm.cekSession() == false) return RedirectToAction("Logout", "Account"); lvm = Session["sessionUserLogin"] as LoginViewModel.userLogin; if (acm.cekValidation(Url.Action().ToString()) == false && lvm.isAdmin == false) return RedirectToAction("NotAuthorized", "Account", new { menu = Url.Action().ToString() }); ViewBag.email = db.emails.OrderBy(a=>a.emailName) as IEnumerable<email>; return View(db.groupEmails.ToList()); }
public async Task<ActionResult> ApprovalProcess(string act, string id) { lvm = Session["sessionUserLogin"] as LoginViewModel.userLogin; bankCashPaymentVoucher apv = db.bankCashPaymentVouchers.Find(id); apv.approvedStatus = act == "approved" ? true : false; apv.approvedDate = DateTime.Now; apv.approvedBy = lvm.userID; db.Entry(apv).State = EntityState.Modified; db.SaveChanges(); return RedirectToAction("Index"); }
// GET: /User/Create public ActionResult Create() { if (acm.cekSession() == false) return RedirectToAction("Logout", "Account"); lvm = Session["sessionUserLogin"] as LoginViewModel.userLogin; if (acm.cekValidation(Url.Action().ToString()) == false && lvm.isAdmin == false) return RedirectToAction("NotAuthorized", "Account", new { menu = Url.Action().ToString() }); ViewBag.Dept = new SelectList(db.departments.ToList(),"deptID","deptName"); return View(); }
// GET: /Divisi/ public ActionResult Index() { if (acm.cekSession() == false) return RedirectToAction("Logout", "Account"); lvm = Session["sessionUserLogin"] as LoginViewModel.userLogin; if (acm.cekValidation(Url.Action().ToString()) == false && lvm.isAdmin == false) return RedirectToAction("NotAuthorized", "Account", new { menu = Url.Action().ToString() }); ViewData["Dept"] = db.departments.ToList(); return View(db.divisis.OrderBy(x => new { x.deptID, x.divisiName }).ToList()); }
// GET: /SisaSaldoCuti/ public ActionResult Index() { if (acm.cekSession() == false) return RedirectToAction("Logout", "Account"); lvm = Session["sessionUserLogin"] as LoginViewModel.userLogin; if (acm.cekValidation(Url.Action().ToString()) == false && lvm.isAdmin == false) return RedirectToAction("NotAuthorized", "Account", new { menu = Url.Action().ToString() }); //loadAbsensi(DateTime.Now.Year); return View(db.sisaSaldoCutis.ToList()); }
// GET: /Vendor/Create public ActionResult Create() { if (acm.cekSession() == false) return RedirectToAction("Logout", "Account"); lvm = Session["sessionUserLogin"] as LoginViewModel.userLogin; if (acm.cekValidation(Url.Action().ToString()) == false && lvm.isAdmin == false) return RedirectToAction("NotAuthorized", "Account", new { menu = Url.Action().ToString() }); ViewBag.Bank = ccm.ddlBank(string.Empty); return View(); }
// // GET: /TrialBalance/ public ActionResult Index() { if (acm.cekSession() == false) return RedirectToAction("Logout", "Account"); lvm = Session["sessionUserLogin"] as LoginViewModel.userLogin; if (acm.cekValidation(Url.Action().ToString()) == false && lvm.isAdmin == false) return RedirectToAction("NotAuthorized", "Account", new { menu = Url.Action().ToString() }); ViewBag.Month = ccm.ddlMonth(DateTime.Now.Month.ToString()); return View(); }
// GET: /TypeFinanceTransaction/Create public ActionResult Create() { if (acm.cekSession() == false) return RedirectToAction("Logout", "Account"); lvm = Session["sessionUserLogin"] as LoginViewModel.userLogin; if (acm.cekValidation(Url.Action().ToString()) == false && lvm.isAdmin == false) return RedirectToAction("NotAuthorized", "Account", new { menu = Url.Action().ToString() }); ViewBag.ddlTft = DDLTypeFinanceTransaction(""); ViewBag.ddlAccount = new SelectList(db.chartOfAccounts.Where(x => x.levelID == 3).Select(x => new { x.id, accountName = "[" + x.accountNo + "] " + x.accountName }), "id", "accountName"); return View(); }
// GET: /TypeFinanceTransaction/ public ActionResult Index() { if (acm.cekSession() == false) return RedirectToAction("Logout", "Account"); lvm = Session["sessionUserLogin"] as LoginViewModel.userLogin; if (acm.cekValidation(Url.Action().ToString()) == false && lvm.isAdmin == false) return RedirectToAction("NotAuthorized", "Account", new { menu = Url.Action().ToString() }); //ViewData["accountName"] = db.chartOfAccounts.Select(x => new { x.accountNo, x.id }).ToList(); ViewBag.accountName = new SelectList(db.chartOfAccounts.Select(x => new { x.accountNo, x.id }),"id","accountNo"); return View(db.typeFinanceTransactions.ToList()); }
// GET: /GroupEmail/Create public ActionResult Create() { if (acm.cekSession() == false) return RedirectToAction("Logout", "Account"); lvm = Session["sessionUserLogin"] as LoginViewModel.userLogin; if (acm.cekValidation(Url.Action().ToString()) == false && lvm.isAdmin == false) return RedirectToAction("NotAuthorized", "Account", new { menu = Url.Action().ToString() }); string[] a = new string[]{}; displayEmailDistributed(a); return View(); }
// GET: /TransReminder/ public ActionResult Index() { if (acm.cekSession() == false) return RedirectToAction("Logout", "Account"); ////Karena masuk Ke dalam menu personal jadi ga usah //lvm = Session["sessionUserLogin"] as LoginViewModel.userLogin; //if (acm.cekValidation(Url.Action().ToString()) == false && lvm.isAdmin == false) // return RedirectToAction("NotAuthorized", "Account", new { menu = Url.Action().ToString() }); lvm = Session["sessionUserLogin"] as LoginViewModel.userLogin; return View(db.transReminders.Where(x=>x.createdUser == lvm.userID).ToList()); }
public async Task<ActionResult> ApprovalProcess(string act, string id) { lvm = Session["sessionUserLogin"] as LoginViewModel.userLogin; int i_id = int.Parse(id); employeeLoan model = db.employeeLoans.Find(i_id); model.approvedStatus = act == "approved" ? true : false; model.approvedDate = DateTime.Now; model.approvedBy = lvm.userID; db.Entry(model).State = EntityState.Modified; db.SaveChanges(); return RedirectToAction("Index"); }
// GET: /MenuValidation/ public ActionResult Index() { if (acm.cekSession() == false) return RedirectToAction("Logout", "Account"); lvm = Session["sessionUserLogin"] as LoginViewModel.userLogin; if (acm.cekValidation(Url.Action().ToString()) == false && lvm.isAdmin == false) return RedirectToAction("NotAuthorized", "Account", new { menu = Url.Action().ToString() }); ViewData["userName"] = db.Users.Where(u => u.isActive == true).ToList(); ViewData["menuName"] = db.Menus.Where(m => m.menuIsActive == true).ToList(); return View(db.MenuValidations.ToList()); }
public async Task<ActionResult> ApprovalCheckDocument(string act, string id) { lvm = Session["sessionUserLogin"] as LoginViewModel.userLogin; purchaseInvoice pInv = db.purchaseInvoices.Find(id); pInv.isCheckDocument = act.ToLower() == "approved" ? true : false; pInv.isCheckDocumentDate = DateTime.Now; pInv.isCheckDocumentUser = lvm.userID; db.Entry(pInv).State = EntityState.Modified; db.SaveChanges(); return RedirectToAction("Index"); }
// // GET: /Absensi/ public ActionResult Index() { if (acm.cekSession() == false) return RedirectToAction("Logout", "Account"); lvm = Session["sessionUserLogin"] as LoginViewModel.userLogin; List<SelectListItem> list = new List<SelectListItem>(); list.Add(new SelectListItem { Value = lvm.employeeId.ToString(), Text = lvm.employeeName }); //ViewBag.EmployeeList = ccm.ddlAbsensiEmployee(0, string.Empty);//munculin bawahan ~ga dipake dl, karena ga ada setup atassan ViewBag.EmployeeList = new SelectList(list, "Value", "Text", lvm.employeeId); ViewBag.employeeID = lvm.employeeId; return View(); }
public ActionResult Create([Bind(Include="groupEmailID,groupEmailName,emailAddress,modifiedDate,modifiedUser")] groupEmail groupemail) { if (acm.cekSession() == false) return RedirectToAction("Logout", "Account"); lvm = Session["sessionUserLogin"] as LoginViewModel.userLogin; if (acm.cekValidation(Url.Action().ToString()) == false && lvm.isAdmin == false) return RedirectToAction("NotAuthorized", "Account", new { menu = Url.Action().ToString() }); string[] a = new string[] { }; displayEmailDistributed(a); if (ModelState.IsValid) { lvm = Session["sessionUserLogin"] as LoginViewModel.userLogin; #region collect email distributed var countChk = 0; for (int i = 0; i < Request.Form.Count; i++) { if (Request.Form.AllKeys.ToList()[i].Contains(".Selected")) countChk++; } string checkedList = string.Empty; for (int i = 0; i < countChk; i++) { var checkboxValue = Request.Form["[" + i + "].Selected"].Split(','); if (checkboxValue[0].ToString().ToLower() != "false") { checkedList += checkboxValue[0].ToString() + ","; } } checkedList = checkedList.Substring(0, checkedList.Length - 1); groupemail.emailAddress = checkedList; #endregion groupemail.modifiedDate = DateTime.Now; groupemail.modifiedUser = lvm.userID; db.groupEmails.Add(groupemail); db.SaveChanges(); return RedirectToAction("Index"); } return View(groupemail); }
// GET: /LeaveRequest/Details/5 public ActionResult Details(int? id, int empId) { if (acm.cekSession() == false) return RedirectToAction("Logout", "Account"); lvm = Session["sessionUserLogin"] as LoginViewModel.userLogin; if (acm.cekValidation(Url.Action().ToString()) == false && lvm.isAdmin == false) return RedirectToAction("NotAuthorized", "Account", new { menu = Url.Action().ToString() }); if (id == null) { return new HttpStatusCodeResult(HttpStatusCode.BadRequest); } var tlq = db.transLeaveRequests.Where(x => x.leaveRequestID == id && x.employeeID == empId).ToList(); if (tlq == null) { return HttpNotFound(); } transLeaveRequest transleaverequest = new transLeaveRequest(); foreach (var a in tlq as IEnumerable<transLeaveRequest>) { transleaverequest.acknowledgeBy = a.acknowledgeBy; transleaverequest.acknowledgeDate = a.acknowledgeDate; transleaverequest.acknowledgeStatus = a.acknowledgeStatus; transleaverequest.approvedBy = a.approvedBy; transleaverequest.approvedDate = a.approvedDate; transleaverequest.approvedStatus = a.approvedStatus; transleaverequest.createdDate = a.createdDate; transleaverequest.createdUser = a.createdUser; transleaverequest.employeeID = a.employeeID; transleaverequest.category = a.category; transleaverequest.cutiInHoliday = a.cutiInHoliday; transleaverequest.leaveDescription = a.leaveDescription; transleaverequest.leaveEndDate = a.leaveEndDate; transleaverequest.leaveRequestID = a.leaveRequestID; transleaverequest.leaveStartDate = a.leaveStartDate; transleaverequest.modifiedDate = a.modifiedDate; transleaverequest.modifiedUser = a.modifiedUser; var employeeName = db.employees.Where(x => x.employeeID == a.employeeID).ToList(); ViewBag.employeeName = employeeName[0].employeeName; } return View(transleaverequest); }
// GET: /Potongan/Details/5 public ActionResult Details(int? id) { if (acm.cekSession() == false) return RedirectToAction("Logout", "Account"); lvm = Session["sessionUserLogin"] as LoginViewModel.userLogin; if (acm.cekValidation(Url.Action().ToString()) == false && lvm.isAdmin == false) return RedirectToAction("NotAuthorized", "Account", new { menu = Url.Action().ToString() }); if (id == null) { return new HttpStatusCodeResult(HttpStatusCode.BadRequest); } potongan potongan = db.potongans.Find(id); if (potongan == null) { return HttpNotFound(); } return View(potongan); }
public ActionResult Create(vendor vendor) { if (acm.cekSession() == false) return RedirectToAction("Logout", "Account"); lvm = Session["sessionUserLogin"] as LoginViewModel.userLogin; if (acm.cekValidation(Url.Action().ToString()) == false && lvm.isAdmin == false) return RedirectToAction("NotAuthorized", "Account", new { menu = Url.Action().ToString() }); if (ModelState.IsValid) { lvm = Session["sessionUserLogin"] as LoginViewModel.userLogin; vendor.createdUser = lvm.userID; vendor.createdDate = DateTime.Now; db.vendors.Add(vendor); db.SaveChanges(); return RedirectToAction("Edit", "Vendor", new { id = vendor.id }); } return View(vendor); }
public ActionResult Create([Bind(Include="typeAbsensiID,typeAbsensiName,createdUser,createdDate,modifiedUser,modifiedDate")] typeAbsensi typeabsensi) { if (acm.cekSession() == false) return RedirectToAction("Logout", "Account"); lvm = Session["sessionUserLogin"] as LoginViewModel.userLogin; if (acm.cekValidation(Url.Action().ToString()) == false && lvm.isAdmin == false) return RedirectToAction("NotAuthorized", "Account", new { menu = Url.Action().ToString() }); if (ModelState.IsValid) { lvm = Session["sessionUserLogin"] as LoginViewModel.userLogin; typeabsensi.createdUser = lvm.userID; typeabsensi.createdDate = DateTime.Now; db.typeAbsensis.Add(typeabsensi); db.SaveChanges(); return RedirectToAction("Index"); } return View(typeabsensi); }
public ActionResult Create([Bind(Include="id,subject,createdUser,createdDate,modifiedUser,modifiedDate")] potongan potongan) { if (acm.cekSession() == false) return RedirectToAction("Logout", "Account"); lvm = Session["sessionUserLogin"] as LoginViewModel.userLogin; if (acm.cekValidation(Url.Action().ToString()) == false && lvm.isAdmin == false) return RedirectToAction("NotAuthorized", "Account", new { menu = Url.Action().ToString() }); if (ModelState.IsValid) { lvm = Session["sessionUserLogin"] as LoginViewModel.userLogin; potongan.createdUser = lvm.userID; potongan.createdDate = DateTime.Now; db.potongans.Add(potongan); db.SaveChanges(); return RedirectToAction("Index"); } return View(potongan); }