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;
}
