public ActionResult Show()
{
var dataSet = Session["Users"] as tbl_Member;
var educations = db.tbl_Education.ToList();
var educationList = new List <EducationModel>();
foreach (var education in educations)
{
if (education.fk_UserID == dataSet.UserID)
{
var eModel = new EducationModel
{
EducationID = education.EducationID,
SchoolName = education.SchoolName,
Department = education.Department,
StartDate = education.StartDate,
FinishDate = education.FinishDate,
fk_StatusID = education.fk_StatusID,
fk_UserID = education.fk_UserID
};
educationList.Add(eModel);
}
}
return(View(educationList));
}
protected void EditButton_Click(object sender, EventArgs e)
{
EducationModel model = new EducationModel()
{
CourseType = CourseTypeTextBox.Text,
YearOfPass = CourseYearTextBox.Text,
CourseSpecialization = CourseSpecialiazationTextBox.Text,
EmployeeId = Convert.ToInt32(EmployeeIdDropDownList.Text)
};
int EditEmployeeId = Convert.ToInt32(EditEmployeeIdInEducationDropDownList.Text);
SqlConnection mysqlconnection = new SqlConnection()
{
ConnectionString = "Data Source = PRAJWOLPC;database = Pioneer_Employee_Database1;Integrated security = SSPI"
};
SqlCommand cmd = new SqlCommand("UPDATE [EducationDetail] SET[CourseType] = " +
"'" + model.CourseType + "',[YearOfPass] = " + Convert.ToInt32(model.YearOfPass) + ",[CourseSpecilization] = '" + model.CourseSpecialization + "'WHERE EmployeeID = " + EditEmployeeId, mysqlconnection);
mysqlconnection.Open();
int result = cmd.ExecuteNonQuery();
ClientScript.RegisterStartupScript(this.GetType(), "Operation was", "alert(' Education Details SUCCESSFULLY Edited');", true);
}
public HttpResponseMessage GetEducationModels(EducationModel model)
{
IUnitOfWork uWork = new UnitOfWork();
IEducationRepository education = new EducationRepository(uWork);
IEducationService educationService = new EducationService(education);
try
{
if (this.ModelState.IsValid)
{
var educationList = educationService.GetAllEducationList(model);
if (educationList != null)
{
return(Request.CreateResponse(HttpStatusCode.OK, educationList));
}
else
{
string message = "Error in getting Data";
return(Request.CreateErrorResponse(HttpStatusCode.Forbidden, message));
}
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex.InnerException.Message));
}
}
public async Task <ResponseModel> Insert(EducationModel model)
{
ResponseModel response = new ResponseModel();
try
{
Education md = new Education();
md.Name = model.Name;
md.Precedence = model.Precedence;
md.IsActive = model.IsActive;
md.CreateBy = base.UserId;
md.CreateDate = DateTime.Now;
md.Deleted = false;
await _context.EducationRepository.AddAsync(md).ConfigureAwait(true);
await _context.SaveChangesAsync();
}
catch (Exception ex)
{
throw ex;
}
return(response);
}
public JsonResult Delete(EducationModel model)
{
try
{
#region " [ Declaration ] "
EducationService _service = new EducationService();
#endregion
#region " [ Main process ] "
model.CreateBy = UserID;
model.DeleteBy = UserID;
model.DeleteDate = DateTime.Now;
#endregion
//Call to service
return(this.Json(_service.Delete(model), JsonRequestBehavior.AllowGet));
}
catch (ServiceException serviceEx)
{
throw serviceEx;
}
catch (DataAccessException accessEx)
{
throw accessEx;
}
catch (Exception ex)
{
throw new ControllerException(FILE_NAME, "Delete", UserID, ex);
}
}
public async Task <IActionResult> GetSingle(Guid Id)
{
var AuthenticatedUserId = User.Identity.GetUserId();
var Education = await Context.UserEducation.FirstOrDefaultAsync(x => x.Id == Id && !x.IsRemoved && x.UserId == Guid.Parse(AuthenticatedUserId));
if (Education != null)
{
var education = new EducationModel
{
UniversityId = Education.UniversityId,
Department = Education.Department,
EducationId = Id,
ActivitiesSocieties = Education.ActivitiesSocieties,
StartYear = int.Parse(Education.StartYear),
EndYear = int.Parse(Education.EndYear),
};
education.AreUniversityorDepartmentCanEditable = Education.AreUniNameOrDepartmentCanEditable();
if (education.ActivitiesSocieties == null || education.ActivitiesSocieties == "undefined")
{
education.ActivitiesSocieties = "";
}
return(Succes(null, education));
}
return(Error(null, null, null, 404));
}
public ActionResult Create()
{
try
{
#region " [ Declaration ] "
EducationTypeService _typeService = new EducationTypeService();
EducationModel model = new EducationModel()
{
ID = Guid.NewGuid(),
CreateBy = UserID,
Insert = true
};
ViewBag.type = _typeService.GetAll(UserID);
#endregion
return(View(model));
}
catch (ServiceException serviceEx)
{
throw serviceEx;
}
catch (DataAccessException accessEx)
{
throw accessEx;
}
catch (Exception ex)
{
throw new ControllerException(FILE_NAME, "Create", UserID, ex);
}
}
public ActionResult Edit(string id)
{
try
{
#region " [ Declaration ] "
EducationTypeService _typeService = new EducationTypeService();
EducationService _service = new EducationService();
ViewBag.id = id;
ViewBag.type = _typeService.GetAll(UserID);
#endregion
// Call to service
EducationModel model = _service.GetItemByID(new EducationModel()
{
ID = new Guid(id), CreateBy = UserID, Insert = false
});
return(View(model));
}
catch (ServiceException serviceEx)
{
throw serviceEx;
}
catch (DataAccessException accessEx)
{
throw accessEx;
}
catch (Exception ex)
{
throw new ControllerException(FILE_NAME, "Edit", UserID, ex);
}
}
/// <summary>
/// Delete
/// </summary>
/// <param name="model">model</param>
/// <returns>ResponseStatusCodeHelper</returns>
public ResponseStatusCodeHelper Delete(EducationModel model)
{
try
{
using (var _context = new TDHEntities())
{
PN_EDUCATION _md = _context.PN_EDUCATION.FirstOrDefault(m => m.id == model.ID && !m.deleted && m.created_by == model.CreateBy);
if (_md == null)
{
throw new DataAccessException(FILE_NAME, "Delete", model.CreateBy);
}
_md.deleted = true;
_md.deleted_by = model.DeleteBy;
_md.deleted_date = DateTime.Now;
_context.PN_EDUCATION.Attach(_md);
_context.Entry(_md).State = EntityState.Modified;
_context.SaveChanges();
}
}
catch (DataAccessException fieldEx)
{
throw fieldEx;
}
catch (Exception ex)
{
throw new ServiceException(FILE_NAME, "Delete", model.CreateBy, ex);
}
Notifier.Notification(model.CreateBy, Message.DeleteSuccess, Notifier.TYPE.Success);
return(ResponseStatusCodeHelper.Success);
}
public HttpResponseMessage Get(int id)
{
EducationModel retr = null;
try
{
Education edu = dbContext.Educations.Find(id);
if (edu != null)
{
EducationModel eduM = new EducationModel()
{
eduType = edu.Name,
ID = edu.EducationID,
};
EmployeeController empCon = new EmployeeController();
for (int i = 0; i < edu.Employees.Count; i++)
{
EmployeeModel empMod = empCon.Get(edu.Employees.ToList()[i].EmployeeID);
eduM.employees.Add(empMod);
}
return(Request.CreateResponse(HttpStatusCode.OK, eduM));
}
}
catch
{
return(Request.CreateResponse(HttpStatusCode.Conflict, retr));
}
return(Request.CreateResponse(HttpStatusCode.NotFound, retr));
}
public HttpResponseMessage Put(int id, [FromBody] EducationModel value)
{
try
{
Education ToBeUpdated = dbContext.Educations.Find(id);
if (ToBeUpdated != null)
{
ToBeUpdated.Name = value.eduType;
ToBeUpdated.Employees.Clear();
EmployeeController empCon = new EmployeeController();
for (int i = 0; i < value.employees.Count; i++)
{
Employee emp = dbContext.Employees.Find(value.employees[i].ID);
ToBeUpdated.Employees.Add(emp);
}
return(Request.CreateResponse(HttpStatusCode.OK, true));
}
}
catch
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, false));
}
return(Request.CreateResponse(HttpStatusCode.NotModified, false));
}
public EducationModel GetEducation(string educationId)
{
string query = @"select id,teacherId,registrationNumber,coursId,CoursePassed,startDate,endDate
from Обучение
where id = {0};" ;
EducationModel educationModel = null;
using (SqlConnection con = new SqlConnection(_connectionString))
using (SqlCommand command = new SqlCommand(string.Format(query, educationId)))
{
con.Open();
command.Connection = con;
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows) // если есть данные
{
educationModel = new EducationModel();
while (reader.Read())
{
educationModel.Id = reader.GetValue(0)?.ToString();
educationModel.TeacherId = reader.GetValue(1)?.ToString();
educationModel.RegistrationNumber = reader.GetValue(2)?.ToString();
educationModel.CoursId = reader.GetValue(3)?.ToString();
educationModel.CoursePassed = reader.GetValue(4)?.ToString();
}
}
reader.Close();
con.Close();
}
return(educationModel);
}
public HttpResponseMessage DeleteEducation(EducationModel model)
{
IUnitOfWork uWork = new UnitOfWork();
IEducationRepository education = new EducationRepository(uWork);
IEducationService educationService = new EducationService(education);
try
{
if (this.ModelState.IsValid)
{
var result = educationService.DeleteEducation(model);
if (result != null)
{
return(Request.CreateResponse(HttpStatusCode.OK, result));
}
else
{
string message = "Not deleted successfully";
return(Request.CreateErrorResponse(HttpStatusCode.Forbidden, message));
}
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex));
}
}
public string EditEducation(EducationModel EduModel)
{
int result = 0;
try
{
sqlConnection = OpenConnection();
sqlCommand = new SqlCommand();
sqlCommand.Connection = sqlConnection;
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.CommandText = "uspEditEducationDetails";
sqlCommand.Parameters.Add("@EmployeeID", SqlDbType.Int).Value = EduModel.EmployeeID.ToString();
sqlCommand.Parameters.Add("@CourseType", SqlDbType.VarChar).Value = EduModel.CourseType;
sqlCommand.Parameters.Add("@YearOfPass", SqlDbType.Int).Value = EduModel.YearOfPass.ToString();
sqlCommand.Parameters.Add("@CourseSpecialisation", SqlDbType.VarChar).Value = EduModel.CourseSpecialisation;
result = sqlCommand.ExecuteNonQuery();
if (result > 0)
{
return("Details have been updated:");
}
return("Failed");
}
catch (Exception ex)
{
return("An error has been occured, please contact administrator:" + ex.Message);
}
finally
{
CloseConncetion(sqlConnection);
}
}
public async Task <ResponseModel> Delete(EducationModel model)
{
ResponseModel response = new ResponseModel();
try
{
Education md = await _context.EducationRepository.FirstOrDefaultAsync(m => m.Id == model.Id);
if (!md.RowVersion.SequenceEqual(model.RowVersion))
{
response.ResponseStatus = Core.CommonModel.Enums.ResponseStatus.OutOfDateData;
return(response);
}
md.Deleted = true;
md.UpdateBy = base.UserId;
md.UpdateDate = DateTime.Now;
_context.EducationRepository.Update(md);
await _context.SaveChangesAsync();
}
catch (Exception ex)
{
throw ex;
}
return(response);
}
public async Task <ResponseModel> Item(int id)
{
ResponseModel response = new ResponseModel();
try
{
Education md = await _context.EducationRepository.FirstOrDefaultAsync(m => m.Id == id);
EducationModel model = new EducationModel()
{
Id = md.Id,
Name = md.Name,
Precedence = md.Precedence,
IsActive = md.IsActive,
RowVersion = md.RowVersion,
};
response.Result = model;
}
catch (Exception ex)
{
throw ex;
}
return(response);
}
protected void EditButton_Click(object sender, EventArgs e)
{
try
{
EducationModel EduModel = new EducationModel()
{
EmployeeID = Convert.ToInt32(EmployeeIDDropDownList.SelectedValue),
CourseType = CourseTypeTextBox.Text,
YearOfPass = Convert.ToInt32(YearOfPassTextBox.Text),
CourseSpecialisation = CourseSpecialisationTextBox.Text
};
EducationAccess EduAccess = new EducationAccess();
string EditEdu = EduAccess.EditEducation(EduModel);
if (EditEdu.Equals("Success"))
{
{
Response.Write("<script>alert('Details have been Updated successfully');</script>");
}
}
}
catch (Exception Ex)
{
Response.Write("<script>alert('Error at EditEducation: '" + Ex.Message + ");</script>");
}
}
public ActionResult Education(EducationModel edu)
{
LoginModel login = Session["Account"] as LoginModel;
edu.IDEdu = user.getID(login.Username.ToString());
user.addNewEducation(edu);
return(View());
}
protected void UpdateLocales(Education entity, EducationModel model)
{
foreach (var localized in model.Locales)
{
_localizedEnitityHelperService.SaveLocalizedValue(entity,
x => x.Name,
localized.Name,
localized.LanguageId);
}
}
protected void EmployeeIDDropDownList_SelectedIndexChanged(object sender, EventArgs e)
{
EducationModel EduModel = new EducationModel();
EducationAccess EduAccess = new EducationAccess();
EduModel = EduAccess.GetEmployee(Convert.ToInt32(EmployeeIDDropDownList.SelectedValue));
CourseTypeTextBox.Text = EduModel.CourseType;
YearOfPassTextBox.Text = EduModel.YearOfPass.ToString();
CourseSpecialisationTextBox.Text = EduModel.CourseSpecialisation;
}
public async Task <IActionResult> EditView([FromQuery] EducationModel educationModel)
{
educationModel.Universities = await Context.University.Select(x => new SelectListItem()
{
Text = x.Name, Value = x.Id.ToString()
}).ToListAsync();
educationModel.ListYears();
return(View(educationModel));
}
public ActionResult Education()
{
ViewData["AdditionHeader"] = "我的设置";
EducationModel model = new EducationModel();
model.CurUser = CurrentUser;
model.CurUserConfig = CurrentUserConfig;
model.Educations = Educations.GetEducationsByUID(model.CurUser.ID);
return(View(model));
}
protected void EditEmployeeIdInEducationDropDownList_SelectedIndexChanged(object sender, EventArgs e)
{
EducationModel model = new EducationModel();
model = GetEducationDetails(Convert.ToInt32(EditEmployeeIdInEducationDropDownList.Text));
CourseTypeTextBox.Text = model.CourseType;
CourseYearTextBox.Text = model.YearOfPass;
CourseSpecialiazationTextBox.Text = model.CourseSpecialization;
EmployeeIdDropDownList.Text = Convert.ToString(model.EmployeeId);
}
public EducationModel UpdateEducation(EducationModel education)
{
try
{
return(_educationRepository.UpdateEducation(education));
}
catch (Exception ex)
{
throw ex;
}
}
public IHttpActionResult SaveEducation(EducationModel education)
{
try
{
return(Ok(_educationService.SaveEducation(education)));
}
catch (Exception ex)
{
return(InternalServerError(ex));
}
}
public ActionResult Edit(int id, EducationModel edModel)
{
var education = db.tbl_Education.FirstOrDefault(e => e.EducationID == id);
education.SchoolName = edModel.SchoolName;
education.Department = edModel.Department;
education.StartDate = edModel.StartDate;
education.FinishDate = edModel.FinishDate;
education.fk_StatusID = edModel.fk_StatusID;
db.SaveChanges();
return(RedirectToAction("Show"));
}
public async Task <IViewComponentResult> InvokeAsync()
{
var Model = new EducationModel();
Model.ListYears();
Model.Universities = await Context.University.Select(x => new SelectListItem()
{
Text = x.Name, Value = x.Id.ToString()
}).ToListAsync();
return(View(Model));
}
public EducationModel UpdateEducation(EducationModel educationModel)
{
var education = _dbContext.Educations
.FirstOrDefault(x => x.Id == educationModel.Id && x.RecordStatus == true);
education.Name = educationModel.Name;
education.UpdateDate = DateTime.Now;
_dbContext.SaveChanges();
return(educationModel);
}
public ActionResult Edit(int id)
{
var education = db.tbl_Education.FirstOrDefault(e => e.EducationID == id);
var change = new EducationModel();
change.SchoolName = education.SchoolName;
change.Department = education.Department;
change.StartDate = education.StartDate;
change.FinishDate = education.FinishDate;
change.fk_StatusID = education.fk_StatusID;
ViewBag.fk_StatusID = new SelectList(db.tbl_Status, "StatusID", "StatusName", education.fk_StatusID);
return(View(change));
}
public EducationModel SaveEducation(EducationModel educationModel)
{
var education = new Education
{
Name = educationModel.Name
};
_dbContext.Educations.Add(education);
_dbContext.SaveChanges();
educationModel.Id = education.Id;
return(educationModel);
}
