public async Task <ActionResult> AddEducationalQualificationDetails(string staffId, string qualification_Id, string specialization_Id, string institution_Id, string passingYear, string MediumOfInstruction)
{
var userId = LoggedInUser.Id;
JsonResult result = new JsonResult();
try
{
//var schoolid = Convert.ToInt32(schoolId);
var staff_Id = Convert.ToInt32(staffId);
var qualificationId = Convert.ToInt32(qualification_Id);
var specializationId = Convert.ToInt32(specialization_Id);
var institutionId = Convert.ToInt32(institution_Id);
var passing_Year = Convert.ToInt64(passingYear);
var Medium_Of_Instruction = MediumOfInstruction;
// , string FrmYear, string ToYear, string Leaving, string Comments
var CheckStaffQualDetails = db.Staff_Educational_Details.Where(a => a.Staff_Id == staff_Id && a.Qualification_Id == qualificationId).Count();
if (CheckStaffQualDetails == 0)
{
Staff_Educational_Details addStaffEduQualDetails = new Staff_Educational_Details();
addStaffEduQualDetails.Staff_Id = staff_Id;
addStaffEduQualDetails.Qualification_Id = qualificationId;
addStaffEduQualDetails.Specialization_Id = specializationId;
addStaffEduQualDetails.Institution_Id = institutionId;
addStaffEduQualDetails.Is_Deleted = false;
addStaffEduQualDetails.Year_Of_Passing = passing_Year;
addStaffEduQualDetails.Medium_Of_Instruction = Medium_Of_Instruction;
addStaffEduQualDetails.Academic_Year = (DateTime.Now.Month < 3) ? DateTime.Now.Year - 1 : DateTime.Now.Year;
//addStaffWorkExpDetails.Comments = Comments;
addStaffEduQualDetails.Created_On = DateTime.Now;
addStaffEduQualDetails.Created_By = userId;
addStaffEduQualDetails.Is_Active = true;
db.Staff_Educational_Details.Add(addStaffEduQualDetails);
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> DeleteEduQualDetails(string staffId, string qual_Id)
{
var userId = LoggedInUser.Id;
JsonResult result = new JsonResult();
try
{
var staff_Id = Convert.ToInt32(staffId);
var qualId = int.Parse(qual_Id);
Staff_Educational_Details deleteEduQualDetails = db.Staff_Educational_Details.Where(a => a.Staff_Id == staff_Id && a.Qualification_Id == qualId).FirstOrDefault();
db.Entry(deleteEduQualDetails).CurrentValues.SetValues(deleteEduQualDetails);
deleteEduQualDetails.Is_Deleted = true;
db.Entry(deleteEduQualDetails).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"));
}
