private void updateStudentMark()
{
try
{
if (!txtStudentId.Text.Trim().Equals(string.Empty))
{
StudentMarkDTO oStudentMarkDTO = new StudentMarkDTO();
oStudentMarkDTO.StudentId = txtStudentId.Text.Trim();
oStudentMarkDTO.SubjectId = cmbSubject.SelectedValue.ToString();
oStudentMarkDTO.Marks = Convert.ToInt32(txtMarks.Text.Trim());
oStudentMarkDTO.ModifiedBy = "Kaveen";
oStudentMarkDTO.ModifiedDateTime = DateTime.Now;
if (oStudentMarkBL.UpdateStudentMark(oStudentMarkDTO))
{
ClearControls();
HandleControls(true);
LoadStudentmarks();
MessageBox.Show("Record updated successfully.!");
}
}
else
{
txtStudentId.Focus();
}
}
catch (Exception ex)
{
throw ex;
}
}
public bool InsertStudentMark(StudentMarkDTO oStudentMarkDTO)
{
bool result = false;
try
{
sb.Clear();
sb.Append("INSERT INTO [StudentMark]");
sb.Append(" VALUES (");
sb.Append(" ?StudentId,");
sb.Append(" ?SubjectId,");
sb.Append(" ?Marks,");
sb.Append(" ?CreatedBy,");
sb.Append(" ?CreatedDateTime,");
sb.Append(" ?ModifiedBy,");
sb.Append(" ?ModifiedDateTime");
sb.Append(" )");
using (CloudConnection connection = new CloudConnection(DMSSWE.Common.ConnectionString))
{
connection.CommandText = sb.ToString();
connection.Parameters.Clear();
connection.Parameters.Add(new Parameter {
Name = "StudentId", Value = oStudentMarkDTO.StudentId
});
connection.Parameters.Add(new Parameter {
Name = "SubjectId", Value = oStudentMarkDTO.SubjectId
});
connection.Parameters.Add(new Parameter {
Name = "Marks", Value = oStudentMarkDTO.Marks
});
connection.Parameters.Add(new Parameter {
Name = "CreatedBy", Value = oStudentMarkDTO.CreatedBy
});
connection.Parameters.Add(new Parameter {
Name = "CreatedDateTime", Value = oStudentMarkDTO.CreatedDateTime
});
connection.Parameters.Add(new Parameter {
Name = "ModifiedBy", Value = oStudentMarkDTO.ModifiedBy
});
connection.Parameters.Add(new Parameter {
Name = "ModifiedDateTime", Value = oStudentMarkDTO.ModifiedDateTime
});
if (connection.ExecuteQuery() > 0)
{
result = true;
}
}
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
public bool UpdateStudentMark(StudentMarkDTO oStudentMarkDTO)
{
bool result = false;
try
{
sb.Clear();
sb.Append("UPDATE [StudentMark]");
sb.Append(" SET");
sb.Append(" Marks=?Marks,");
sb.Append(" ModifiedBy=?ModifiedBy,");
sb.Append(" ModifiedDateTime=?ModifiedDateTime");
sb.Append(" WHERE StudentId=?StudentId AND SubjectId=?SubjectId");
using (CloudConnection connection = new CloudConnection(DMSSWE.Common.ConnectionString))
{
connection.CommandText = sb.ToString();
connection.Parameters.Clear();
connection.Parameters.Add(new Parameter {
Name = "StudentId", Value = oStudentMarkDTO.StudentId
});
connection.Parameters.Add(new Parameter {
Name = "SubjectId", Value = oStudentMarkDTO.SubjectId
});
connection.Parameters.Add(new Parameter {
Name = "Marks", Value = oStudentMarkDTO.Marks
});
connection.Parameters.Add(new Parameter {
Name = "ModifiedBy", Value = oStudentMarkDTO.ModifiedBy
});
connection.Parameters.Add(new Parameter {
Name = "ModifiedDateTime", Value = oStudentMarkDTO.ModifiedDateTime
});
if (connection.ExecuteQuery() > 0)
{
result = true;
}
}
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
private void CreateStudentMark()
{
try
{
if (!txtStudentId.Text.Trim().Equals(string.Empty))
{
if (!oStudentMarkBL.CheckAvailability(txtStudentId.Text.Trim(), cmbSubject.SelectedValue.ToString()))
{
StudentMarkDTO oStudentMarkDTO = new StudentMarkDTO();
oStudentMarkDTO.StudentId = txtStudentId.Text.Trim().ToUpper();
oStudentMarkDTO.SubjectId = cmbSubject.SelectedValue.ToString();
oStudentMarkDTO.Marks = Convert.ToInt32(txtMarks.Text.Trim());
oStudentMarkDTO.CreatedBy = "Kaveen";
oStudentMarkDTO.CreatedDateTime = DateTime.Now;
oStudentMarkDTO.ModifiedBy = "Kaveen";
oStudentMarkDTO.ModifiedDateTime = DateTime.Now;
if (oStudentMarkBL.InsertStudentMark(oStudentMarkDTO))
{
ClearControls();
LoadStudentmarks();
MessageBox.Show("Record inserted successfully.!");
}
}
else
{
txtStudentId.Clear();
txtStudentId.Focus();
MessageBox.Show("Record already exist.!");
}
}
else
{
txtStudentId.Focus();
}
}
catch (Exception ex)
{
throw ex;
}
}
public async Task <IActionResult> Add([FromBody] StudentMarkDTO request)
{
try
{
if (request == null)
{
return(StatusCode(StatusCodes.Status400BadRequest, new ApiResponse {
message = "invalid payload."
}));
}
if (string.IsNullOrWhiteSpace(request.FirstName))
{
return(StatusCode(StatusCodes.Status400BadRequest, new ApiResponse {
message = "`FirstName` is mandatory."
}));
}
request.FirstName = request.FirstName.Trim();
if (string.IsNullOrWhiteSpace(request.LastName))
{
return(StatusCode(StatusCodes.Status400BadRequest, new ApiResponse {
message = "`LastName` is mandatory."
}));
}
request.LastName = request.LastName.Trim();
if (request.Class == 0)
{
return(StatusCode(StatusCodes.Status400BadRequest, new ApiResponse {
message = "`Class` is mandatory."
}));
}
if (await _DbContext.tbl_Students.AnyAsync(x => x.FirstName == request.FirstName && x.LastName == request.LastName && x.Class == request.Class))
{
return(StatusCode(StatusCodes.Status400BadRequest, new ApiResponse {
message = "Student with same details already exists."
}));
}
var newRecord = new tbl_Student {
FirstName = request.FirstName, LastName = request.LastName, Class = request.Class
};
await _DbContext.tbl_Students.AddAsync(newRecord);
await _DbContext.SaveChangesAsync();
return(StatusCode(StatusCodes.Status200OK, new ApiResponse {
success = true, message = "success", data = newRecord
}));
}
catch (Exception ex)
{
return(StatusCode(StatusCodes.Status500InternalServerError, new ApiResponse {
message = "unexpected error", data = ex.Message
}));
}
}
