public IActionResult Index([Bind("depName")] Department dep) { if (ModelState.IsValid) { _siparisTakipDB.Add(dep); _siparisTakipDB.SaveChanges(); } return(RedirectToAction("Index", "Department")); }
public ActionResult MailUpdate(string settingEPosta, string settingPassword, string settingSmtpHost, int settingSmtpPort, bool settingSmtpSSL) { bool session = SessionCont(); if (session == false) { return(RedirectToAction("Index", "Home")); } string hataMesaji = "", status = "danger"; int settingCount = _siparisTakipDB.Settings.ToList().Count(); if (settingEPosta != null) { if (settingCount == 0) // Mail Yok { hataMesaji = "Mail eklendi."; status = "success"; Setting setting = new Setting { settingEPosta = settingEPosta, settingPassword = settingPassword, settingSmtpHost = settingSmtpHost, settingSmtpPort = settingSmtpPort, settingSmtpSSL = settingSmtpSSL }; _siparisTakipDB.Add(setting); _siparisTakipDB.SaveChanges(); } else // Mail Yok { hataMesaji = "Mail düzenlendi."; status = "success"; Setting setting = _siparisTakipDB.Settings.SingleOrDefault(); setting.settingEPosta = settingEPosta; setting.settingPassword = settingPassword; setting.settingSmtpHost = settingSmtpHost; setting.settingSmtpPort = settingSmtpPort; setting.settingSmtpSSL = settingSmtpSSL; _siparisTakipDB.SaveChanges(); } } else { hataMesaji = "Veriler gonderilirken bir hata oluştu"; } string result = hataMesaji + "|" + status; result = JsonConvert.SerializeObject(result); return(new JsonResult(result)); }
public IActionResult PermissionEdit(int?id) { if (SessionCont() == false) { return(RedirectToAction("Index", "Account")); } if (id == null) { return(NotFound()); } var user = _siparisTakipDB.Users .FirstOrDefault(m => m.userId == id); if (user.userPermission == "Customer") { user.userPermission = "Administrator"; } else { user.userPermission = "Customer"; } _siparisTakipDB.SaveChanges(); int SessionID = Int32.Parse(HttpContext.Session.GetString("userId")); if (id == SessionID) { HttpContext.Session.SetString("userPermission", user.userPermission); } return(RedirectToAction("Index", "UserManagment")); }
public IActionResult RegisterPost(string userMail, string REuserMail, string userName, string userSurname, string userPassword, string REuserPassword, string password) { if (SessionCont() == false) { return(RedirectToAction("Index", "Home")); } if (REuserMail == userMail) { if (REuserPassword == userPassword) { int result = 0; result = _siparisTakipDB.Users.Where(u => u.userMail == userMail && u.userPassword == userPassword).Count(); if (result == 0) { User newUser = new User { userMail = userMail, userName = userName, userSurname = userSurname, userPassword = userPassword, userPermission = "Customer" }; _siparisTakipDB.Add(newUser); _siparisTakipDB.SaveChanges(); TempData["Info"] = "Hesap Başarıyla Oluşturuldu"; TempData["InfoType"] = "success"; } else { TempData["Info"] = "Bu Mail Hesabı Zaten Kayıtlı"; TempData["InfoType"] = "danger"; } } else { TempData["Info"] = "Şifreler Uyuşmuyor"; TempData["InfoType"] = "danger"; } } else { TempData["Info"] = "E-Postalar Uyuşmuyor"; TempData["InfoType"] = "danger"; } return(RedirectToAction(nameof(AccountController.Index), "Account")); }
public IActionResult Edit([Bind("requestId,requestEstimatedPrice,requestDeliveryDate,requestSupplyCompany1," + "requestSupplyCompany2,requestSupplyCompany3," + "requestStatus,requestSpecies,requestQuantity," + "requestDescription,requestProductFeatures,requestExpensePlace," + "requestProject,requestSteff,requestDepartment")] Request req) { bool session = SessionCont(); if (session == false) { return(RedirectToAction("Index", "Home")); } if (ModelState.IsValid) { try { var thisRequest = _siparisTakipDB.Requests.Where(m => m.requestId == req.requestId).FirstOrDefault(); thisRequest.requestDeliveryDate = req.requestDeliveryDate; thisRequest.requestDepartment = req.requestDepartment; thisRequest.requestDescription = req.requestDescription; thisRequest.requestEstimatedPrice = req.requestEstimatedPrice; thisRequest.requestExpensePlace = req.requestExpensePlace; thisRequest.requestProductFeatures = req.requestProductFeatures; thisRequest.requestProject = req.requestProject; thisRequest.requestQuantity = req.requestQuantity; thisRequest.requestSpecies = req.requestSpecies; thisRequest.requestStatus = req.requestStatus; thisRequest.requestSteff = req.requestSteff; thisRequest.requestSupplyCompany1 = req.requestSupplyCompany1; thisRequest.requestSupplyCompany2 = req.requestSupplyCompany2; thisRequest.requestSupplyCompany3 = req.requestSupplyCompany3; _siparisTakipDB.Update(thisRequest); _siparisTakipDB.SaveChanges(); } catch (DbUpdateConcurrencyException) { } return(RedirectToAction("Index", "AllRequests")); } return(View()); }
public ActionResult Delete(int id, string requestDeleteDescription) { string result = "error"; var request = _siparisTakipDB.Requests .FirstOrDefault(m => m.requestId == id); if (request == null) { result = "error"; result = JsonConvert.SerializeObject(result); return(new JsonResult(result)); } request.requestStatus = 2; request.requestDeleteDescription = requestDeleteDescription; _siparisTakipDB.Update(request); _siparisTakipDB.SaveChanges(); result = "success"; result = JsonConvert.SerializeObject(result); return(new JsonResult(result)); }
public ActionResult RequestStatusEdit(string data, int status) { string message = "success"; if (data != null) { data = data.Replace("res[]=", "-"); data = data.Replace("&", ""); string[] id = data.Split('-'); int lastRequestId = -1; if (status == 1) { for (int i = 1; i < id.Length; i++) { Request GelenData = _siparisTakipDB.Requests.Where(m => m.requestId == Int32.Parse(id[i])).SingleOrDefault(); if (GelenData.requestStatus == 0) { lastRequestId = GelenData.requestId; break; } } if (lastRequestId != -1) { //message = lastRequestId + "Mail gidecek"; Request newCheckStatus = _siparisTakipDB.Requests .Include(m => m.user) .Where(m => m.requestId == lastRequestId).SingleOrDefault(); sendMail(newCheckStatus); } } for (int i = 1; i < id.Length; i++) { Request BilgiDegistir = _siparisTakipDB.Requests.SingleOrDefault(k => k.requestId == Int32.Parse(id[i])); BilgiDegistir.requestStatus = status; _siparisTakipDB.SaveChanges(); } } return(new JsonResult(message)); }
public IActionResult CreateRequest( [Bind("requestDepartment", "requestSteff", "requestProject", "requestExpensePlace", "requestProductFeatures", "requestDescription", "requestQuantity", "requestSpecies", "requestEstimatedPrice", "date", "requestSupplyCompany1", "requestSupplyCompany1", "requestSupplyCompany2", "requestSupplyCompany3", "requestUser,", "ImageFile", "PDFFile", "ExcelFile" )] Request request) { try { string resimPath = "resimYok.jpg"; string excelPath = "-"; string pdfPath = "-"; Random rastgele = new Random(); int sayi = rastgele.Next(5555, 25000); string resimler = Path.Combine(_evrimoment.WebRootPath, "images"); string pdfler = Path.Combine(_evrimoment.WebRootPath, "pdf"); string Exceller = Path.Combine(_evrimoment.WebRootPath, "excel"); if (request.PDFFile != null) { string[] parcalaPath = request.PDFFile.FileName.Split("."); if (parcalaPath[parcalaPath.Length - 1] == "pdf" && request.PDFFile.Length > 0) { using (var fileStream = new FileStream(Path.Combine(pdfler, sayi + "-" + request.PDFFile.FileName), FileMode.Create)) { request.PDFFile.CopyTo(fileStream); } pdfPath = sayi + "-" + request.PDFFile.FileName; } } if (request.ExcelFile != null) { string[] parcalaPath = request.ExcelFile.FileName.Split("."); if (parcalaPath[parcalaPath.Length - 1] == "xls" || parcalaPath[parcalaPath.Length - 1] == "xlsx" && request.ExcelFile.Length > 0) { using (var fileStream = new FileStream(Path.Combine(Exceller, sayi + "-" + request.ExcelFile.FileName), FileMode.Create)) { request.ExcelFile.CopyTo(fileStream); } excelPath = sayi + "-" + request.ExcelFile.FileName; } } if (request.ImageFile != null) { if (request.ImageFile.Length > 0) { using (var fileStream = new FileStream(Path.Combine(resimler, sayi + "-" + request.ImageFile.FileName), FileMode.Create)) { request.ImageFile.CopyTo(fileStream); } resimPath = sayi + "-" + request.ImageFile.FileName; } } string nowDate = DateTime.Now.ToShortDateString(); int allDateCount = _siparisTakipDB.Requests.Where(n => n.requestCreateAt == nowDate).Count(); string year = DateTime.Now.Year.ToString(); string mount = DateTime.Now.Month.ToString(); int dayInt = Int32.Parse(DateTime.Now.Day.ToString()); string alldataString = ""; string day = dayInt.ToString(); if (dayInt < 10) { day = "0" + dayInt; } if (allDateCount < 10) { alldataString = "000" + (allDateCount + 1); } else if (allDateCount < 100) { alldataString = "00" + (allDateCount + 1); } else if (allDateCount < 1000) { alldataString = "0" + (allDateCount + 1); } else { alldataString = (allDateCount + 1).ToString(); } request.requestDeliveryDate = Convert.ToDateTime(request.date); request.requestImage = resimPath; request.requestPDF = pdfPath; request.requestExcel = excelPath; request.userId = Int32.Parse(HttpContext.Session.GetString("userId")); request.requestCreateAt = DateTime.Now.ToShortDateString(); request.requestNo = "T" + year + mount + day + "-" + alldataString; request.requestDeleteDescription = ""; request.user = _siparisTakipDB.Users.Where(m => m.userId == request.userId).FirstOrDefault(); _siparisTakipDB.Add(request); _siparisTakipDB.SaveChanges(); } catch (DbUpdateConcurrencyException) { return(RedirectToAction("Index", "Home")); } return(RedirectToAction("Index", "PendingRequests")); }