public ActionResult DeleteConfirmed(int id)
{
USER_METAS uSER_METAS = db.USER_METAS.Find(id);
db.USER_METAS.Remove(uSER_METAS);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "USER_ID,DEPARTMENT_ID,SEX,BIRTHDAY,START_TIME,NUMBER_PHONE,SENIORITY,NATIVE_LAND,LITERACY")] USER_METAS uSER_METAS)
{
if (ModelState.IsValid)
{
db.Entry(uSER_METAS).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.DEPARTMENT_ID = new SelectList(db.DEPARTMENTS, "DEPARTMENT_ID", "DEPARTMENT_NAME", uSER_METAS.DEPARTMENT_ID);
ViewBag.USER_ID = new SelectList(db.USERS, "USER_ID", "USERNAME", uSER_METAS.USER_ID);
return(View(uSER_METAS));
}
// GET: USER_METAS/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
USER_METAS uSER_METAS = db.USER_METAS.Find(id);
if (uSER_METAS == null)
{
return(HttpNotFound());
}
return(View(uSER_METAS));
}
// GET: USER_METAS/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
USER_METAS uSER_METAS = db.USER_METAS.Find(id);
if (uSER_METAS == null)
{
return(HttpNotFound());
}
ViewBag.DEPARTMENT_ID = new SelectList(db.DEPARTMENTS, "DEPARTMENT_ID", "DEPARTMENT_NAME", uSER_METAS.DEPARTMENT_ID);
ViewBag.USER_ID = new SelectList(db.USERS, "USER_ID", "USERNAME", uSER_METAS.USER_ID);
return(View(uSER_METAS));
}
public ActionResult Import_UserMetas(HttpPostedFileBase file)
{
try
{
DataSet ds = new DataSet();
if (Request.Files["file"].ContentLength > 0)
{
string fileExtension = System.IO.Path.GetExtension(Request.Files["file"].FileName);
if (fileExtension == ".xls" || fileExtension == ".xlsx")
{
string fileLocation = Server.MapPath("~/Content/") + Request.Files["file"].FileName;
if (System.IO.File.Exists(fileLocation))
{
System.IO.File.Delete(fileLocation);
}
Request.Files["file"].SaveAs(fileLocation);
string excelConnectionString = string.Empty;
excelConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + fileLocation + ";Extended Properties=\"Excel 12.0;HDR=Yes;IMEX=2\"";
//connection String for xls file format.
if (fileExtension == ".xls")
{
excelConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + fileLocation + ";Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=2\"";
}
//connection String for xlsx file format.
else if (fileExtension == ".xlsx")
{
excelConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + fileLocation + ";Extended Properties=\"Excel 12.0;HDR=Yes;IMEX=2\"";
}
//Create Connection to Excel work book and add oledb namespace
OleDbConnection excelConnection = new OleDbConnection(excelConnectionString);
excelConnection.Open();
DataTable dt = new DataTable();
dt = excelConnection.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
if (dt == null)
{
return(null);
}
String[] excelSheets = new String[dt.Rows.Count];
int t = 0;
//excel data saves in temp file here.
foreach (DataRow row in dt.Rows)
{
excelSheets[t] = row["TABLE_NAME"].ToString();
t++;
}
OleDbConnection excelConnection1 = new OleDbConnection(excelConnectionString);
string query = string.Format("Select * from [{0}]", excelSheets[0]);
using (OleDbDataAdapter dataAdapter = new OleDbDataAdapter(query, excelConnection1))
{
dataAdapter.Fill(ds);
}
}
if (fileExtension.ToString().ToLower().Equals(".xml"))
{
string fileLocation = Server.MapPath("~/Content/") + Request.Files["FileUpload"].FileName;
if (System.IO.File.Exists(fileLocation))
{
System.IO.File.Delete(fileLocation);
}
Request.Files["FileUpload"].SaveAs(fileLocation);
XmlTextReader xmlreader = new XmlTextReader(fileLocation);
// DataSet ds = new DataSet();
ds.ReadXml(xmlreader);
xmlreader.Close();
}
so_dong_thanh_cong = 0;
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
string usname = ds.Tables[0].Rows[i][0].ToString();
var query = (from u in db.USERS
where u.USERNAME == usname
select u).FirstOrDefault();
int id = query.USER_ID;
USER_METAS query_meta = new USER_METAS();
query_meta.USER_ID = id;
query_meta.DEPARTMENT_ID = ds.Tables[0].Rows[i][1].ToString();
query_meta.SEX = ds.Tables[0].Rows[i][2].ToString();
query_meta.BIRTHDAY = xuLyNgayThang.XuLyChuoiNgayThang(ds.Tables[0].Rows[i][3].ToString());
query_meta.START_TIME = xuLyNgayThang.XuLyChuoiNgayThang(ds.Tables[0].Rows[i][4].ToString());
query_meta.NUMBER_PHONE = ds.Tables[0].Rows[i][5].ToString();
query_meta.SENIORITY = ds.Tables[0].Rows[i][6].ToString();
query_meta.NATIVE_LAND = ds.Tables[0].Rows[i][7].ToString();
query_meta.LITERACY = ds.Tables[0].Rows[i][8].ToString();
db.USER_METAS.Add(query_meta);
db.SaveChanges();
so_dong_thanh_cong++;
}
}
}
catch (Exception Ex)
{
ViewBag.Error = " Đã xảy ra lỗi, Liên hệ ngay với admin. " + Environment.NewLine + " Thông tin chi tiết về lỗi:" + Environment.NewLine + Ex;
}
finally
{
ViewBag.Message = "Đã import thành công " + so_dong_thanh_cong + " dòng";
}
return(View());
}
