public ActionResult Create(long?ID)
{
HRMS_EMP_ReferenceDetail obj = new HRMS_EMP_ReferenceDetail();
long emp_id = Convert.ToInt64(Session["id"]);
string role = db.Accounts.Where(x => x.ID == emp_id).Select(x => x.role).FirstOrDefault();
if (role == "admin")
{
ViewBag.Role = "admin";
obj.EMP_ID = ID.Value;
bool isExist = db.HRMS_EMP_ReferenceDetail.Any(x => x.EMP_ID == obj.EMP_ID);
if (isExist)
{
return(RedirectToAction("Index", "EmployeeAttachmentDetail", new { ID = obj.EMP_ID }));
}
}
//if attck by direct URL
if (role == "emp")
{
bool isExist = db.HRMS_EMP_ReferenceDetail.Any(x => x.EMP_ID == emp_id);
if (isExist)
{
long id = db.HRMS_EMP_ReferenceDetail.Where(x => x.EMP_ID == emp_id).Select(x => x.ID).FirstOrDefault();
return(RedirectToAction("Details", "EmployeeReferenceDetail", new { id }));
}
}
ViewBag.Country = new SelectList(db.Country, "CountryID", "CountryName");
ViewBag.State = new SelectList("");
ViewBag.City = new SelectList("");
//ViewBag.EMP_ID = new SelectList(db.HRMS_Emp_Details, "Emp_ID", "First_Name");
return(View(obj));
}
public ActionResult Edit(long?id)
{
long emp_id = Convert.ToInt64(Session["id"]);
string role = db.Accounts.Where(x => x.ID == emp_id).Select(x => x.role).FirstOrDefault();
if (role == "admin")
{
ViewBag.Role = "admin";
}
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
//URL Attack
if (role == "emp")
{
id = db.HRMS_EMP_ReferenceDetail.Where(x => x.EMP_ID == emp_id).Select(x => x.ID).FirstOrDefault();
}
HRMS_EMP_ReferenceDetail hRMS_EMP_ReferenceDetail = db.HRMS_EMP_ReferenceDetail.Find(id);
if (hRMS_EMP_ReferenceDetail == null)
{
return(HttpNotFound());
}
ViewBag.Country = new SelectList(db.Country, "CountryID", "CountryName");
ViewBag.State = new SelectList(db.State.Where(x => x.CountryID == hRMS_EMP_ReferenceDetail.Country), "StateID", "StateName");
ViewBag.City = new SelectList(db.City.Where(x => x.StateID == hRMS_EMP_ReferenceDetail.State), "CityID", "CityName");
return(View(hRMS_EMP_ReferenceDetail));
}
public ActionResult Edit([Bind(Include = "ID,EMP_ID,Is_Ref_Emp,Name,Country,State,City,Relationship,Pincode,Address,Designation,Company,PhoneNo,MobileNo,Email")] HRMS_EMP_ReferenceDetail hRMS_EMP_ReferenceDetail)
{
long emp_id = Convert.ToInt64(Session["id"]);
string role = db.Accounts.Where(x => x.ID == emp_id).Select(x => x.role).FirstOrDefault();
if (role == "emp")
{
ModelState.Remove("EMP_ID");
hRMS_EMP_ReferenceDetail.EMP_ID = emp_id;
}
if (ModelState.IsValid)
{
bool isValid = db.HRMS_EMP_ReferenceDetail.Any(x => (x.ID != hRMS_EMP_ReferenceDetail.ID) && (x.EMP_ID == hRMS_EMP_ReferenceDetail.EMP_ID));
if (!isValid)
{
db.Entry(hRMS_EMP_ReferenceDetail).State = EntityState.Modified;
db.SaveChanges();
ViewBag.success = "Your Record Successfully Updated!";
if (role == "emp")
{
long id = db.HRMS_EMP_ReferenceDetail.Where(x => x.EMP_ID == emp_id).Select(x => x.ID).FirstOrDefault();
return(RedirectToAction("Details", "EmployeeReferenceDetail", new { id }));
}
ViewBag.Country = new SelectList(db.Country, "CountryID", "CountryName");
ViewBag.State = new SelectList(db.State.Where(x => x.CountryID == hRMS_EMP_ReferenceDetail.Country), "StateID", "StateName");
ViewBag.City = new SelectList(db.City.Where(x => x.StateID == hRMS_EMP_ReferenceDetail.State), "CityID", "CityName");
if (role == "admin")
{
ViewBag.Role = "admin";
}
return(View(hRMS_EMP_ReferenceDetail));
}
else
{
ViewBag.error = "Sorry!";
ViewBag.Country = new SelectList(db.Country, "CountryID", "CountryName");
ViewBag.State = new SelectList(db.State.Where(x => x.CountryID == hRMS_EMP_ReferenceDetail.Country), "StateID", "StateName");
ViewBag.City = new SelectList(db.City.Where(x => x.StateID == hRMS_EMP_ReferenceDetail.State), "CityID", "CityName");
if (role == "admin")
{
ViewBag.Role = "admin";
}
return(View(hRMS_EMP_ReferenceDetail));
}
}
ViewBag.Country = new SelectList(db.Country, "CountryID", "CountryName");
ViewBag.State = new SelectList(db.State.Where(x => x.CountryID == hRMS_EMP_ReferenceDetail.Country), "StateID", "StateName");
ViewBag.City = new SelectList(db.City.Where(x => x.StateID == hRMS_EMP_ReferenceDetail.State), "CityID", "CityName");
if (role == "admin")
{
ViewBag.Role = "admin";
}
return(View(hRMS_EMP_ReferenceDetail));
}
public ActionResult Details(long?id, string name)
{
long emp_id = Convert.ToInt64(Session["id"]);
string role = db.Accounts.Where(x => x.ID == emp_id).Select(x => x.role).FirstOrDefault();
if (role == "admin")
{
ViewBag.Role = "admin";
if (name != null)
{
bool isThere = db.HRMS_EMP_ReferenceDetail.Any(x => x.EMP_ID == id.Value);
if (!isThere)
{
return(RedirectToAction("Create", "EmployeeReferenceDetail", new { ID = id.Value }));
}
else
{
ViewBag.EditVisible = "No";
HRMS_EMP_ReferenceDetail employee_Personal_Detail = db.HRMS_EMP_ReferenceDetail.Where(x => x.EMP_ID == id.Value).FirstOrDefault();
return(View(employee_Personal_Detail));
}
}
}
//if no entry it will redirect to create
bool isExist = db.HRMS_EMP_ReferenceDetail.Any(x => x.EMP_ID == emp_id);
if (!isExist)
{
return(RedirectToAction("Create"));
}
else
{
// if (id == null)
//{
// return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
//}
if (role == "emp")
{
id = db.HRMS_EMP_ReferenceDetail.Where(x => x.EMP_ID == emp_id).Select(x => x.ID).FirstOrDefault();
}
HRMS_EMP_ReferenceDetail hRMS_EMP_ReferenceDetail = db.HRMS_EMP_ReferenceDetail.Find(id);
if (hRMS_EMP_ReferenceDetail == null)
{
return(HttpNotFound());
}
return(View(hRMS_EMP_ReferenceDetail));
}
}
public bool delete(long id)
{
HRMS_EMP_ReferenceDetail hRMS_EMP_ReferenceDetail = db.HRMS_EMP_ReferenceDetail.Find(id);
if (hRMS_EMP_ReferenceDetail != null)
{
db.HRMS_EMP_ReferenceDetail.Remove(hRMS_EMP_ReferenceDetail);
db.SaveChanges();
return(true);
}
else
{
return(false);
}
}
public ActionResult Create([Bind(Include = "ID,EMP_ID,Is_Ref_Emp,Name,Country,State,City,Relationship,Pincode,Address,Designation,Company,PhoneNo,MobileNo,Email")] HRMS_EMP_ReferenceDetail hRMS_EMP_ReferenceDetail)
{
long emp_id = Convert.ToInt64(Session["id"]);
string role = db.Accounts.Where(x => x.ID == emp_id).Select(x => x.role).FirstOrDefault();
if (role == "emp")
{
ModelState.Remove("EMP_ID");
hRMS_EMP_ReferenceDetail.EMP_ID = emp_id;
}
if (ModelState.IsValid)
{
bool isValid = db.HRMS_EMP_ReferenceDetail.Any(x => x.EMP_ID == hRMS_EMP_ReferenceDetail.EMP_ID);
if (!isValid)
{
// HRMS_EMP_ReferenceDetail.IsActive = true;
db.HRMS_EMP_ReferenceDetail.Add(hRMS_EMP_ReferenceDetail);
db.SaveChanges();
ViewBag.success = "Reference is Successfully created!";
ModelState.Clear();
if (role == "emp")
{
long id = db.HRMS_EMP_ReferenceDetail.Where(x => x.EMP_ID == emp_id).Select(x => x.ID).FirstOrDefault();
return(RedirectToAction("Details", "EmployeeReferenceDetail", new { id }));
}
//ViewBag.Country = new SelectList(db.Country, "CountryID", "CountryName");
//ViewBag.State = new SelectList("");
//ViewBag.City = new SelectList("");
if (role == "admin")
{
ViewBag.Role = "admin";
return(RedirectToAction("Index", "EmployeeAttachmentDetail", new { ID = hRMS_EMP_ReferenceDetail.EMP_ID }));
}
//return View();
}
else
{
ViewBag.error = "Reference is already exist!";
//long cid = db.Country.Where(x => x.CountryName == unitMaster.Country).Select(x => x.CountryID).SingleOrDefault();
//long sid = db.State.Where(x => x.StateName == unitMaster.State).Select(x => x.StateID).SingleOrDefault();
ViewBag.Country = new SelectList(db.Country, "CountryID", "CountryName");
ViewBag.State = new SelectList(db.State.Where(x => x.CountryID == hRMS_EMP_ReferenceDetail.Country), "StateID", "StateName");
ViewBag.City = new SelectList(db.City.Where(x => x.StateID == hRMS_EMP_ReferenceDetail.State), "CityID", "CityName");
if (role == "admin")
{
ViewBag.Role = "admin";
}
return(View(hRMS_EMP_ReferenceDetail));
}
}
ViewBag.Country = new SelectList(db.Country, "CountryID", "CountryName");
ViewBag.State = new SelectList(db.State.Where(x => x.CountryID == hRMS_EMP_ReferenceDetail.Country), "StateID", "StateName");
ViewBag.City = new SelectList(db.City.Where(x => x.StateID == hRMS_EMP_ReferenceDetail.State), "CityID", "CityName");
if (role == "admin")
{
ViewBag.Role = "admin";
}
return(View(hRMS_EMP_ReferenceDetail));
}
