public ActionResult DeleteConfirmed(int id)
{
tbl_staff tbl_staff = db.tbl_staff.Find(id);
db.tbl_staff.Remove(tbl_staff);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "staff_id,staff_name,staff_contact,staff_cnic,staff_address")] tbl_staff tbl_staff)
{
if (ModelState.IsValid)
{
db.Entry(tbl_staff).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tbl_staff));
}
public ActionResult Create([Bind(Include = "staff_id,staff_name,staff_contact,staff_cnic,staff_address")] tbl_staff tbl_staff)
{
if (ModelState.IsValid)
{
db.tbl_staff.Add(tbl_staff);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tbl_staff));
}
// GET: Staff/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tbl_staff tbl_staff = db.tbl_staff.Find(id);
if (tbl_staff == null)
{
return(HttpNotFound());
}
return(View(tbl_staff));
}
public object DeleteStaff(ParamRegistration PR)
{
try
{
tbl_user objuser = db.tbl_user.Where(r => r.UserId == PR.UserId).FirstOrDefault();
if (objuser.Display == 1)
{
objuser.Display = 0;
}
else
{
objuser.Display = 1;
}
db.SaveChanges();
if (PR.Type == "Staff")
{
tbl_staff objstaff = db.tbl_staff.Where(r => r.UserId == PR.UserId).FirstOrDefault();
if (objstaff.Display == 1)
{
objstaff.Display = 0;
}
else
{
objstaff.Display = 1;
}
db.SaveChanges();
}
return(new Result()
{
IsSucess = true, ResultData = "User Deleted Successfully."
});
}
catch (Exception ex)
{
return(new Error()
{
IsError = true, Message = ex.Message
});
}
}
public object UpdateStaff(ParamRegistration PR)
{
try
{
tbl_user objuser = db.tbl_user.Where(r => r.UserId == PR.UserId).FirstOrDefault();
objuser.name = PR.Name;
objuser.type = PR.Type;
objuser.gender = PR.Gender;
objuser.email = PR.Email;
objuser.contact = PR.Contact;
objuser.modified_date = DateTime.Now;
objuser.status = 1;
objuser.Islive = 1;
db.SaveChanges();
if (PR.Type == "Staff")
{
tbl_staff objstaff = db.tbl_staff.Where(r => r.UserId == PR.UserId).FirstOrDefault();
objstaff.department = PR.Department;
objstaff.designation = PR.Designation;
objstaff.modified_date = DateTime.Now;
db.SaveChanges();
}
return(new Result()
{
IsSucess = true, ResultData = "User Saved Successfully."
});
}
catch (Exception ex)
{
return(new Error()
{
IsError = true, Message = ex.Message
});
}
}
public object SaveRegistration(ParamRegistration PR)
{
try
{
var usercode = db.tbl_user.Where(r => r.code == PR.code).FirstOrDefault();
if (usercode != null)
{
return(new Error()
{
IsError = true, Message = "User Code Already Exists."
});
}
tbl_user objuser = new tbl_user();
objuser.name = PR.Name;
objuser.UserId = PR.UserId;
objuser.type = PR.Type;
objuser.gender = PR.Gender;
objuser.code = PR.code;
objuser.email = PR.Email;
objuser.contact = PR.Contact;
string EncryptedPassword = CryptIt.Encrypt(PR.Password);
objuser.password = EncryptedPassword;
objuser.status = 1;
objuser.Islive = 1;
objuser.Display = 1;
objuser.created_date = DateTime.Now;
db.tbl_user.Add(objuser);
db.SaveChanges();
if (PR.Type == "Student")
{
tbl_student objstudent = new tbl_student();
objstudent.UserId = PR.UserId;
tbl_user obstudent = db.tbl_user.Where(r => r.code == PR.code).FirstOrDefault();
objstudent.UserId = obstudent.UserId;
objstudent.code = PR.code;
objstudent.course_name = PR.CourseName;
objstudent.class_name = PR.ClassName;
objstudent.IsParent = 0;
objstudent.Display = 1;
objstudent.created_date = DateTime.Now;
db.tbl_student.Add(objstudent);
db.SaveChanges();
}
else if (PR.Type == "Faculty")
{
tbl_faculty objfaculty = new tbl_faculty();
objfaculty.UserId = PR.UserId;
tbl_user obfaculty = db.tbl_user.Where(r => r.code == PR.code).FirstOrDefault();
objfaculty.UserId = obfaculty.UserId;
objfaculty.code = PR.code;
objfaculty.department = PR.CourseName;
objfaculty.designation = PR.Designation;
objfaculty.Display = 1;
objfaculty.created_date = DateTime.Now;
db.tbl_faculty.Add(objfaculty);
db.SaveChanges();
}
else if (PR.Type == "Parent")
{
tbl_parent objparent = new tbl_parent();
objparent.UserId = PR.UserId;
objparent.relationship = PR.Relationship;
tbl_user obstudent = db.tbl_user.Where(r => r.code == PR.code).FirstOrDefault();
objparent.UserId = obstudent.UserId;
objparent.code = PR.code;
objparent.Display = 1;
objparent.created_date = DateTime.Now;
db.tbl_parent.Add(objparent);
db.SaveChanges();
//tbl_student objstudent = db.tbl_student.Where(r => r.UserId == PR.UserId).FirstOrDefault();
//objstudent.IsParent = 1;
//db.SaveChanges();
}
else if (PR.Type == "Staff")
{
tbl_staff objstaff = new tbl_staff();
objstaff.UserId = objuser.UserId;
tbl_user obstaff = db.tbl_user.Where(r => r.code == PR.code).FirstOrDefault();
objstaff.UserId = objstaff.UserId;
objstaff.code = PR.code;
objstaff.department = PR.CourseName;
objstaff.designation = PR.Designation;
objstaff.Display = 1;
objstaff.created_date = DateTime.Now;
db.tbl_staff.Add(objstaff);
db.SaveChanges();
}
else
{
return(new Error()
{
IsError = true, Message = "User Type Not Matched."
});
}
return(new Result()
{
IsSucess = true, ResultData = "User Saved Successfully."
});
}
catch (Exception ex)
{
return(new Error()
{
IsError = true, Message = ex.Message
});
}
}
public object DeleteStaff(ParamRegistration PR)
{
try
{
string res = "";
tbl_user objuser = db.tbl_user.Where(r => r.UserId == PR.UserId).FirstOrDefault();
if (objuser.Display == 1)
{
objuser.Display = 0;
}
else
{
objuser.Display = 1;
}
db.SaveChanges();
if (PR.Type == "Staff")
{
tbl_staff objstaff = db.tbl_staff.Where(r => r.UserId == PR.UserId).FirstOrDefault();
if (objstaff.Display == 1)
{
objstaff.Display = 0;
}
else
{
objstaff.Display = 1;
}
db.SaveChanges();
if (objstaff.Display == 1)
{
if (objuser.name.Length > 0)
{
string appset = ConfigurationManager.AppSettings["BaseEmailUrl"];
res = " <b>Dear " + objuser.name + "</b>, Your account for griveance redressal system has been activated by the admin,<a href='" + appset + "'>click here</a> to login your account ";
}
else
{
res = "Sorry we didn't find you in our system.";
return(res);
}
try
{
Email objemail = new Email();
bool IsDelete;
if (objuser.email.Length > 0)
{
//IsDelete = objSMS.SMSSend(MobNo, res);
IsDelete = objemail.SendEmail(objuser.email, res, "Active Status", "", "", "", "");
}
else
{
res = "Sorry we didn't find your Email ID in our system.";
}
return(res);
}
catch (Exception e)
{
return(new Error()
{
IsError = true, Message = e.Message
});
}
}
}
return(new Result()
{
IsSucess = true, ResultData = "User Deleted Successfully."
});
}
catch (Exception ex)
{
return(new Error()
{
IsError = true, Message = ex.Message
});
}
}
