public async Task <ActionResult> AddPrevWorkExpDetails(string schoolId, string Staff_Id, string Name, string Address, string Designation, string FrmYear, string ToYear, string Subjects_Handled, string Designation_Id)
{
var userId = LoggedInUser.Id;
JsonResult result = new JsonResult();
try
{
var schoolid = Convert.ToInt32(schoolId);
var staffId = Convert.ToInt32(Staff_Id);
var designation = Convert.ToInt32(Designation_Id);
var frmYear = Convert.ToInt32(FrmYear);
var toYear = Convert.ToInt32(ToYear);
// , string FrmYear, string ToYear, string Leaving, string Comments
var CheckStudent = db.Staff_Exp_Details.Where(a => a.Staff_Id == staffId && a.School_Id == schoolid).Count();
if (CheckStudent == 0)
{
Staff_Exp_Details addStaffWorkExpDetails = new Staff_Exp_Details();
addStaffWorkExpDetails.Staff_Id = staffId;
addStaffWorkExpDetails.School_Id = schoolid;
addStaffWorkExpDetails.Designation_Id = Convert.ToInt32(Designation_Id);
addStaffWorkExpDetails.From_Year = frmYear;
addStaffWorkExpDetails.Is_Deleted = false;
addStaffWorkExpDetails.To_Year = toYear;
addStaffWorkExpDetails.Subject_Id = Subjects_Handled;
addStaffWorkExpDetails.Academic_Year = (DateTime.Now.Month < 3) ? DateTime.Now.Year - 1 : DateTime.Now.Year;
//addStaffWorkExpDetails.Comments = Comments;
addStaffWorkExpDetails.Created_On = DateTime.Now;
addStaffWorkExpDetails.Created_By = userId;
addStaffWorkExpDetails.Is_Active = true;
db.Staff_Exp_Details.Add(addStaffWorkExpDetails);
await db.SaveChangesAsync();
}
else
{
}
}
catch (Exception ex)
{
result.Data = new { Result = "ERROR", Message = " This property already available in this block " };
}
return(RedirectToAction("CreateStaffOtherDetails"));
}
public async Task <ActionResult> DeleteWorkExpDetails(string schoolId, string StaffId)
{
var userId = LoggedInUser.Id;
JsonResult result = new JsonResult();
try
{
var school_Id = Convert.ToInt32(schoolId);
var staff_Id = Convert.ToInt32(StaffId);
Staff_Exp_Details deleteWorkExpDetails = db.Staff_Exp_Details.Where(a => a.School_Id == school_Id && a.Staff_Id == staff_Id).FirstOrDefault();
db.Entry(deleteWorkExpDetails).CurrentValues.SetValues(deleteWorkExpDetails);
deleteWorkExpDetails.Is_Deleted = true;
db.Entry(deleteWorkExpDetails).State = EntityState.Modified;
await db.SaveChangesAsync();
}
catch (Exception ex)
{
result.Data = new { Result = "ERROR", Message = " This property already available in this block " };
}
return(RedirectToAction("CreateStaffOtherDetails"));
}
// GET: Core/Staffs/Delete/5
public async Task <ActionResult> Delete(long?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
//if (staff == null)
//{
// return HttpNotFound();
//}
using (StudentDbContext db = new StudentDbContext())
{
Staff staff = await db.Staffs.FindAsync(id);
if (staff != null)
{
staff.Is_Deleted = true;
db.Entry(staff).CurrentValues.SetValues(staff);
db.Entry(staff).State = EntityState.Modified;
await db.SaveChangesAsync();
}
}
using (StudentDbContext db = new StudentDbContext())
{
Staff_Educational_Details staffEducationalDetails = await db.Staff_Educational_Details.FindAsync(id);
if (staffEducationalDetails != null)
{
staffEducationalDetails.Is_Deleted = true;
db.Entry(staffEducationalDetails).CurrentValues.SetValues(staffEducationalDetails);
db.Entry(staffEducationalDetails).State = EntityState.Modified;
await db.SaveChangesAsync();
}
}
using (StudentDbContext db = new StudentDbContext())
{
Staff_Salary_Detail staffSalaryDetail = await db.Staff_Salary_Details.FindAsync(id);
if (staffSalaryDetail != null)
{
staffSalaryDetail.Is_Deleted = true;
db.Entry(staffSalaryDetail).CurrentValues.SetValues(staffSalaryDetail);
db.Entry(staffSalaryDetail).State = EntityState.Modified;
await db.SaveChangesAsync();
}
}
using (StudentDbContext db = new StudentDbContext())
{
Staff_Exp_Details stafExpDetails = await db.Staff_Exp_Details.FindAsync(id);
if (stafExpDetails != null)
{
stafExpDetails.Is_Deleted = true;
db.Entry(stafExpDetails).CurrentValues.SetValues(stafExpDetails);
db.Entry(stafExpDetails).State = EntityState.Modified;
await db.SaveChangesAsync();
}
}
return(RedirectToAction("Index"));
}
