public ActionResult DeleteConfirmed(int id)
{
BANG_CHAM_CONG bANG_CHAM_CONG = db.BANG_CHAM_CONG.Find(id);
db.BANG_CHAM_CONG.Remove(bANG_CHAM_CONG);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "CHAM_CONG_ID,USER_ID,NGAY_CHUAN,GIO_DI_MUON,GIO_VE_SOM,TANG_CA_NGAY_THUONG,TANG_CA_NGAY_LE,SO_LAN_QUEN_CHAM,SO_NGAY_NGHI,CONG_THUC_TE,UNG_LUONG,GHI_CHU,THANG_CHAM_CONG")] BANG_CHAM_CONG bANG_CHAM_CONG)
{
if (ModelState.IsValid)
{
db.Entry(bANG_CHAM_CONG).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.USER_ID = new SelectList(db.USERS, "USER_ID", "USERNAME", bANG_CHAM_CONG.USER_ID);
return(View(bANG_CHAM_CONG));
}
// GET: BANG_CHAM_CONG/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
BANG_CHAM_CONG bANG_CHAM_CONG = db.BANG_CHAM_CONG.Find(id);
if (bANG_CHAM_CONG == null)
{
return(HttpNotFound());
}
return(View(bANG_CHAM_CONG));
}
// GET: BANG_CHAM_CONG/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
BANG_CHAM_CONG bANG_CHAM_CONG = db.BANG_CHAM_CONG.Find(id);
if (bANG_CHAM_CONG == null)
{
return(HttpNotFound());
}
ViewBag.USER_ID = new SelectList(db.USERS, "USER_ID", "USERNAME", bANG_CHAM_CONG.USER_ID);
return(View(bANG_CHAM_CONG));
}
public ActionResult Index(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 username = ds.Tables[0].Rows[i][2].ToString();
var query = (from u in db.USERS
where u.USERNAME == username
select u).FirstOrDefault();
int id = query.USER_ID;
BANG_CHAM_CONG BCC = new BANG_CHAM_CONG();
BCC.USER_ID = id;
BCC.NGAY_CHUAN = ds.Tables[0].Rows[i][3].ToString();
BCC.GIO_DI_MUON = ds.Tables[0].Rows[i][4].ToString();
BCC.GIO_VE_SOM = ds.Tables[0].Rows[i][5].ToString();
BCC.TANG_CA_NGAY_THUONG = ds.Tables[0].Rows[i][6].ToString();
BCC.TANG_CA_NGAY_LE = ds.Tables[0].Rows[i][7].ToString();
BCC.SO_LAN_QUEN_CHAM = ds.Tables[0].Rows[i][8].ToString();
BCC.SO_NGAY_NGHI = ds.Tables[0].Rows[i][9].ToString();
BCC.CONG_THUC_TE = ds.Tables[0].Rows[i][10].ToString();
BCC.UNG_LUONG = ds.Tables[0].Rows[i][11].ToString();
BCC.GHI_CHU = ds.Tables[0].Rows[i][12].ToString();
BCC.THANG_CHAM_CONG = ds.Tables[0].Rows[i][13].ToString();
db.BANG_CHAM_CONG.Add(BCC);
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());
}
