public IActionResult Index([Bind("depName")] Department dep)
{
if (ModelState.IsValid)
{
_siparisTakipDB.Add(dep);
_siparisTakipDB.SaveChanges();
}
return(RedirectToAction("Index", "Department"));
}
public async Task <IActionResult> Create([Bind("userId,userName,userSurname,userMail,userPassword")] User user)
{
if (ModelState.IsValid)
{
_context.Add(user);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(user));
}
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 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 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"));
}
