public ActionResult Create([Bind(Include = "Id,客戶Id,職稱,姓名,Email,手機,電話")] 客戶聯絡人 客戶聯絡人)
{
if (ModelState.IsValid)
{
db.客戶聯絡人.Add(客戶聯絡人);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(客戶聯絡人));
}
public ActionResult Create([Bind(Include = "Id,客戶名稱,統一編號,電話,傳真,地址,Email")] 客戶資料 客戶資料)
{
if (ModelState.IsValid)
{
db.客戶資料.Add(客戶資料);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(客戶資料));
}
public ActionResult Create([Bind(Include = "客戶名稱,contactCounts,bankCounts,Id")] VW_CustomerReport vW_CustomerReport)
{
if (ModelState.IsValid)
{
db.VW_CustomerReport.Add(vW_CustomerReport);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(vW_CustomerReport));
}
public ActionResult Create([Bind(Include = "customerID,customerFirstName,customerLastName,customerPhoneNumber")] customer customer)
{
if (ModelState.IsValid)
{
db.customers.Add(customer);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(customer));
}
public ActionResult Create([Bind(Include = "Id,客戶Id,銀行名稱,銀行代碼,分行代碼,帳戶名稱,帳戶號碼")] 客戶銀行資訊 客戶銀行資訊)
{
if (ModelState.IsValid)
{
db.客戶銀行資訊.Add(客戶銀行資訊);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(客戶銀行資訊));
}
public ActionResult Create(User user)
{
if (ModelState.IsValid)
{
db.Users.Add(user);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(user));
}
public ActionResult Create([Bind(Include = "客戶名稱,銀行帳戶數量,聯絡人數量")] 客戶關聯清單 客戶關聯清單)
{
if (ModelState.IsValid)
{
db.客戶關聯清單.Add(客戶關聯清單);
db.SaveChanges();
return(RedirectToAction("Index"));
}
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(Order order)
{
if (ModelState.IsValid)
{
db.Orders.Add(order);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.uid = new SelectList(db.Users, "Id", "Username", order.uid);
return(View(order));
}
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 bool Create(tCustomer oCustomer)
{
try
{
_db.DbSetCusomter.Add(oCustomer);
_db.SaveChanges();
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
public JsonResult SaveCustomer(CustomerViewModel customer)
{
using (var db = new CustomerEntities())
{
var cus = db.Customers.Find(customer.ID);
if (cus != null)
{
cus.Name = customer.Name;
cus.Address = customer.Address;
cus.Phone = customer.Phone;
if (db.SaveChanges() > 0)
{
return(Json(new { status = "success", response = cus }));
}
else
{
return(Json(new { status = "failed", reason = "could not save" }));
}
}
else
{
return(Json(new { status = "failed", reason = "not found" }));
}
}
}
/// <summary>
/// Create the customer.
/// </summary>
/// <param name="saveObject">The save object.</param>
/// <returns></returns>
public Customers CreateCustomer(Customers saveObject)
{
try
{
#region Save Customer User
var customerToSave = _entityMapper.Map <Customers, BcTCustomer>(saveObject);
var customerSaved = _customerEntities.BcTCustomers.Add(customerToSave).Entity;
_customerEntities.SaveChanges();
#endregion
return(_entityMapper.Map <BcTCustomer, Customers>(customerSaved));
}
catch
{
throw;
}
}
public ActionResult BatchUpdate(客戶聯絡人BatchUpdate[] items)
{
if (items != null && ModelState.IsValid)
{
foreach (var item in items)
{
var cc = db.客戶聯絡人.Find(item.Id);
cc.職稱 = item.職稱;
cc.手機 = item.手機;
cc.電話 = item.電話;
}
db.SaveChanges();
return(RedirectToAction("BatchUpdate"));
}
Get客戶聯絡人();
return(View());
}
public ActionResult ParcelDetails([Bind(Exclude = "ParcelID")] Parcel parcel)
{
if (ModelState.IsValid)
{
db.Parcels.Add(parcel);
db.SaveChanges();
return(RedirectToAction("ThankYou", new { id = parcel.CustomID }));
}
return(View(parcel));
}
public string Add(CustomerInformation model)
{
CustomerEntities db = new CustomerEntities();
CustomerInformation cs = new CustomerInformation();
cs.Name = model.Name;
cs.Surname = model.Surname;
db.CustomerInformations.Add(cs);
db.SaveChanges();
return("1");
}
public Customer Post(Customer customer)
{
using (CustomerEntities entities = new CustomerEntities())
{
entities.Customer.Add(new Customer()
{
Name = "Poopoo"
});
entities.SaveChanges();
return(entities.Customer.FirstOrDefault());
}
}
public ActionResult CustomerDetails([Bind(Exclude = "CustomerID")] Customer customer)
{
if (ModelState.IsValid)
{
db.Customers.Add(customer);
db.SaveChanges();
return(RedirectToAction("ParcelDetails", "Parcel", new { id = customer.CustomerID }));
}
else
{
return(View(customer));
}
}
public ActionResult Account(Customer customer)
{
if (ModelState.IsValid)
{
using (CustomerEntities cEntities = new CustomerEntities())
{
customer.customer_ID = Convert.ToInt32(Session["customerID"]);
cEntities.Entry(customer).State = EntityState.Modified;
cEntities.SaveChanges();
return RedirectToAction("Account");
}
}
return View();
}
// PUT: api/Cust/5
/// <summary>
/// Updates the existing cutomer
/// </summary>
/// <param name="inputIDnumber"></param>
/// <param name="inputFirstname"></param>
/// <param name="inputlastname"></param>
/// <param name="inputCell"></param>
/// <param name="inputEmail"></param>
/// <returns>Returns message</returns>
public string Put(string inputIDnumber, string inputFirstname, string inputlastname, string inputCell, string inputEmail)
{
var cust = (from c in customerEntities.Customers where c.ID_Number == inputIDnumber select c).ToList().FirstOrDefault();
cust.Email_Address = inputEmail;
cust.First_Name = inputFirstname;
cust.Last_Name = inputlastname;
cust.Mobile_Number = inputCell;
customerEntities.Customers.AddOrUpdate(cust);
customerEntities.SaveChanges();
return(new JavaScriptSerializer().Serialize(new
{
Message = "Customer Updated Successfully"
}));
}
public bool AddCustomer(string customer)
{
try
{
using (var db = new CustomerEntities())
{
var newCustomer = db.Main_Dim_CustomerSet.Create();
newCustomer.Customer_name = customer;
db.Main_Dim_CustomerSet.Add(newCustomer);
db.SaveChanges();
}
return true;
}
catch
{
return false;
}
}
public ActionResult Register(Customer customer, CustomerAddress customerAddress, CustomerLogin customerLogin)
{
string viewChange = "";
try
{
if (ModelState.IsValid)
{
//encrypt the password
customerLogin.password = HashKey.GetHashKey(customerLogin.password);
//inserting into customers table
using (CustomerEntities cEntityy = new CustomerEntities())
{
cEntityy.Customers.Add(customer);
cEntityy.SaveChanges();
}
using (CustomerAddressEntities caEntity = new CustomerAddressEntities())
{
customerAddress.customer_ID = customer.customer_ID;
//inserting into customer address table
caEntity.CustomerAddresses.Add(customerAddress);
caEntity.SaveChanges();
}
using (CustomerLoginEntities clEntity = new CustomerLoginEntities())
{
customerLogin.customer_ID = customer.customer_ID;
customerLogin.email = customer.email;
customerLogin.dateCreated = DateTime.Now;
//inserting into customer login table
clEntity.CustomerLogins.Add(customerLogin);
clEntity.SaveChanges();
return RedirectToAction("Index", "Customer");
}
}
else
{
viewChange = "LoginRegister";
}
}
catch(EntryPointNotFoundException ex){}
catch (Exception ex) { viewChange = "LoginRegister"; }
return View(viewChange);
}
public JsonResult AddCustomer(CustomerViewModel customer)
{
using (var db = new CustomerEntities())
{
var cust = new Customer()
{
Name = customer.Name,
Address = customer.Address,
Phone = customer.Phone
};
db.Customers.Add(cust);
if (db.SaveChanges() > 0)
{
return(Json(new { status = "success", result = cust }));
}
else
{
return(Json(new { status = "failed", reason = "could save to db" }));
}
}
}
protected void btnAddNewCustomer_Click(object sender, EventArgs e)
{
try
{
asiakas customer = new asiakas();
customer.astunnus = txtID.Text;
customer.asnimi = txtName.Text;
customer.yhteyshlo = txtContact.Text;
customer.maa = txtCountryCode.Text;
customer.postinro = txtPostalCode.Text;
customer.postitmp = txtPostOffice.Text;
customer.ostot = double.Parse(txtPurchases.Text);
customer.asvuosi = short.Parse(txtYear.Text);
entities.asiakas.Add(customer);
entities.SaveChanges();
lblMessage.Text = "Customer added succesfully!";
}
catch (Exception ex)
{
lblMessage.Text = ex.Message;
}
}
public JsonResult DeleteCustomer(int id)
{
using (var db = new CustomerEntities())
{
var cus = db.Customers.Find(id);
if (cus != null)
{
db.Customers.Remove(cus);
if (db.SaveChanges() > 0)
{
return(Json(new { status = "success" }));
}
else
{
return(Json(new { status = "failed" }));
}
}
else
{
return(Json(new { status = "failed", reason = "not exists" }));
}
}
}
// POST: api/Cust
/// <summary>
/// Posts the data that it receives from the Web App
/// </summary>
/// <param name="inputIDnumber"></param>
/// <param name="inputFirstname"></param>
/// <param name="inputlastname"></param>
/// <param name="inputCell"></param>
/// <param name="inputEmail"></param>
/// <returns>Returns message</returns>
public string Post(string inputIDnumber, string inputFirstname, string inputlastname, string inputCell, string inputEmail)
{
var cust = "";
CustomerEntities customerEntities = new CustomerEntities();
try
{
cust = (from c in customerEntities.Customers where c.ID_Number == inputIDnumber select c.ID_Number).FirstOrDefault();
}
catch (Exception e)
{
return(e.Message);
}
if (String.IsNullOrEmpty(cust))
{
Customer customer = new Customer();
customer.ID_Number = inputIDnumber;
customer.First_Name = inputFirstname;
customer.Last_Name = inputlastname;
customer.Mobile_Number = inputCell;
customer.Email_Address = inputEmail;
customerEntities.Customers.Add(customer);
customerEntities.SaveChanges();
return(new JavaScriptSerializer().Serialize(new
{
Message = "Customer Added Successfully"
}));
}
else
{
return(new JavaScriptSerializer().Serialize(new
{
Message = "Customer Already Exists"
}));
}
}
public bool AddLogToMainTable(string ID, DateTime timestamp, string action)
{
try
{
using (var db = new CustomerEntities())
{
var newlog = db.Main_Fact_LogsSet.Create();
newlog.UnitName = ID;
newlog.Timestamp = timestamp;
newlog.EventName = action;
db.Main_Fact_LogsSet.Add(newlog);
db.SaveChanges();
return true;
}
}
catch (Exception ex)
{
return false;
}
}
public bool AddUnitToCustomerTable(string UnitID, string customer)
{
try
{
using (var dbCustomer = new CustomerEntities())
{
var newBridgeUnit = dbCustomer.Main_Bridge_Customer_UnitSet.Create();
var newUnit = dbCustomer.Main_Dim_UnitSet.Create();
var cust = dbCustomer.Main_Dim_CustomerSet.Where(o => o.Customer_name.Equals(customer)).First();
newUnit.UnitID = UnitID;
newBridgeUnit.Main_Dim_UnitSet = newUnit;
newBridgeUnit.Main_Dim_CustomerSet = cust;
dbCustomer.Main_Bridge_Customer_UnitSet.Add(newBridgeUnit);
dbCustomer.SaveChanges();
}
return true;
}
catch (Exception ex)
{
return false;
}
/*switch (customer)
{
case "RegionH":
try
{
using (var dbCustomer = new CustomerEntities())
{
var newBridgeUnit = dbCustomer.Main_Bridge_Customer_UnitSet.Create();
var newUnit = dbCustomer.Main_Dim_UnitSet.Create();
var cust = dbCustomer.Main_Dim_CustomerSet.Where(o => o.Customer_name.Equals(customer)).First();
newUnit.UnitID = UnitID;
newBridgeUnit.Main_Dim_UnitSet = newUnit;
newBridgeUnit.Main_Dim_CustomerSet = cust;
dbCustomer.Main_Bridge_Customer_UnitSet.Add(newBridgeUnit);
dbCustomer.SaveChanges();
}
return true;
}
catch (Exception ex)
{
return false;
}
case "Lundbeck":
try
{
using (var db = new LundbeckEntities())
{
//CHANGE!!
}
return true;
}
catch (Exception ex)
{
return false;
}
default:
return false;
}*/
}
public bool Adduser(string username, string password, string customer)
{
try
{
using (var db = new CustomerEntities())
{
var newUser = db.Main_UsersSet.Create();
newUser.Username = username;
newUser.Password = password;
newUser.Customer = customer;
db.Main_UsersSet.Add(newUser);
db.SaveChanges();
return true;
}
}
catch (Exception ex)
{
return false;
}
}
