//
// 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();
}
