public int inserteducation(EducationDetailsModel education) { EducationDataAccess edacces = new EducationDataAccess(); int edu = edacces.SaveEducation(education); return(edu); }
public async Task <IActionResult> Put(int id, [FromBody] UpdateEducationMaster education) { try { if (!ModelState.IsValid) { return(Ok(new OperationResponse { HasSucceeded = false, IsDomainValidationErrors = true, StatusCode = ((int)ResponseStatus.BadRequest).ToString(), Message = string.Join("; ", ModelState.Values .SelectMany(x => x.Errors) .Select(x => x.ErrorMessage)) })); } EducationDataAccess _educationAccess = new EducationDataAccess(_iconfiguration); DatabaseResponse response = await _educationAccess.UpdateEducation(education, id); if (response.ResponseCode == (int)DbReturnValue.UpdateSuccess) { return(Ok(new OperationResponse { HasSucceeded = true, IsDomainValidationErrors = false, Message = EnumExtensions.GetDescription(DbReturnValue.UpdateSuccess), ReturnedObject = response.Results })); } else { Log.Error(EnumExtensions.GetDescription(DbReturnValue.UpdationFailed)); return(Ok(new OperationResponse { HasSucceeded = false, IsDomainValidationErrors = false, Message = EnumExtensions.GetDescription(DbReturnValue.NotExists), ReturnedObject = response.Results })); } } catch (Exception ex) { Log.Error(new ExceptionHelper().GetLogString(ex, ErrorLevel.Critical)); return(Ok(new OperationResponse { HasSucceeded = false, Message = StatusMessages.ServerError, StatusCode = ((int)ResponseStatus.ServerError).ToString(), IsDomainValidationErrors = false })); } }
protected void EmployeeIDDropDownList_SelectedIndexChanged(object sender, EventArgs e) { EducationDetailsModel educationmodel = new EducationDetailsModel(); EducationDataAccess educationaccess = new EducationDataAccess(); educationmodel = educationaccess.GetEducationDetails(Convert.ToInt32(EmployeeIDDropDownList.SelectedValue)); CourseTypeTextBox.Text = educationmodel.CourseType; CourseSpecialisationTextBox.Text = educationmodel.CourseSpecialisation; YearOfPassTextBox.Text = educationmodel.YearOfPass.ToString(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { EducationDataAccess obj = new EducationDataAccess(); List <int> EmpIDList = obj.GetEmployeeID(); int i = 0; foreach (int EmpID in EmpIDList) { EmployeeIDDropDownList.Items.Insert(i, new ListItem(EmpID.ToString(), EmpID.ToString())); i++; } } UnobtrusiveValidationMode = UnobtrusiveValidationMode.None; }
private void button4_Click(object sender, EventArgs e) { try { EducationDetailsModel edu = new EducationDetailsModel() { CourseType = CourseTypetextbox.Text, CourseSpecialisation = CourseSpecialisationtextbox.Text, YearOfPass = Convert.ToInt32(YearOfPasstextbox.Text), }; EducationDataAccess education = new EducationDataAccess(); education.SaveEducation(edu); } catch (Exception ex) { MessageBox.Show("Please enter the values:"); } }
public async Task <IActionResult> Get() { try { EducationDataAccess _educationAccess = new EducationDataAccess(_iconfiguration); DatabaseResponse response = await _educationAccess.GetEducations(); if (response.ResponseCode == (int)DbReturnValue.RecordExists) { return(Ok(new OperationResponse { HasSucceeded = true, IsDomainValidationErrors = false, Message = EnumExtensions.GetDescription(DbReturnValue.RecordExists), ReturnedObject = response.Results })); } else { Log.Error(EnumExtensions.GetDescription(DbReturnValue.NoRecords)); return(Ok(new OperationResponse { HasSucceeded = false, IsDomainValidationErrors = false, Message = EnumExtensions.GetDescription(DbReturnValue.NoRecords) })); } } catch (Exception ex) { Log.Error(new ExceptionHelper().GetLogString(ex, ErrorLevel.Critical)); return(Ok(new OperationResponse { HasSucceeded = false, Message = StatusMessages.ServerError, StatusCode = ((int)ResponseStatus.ServerError).ToString(), IsDomainValidationErrors = false, })); } }
protected void EducationalDetailsSave_Click(object sender, EventArgs e) { try { EducationDetailsModel education = new EducationDetailsModel() { CourseType = CourseTypeTextBox.Text, CourseSpecialisation = CourseTypeTextBox.Text, YearOfPass = Convert.ToInt32(YearOfPassTextBox.Text), }; EducationDataAccess educationdata = new EducationDataAccess(); string edsave = educationdata.SaveEducation(education); if (edsave.Equals("success")) { Response.Write("<script>alert('Details have been saved successfully!');</script>"); } } catch (Exception ex) { //MessageBox.Show("Please enter the values: " + ex.Message); Response.Write("<script>alert('Please enter the values!" + ex.Message + "');</script>"); } }
protected void EducationalDetailsEdit_Click(object sender, EventArgs e) { try { EducationDetailsModel edmodel = new EducationDetailsModel() { CourseType = CourseTypeTextBox.Text, EmployeeID = Convert.ToInt32(EmployeeIDDropDownList.SelectedValue), CourseSpecialisation = CourseSpecialisationTextBox.Text, YearOfPass = Convert.ToInt32(YearOfPassTextBox.Text), }; EducationDataAccess cmpaccess = new EducationDataAccess(); string ededit = cmpaccess.Editeducation(edmodel); if (ededit.Equals("success")) { Response.Write("<script>alert('Details have been updated successfully!');</script>"); } } catch (Exception ex) { //MessageBox.Show("Please enter the values: " + ex.Message); Response.Write("<script>alert('Please enter the values!" + ex.Message + "');</script>"); } }