public ActionResult Create([Bind(Include = "Mail_Id,MailSubject,MailBody,MailTo,MailCC,MailBCC,IsBodyHtml,IsSend,SendDate,ErrorMessage,CreatedDate,CreatedUser")] Mails mails) { if (ModelState.IsValid) { db.Mails.Add(mails); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(mails)); }
public ActionResult ProductAdder(Products product) { Products newproduct = new Products(); using (var db = new KTOtomasyonEntities()) { if (Request.Files.Count > 0) { var file = Request.Files[0]; if (file != null && file.ContentLength > 0) { var fileName = Path.GetFileName(file.FileName); var path = Path.Combine(Server.MapPath("~/img/producticons/"), fileName); file.SaveAs(path); } } newproduct.Name = product.Name; newproduct.PhotoUrl = product.PhotoUrl; newproduct.IsActive = true; db.Products.Add(newproduct); db.SaveChanges(); } return(RedirectToAction("Index", "Home")); }
public ActionResult UserUpdate(Users user) { Users userupdate = null; try { using (var db = new KTOtomasyonEntities()) { userupdate = db.Users.Where(d => d.User_Id == user.User_Id).First(); userupdate.Name = user.Name; userupdate.Gender = user.Gender; userupdate.Birthday = user.Birthday; userupdate.Mail = user.Mail; userupdate.Password = user.Password; userupdate.UserType = 1; userupdate.IsDeleted = false; userupdate.IsActive = true; db.SaveChanges(); } } catch (Exception ex) { ex.AddToDBLog("HomeController.UserUpdate", "Sıkıntı Büyük"); } return(RedirectToAction("UserDetail", new { id = user.User_Id })); }
//Veritabanına log ekler. public static void AddToDBLog(this Exception exc, string MethodName, string Message = "") { Logs logum = new Logs(); using (var db = new KTOtomasyonEntities()) { logum.CreatedDate = DateTime.Now; logum.CreatedUser = Convert.ToInt32(HttpContext.Current.Session["UserId"]); logum.ExMessage = exc.ToString(); logum.MethodName = MethodName; logum.Message = Message; db.Logs.Add(logum); db.SaveChanges(); } }
public ActionResult OperationUpdate(Operations operation) { Operations op = null; using (var db = new KTOtomasyonEntities()) { op = db.Operations.Where(x => x.Operation_Id == operation.Operation_Id).First(); op.Product_Id = operation.Product_Id; op.Name = operation.Name; op.Price = operation.Price; op.IsActive = true; db.SaveChanges(); } return(RedirectToAction("NewOperation", "Home")); }
public ActionResult OperationAdder(Operations operation) { Operations op = new Operations(); using (var db = new KTOtomasyonEntities()) { op.Product_Id = operation.Product_Id; op.Name = operation.Name; op.Price = operation.Price; op.IsActive = true; db.Operations.Add(op); db.SaveChanges(); } return(RedirectToAction("Operations", "Home")); }
public ActionResult UserAdder(Users user) { Users useradd = new Users(); using (var db = new KTOtomasyonEntities()) { useradd.Name = user.Name; useradd.Gender = user.Gender; useradd.Mail = user.Mail; useradd.Password = user.Name; useradd.IsDeleted = false; useradd.UserType = 1; db.Users.Add(useradd); db.SaveChanges(); } return(RedirectToAction("Index", "Home")); }
//Veritabanına mail ekler. public static void AddToDBMail(string subject, string body, string fromadd, string toadd) { Mails mailim = new Mails(); using (var db = new KTOtomasyonEntities()) { mailim.CreatedDate = DateTime.Now; mailim.CreatedUser = Convert.ToInt32(HttpContext.Current.Session["UserId"]); mailim.MailTo = toadd.ToString(); mailim.MailFrom = fromadd.ToString(); mailim.MailBody = body.ToString(); mailim.MailSubject = subject.ToString(); mailim.SendDate = DateTime.Now; mailim.IsSend = true; mailim.IsBodyHtml = false; db.Mails.Add(mailim); db.SaveChanges(); } }
public ActionResult UserDelete(Users user) { if (Session["UserId"] == null) { return(RedirectToAction("Index", "Login")); } else { Users userdelete = null; using (var db = new KTOtomasyonEntities()) { userdelete = db.Users.Where(d => d.User_Id == user.User_Id).First(); userdelete.IsDeleted = true; db.SaveChanges(); } return(RedirectToAction("Index")); } }
public ActionResult OrderDelete(int Order_Id) { using (TransactionScope scope = new TransactionScope()) { try { using (var db = new KTOtomasyonEntities()) { Orders orderdelete = null; var orderadd = db.Orders.Where(x => x.Order_Id == Order_Id).FirstOrDefault(); orderdelete = db.Orders.Where(x => x.Order_Id == Order_Id).FirstOrDefault(); orderdelete.CreatedUser = orderadd.CreatedUser; orderdelete.CustomerName = orderadd.CustomerName; orderdelete.PhoneNumber = orderadd.PhoneNumber; orderdelete.Debt = orderadd.Debt; orderdelete.Discount = orderadd.Discount; orderdelete.Addition = orderadd.Addition; orderdelete.OrderDate = orderadd.OrderDate; orderdelete.CreatedDate = orderadd.CreatedDate; orderdelete.IsPaid = orderadd.IsPaid; orderdelete.IsDelivered = orderadd.IsDelivered; orderdelete.IsDeleted = true; db.SaveChanges(); scope.Complete(); } } catch (Exception ex) { scope.Dispose(); ex.AddToDBLog("HomeController.OrderDelete", ex.Message); } } return(RedirectToAction("Index", "Home")); }
public JsonResult DefaultSendMail() { ReturnValue retVal = new ReturnValue(); try { retVal.success = false; SmtpClient smtp = new SmtpClient("smtp-mail.outlook.com", 587); //587 smtp.DeliveryMethod = SmtpDeliveryMethod.Network; smtp.EnableSsl = true; smtp.UseDefaultCredentials = false; smtp.Credentials = new System.Net.NetworkCredential("*****@*****.**", "3428simple"); MailMessage mail = new MailMessage(); mail.From = new MailAddress("*****@*****.**", "Simple Terzi - Axis"); mail.To.Add(new MailAddress("*****@*****.**")); //mail.CC.Add(new MailAddress("*****@*****.**")); mail.Bcc.Add(new MailAddress("*****@*****.**", "Zübeyir KOÇALİOĞLU")); Mails addmail = new Mails(); using (var db = new KTOtomasyonEntities()) { var Data = db.vTodayTotalOrder.OrderByDescending(x => x.Sira).ToList(); var ThisMessageBody = Data.First(); mail.Subject = "Simple Terzi Sipariş Rapor"; mail.Body = "Bugün : Toplam sipariş miktarı '"; mail.Body += ThisMessageBody.SipMiktar + "' ve sipariş tutarı '" + ThisMessageBody.SipTutar + "'₺ dir."; addmail.CreatedDate = DateTime.Now; addmail.MailTo = "*****@*****.**"; addmail.MailBCC = "*****@*****.**"; addmail.MailBody = "Bugün : Toplam sipariş miktarı '"; addmail.MailBody += ThisMessageBody.SipMiktar + "' ve sipariş tutarı '" + ThisMessageBody.SipTutar + "'₺ dir."; addmail.MailSubject = "Simple Terzi Sipariş Rapor"; addmail.SendDate = DateTime.Now; addmail.IsSend = true; db.Mails.Add(addmail); db.SaveChanges(); } smtp.Send(mail); retVal.success = true; retVal.message = "mail gönderildi"; } catch (Exception ex) { ex.AddToDBLog("SendMail", ex.Message); retVal.message = "mail gönderilemedi"; retVal.error = ex.Message; retVal.success = true; } return(Json(retVal)); }
//Sipariş kaydet işlemini gerçekleştirir. public JsonResult OrderSave(OrderWithDetail orderWithDetail) { Orders orderadd = new Orders(); ReturnValue ret = new ReturnValue(); if (Shared.CheckSession() == false) { ret.requiredLogin = true; ret.message = "Lütfen giriş yapınız."; ret.success = false; return(Json(ret)); } using (TransactionScope scope = new TransactionScope()) { try { ret.success = false; //Sipariş id'sine göre kayıtları databaseden çeker using (var db = new KTOtomasyonEntities()) { if (orderWithDetail.OrderDetails == null || orderWithDetail.OrderDetails.Count == 0) { ret.requiredLogin = false; ret.message = "Lütfen işlem giriniz."; ret.success = false; return(Json(ret)); } if (orderWithDetail.Order_Id != 0) { orderadd = db.Orders.Where(x => x.Order_Id == orderWithDetail.Order_Id).FirstOrDefault(); } orderadd.CustomerName = orderWithDetail.CustomerName; orderadd.PhoneNumber = orderWithDetail.PhoneNumber; orderadd.Debt = orderWithDetail.Debt; orderadd.Addition = orderWithDetail.Addition; orderadd.Discount = orderWithDetail.Discount; orderadd.OrderDate = orderWithDetail.OrderDate; orderadd.CreatedDate = DateTime.Now; orderadd.CreatedUser = Convert.ToInt32(Session["UserId"]); orderadd.IsPaid = orderWithDetail.IsPaid; orderadd.IsDelivered = orderWithDetail.IsDelivered; orderadd.IsDeleted = orderWithDetail.IsDeleted; if (orderWithDetail.Order_Id == 0) { db.Orders.Add(orderadd); } db.SaveChanges(); int id = orderadd.Order_Id; foreach (var item in orderadd.OrderDetail.ToList()) { db.OrderDetail.Remove(item); } db.SaveChanges(); foreach (var item in orderWithDetail.OrderDetails) { OrderDetail odetail = new OrderDetail(); odetail.Order_Id = id; odetail.Operation_Id = item.Operation_Id; odetail.Quantity = item.Quantity; odetail.Price = item.Price; odetail.TotalPrice = item.TotalPrice; db.OrderDetail.Add(odetail); } db.SaveChanges(); scope.Complete(); ret.retObject = orderWithDetail; } ret.message = "Başarıyla kaydedildi."; ret.success = true; } catch (Exception ex) { ex.AddToDBLog("HomeController.OrderSave"); ret.success = false; ret.message = ex.Message; scope.Dispose(); } } return(Json(ret)); }