public ActionResult CreadeCliInfo(InvClientInfo invClientInfo)
{
ModelState.Remove("id");
ModelState.Remove("initdate");
ModelState.Remove("AccountId");
if (ModelState.IsValid)
{
if (Session["Guid"] != null)
{
string Guid = Session["Guid"].ToString();
InvAccount invAccount = db.InvAccounts.Where(x => x.Guid == Guid).FirstOrDefault();
invClientInfo.AccountId = invAccount.Id;
//invClientInfo.InitDate = DateTime.Now.AddHours(15);
invClientInfo.Status = ClientStatusType.已建立; // =0
db.InvClientInfos.Add(invClientInfo);
db.SaveChanges();
return(Json(true));
}
return(Json(false));
}
return(Json(false));
}
public ActionResult DeleteConfirmed(int id)
{
InvClientInfo invClientInfo = db.InvClientInfos.Find(id);
db.InvClientInfos.Remove(invClientInfo);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "Id,InitDate,AccountId,UniformNumbers,CompName,CompAddress,CompPhoneNumber,Status")] InvClientInfo invClientInfo)
{
if (ModelState.IsValid)
{
db.Entry(invClientInfo).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.AccountId = new SelectList(db.InvAccounts, "Id", "Guid", invClientInfo.AccountId);
return(View(invClientInfo));
}
// GET: InvClientInfoes/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
InvClientInfo invClientInfo = db.InvClientInfos.Find(id);
if (invClientInfo == null)
{
return(HttpNotFound());
}
return(View(invClientInfo));
}
// GET: InvClientInfoes/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
InvClientInfo invClientInfo = db.InvClientInfos.Find(id);
if (invClientInfo == null)
{
return(HttpNotFound());
}
ViewBag.AccountId = new SelectList(db.InvAccounts, "Id", "Guid", invClientInfo.AccountId);
return(View(invClientInfo));
}
public ActionResult UpdateCliEd(InvClientInfo invClientInfo)
{
if (Session["Guid"] != null)
{
string Guid = Session["Guid"].ToString();
InvAccount invAccount = db.InvAccounts.Where(x => x.Guid == Guid).FirstOrDefault();
if (ModelState.IsValid)
{
invClientInfo.AccountId = invAccount.Id; // 單純預防，非必要
db.Entry(invClientInfo).State = EntityState.Modified;
db.SaveChanges();
return(Json(true));
}
return(Json(false));
}
return(Json(false));
}
public ActionResult DeleteCliInfo(int Id)
{
if (Session["Guid"] != null)
{
string Guid = Session["Guid"].ToString();
InvAccount invAccount = db.InvAccounts.Where(x => x.Guid == Guid).FirstOrDefault();
if (ModelState.IsValid)
{
//InvClientInfo invClientInfo = db.InvClientInfos.Find(Id); // 限主索引，且連表格會一起抓，故常與JsonIgnore並用
InvClientInfo invClientInfo = db.InvClientInfos.Where(C => C.AccountId == invAccount.Id && C.Id == Id).FirstOrDefault(); // 限主索引，且連表格會一起抓，故常與JsonIgnore並用
invClientInfo.Status = ClientStatusType.已刪除;
db.Entry(invClientInfo).State = EntityState.Modified;
//db.InvClientInfos.Remove(invClientInfo);
db.SaveChanges();
return(Json(true));
}
return(Json(false));
}
return(Json(false));
}
public ActionResult CheckCliUn(string UniformNumbers)
{
if (Session["Guid"] != null)
{
string Guid = Session["Guid"].ToString();
InvAccount invAccount = db.InvAccounts.Where(x => x.Guid == Guid).FirstOrDefault();
if (ModelState.IsValid)
{
InvClientInfo invClientInfo = db.InvClientInfos.Where(C => C.UniformNumbers == UniformNumbers && C.AccountId == invAccount.Id)
.FirstOrDefault();
if (invClientInfo != null)
{
return(Json(true));
}
return(Json(false));
}
return(Json(false));
}
return(Json(false));
}
