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>");
}
}
