public ActionResult Coment_section(Coment_section send_coment)
{
var get_sec = get_section_store();
var checkid = get_section_user();
List <Coment_section> show_coment = new List <Coment_section>();
using (Order_Food_dbEntities1 db = new Order_Food_dbEntities1())
{
if (send_coment.edit_value == "show")
{
show_coment = db.Coment_section.Where(x => x.customer_name == get_sec).ToList();
send_coment.user_name = checkid;
send_coment.customer_name = get_sec;
send_coment.date = DateTime.Now;
db.Coment_section.Add(send_coment);
db.SaveChanges();
}
else if (send_coment.edit_value == "edit")
{
var edit_coment = db.Coment_section.Single(x => x.id == send_coment.id);
edit_coment.edit_value = send_coment.edit_value;
db.SaveChanges();
}
else if (send_coment.edit_value == "get_edit")
{
var edit_coment = db.Coment_section.Single(x => x.id == send_coment.id);
edit_coment.coment = send_coment.coment;
edit_coment.edit_value = "show";
db.SaveChanges();
}
}
return(View());
}
public ActionResult Add_store_img(HttpPostedFileBase getimg_store, Add_store_img obj)
{
//----------------------new_folder------------------------
string checkid = Session["user_user"].ToString();
string name_folder = Path.Combine(Server.MapPath("~/img/user_img"), checkid, "store_pic");
//----------------------name and save img------------------------
string fileName = Path.GetFileNameWithoutExtension(getimg_store.FileName);
string extention = Path.GetExtension(getimg_store.FileName);
fileName = fileName + DateTime.Now.ToString("yyyyMMdd") + extention;
string path = Path.Combine(Server.MapPath("~/img/user_img" + "/" + checkid), "store_pic", fileName);
using (Order_Food_dbEntities1 db = new Order_Food_dbEntities1())
{
if (System.IO.Directory.Exists(name_folder))
{
getimg_store.SaveAs(path);
var get_img = db.Add_store_img.Single(x => x.customer_name == checkid);
get_img.add_img = fileName;
db.SaveChanges();
}
else
{
Directory.CreateDirectory(name_folder);
getimg_store.SaveAs(path);
obj.add_img = fileName;
obj.customer_name = checkid;
db.Add_store_img.Add(obj);
db.SaveChanges();
}
}
return(RedirectToAction("Homeaddstore", "UsingU"));
}
public ActionResult Add_description(Description get_description)
{
string checkid = Session["user_user"].ToString();
using (Order_Food_dbEntities1 db = new Order_Food_dbEntities1())
{
var check = db.Description.Where(x => x.customer_name == checkid).FirstOrDefault();
if (check != null)
{
var get_descrpt = db.Description.Single(x => x.customer_name == checkid);
get_descrpt.edit_value = get_description.edit_value;
db.SaveChanges();
if (get_descrpt.edit_value == "show")
{
get_descrpt.description1 = get_description.description1;
db.SaveChanges();
}
}
else
{
get_description.customer_name = checkid;
db.Description.Add(get_description);
db.SaveChanges();
}
}
return(View());
}
public ActionResult Get_time_store(Get_time get_time)
{
string checkid = Session["user_user"].ToString();
using (Order_Food_dbEntities1 db = new Order_Food_dbEntities1())
{
var check = db.Get_time.Where(x => x.customer_name == checkid).FirstOrDefault();
if (check != null)
{
var get_nametim = db.Get_time.Single(x => x.customer_name == checkid);
get_nametim.edit_value = get_time.edit_value;
db.SaveChanges();
if (get_nametim.edit_value == "show")
{
get_nametim.day_open = get_time.day_open;
get_nametim.day_close = get_time.day_close;
get_nametim.time_open = get_time.time_open;
get_nametim.time_close = get_time.time_close;
db.SaveChanges();
}
}
else
{
get_time.customer_name = checkid;
db.Get_time.Add(get_time);
db.SaveChanges();
}
}
return(View());
}
public ActionResult Get_c_address(Get_location get_lo)
{
string checkid = Session["user_user"].ToString();
using (Order_Food_dbEntities1 db = new Order_Food_dbEntities1())
{
var check = db.Get_location.Where(x => x.customer_name == checkid).FirstOrDefault();
if (check != null)
{
var get_location_ed = db.Get_location.Single(x => x.customer_name == checkid);
get_location_ed.edit_value = get_lo.edit_value;
db.SaveChanges();
if (get_location_ed.edit_value == "show")
{
get_location_ed.address_street = get_lo.address_street;
get_location_ed.address_district = get_lo.address_district;
get_location_ed.address_county = get_lo.address_county;
get_location_ed.address_province = get_lo.address_province;
db.SaveChanges();
}
}
else
{
get_lo.customer_name = checkid;
db.Get_location.Add(get_lo);
db.SaveChanges();
}
}
return(View());
}
public ActionResult Show_chat()
{
string get_name = get_section_user();
string get_anoter = get_section_store();
List <Chat> get_chat = new List <Chat>();
using (Order_Food_dbEntities1 db = new Order_Food_dbEntities1())
{
try
{
string get_chat_name = Session["get_chat_name"].ToString();
string get_check = Session["get_check"].ToString();
var get_non = db.Alert_customer.Single(x => x.name == get_chat_name && x.user_name == get_name);
if (get_non.alert == "show")
{
get_non.alert = "non";
get_non.date = DateTime.Today;
get_non.time = DateTime.Now.TimeOfDay;
db.SaveChanges();
}
get_chat = db.Chat.Where(x => x.customer_name == get_chat_name && x.user_name == get_name).ToList();
ViewBag.check = "c";
}
catch
{
ViewBag.check = "u";
get_chat = db.Chat.Where(x => x.customer_name == get_name && x.user_name == get_anoter).ToList();
}
}
return(View(get_chat));
}
public ActionResult update_customer(Add_Store obj, HttpPostedFileBase getimg)
{
if (obj.description != null)
{
if (getimg != null)
{
//----------------------new_folder------------------------
string checkid = Session["user_user"].ToString();
string name_folder = Path.Combine(Server.MapPath("~/img/user_img"), checkid);
//----------------------name and save img------------------------
string fileName = Path.GetFileNameWithoutExtension(getimg.FileName);
string extention = Path.GetExtension(getimg.FileName);
fileName = fileName + DateTime.Now.ToString("yyyyMMdd") + extention;
string path = Path.Combine(Server.MapPath("~/img/user_img" + "/" + checkid), fileName);
if (System.IO.Directory.Exists(name_folder))
{
using (Order_Food_dbEntities1 db = new Order_Food_dbEntities1())
{
//List<string> get_list = get_check.ToList();
//List<string> get_name = getname.ToList();
//get_cat.category = get_list.ToString();
//get_cat.customer_name = get_name.ToString();
//db.Get_catagory.Add(get_cat);
getimg.SaveAs(path);
obj.pic = fileName;
obj.name = checkid;
db.Add_Store.Add(obj);
db.SaveChanges();
}
}
else
{
using (Order_Food_dbEntities1 db = new Order_Food_dbEntities1())
{
Directory.CreateDirectory(name_folder);
getimg.SaveAs(path);
obj.pic = fileName;
obj.name = checkid;
db.Add_Store.Add(obj);
db.SaveChanges();
}
}
//List<string> myList = new List<string>();
//Session["var"] = myList;
}
}
else
{
using (Order_Food_dbEntities1 db = new Order_Food_dbEntities1())
{
string checkid = Session["user_user"].ToString();
var img = db.Add_Store.Where(s => s.name == checkid).Select(s => s.pic).ToList();
return(View(img));
}
}
//string fileName = Path.GetFileName(Food_Picture_pic.FileName);
//string path = Path.Combine(Server.MapPath("~/img/user_img"), fileName);
//Food_Picture_pic.SaveAs(path);
return(RedirectToAction("Homeaddstore", "UsingU"));
}
public ActionResult showsaveimg(int get_del)
{
using (Order_Food_dbEntities1 db = new Order_Food_dbEntities1())
{
var del_pic = db.Add_Store.Single(x => x.id == get_del);
db.Add_Store.Remove(del_pic);
db.SaveChanges();
}
return(View());
}
public ActionResult Resgister(User obj, Food_Picture img, HttpPostedFileBase Food_Picture_pic, string Direction, string Province)
{
if (obj.User_user != null)
{
using (Order_Food_dbEntities1 db = new Order_Food_dbEntities1())
{
obj.Status = Direction;
obj.Province = Province;
db.User.Add(obj);
db.SaveChanges();
ViewBag.ab = "ใส้ข้อมูลสำเร็จ";
if (Food_Picture_pic != null && Food_Picture_pic.ContentLength > 0)
{
string fileName = Path.GetFileName(Food_Picture_pic.FileName);
string path = Path.Combine(Server.MapPath("~/img/user_img"), fileName);
Food_Picture_pic.SaveAs(path);
img.Food_Picture_pic = fileName;
img.Food_Picture_name = obj.User_user;
db.Food_Picture.Add(img);
db.SaveChanges();
Food_Picture newrow = new Food_Picture();
ViewData.Model = db.Food_Picture;
ViewBag.savestage = "บันทึกเรียบร้อย";
}
else
{
img.Food_Picture_name = obj.User_user;
img.Food_Picture_pic = "noimg.jpg";
db.Food_Picture.Add(img);
db.SaveChanges();
}
return(RedirectToAction("Login", "Index"));
}
}
else
{
ViewBag.ab = "มีข้าว่างใส้ช้อมูลไม่สำเร็จ";
}
return(View());
}
public ActionResult redit(string user, string re_pw)
{
ViewBag.regis = "เข้า Editpw";
using (Order_Food_dbEntities1 db = new Order_Food_dbEntities1())
{
try
{
var get_repw = db.User.Single(x => x.User_user == user);
get_repw.User_repw = re_pw;
db.SaveChanges();
ViewBag.regis = "ใส้ข้อมูลเรียบร้อย";
}
catch {
ViewBag.regis = "แก้ไขไม่สำเร็จ";
}
return(View());
}
}
public ActionResult Chat_section(Chat send_chat, Alert_customer alet_cu)
{
var get_name = get_section_user();
using (Order_Food_dbEntities1 db = new Order_Food_dbEntities1())
{
try
{
string get_chat_name = Session["get_chat_name"].ToString();
string get_check = Session["get_check"].ToString();
send_chat.customer_name = get_chat_name;
send_chat.user_name = get_name;
send_chat.chexk = "c";
db.Chat.Add(send_chat);
}
catch
{
var get_store = get_section_store();
send_chat.customer_name = get_name;
send_chat.user_name = get_store;
send_chat.chexk = "u";
db.Chat.Add(send_chat);
try
{
var check_null = db.Alert_customer.Single(x => x.name == get_name && x.user_name == get_store);
check_null.date = DateTime.Today;
check_null.time = DateTime.Now.TimeOfDay;
check_null.alert = "show";
}
catch
{
alet_cu.alert = "show";
alet_cu.user_name = get_store;
alet_cu.name = get_name;
alet_cu.date = DateTime.Today;
alet_cu.time = DateTime.Now.TimeOfDay;
db.Alert_customer.Add(alet_cu);
}
}
db.SaveChanges();
}
return(View());
}
public ActionResult Add_food(string[] get_name_menu, string[] get_name_price, Get_menu get_menu)
{
string checkid = Session["user_user"].ToString();
using (Order_Food_dbEntities1 db = new Order_Food_dbEntities1())
{
var check = db.Get_menu.Where(x => x.customer_name == checkid).FirstOrDefault();
if (check != null)
{
//List<Get_menu> get_namemenu = new List<Get_menu>();
var get_namemenu = db.Get_menu.Where(x => x.customer_name == checkid).First();
var a = db.Get_menu.Where(x => x.customer_name == checkid).Select(x => x.edit_value);
foreach (var obj in db.Get_menu.Where(x => x.customer_name == checkid))
{
obj.edit_value = get_menu.edit_value;
}
db.SaveChanges();
if (get_namemenu.edit_value == "show")
{
var data = from customer_name in db.Get_menu where customer_name.customer_name == checkid select customer_name;
foreach (var remove in data)
{
db.Get_menu.Remove(remove);
}
db.SaveChanges();
int i = get_name_menu.Length;
for (int ch = 0; ch < i; ch++)
{
get_menu.customer_name = checkid;
get_menu.Menu_name = get_name_menu[ch];
get_menu.Menu_price = get_name_price[ch];
db.Get_menu.Add(get_menu);
db.SaveChanges();
}
//int i = get_name_menu.Length;
//for (int ch = 0; ch < i; ch++)
//{
// get_namemenu.Menu_name = get_name_menu[ch];
// get_namemenu.Menu_price = get_name_price[ch];
// db.SaveChanges();
//}
}
}
else
{
int i = get_name_menu.Length;
for (int ch = 0; ch < i; ch++)
{
get_menu.customer_name = checkid;
get_menu.Menu_name = get_name_menu[ch];
get_menu.Menu_price = get_name_price[ch];
db.Get_menu.Add(get_menu);
db.SaveChanges();
}
}
}
return(View());
}
public ActionResult Category(string[] ajex_cat, Get_catagory get_catagory)
{
string checkid = Session["user_user"].ToString();
using (Order_Food_dbEntities1 db = new Order_Food_dbEntities1())
{
var check = db.Get_catagory.Where(x => x.customer_name == checkid).FirstOrDefault();
if (check != null)
{
//เลือกที่เซฟจะไป เเล้ว เซฟ
var get_namecat = db.Get_catagory.Single(x => x.customer_name == checkid);
//save สถานะ
get_namecat.edit_value = get_catagory.edit_value;
db.SaveChanges();
if (get_namecat.edit_value == "show")
{
//save ที่แก้ไชมาเเล้ว
int i = ajex_cat.Length;
get_catagory.customer_name = checkid;
switch (i)
{
case 1:
get_namecat.category01 = ajex_cat[0];
get_namecat.category02 = null;
get_namecat.category03 = null;
break;
case 2:
get_namecat.category01 = ajex_cat[0];
get_namecat.category02 = ajex_cat[1];
get_namecat.category03 = null;
break;
case 3:
get_namecat.category01 = ajex_cat[0];
get_namecat.category02 = ajex_cat[1];
get_namecat.category03 = ajex_cat[2];
break;
}
db.SaveChanges();
}
}
else
{
//save ครั้งฃเเรก
int i = ajex_cat.Length;
get_catagory.customer_name = checkid;
switch (i)
{
case 1:
get_catagory.category01 = ajex_cat[0];
break;
case 2:
get_catagory.category01 = ajex_cat[0];
get_catagory.category02 = ajex_cat[1];
break;
case 3:
get_catagory.category01 = ajex_cat[0];
get_catagory.category02 = ajex_cat[1];
get_catagory.category02 = ajex_cat[2];
break;
}
db.Get_catagory.Add(get_catagory);
db.SaveChanges();
}
//List<user_account> ad_st = new List<user_account> { new user_account { name = "", last = "" } };
//var ab = model_car();
//List<Category> loob_cat = new List<Category>();
//using (Order_Food_dbEntities1 db = new Order_Food_dbEntities1())
//{
// loob_cat = db.Category.ToList();
//}
//if (check != null)
//{
// ViewBag.storechek = "true";
// ลูปจาก db เพื่อเอามาใช่งาน
// List<string> a = new List<string>();
// a = db.Get_catagory.Where(x => x.customer_name == checkid).Select(x => x.category01).ToList();
// ViewBag.show_cat = a;
// return View();
//}
//else
//{
// if (ajex_cat != null)
// {
// int i = ajex_cat.Length;
// for (int ch = 0; ch < i; ch++)
// {
// get_cat.category01 = ajex_cat[ch];
// get_cat.customer_name = checkid;
// db.Get_catagory.Add(get_cat);
// db.SaveChanges();
// }
// }
// else
// {
// ViewBag.storechek = "false";
// }
//}
}
//return View(ad_st);
return(View());
}
