public ActionResult UpdateData(string JsonData)
{
JObject objdata = new JObject();
objdata = JObject.Parse(JsonData);
var encriptPw = encryptPassword(objdata["password"].ToString());
var idEmp = objdata["idEmployee"].ToString();
using (var dbAdd = new OCTIIS_WEBAPPEntities3())
{
var updateData = (from update in dbAdd.Eng_AccountUser where update.id_employee == idEmp select update).FirstOrDefault();
if (updateData != null)
{
updateData.id_employee = objdata["idEmployee"].ToString();
updateData.username = objdata["userName"].ToString();
updateData.password = encriptPw;
updateData.name = objdata["nameUser"].ToString();
updateData.lastname = objdata["lastName"].ToString();
updateData.nickname = objdata["nickname"].ToString();
updateData.id_dept = Convert.ToInt32(objdata["department"].ToString());
updateData.id_position = Convert.ToInt32(objdata["position"].ToString());
updateData.permission_id = Convert.ToInt32(objdata["setpermissionUser"].ToString());
updateData.email = objdata["emails"].ToString();
}
dbAdd.SaveChanges();
}
return(Json(String.Format("Complete")));
}
public ActionResult SaveData(string JsonData)
{
JObject objdata = new JObject();
objdata = JObject.Parse(JsonData);
var encriptPw = encryptPassword(objdata["password"].ToString());
var geta = objdata["idEmployee"].ToString();
using (var dbAdd = new OCTIIS_WEBAPPEntities3())
{
var saveadduser = new Eng_AccountUser()
{
id_employee = objdata["idEmployee"].ToString(),
username = objdata["userName"].ToString(),
password = encriptPw,
name = objdata["nameUser"].ToString(),
lastname = objdata["lastName"].ToString(),
nickname = objdata["nickname"].ToString(),
id_dept = Convert.ToInt32(objdata["department"].ToString()),
id_position = Convert.ToInt32(objdata["position"].ToString()),
permission_id = Convert.ToInt32(objdata["setpermissionUser"].ToString()),
email = objdata["email"].ToString() + "@ogura-thia.com"
};
dbAdd.Eng_AccountUser.Add(saveadduser);
dbAdd.SaveChanges();
}
return(Json(String.Format("Complete")));
}
public ActionResult UpComment(string test, string com)
{
using (var context = new OCTIIS_WEBAPPEntities3())
{
var upother = context.Eng_ModelAction.Where(e => e.id_modelact.ToString() == test);
foreach (var up in upother)
{
var data = up.date_useradd;
if (data != null)
{
up.comment_user = com;
up.status_job = "4";
up.date_userupdate = DateTime.Now.ToString();
}
else
{
up.comment_user = com;
up.status_job = "4";
up.date_useradd = DateTime.Now.ToString();
}
}
UpdateModel(upother);
context.SaveChanges();
}
return(Json("Successfully!"));
}
public ActionResult SaveDataDepartment(string jsonStr)
{
var dataDep = jsonStr.ToString();
using (var dbAdd = new OCTIIS_WEBAPPEntities3())
{
var savedep = new Department()
{
department1 = dataDep,
};
dbAdd.Departments.Add(savedep);
dbAdd.SaveChanges();
}
return(Json(String.Format("Complete")));
}
public ActionResult SaveDataPosition(string jsonStr)
{
var dataPos = jsonStr.ToString();
using (var dbAdd = new OCTIIS_WEBAPPEntities3())
{
var savepos = new Position()
{
position1 = dataPos,
};
dbAdd.Positions.Add(savepos);
dbAdd.SaveChanges();
}
return(Json(String.Format("Complete")));
}
public ActionResult DeleteDataPermis(int idPermis)
{
using (var dbAdd = new OCTIIS_WEBAPPEntities3())
{
var deleteData = (from del in dbAdd.Eng_PermissionSub where del.id_persub == idPermis select del).FirstOrDefault();
if (deleteData != null)
{
dbAdd.Eng_PermissionSub.Remove(deleteData);
}
dbAdd.SaveChanges();
}
string message = "Delete success.";
return(Json(String.Format(message)));
}
public ActionResult DeleteDataDepartment(string jsonStr)
{
var depid = Convert.ToInt32(jsonStr.ToString());
using (var dbAdd = new OCTIIS_WEBAPPEntities3())
{
var deptdb = (from dele in dbAdd.Departments where dele.dept_id == depid select dele).FirstOrDefault();
if (deptdb != null)
{
dbAdd.Departments.Remove(deptdb);
}
dbAdd.SaveChanges();
}
return(Json("Delete Complete"));
}
public ActionResult DeleteDataPosition(string jsonStr)
{
var posid = Convert.ToInt32(jsonStr.ToString());
using (var dbAdd = new OCTIIS_WEBAPPEntities3())
{
var posdb = (from posdel in dbAdd.Positions where posdel.id_position == posid select posdel).FirstOrDefault();
if (posdb != null)
{
dbAdd.Positions.Remove(posdb);
}
dbAdd.SaveChanges();
}
return(Json("Delete Complete"));
}
public ActionResult DeleteDataUser(string idEmp)
{
using (var dbAdd = new OCTIIS_WEBAPPEntities3())
{
var updateData = (from update in dbAdd.Eng_AccountUser where update.id_employee == idEmp select update).FirstOrDefault();
if (updateData != null)
{
dbAdd.Eng_AccountUser.Remove(updateData);
}
dbAdd.SaveChanges();
}
string message = "Delete success.";
return(Json(String.Format(message)));
}
public ActionResult EditDataDepartment(string jsonStr)
{
JObject objJson = new JObject();
objJson = JObject.Parse(jsonStr);
var depid = Convert.ToInt32(objJson["depid"].ToString());
using (var db = new OCTIIS_WEBAPPEntities3())
{
var deptdb = (from d in db.Departments
where d.dept_id == depid
select d).FirstOrDefault();
if (deptdb != null)
{
deptdb.department1 = objJson["depname"].ToString();
}
db.SaveChanges();
}
return(Json("Update data success"));
}
public ActionResult EditDataPosition(string jsonStr)
{
JObject objJson = new JObject();
objJson = JObject.Parse(jsonStr);
var posid = Convert.ToInt32(objJson["posid"].ToString());
using (var db = new OCTIIS_WEBAPPEntities3())
{
var posdb = (from d in db.Positions
where d.id_position == posid
select d).FirstOrDefault();
if (posdb != null)
{
posdb.position1 = objJson["posname"].ToString();
}
db.SaveChanges();
}
return(Json("Update data success"));
}
public ActionResult AddPermission(string jsonData)
{
JObject objJson = new JObject();
objJson = JObject.Parse(jsonData);
using (var dbAdd = new OCTIIS_WEBAPPEntities3())
{
var savePermissions = new Eng_PermissionSub()
{
name_function = objJson["txtfunName"].ToString(),
name_controler = objJson["txtControlName"].ToString(),
name_action = objJson["txtMainAction"].ToString(),
id_permissionuser = Convert.ToInt32(objJson["txtperUser"].ToString()),
name_statusfc = objJson["txtstatus"].ToString(),
id_mainmenu = Convert.ToInt32(objJson["txtManuGrp"].ToString())
};
dbAdd.Eng_PermissionSub.Add(savePermissions);
dbAdd.SaveChanges();
}
return(Json(String.Format("Complete")));
}
public ActionResult EditSetPermission(string jsonData)
{
JObject objdata = new JObject();
objdata = JObject.Parse(jsonData);
var idper = Convert.ToInt32(objdata["txtSubId"].ToString());
using (var dbAdd = new OCTIIS_WEBAPPEntities3())
{
var updateData = (from update in dbAdd.Eng_PermissionSub where update.id_persub == idper select update).FirstOrDefault();
if (updateData != null)
{
updateData.name_function = objdata["txtfunName"].ToString();
updateData.name_controler = objdata["txtControlName"].ToString();
updateData.name_action = objdata["txtMainAction"].ToString();
updateData.id_permissionuser = Convert.ToInt32(objdata["txtperUser"].ToString());
updateData.name_statusfc = objdata["txtstatus"].ToString();
updateData.id_mainmenu = Convert.ToInt32(objdata["txtManuGrp"].ToString());
}
dbAdd.SaveChanges();
}
return(Json(String.Format("Complete")));
}
public ActionResult UploadFiles(string test, string com)
{
if (Request.Files.Count > 0)
{
try
{
string fname, fnameup, type, fnamedel;
// Get all files from Request object
HttpFileCollectionBase files = Request.Files;
for (int i = 0; i < files.Count; i++)
{
//string path = AppDomain.CurrentDomain.BaseDirectory + "Uploads/";
//string filename = Path.GetFileName(Request.Files[i].FileName);
HttpPostedFileBase file = files[i];
// Checking for Internet Explorer
if (Request.Browser.Browser.ToUpper() == "IE" || Request.Browser.Browser.ToUpper() == "INTERNETEXPLORER")
{
string[] testfiles = file.FileName.Split(new char[] { '\\' });
fname = testfiles[testfiles.Length - 1];
fnameup = file.FileName;
}
else
{
fname = file.FileName;
fnameup = file.FileName;
}
// Get the complete folder path and store the file inside it.
string[] filetype = file.FileName.Split(new char[] { '.' });
type = filetype[1];
switch (type)
{
case "pdf":
fname = Path.Combine(Server.MapPath("~/File/PDF/"), fname);
file.SaveAs(fname);
fnameup = file.FileName;
using (var context = new OCTIIS_WEBAPPEntities3())
{
var uplist = context.Eng_ModelAction.Where(e => e.id_modelact.ToString() == test);
foreach (var del in uplist)
{
var delname = del.name_docpdf;
fnamedel = Server.MapPath("~/File/PDF/" + delname);
try
{
System.IO.File.Delete(fnamedel);
}
catch (Exception e)
{
Console.WriteLine("error", e.Message);
}
}
foreach (var up in uplist)
{
up.name_docpdf = fnameup;
}
UpdateModel(uplist);
context.SaveChanges();
}
break;
case "xls":
case "csv":
case "xml":
case "xlsm":
case "xlsx":
fname = Path.Combine(Server.MapPath("~/File/Excel/"), fname);
file.SaveAs(fname);
fnameup = file.FileName;
using (var context = new OCTIIS_WEBAPPEntities3())
{
var uplist = context.Eng_ModelAction.Where(e => e.id_modelact.ToString() == test);
foreach (var del in uplist)
{
var delname = del.name_docexcel;
fnamedel = Server.MapPath("~/File/Excel/" + delname);
try
{
System.IO.File.Delete(fnamedel);
}
catch (Exception e)
{
Console.WriteLine("error", e.Message);
}
}
foreach (var up in uplist)
{
up.name_docexcel = fnameup;
}
UpdateModel(uplist);
context.SaveChanges();
}
break;
case "png":
case "jpg":
case "jpge":
case "gif":
fname = Path.Combine(Server.MapPath("~/File/Picture/"), fname);
file.SaveAs(fname);
fnameup = file.FileName;
using (var context = new OCTIIS_WEBAPPEntities3())
{
var uplist = context.Eng_ModelAction.Where(e => e.id_modelact.ToString() == test);
foreach (var del in uplist)
{
var delname = del.name_image;
fnamedel = Server.MapPath("~/File/Picture/" + delname);
try
{
System.IO.File.Delete(fnamedel);
}
catch (Exception e)
{
Console.WriteLine("error", e.Message);
}
}
foreach (var up in uplist)
{
up.name_image = fnameup;
}
UpdateModel(uplist);
context.SaveChanges();
}
break;
}
using (var context = new OCTIIS_WEBAPPEntities3())
{
var upother = context.Eng_ModelAction.Where(e => e.id_modelact.ToString() == test);
foreach (var up in upother)
{
var data = up.date_useradd;
if (data != null)
{
up.comment_user = com;
up.status_job = "4";
up.date_userupdate = DateTime.Now.ToString();
}
else
{
up.comment_user = com;
up.status_job = "4";
up.date_useradd = DateTime.Now.ToString();
}
}
UpdateModel(upother);
context.SaveChanges();
}
}
// Returns message that successfully uploaded
return(Json("File Uploaded Successfully!"));
}
catch (Exception ex)
{
return(Json("Error occurred. Error details: " + ex.Message));
}
}
else
{
return(Json("No files selected."));
}
}
