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 }));
}
public JsonResult GetDateReport(DateTime?FirstOrderDate, DateTime?LastOrderDate)
{
using (var db = new KTOtomasyonEntities())
{
var toplam = db.ToplaTutar(FirstOrderDate, LastOrderDate).First();
return(Json(toplam));
}
}
public JsonResult GetMountlyReport()
{
using (var db = new KTOtomasyonEntities())
{
var result = db.AylikSiparisTutar().ToList();
return(Json(result));
}
}
//Makbuz görüntülenme ekranıdır.
public ActionResult Receipt(int Order_Id)
{
DisplayReceipt orderreceipt = new DisplayReceipt();
if (Session["UserId"] == null)
{
return(RedirectToAction("Index", "Login"));
}
else
{
try
{
using (var db = new KTOtomasyonEntities())
{
var orderdata = db.Orders.Where(x => x.Order_Id == Order_Id).FirstOrDefault();
orderreceipt.Order_Id = orderdata.Order_Id;
orderreceipt.CreatedUser = orderdata.CreatedUser;
orderreceipt.CreatedUserText = orderdata.Users.Name;
orderreceipt.CustomerName = orderdata.CustomerName;
orderreceipt.PhoneNumber = orderdata.PhoneNumber;
orderreceipt.Debt = orderdata.Debt;
orderreceipt.Addition = orderdata.Addition;
//orderreceipt.Discount = orderdata.Discount;
orderreceipt.OrderDate = orderdata.OrderDate;
orderreceipt.CreatedDate = orderdata.CreatedDate;
orderreceipt.TTotalPrice = Convert.ToInt32(orderdata.OrderDetail.Sum(x => x.TotalPrice).Value);
orderreceipt.NTotalPrice = Convert.ToInt32(orderdata.OrderDetail.Sum(x => x.TotalPrice).Value) - ((Convert.ToInt32(orderdata.OrderDetail.Sum(x => x.TotalPrice).Value) * Convert.ToInt32(orderdata.Discount) / 100));
orderreceipt.TQuantity = orderdata.OrderDetail.Sum(x => x.Quantity).Value;
orderreceipt.DetailList = new List <OrderDetails>();
orderreceipt.IsPaid = orderdata.IsPaid.Value;
foreach (var item in orderdata.OrderDetail.ToList())
{
orderreceipt.DetailList.Add(new OrderDetails
{
Operation_Id = item.Operation_Id,
Quantity = item.Quantity,
Price = Convert.ToInt32(item.Price),
TotalPrice = Convert.ToInt32(item.TotalPrice),
OrderDetail_Id = item.OrderDetail_Id,
OperationText = item.Operations.Name,
ProductName = item.Operations.Products.Name
});
}
}
}
catch (Exception ex)
{
ex.AddToDBLog("HomeController.Receipt", ex.Message);
RedirectToAction("ErrorPage", "Home");
}
}
return(PartialView(orderreceipt));
}
//--Kullanıcılar--
public ActionResult Users(int?p, string filter)
{
DisplayUsers user = new DisplayUsers();
if (p == null)
{
p = 1;
}
if (Session["UserId"] == null)
{
return(RedirectToAction("Index", "Login"));
}
else
{
try
{
//Kullanıcıları alıyoruz
using (var db = new KTOtomasyonEntities())
{
//Filter
IQueryable <Users> query = null;
if (string.IsNullOrEmpty(filter))
{
query = db.Users.Where(x => 1 == 1 && x.IsDeleted == false);
}
else
{
query = db.Users.Where(x => x.IsDeleted == false && (x.Name.Contains(filter)));
}
user.UsersList = query.OrderByDescending(x => x.User_Id).Skip(defaultPageSize * (p.Value - 1)).Take(defaultPageSize).ToList();
user.CurrentPage = p.Value;
user.TotalCount = query.Count();
if ((user.TotalCount % defaultPageSize) == 0)
{
user.TotalPage = user.TotalCount / defaultPageSize;
}
else
{
user.TotalPage = (user.TotalCount / defaultPageSize) + 1;
}
}
}
catch (Exception ex)
{
ex.AddToDBLog("HomeController.Users", ex.Message);
RedirectToAction("ErrorPage", "Home");
}
return(View(user));
}
}
//--Ürünler--
public ActionResult Products(int?p, string filter)
{
DisplayProducts product = new DisplayProducts();
if (p == null)
{
p = 1;
}
if (Session["UserId"] == null)
{
return(RedirectToAction("Index", "Login"));
}
else
{
try
{
//Ürünleri alıyoruz
using (var db = new KTOtomasyonEntities())
{
//Filter
IQueryable <Products> query = null;
if (string.IsNullOrEmpty(filter))
{
query = db.Products.Where(x => 1 == 1 && x.IsActive == true);
}
else
{
query = db.Products.Where(x => x.IsActive == true && (x.Name.Contains(filter)));
}
product.ProductList = query.OrderByDescending(x => x.Product_Id).Skip(defaultPageSize * (p.Value - 1)).Take(defaultPageSize).ToList();
product.CurrentPage = p.Value;
product.TotalCount = query.Count();
if ((product.TotalCount % defaultPageSize) == 0)
{
product.TotalPage = product.TotalCount / defaultPageSize;
}
else
{
product.TotalPage = (product.TotalCount / defaultPageSize) + 1;
}
}
}
catch (Exception)
{
RedirectToAction("ErrorPage", "Home");
}
return(View(product));
}
}
// GET: Customer
public ActionResult Index(int?p, string filter)
{
DisplayCustomers customer = new DisplayCustomers();
if (p == null)
{
p = 1;
}
if (Session["UserId"] == null)
{
return(RedirectToAction("Index", "Login"));
}
else
{
try
{
//Ürünleri alıyoruz
using (var db = new KTOtomasyonEntities())
{
//Filter
IQueryable <vCustomers> query = null;
if (string.IsNullOrEmpty(filter))
{
query = db.vCustomers.Where(x => 1 == 1);
}
else
{
query = db.vCustomers.Where(x => x.CustomerName.Contains(filter) && (x.PhoneNumber.Contains(filter)));
}
customer.CustomerList = query.OrderByDescending(x => x.PhoneNumber).Skip(defaultPageSize * (p.Value - 1)).Take(defaultPageSize).ToList();
customer.CurrentPage = p.Value;
customer.TotalCount = query.Count();
if ((customer.TotalCount % defaultPageSize) == 0)
{
customer.TotalPage = customer.TotalCount / defaultPageSize;
}
else
{
customer.TotalPage = (customer.TotalCount / defaultPageSize) + 1;
}
}
}
catch (Exception)
{
RedirectToAction("ErrorPage", "Home");
}
return(View(customer));
}
}
//--Tadilatlar--
public ActionResult Operations(int?p, string filter, string pfilter)
{
DisplayOperations operation = new DisplayOperations();
if (p == null)
{
p = 1;
}
if (Session["UserId"] == null)
{
return(RedirectToAction("Index", "Login"));
}
else
{
try
{
//Tadilatları alıyoruz
using (var db = new KTOtomasyonEntities())
{
//Filter
IQueryable <Operations> query = null;
if (string.IsNullOrEmpty(filter))
{
query = db.Operations.Where(x => x.Product_Id.ToString() == filter && x.IsActive == true);
}
else
{
query = db.Operations.Where(x => x.IsActive == true && (x.Product_Id.ToString().Equals(filter)));
}
operation.OperationList = query.OrderByDescending(x => x.Operation_Id).Skip(defaultPageSize * (p.Value - 1)).Take(defaultPageSize).ToList();
operation.ProductName = db.Products.Where(x => x.Product_Id.ToString() == filter).FirstOrDefault().Name;
operation.CurrentPage = p.Value;
operation.TotalCount = query.Count();
if ((operation.TotalCount % defaultPageSize) == 0)
{
operation.TotalPage = operation.TotalCount / defaultPageSize;
}
else
{
operation.TotalPage = (operation.TotalCount / defaultPageSize) + 1;
}
}
}
catch (Exception)
{
RedirectToAction("ErrorPage", "Home");
}
return(View(operation));
}
}
//Telefon noya göre müşteri bilgisi çeker.
public JsonResult GetPhoneData(string PNumber)
{
OrderWithDetail orderWithDetail = new OrderWithDetail();
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
{
using (var db = new KTOtomasyonEntities())
{
var phonedata = db.Orders.Where(x => x.PhoneNumber == PNumber).FirstOrDefault();
if (phonedata != null)
{
orderWithDetail.Order_Id = phonedata.Order_Id;
orderWithDetail.CustomerName = phonedata.CustomerName;
orderWithDetail.PhoneNumber = phonedata.PhoneNumber;
orderWithDetail.Debt = phonedata.Debt;
orderWithDetail.Discount = phonedata.Discount;
orderWithDetail.OrderDate = DateTime.Now;
ret.message = "Müşteri Bulundu.";
ret.success = true;
ret.retObject = orderWithDetail;
scope.Complete();
}
else
{
ret.message = "Müşteri Bulunamadı.";
ret.success = false;
}
}
}
catch (Exception ex)
{
scope.Dispose();
ret.success = false;
ret.message = ex.Message;
ex.AddToDBLog("HomeController.GetPhoneData");
}
}
return(Json(ret));
}
//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 UserProfile(int id)
{
if (Session["UserId"] == null)
{
return(RedirectToAction("Index", "Login"));
}
else
{
Users userdetail = null;
using (var db = new KTOtomasyonEntities())
{
userdetail = db.Users.Where(d => d.User_Id == id).First();
}
return(View(userdetail));
}
}
//Her ürünün tadilatlarının listesini çeker.
public JsonResult GetOperations(int Product_Id)
{
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
{
using (var db = new KTOtomasyonEntities())
{
var operationdata = db.Operations.Where(x => x.Product_Id == Product_Id).Select(x => new { Name = x.Name, Price = x.Price, Operation_Id = x.Operation_Id }).ToList();
if (operationdata == null)
{
ret.requiredLogin = false;
ret.message = "Lütfen işlem giriniz.";
ret.success = false;
return(Json(ret));
}
ret.retObject = operationdata;
ret.message = "Başarıyla kaydedildi.";
ret.success = true;
scope.Complete();
return(Json(operationdata));
}
}
catch (Exception ex)
{
ret.success = false;
ret.message = ex.Message;
ex.AddToDBLog("HomeController.GetOperations");
scope.Dispose();
}
return(Json(ret));
}
}
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"));
}
public ActionResult OperationEdit(int id)
{
if (Session["UserId"] == null)
{
return(RedirectToAction("Index", "Login"));
}
else
{
Operations op = null;
using (var db = new KTOtomasyonEntities())
{
ViewBag.VBProducts = db.Products.ToList();
op = db.Operations.Where(d => d.Operation_Id == id).First();
}
return(View(op));
}
}
public ActionResult Index(Users user)
{
using (var db = new KTOtomasyonEntities())
{
var userLogin = db.Users.FirstOrDefault(x => x.Mail == user.Mail && x.Password == user.Password && x.IsDeleted == false);
if (userLogin != null)
{
Session["UserId"] = userLogin.User_Id;
Session["Name"] = userLogin.Name;
//Shared.SendLogMail();
return(RedirectToAction("Index", "Home"));
}
else
{
ViewBag.Mesaj = "Hatalı kullanıcı adı ya da şifre!";
return(View());
}
}
}
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"));
}
}
//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 NewOperation()
{
if (Session["UserId"] == null)
{
return(RedirectToAction("Index", "Login"));
}
else
{
try
{
using (var db = new KTOtomasyonEntities())
{
ViewBag.VBProducts = db.Products.ToList();
}
}
catch (Exception e)
{
e.AddToDBLog("Newoperation");
}
}
return(View());
}
//Body ve subject mail gönderir
public ActionResult NowSendMail()
{
try
{
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("*****@*****.**", "********");
MailMessage mail = new MailMessage();
mail.From = new MailAddress("*****@*****.**", "Simple Terzi - Axis");
mail.To.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 LogData = db.Logs.OrderByDescending(x => x.Log_Id).ToList();
var ThisMessageBody = Data.First();
var ThisMessageBody2 = LogData.First();
mail.Subject = "Simple Terzi Sipariş Rapor";
mail.Body = "Bugün, Toplam sipariş miktarı '";
mail.Body += ThisMessageBody.SipMiktar + "' ve sipariş tutarı '" + ThisMessageBody.SipTutar + "'₺ dir.";
mail.Body += "Hata mesajı method adı : '" + ThisMessageBody2.MethodName + "' ve Exception mesajı : '" + ThisMessageBody2.ExMessage;
}
smtp.Send(mail);
}
catch (Exception ex)
{
ex.AddToDBLog("SendMail", ex.Message);
}
return(RedirectToAction("Index", "Home"));
}
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"));
}
//Tüm siparişlerin listelendiği ekrandır.
public ActionResult Index(int?p, string filter, string otype, string oname)
{
DisplayOrderDetail orders = new DisplayOrderDetail();
if (p == null)
{
p = 1;
}
if (Session["UserId"] == null)
{
return(RedirectToAction("Index", "Login"));
}
else
{
try
{
//Siparişleri databeseden alıyoruz
using (var db = new KTOtomasyonEntities())
{
//Filter
IQueryable <vOrders> query = null;
if (string.IsNullOrEmpty(filter))
{
query = db.vOrders.Where(x => 1 == 1);
}
else
{
query = db.vOrders.Where(x => x.CustomerName.Contains(filter) || x.Order_Id.ToString().Equals(filter) || x.PhoneNumber.ToString().Equals(filter));
}
//Skip ve Take parametreleri silindi!
if (string.IsNullOrEmpty(oname))
{
orders.OrdersList = query.OrderByDescending(x => x.Order_Id).ToList();
}
else if (oname == "durum")
{
if (string.IsNullOrEmpty(otype) || otype == "asc")
{
orders.OrdersList = query.OrderByDescending(x => x.Order_Id).Where(x => x.IsDelivered == false).ToList();
}
else if (otype == "desc")
{
orders.OrdersList = query.OrderByDescending(x => x.Order_Id).Where(x => x.IsDelivered == true).ToList();
}
}
}
}
catch (Exception e)
{
e.AddToDBLog("HomeController.Index");
RedirectToAction("ErrorPage", "Home");
}
ViewBag.oname = oname;
ViewBag.otype = otype;
return(View(orders));
}
}
//Tıklanılan siparişin detaylarını getirir.
public JsonResult GetOrderData(int Order_Id)
{
OrderWithDetail orderWithDetail = new OrderWithDetail();
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
{
using (var db = new KTOtomasyonEntities())
{
var orderdata = db.Orders.Where(x => x.Order_Id == Order_Id).FirstOrDefault();
orderWithDetail.Order_Id = orderdata.Order_Id;
orderWithDetail.CreatedUser = orderdata.CreatedUser;
orderWithDetail.CreatedUserText = orderdata.Users.Name;
orderWithDetail.CustomerName = orderdata.CustomerName;
orderWithDetail.PhoneNumber = orderdata.PhoneNumber;
orderWithDetail.Debt = orderdata.Debt;
orderWithDetail.Discount = orderdata.Discount;
orderWithDetail.Addition = orderdata.Addition;
orderWithDetail.OrderDate = orderdata.OrderDate;
orderWithDetail.CreatedDate = orderdata.CreatedDate;
orderWithDetail.IsPaid = orderdata.IsPaid;
orderWithDetail.IsDelivered = orderdata.IsDelivered;
orderWithDetail.IsDeleted = orderdata.IsDeleted;
orderWithDetail.OrderDetails = new List <OrderDetails>();
foreach (var item in orderdata.OrderDetail)
{
orderWithDetail.OrderDetails.Add(new OrderDetails
{
Order_Id = item.Order_Id,
Operation_Id = item.Operation_Id,
Quantity = item.Quantity,
Price = item.Price,
TotalPrice = item.TotalPrice,
OrderDetail_Id = item.OrderDetail_Id,
OperationText = item.Operations.Name
});
}
scope.Complete();
return(Json(orderWithDetail));
}
}
catch (Exception ex)
{
ex.AddToDBLog("HomeController.GetOrderData");
ret.success = false;
ret.message = ex.Message;
scope.Dispose();
}
}
return(Json(ret));
}
//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));
}
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));
}
