// // GET: /Committee/Edit/5 public ActionResult Edit(decimal id = 0) { if (Session["USER"] == null) { return(RedirectToAction("../Account/ManagementLogin")); } TB_COMMITEE tb_commitee = db.TB_COMMITEE.Single(t => t.COMMITEE_ID == id); if (tb_commitee == null) { return(HttpNotFound()); } ViewBag.COMMITEE_TITLE_ID = new SelectList(db.TB_M_TITLE, "TITLE_ID", "TITLE_NAME_TH", tb_commitee.COMMITEE_TITLE_ID); return(View(tb_commitee)); }
public ActionResult Create(TB_COMMITEE tb_commitee) { if (Session["USER"] == null) { return(RedirectToAction("../Account/ManagementLogin")); } if (ModelState.IsValid) { db.TB_COMMITEE.Add(tb_commitee); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.COMMITEE_TITLE_ID = new SelectList(db.TB_M_TITLE, "TITLE_ID", "TITLE_NAME_TH", tb_commitee.COMMITEE_TITLE_ID); return(View(tb_commitee)); }
// // GET: /Committee/Delete/5 public JsonResult Delete(int ID) { try { TB_COMMITEE tb_commitee = db.TB_COMMITEE.Single(t => t.COMMITEE_ID == ID); db.TB_COMMITEE.Remove(tb_commitee); db.SaveChanges(); // delete the record from ID and return true else false } catch (Exception ex) { return(Json(ex.InnerException.Message, JsonRequestBehavior.AllowGet)); } //return new JsonResult { JsonRequestBehavior = JsonRequestBehavior.AllowGet, Data = new { msg = "success" } }; return(Json(true, JsonRequestBehavior.AllowGet)); }
public ActionResult Edit(TB_COMMITEE tb_commitee) { if (Session["USER"] == null) { return(RedirectToAction("../Account/ManagementLogin")); } if (ModelState.IsValid) { var _update = db.TB_COMMITEE.FirstOrDefault(f => f.COMMITEE_ID == tb_commitee.COMMITEE_ID); if (_update != null) { _update.COMMITEE_ID = tb_commitee.COMMITEE_ID; _update.COMMITEE_TITLE_ID = tb_commitee.COMMITEE_TITLE_ID; _update.COMMITEE_NAME = tb_commitee.COMMITEE_NAME; _update.COMMITEE_SURNAME = tb_commitee.COMMITEE_SURNAME; _update.COMMITEE_STATUS = tb_commitee.COMMITEE_STATUS; } db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.COMMITEE_TITLE_ID = new SelectList(db.TB_M_TITLE, "TITLE_ID", "TITLE_NAME_TH", tb_commitee.COMMITEE_TITLE_ID); return(View(tb_commitee)); }
private void Import_To_Grid(string FilePath, string Extension, string isHDR) { string conStr = ""; switch (Extension) { case ".xls": //Excel 97-03 conStr = ConfigurationManager.ConnectionStrings["Excel03ConString"].ConnectionString; break; case ".xlsx": //Excel 07 conStr = ConfigurationManager.ConnectionStrings["Excel07ConString"].ConnectionString; break; } conStr = String.Format(conStr, FilePath, isHDR); OleDbConnection connExcel = new OleDbConnection(conStr); OleDbCommand cmdExcel = new OleDbCommand(); OleDbDataAdapter oda = new OleDbDataAdapter(); DataTable dt = new DataTable(); cmdExcel.Connection = connExcel; //Get the name of First Sheet connExcel.Open(); DataTable dtExcelSchema; dtExcelSchema = connExcel.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null); string SheetName = dtExcelSchema.Rows[0]["TABLE_NAME"].ToString(); connExcel.Close(); //Read Data from First Sheet connExcel.Open(); cmdExcel.CommandText = "SELECT * From [" + SheetName + "]"; oda.SelectCommand = cmdExcel; oda.Fill(dt); //String xx = dt.Rows[0][0].ToString(); using (ChinaPhet10Entities context = new ChinaPhet10Entities()) { //context.TB_COMMITEE.ToList().ForEach(context.TB_COMMITEE); foreach (TB_COMMITEE deleteCmt in context.TB_COMMITEE.ToList()) { context.TB_COMMITEE.Remove(deleteCmt); } for (int i = 1; i < dt.Rows.Count; i++) { TB_COMMITEE commitee = new TB_COMMITEE(); commitee.COMMITEE_TITLE_ID = 0; commitee.COMMITEE_NAME = dt.Rows[i][1].ToString(); commitee.COMMITEE_SURNAME = dt.Rows[i][2].ToString(); commitee.COMMITEE_PHONE = dt.Rows[i][3].ToString(); commitee.COMMITEE_STATUS = dt.Rows[i][4].ToString(); context.TB_COMMITEE.Add(commitee); } context.SaveChanges(); } connExcel.Close(); //Bind Data to GridView //GridView1.Caption = Path.GetFileName(FilePath); //GridView1.DataSource = dt; //GridView1.DataBind(); }