public ActionResult Index() { List <tbl_customers> customers = new List <tbl_customers>(); string mainconn = ConfigurationManager.ConnectionStrings["allpaxServiceRecordEntities"].ConnectionString; SqlConnection sqlconn = new SqlConnection(mainconn); sqlconn.Open(); string sqlquery1 = "SELECT tbl_customers.customerCode, tbl_customers.customerName, tbl_customers.address, tbl_customers.id " + "FROM tbl_customers"; SqlCommand sqlcomm1 = new SqlCommand(sqlquery1, sqlconn); SqlDataAdapter sda1 = new SqlDataAdapter(sqlcomm1); DataTable dt1 = new DataTable(); sda1.Fill(dt1); foreach (DataRow dr1 in dt1.Rows) { tbl_customers customer = new tbl_customers(); customer.customerCode = dr1[0].ToString(); customer.customerName = dr1[1].ToString(); customer.address = dr1[2].ToString(); customer.id = (int)dr1[3]; customers.Add(customer); } sqlconn.Close(); return(View(customers)); }
//GET RESOURCE TYPES public List <tbl_customers> customerList() { List <tbl_customers> customers = new List <tbl_customers>(); string mainconn = ConfigurationManager.ConnectionStrings["allpaxServiceRecordEntities"].ConnectionString; SqlConnection sqlconn = new SqlConnection(mainconn); string sqlquery1 = "SELECT tbl_customers.customerCode, tbl_customers.customerName, tbl_customers.address, tbl_customers.id " + "FROM tbl_customers"; SqlCommand sqlcomm1 = new SqlCommand(sqlquery1, sqlconn); //sqlcomm1.Parameters.Add(new SqlParameter("jobID", jobID)); SqlDataAdapter sda3 = new SqlDataAdapter(sqlcomm1); DataTable dt1 = new DataTable(); sda3.Fill(dt1); foreach (DataRow dr1 in dt1.Rows) { tbl_customers customer = new tbl_customers(); customer.customerCode = dr1[0].ToString(); customer.customerName = dr1[1].ToString(); customer.address = dr1[2].ToString(); customer.id = (int)dr1[3]; customers.Add(customer); } return(customers); }
public void GetAllCustomers() { string cs = ConfigurationManager.ConnectionStrings["allpaxServiceRecordEntities"].ConnectionString; List <tbl_customers> customers = new List <tbl_customers>(); using (SqlConnection con = new SqlConnection(cs)) { SqlCommand cmd = new SqlCommand("spGetAllCustomers", con); cmd.CommandType = CommandType.StoredProcedure; con.Open(); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { tbl_customers customer = new tbl_customers(); customer.customerCode = rdr["customerCode"].ToString(); customer.customerName = rdr["customerName"].ToString(); customer.address = rdr["address"].ToString(); customer.id = (int)rdr["id"]; customers.Add(customer); } } JavaScriptSerializer js = new JavaScriptSerializer(); Context.Response.Write(js.Serialize(customers)); }
public ActionResult DeleteCustomer(tbl_customers customerDelete) { try { db.Database.ExecuteSqlCommand("DELETE FROM tbl_customers WHERE customerCode=({0})", customerDelete.customerCode); return(Json(Url.Action("Index", "Customers"))); } catch (Exception e) { return(Content(e.Message)); } }
public ActionResult AddCustomer(tbl_customers customerAdd) { try { db.Database.ExecuteSqlCommand("Insert into tbl_customers Values({0},{1},{2})", customerAdd.customerCode, customerAdd.customerName, customerAdd.address); return(Json(Url.Action("Index", "Customers"))); } catch (Exception e) { return(Content(e.Message)); } }
public ActionResult UpdateCustomer(tbl_customers customerUpdate) { try { db.Database.ExecuteSqlCommand( "UPDATE tbl_customers " + "SET " + "customerCode = {0}, " + "customerName = {1}, " + "address = {2} " + "WHERE id = {3}", customerUpdate.customerCode, customerUpdate.customerName, customerUpdate.address, customerUpdate.id); return(Json(Url.Action("Index", "Customers"))); } catch (Exception e) { return(Content(e.Message)); } }
public bool insertRecord(Customer customer) { bool result = false; try { tbl_customers _Customer = new tbl_customers(); _Customer.id = customer.Id; _Customer.short_name = customer.Short_name; _Customer.com_name = customer.Com_name; _Customer.com_addr = customer.Com_addr; _Customer.contact_name = customer.Contact_name; _Customer.contact_phone = customer.Contact_phone; _Customer.contract = customer.Contract; _Customer.contract_date = customer.Contract_date; _Customer.note = customer.Note; _tsmEntity.tbl_customers.Add(_Customer); _tsmEntity.SaveChanges(); result = true; return(result); } catch { return(result); } }
public void Delete(int id) { tbl_customers existing = context.tbl_customers.Find(id); context.tbl_customers.Remove(existing); }
public void Insert(tbl_customers obj) { context.tbl_customers.Add(obj); }
public void Update(tbl_customers obj) { context.Entry(obj).State = EntityState.Modified; }