public bool ModifyStudent(ModifyStudentDTO obj) { bool res = false; obj.ModifiedBy = "1002"; SqlCommand cmd = new SqlCommand("sp_ModifyStudent"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@P_StudentId", obj.StudentId); cmd.Parameters.AddWithValue("@p_Name", obj.Name); cmd.Parameters.AddWithValue("@p_Dob", obj.Dob); cmd.Parameters.AddWithValue("@P_DepartmentId", obj.DepartmentId); cmd.Parameters.AddWithValue("@P_ClassId", obj.ClassId); cmd.Parameters.AddWithValue("@P_SectionId", obj.SectionId); cmd.Parameters.AddWithValue("@P_Email", obj.Email); cmd.Parameters.AddWithValue("@P_Mobile", obj.Mobile); cmd.Parameters.AddWithValue("@P_Address", obj.Address); cmd.Parameters.AddWithValue("@p_ActionBy", obj.ModifiedBy); int result = new DBlayer().ExecuteNonQuery(cmd); if (result != Int32.MaxValue) { res = true; } return(res); }
public async Task <IActionResult> CreateSource([FromBody] ModifyStudentDTO source) { try { if (source == null) { return(BadRequest()); } if (!ModelState.IsValid) { return(BadRequest("Invalid model object")); } var sourceEntity = _mapper.Map <Student>(source); return(Ok(await _repositoryWrapper.StudentRepo.NewData(sourceEntity))); } catch (Exception ex) { //_logger.LogError($"Something went wrong inside CreateSources action: {ex.Message}"); if (ex.InnerException != null) { return(BadRequest(ex.Message + "," + ex.InnerException.Message)); } return(BadRequest(ex.Message)); } }
public HttpResponseMessage ModifyStudent(ModifyStudentDTO obj) { HttpResponseMessage message; try { StudentDAL dal = new StudentDAL(); var dynobj = new { result = dal.ModifyStudent(obj) }; message = Request.CreateResponse(HttpStatusCode.OK, dynobj); } catch (Exception ex) { message = Request.CreateResponse(HttpStatusCode.BadRequest, new { msgText = "something Wrong.Try Again!" }); } return(message); }