public ActionResult Create([Bind(Include = "Id,客戶Id,職稱,姓名,Email,手機,電話,已刪除")] 客戶聯絡人 客戶聯絡人)
{
if (ModelState.IsValid)
{
// Modified for disallowed duplicate same customer and email
//db.客戶聯絡人.Add(客戶聯絡人);
//db.SaveChanges();
//return RedirectToAction("Index");
if (db.客戶聯絡人.Where(g => g.客戶Id == 客戶聯絡人.客戶Id && g.Email == 客戶聯絡人.Email).Count() == 0)
{
db.客戶聯絡人.Add(客戶聯絡人);
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
//throw new Exception("同一個客戶下的聯絡人，其 Email 不能重複！");
ModelState.AddModelError("CreateErr", "同一個客戶下的聯絡人，其 Email 不能重複！");
}
// end of modify
}
ViewBag.客戶Id = new SelectList(db.客戶資料.Where(c => c.已刪除 == false), "Id", "客戶名稱", 客戶聯絡人.客戶Id);
return(View(客戶聯絡人));
}
public IHttpActionResult Put客戶資料(int id, 客戶資料 客戶資料)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != 客戶資料.Id)
{
return(BadRequest());
}
db.Entry(客戶資料).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!客戶資料Exists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public ActionResult Create([Bind(Include = "Id,客戶Id,職稱,姓名,Email,手機,電話")] 客戶聯絡人 客戶聯絡人)
{
//if (客戶聯絡人.客戶Id == db.客戶聯絡人.Where(i => i.客戶Id > 0) && 客戶聯絡人.Email == db.客戶聯絡人.Where(i => i.Email == ))
//{
// var errormessage = "同一客戶名稱下不得有相同的Email";
// return RedirectToAction("Create", errormessage);
//}
var data = db.客戶聯絡人.Where(i => i.客戶Id == 客戶聯絡人.Id && i.Email == 客戶聯絡人.Email);
if (data != null)
{
var ViewBag = "同一客戶名稱下不得有相同的Email";
return(RedirectToAction("Create", ViewBag));
}
if (ModelState.IsValid)
{
db.客戶聯絡人.Add(客戶聯絡人);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.客戶Id = new SelectList(db.客戶資料, "Id", "客戶名稱", 客戶聯絡人.客戶Id);
return(View(客戶聯絡人));
}
public ActionResult Create(客戶資料 client)
{
if (ModelState.IsValid)
{
db.客戶資料.Add(client);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(client));
}
public ActionResult Create([Bind(Include = "客戶名稱,客戶銀行數量,客戶聯絡人數量")] 清單 清單)
{
if (ModelState.IsValid)
{
db.清單.Add(清單);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(清單));
}
public ActionResult Create([Bind(Include = "Id,客戶分類名稱,IsDelete")] 客戶分類 客戶分類)
{
if (ModelState.IsValid)
{
db.客戶分類.Add(客戶分類);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(客戶分類));
}
public ActionResult Create(客戶銀行資訊 bank, FormCollection fc)
{
if (ModelState.IsValid)
{
bank.客戶Id = Convert.ToInt32(fc.Get("ddlClient"));
db.客戶銀行資訊.Add(bank);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(bank));
}
public ActionResult Create([Bind(Include = "Id,客戶名稱,統一編號,電話,傳真,地址,Email")] 客戶資料 客戶資料)
{
if (ModelState.IsValid)
{
db.客戶資料.Add(客戶資料);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(客戶資料));
}
public ActionResult Create([Bind(Include = "客戶名稱,聯絡人數量,銀行帳戶數量")] 客戶檢視表 客戶檢視表)
{
if (ModelState.IsValid)
{
db.客戶檢視表.Add(客戶檢視表);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(客戶檢視表));
}
public ActionResult Create([Bind(Include = "Id,客戶Id,職稱,姓名,Email,手機,電話")] 客戶聯絡人 客戶聯絡人)
{
if (ModelState.IsValid)
{
db.客戶聯絡人.Add(客戶聯絡人);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.客戶Id = new SelectList(db.客戶資料, "Id", "客戶名稱", 客戶聯絡人.客戶Id);
return(View(客戶聯絡人));
}
public ActionResult Create([Bind(Include = "Id,客戶Id,銀行名稱,銀行代碼,分行代碼,帳戶名稱,帳戶號碼")] 客戶銀行資訊 客戶銀行資訊)
{
if (ModelState.IsValid)
{
db.客戶銀行資訊.Add(客戶銀行資訊);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.客戶Id = new SelectList(db.客戶資料, "Id", "客戶名稱", 客戶銀行資訊.客戶Id);
return(View(客戶銀行資訊));
}
public ActionResult Create(客戶銀行資訊 客戶銀行資訊)
{
if (ModelState.IsValid)
{
客戶銀行資訊.IsDeleted = false;
db.客戶銀行資訊.Add(客戶銀行資訊);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.客戶Id = new SelectList(db.客戶資料, "Id", "客戶名稱", 客戶銀行資訊.客戶Id);
return(View(客戶銀行資訊));
}
public ActionResult Create(客戶資料 newData)
{
if (ModelState.IsValid)
{
db.客戶資料.Add(newData);
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
return(View(newData));
}
}
public ActionResult Create([Bind(Include = "Id,客戶名稱,統一編號,電話,傳真,地址,Email")] 客戶資料 客戶資料)
{
ViewBag.message = webTitle;
if (ModelState.IsValid)
{
客戶資料.是否已刪除 = true;
db.客戶資料.Add(客戶資料);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(客戶資料));
}
public ActionResult Create(客戶聯絡人 contrct, FormCollection fc)
{
var all = db.客戶資料.AsQueryable();
var client = all.Where(c => c.是否已刪除 == false).OrderByDescending(c => c.Id);
SelectList sl = new SelectList(client, "ID", "客戶名稱");
ViewBag.CategoryItems = sl;
if (ModelState.IsValid)
{
contrct.客戶Id = Convert.ToInt32(fc.Get("ddlClient"));
db.客戶聯絡人.Add(contrct);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(contrct));
}
public ActionResult Create([Bind(Include = "Id,客戶名稱,統一編號,電話,傳真,地址,Email")] 客戶資料 客戶資料)
{
if (ModelState.IsValid)
{
客戶資料 客 = db.客戶資料.Where(p => p.IsDelete == 0).FirstOrDefault();
if (客 != null)
{
db.客戶資料.Add(客戶資料);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
return(View(客戶資料));
}
public ActionResult Create([Bind(Include = "Id,客戶名稱,統一編號,電話,傳真,地址,Email")] 客戶資料 客戶資料)
{
if (ModelState.IsValid)
{
if (db.客戶資料.Where(q => q.Email == 客戶資料.Email).Count() > 0)
{
ModelState.AddModelError(string.Empty, "Email重複");
}
else
{
db.客戶資料.Add(客戶資料);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
return(View(客戶資料));
}
public static void RemoveAll()
{
using (var context = new 客戶資料Entities())
{
context.客戶銀行資訊.RemoveRange(context.客戶銀行資訊);
context.客戶聯絡人.RemoveRange(context.客戶聯絡人);
context.客戶資料.RemoveRange(context.客戶資料);
context.SaveChanges();
}
}
public ActionResult Create([Bind(Include = "Id,客戶Id,職稱,姓名,Email,手機,電話")] 客戶聯絡人 客戶聯絡人)
{
if (ModelState.IsValid)
{
if (db.客戶聯絡人.Where(q => q.Email == 客戶聯絡人.Email).Count() > 0)
{
ModelState.AddModelError(string.Empty, "Email重複");
}
else
{
db.客戶聯絡人.Add(客戶聯絡人);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
ViewBag.客戶Id = new SelectList(db.客戶資料, "Id", "客戶名稱", 客戶聯絡人.客戶Id);
return(View(客戶聯絡人));
}
public ActionResult Create([Bind(Include = "Id,客戶Id,職稱,姓名,Email,手機,電話")] 客戶聯絡人 客戶聯絡人)
{
if (ModelState.IsValid)
{
var emailDuplicate = db.客戶聯絡人.Where(p => p.客戶Id == 客戶聯絡人.客戶Id && p.Email == 客戶聯絡人.Email);
if (emailDuplicate.Count() == 0)
{
db.客戶聯絡人.Add(客戶聯絡人);
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
TempData["notice"] = "Email重複，請重新輸入";
}
}
ViewBag.客戶Id = new SelectList(db.客戶資料, "Id", "客戶名稱", 客戶聯絡人.客戶Id);
return(View(客戶聯絡人));
}
public ActionResult Edit([Bind(Include = "Id,客戶Id,職稱,姓名,Email,手機,電話")] 客戶聯絡人 客戶聯絡人)
{
if (ModelState.IsValid)
{
db.Entry(客戶聯絡人).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.客戶Id = new SelectList(customerRepo.All(), "Id", "客戶名稱", 客戶聯絡人.客戶Id);
return(View(客戶聯絡人));
}
public ActionResult BatchUpdate(CustomerBatchUpdateViewModel[] items)
{
if (ModelState.IsValid)
{
foreach (var item in items) //?? items=null
{
客戶聯絡人 客戶聯絡人 = db.客戶聯絡人.Find(item.Id);
客戶聯絡人.客戶Id = item.客戶Id;
客戶聯絡人.職稱 = item.職稱;
客戶聯絡人.姓名 = item.姓名;
客戶聯絡人.Email = item.Email;
客戶聯絡人.手機 = item.手機;
客戶聯絡人.電話 = item.電話;
客戶聯絡人.是否已刪除 = item.是否已刪除;
}
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View());
}
public ActionResult Create([Bind(Include = "Id,客戶Id,職稱,姓名,Email,手機,電話,停用")] 客戶聯絡人 客戶聯絡人)
{
if (ModelState.IsValid)
{
var people = db.客戶聯絡人.Where(x => x.Email == 客戶聯絡人.Email).FirstOrDefault();
if (people != null)
{
TempData["msg"] = "<script>alert('Email不可以重複');</script>";
//throw new Exception("Email不可以重複");
}
else
{
db.客戶聯絡人.Add(客戶聯絡人);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
ViewBag.客戶Id = new SelectList(db.客戶資料, "Id", "客戶名稱", 客戶聯絡人.客戶Id);
return(View(客戶聯絡人));
}
public ActionResult Create(客戶聯絡人 newData)
{
if (ModelState.IsValid)
{
db.客戶聯絡人.Add(newData);
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
var CustData = from A in db.客戶資料
select new
{
A.Id,
A.客戶名稱,
};
List <SelectListItem> mySelectItemList = new List <SelectListItem>();
foreach (var Custitem in CustData)
{
mySelectItemList.Add(new SelectListItem()
{
Text = Custitem.客戶名稱,
Value = Custitem.Id.ToString(),
Selected = Custitem.Id.Equals(newData.客戶Id)
});
}
ViewBag.客戶Id = mySelectItemList;
return(View(newData));
}
}
public ActionResult Create([Bind(Include = "Id,客戶名稱,統一編號,電話,傳真,地址,Email,客戶分類")] 客戶資料 客戶資料)
{
if (ModelState.IsValid)
{
db.客戶資料.Add(客戶資料);
db.SaveChanges();
//repo.Add(客戶資料)
//repo.Update(客戶資料);
//repo.UnitOfWork.Commit();
return(RedirectToAction("Index"));
}
PrepareViewBag();
//客戶資料.客戶分類清單= Get客戶分類清單();
//ViewData.Model = 客戶資料;
return(View(客戶資料));
}
public static void Init()
{
using (var context = new 客戶資料Entities())
{
if (!context.客戶資料.Any(customer => !customer.已刪除))
{
var customers = Random客戶資料(50).ToArray();
var blanks = customers.SelectMany(c => Random銀行資訊(random.Next(1, 10), c.客戶名稱, c.Id)).ToArray();
var concats = customers.SelectMany(c => Random客戶聯絡人(random.Next(1, 10), c.客戶名稱, c.Id)).ToArray();
context.客戶資料.AddOrUpdate(customers);
context.客戶聯絡人.AddOrUpdate(concats);
context.客戶銀行資訊.AddOrUpdate(blanks);
context.SaveChanges();
}
}
}