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));
}
