public JsonResult InsertCutiMassal(string[] CutiId, DateTime txtTglMulai, DateTime txtTglSelesai, string txtAlasan)
{
try
{
foreach (string id in CutiId)
{
personal_information pInfo = sopace.personal_information.Where(e => e.NIP == id).FirstOrDefault();
const string chars = "ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789";
Random random = new Random();
string unique = new string(Enumerable.Repeat(chars, 4).Select(s => s[random.Next(s.Length)]).ToArray());
cuti ct = new cuti();
ct.id_cuti = "Cuti-" + DateTime.Now.Year + "-" + unique;
ct.NIP = id;
ct.no_tlp = pInfo.no_hp;
ct.tgl_mulai_cuti = txtTglMulai;
ct.tgl_selesai_cuti = txtTglSelesai;
ct.alasan_cuti = txtAlasan;
ct.alamat = pInfo.alamat_identitas;
sopace.cutis.Add(ct);
sopace.SaveChanges();
}
return(Json("Input Success"));
}
catch (Exception e) {
return(Json("Input Filed, please check your data input"));
}
}
public ActionResult UpdatePersonalInformation(InsertPersonUser insertPersonUser)
{
var entity = sopace.personal_information.Where(e =>
e.NIP == insertPersonUser.Personal_Information.NIP).FirstOrDefault();
if (entity != null)
{
personal_information pInfo = insertPersonUser.Personal_Information;
user User = insertPersonUser.User;
sopace.Entry(entity).CurrentValues.SetValues(pInfo);
var entityUser = sopace.users.Where(e => e.NIP == insertPersonUser.User.NIP).FirstOrDefault();
if (entityUser != null)
{
file_dokumen fd = insertPersonUser.File_Dokumen;
sopace.users.Remove(entityUser);
User.password = encryptor.Encrypt(User.password);
sopace.users.Add(User);
var entityFileDok = sopace.file_dokumen.Where(e => e.NIP == insertPersonUser.User.NIP).FirstOrDefault();
if (entityFileDok != null)
{
sopace.Entry(entityFileDok).CurrentValues.SetValues(fd);
}
}
sopace.SaveChanges();
}
return(RedirectToAction("ViewAll"));
}
public InsertPersonUser DataForEdit(string username)
{
InsertPersonUser insertPersonUser = new InsertPersonUser();
personal_information pInfo = sopace.users.Where(u => u.username == username)
.Join(sopace.personal_information, u => u.NIP, p => p.NIP, (u, p) => p).FirstOrDefault();
user user = sopace.users.Where(e => e.username == username).FirstOrDefault();
file_dokumen fd = sopace.users.Where(u => u.username == username).Join(sopace.file_dokumen,
u => u.NIP,
fdo => fdo.NIP,
(u, fdo) => fdo).FirstOrDefault();
user.password = encryptor.Decrypt(user.password);
insertPersonUser.User = user;
insertPersonUser.Personal_Information = pInfo;
TempData["tglLahir"] = pInfo.tgl_lahir.Value.ToString("yyyy-MM-dd");
TempData["tglMasuk"] = pInfo.tgl_masuk.Value.ToString("yyyy-MM-dd");
if (fd != null)
{
if (fd.foto_profil != null)
{
TempData["fotoProfil"] = fd.foto_profil;
}
if (fd.foto_buku_rekening != null)
{
TempData["fotoBkRek"] = fd.foto_buku_rekening.ToString();
}
if (fd.cv != null)
{
TempData["CV"] = fd.cv.ToString();
}
TempData["nip"] = fd.NIP;
}
return(insertPersonUser);
}
public ActionResult SearchInfo(string search)
{
personal_information model = new personal_information();
model.nameofperson = search;
var result = _objInfo.SearchPersonalInfo(model);
return(View(result.Result.Response));
}
public async Task <ProjectResult> SearchPersonalInfo(personal_information model)
{
try
{
var result = _db.personal_information.Where(psd => psd.nameofperson == model.nameofperson).ToList();
return(new ProjectResult {
Message = "Success", Status = 1, Response = result
});
}
catch (Exception exp)
{
return(new ProjectResult {
Message = exp.ToString(), Status = 0, Response = null
});
}
}
public ActionResult DeletePersonInfo(string username)
{
if (username == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
InsertPersonUser insertPersonUser = new InsertPersonUser();
personal_information pInfo = sopace.users.Where
(u => u.username == username).
Join(sopace.personal_information, u => u.NIP, p => p.NIP, (u, p) => p).FirstOrDefault();
if (pInfo == null)
{
return(HttpNotFound());
}
else
{
DeleteDirectory(pInfo.NIP);
sopace.personal_information.Remove(pInfo);
sopace.SaveChanges();
}
return(RedirectToAction("ViewAll"));
}
public async Task <ProjectResult> SearchInfoCityName(personal_information model)
{
try
{
if (model.city != null && model.nameofperson != null)
{
var result = _db.personal_information.Where(psd => psd.city == model.city && psd.nameofperson == model.nameofperson).ToList();
return(new ProjectResult {
Message = "Success", Status = 1, Response = result
});
}
else if (model.nameofperson != null)
{
var result = _db.personal_information.Where(psd => psd.nameofperson == model.nameofperson).ToList();
return(new ProjectResult {
Message = "Success", Status = 1, Response = result
});
}
else
{
var result = _db.personal_information.Where(psd => psd.city == model.city).ToList();
return(new ProjectResult {
Message = "Success", Status = 1, Response = result
});
}
}
catch (Exception exp)
{
return(new ProjectResult {
Message = exp.ToString(), Status = 0, Response = null
});
}
}
