public bool SaveStudent(SaveStudentDTO obj) { bool res = false; obj.CreatedBy = "1001"; SqlCommand cmd = new SqlCommand("sp_SaveStudent"); cmd.CommandType = CommandType.StoredProcedure; 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.CreatedBy); int result = new DBlayer().ExecuteNonQuery(cmd); if (result != Int32.MaxValue) { res = true; } return(res); }
public HttpResponseMessage SaveStudent(SaveStudentDTO obj) { HttpResponseMessage message; try { StudentDAL dal = new StudentDAL(); var dynobj = new { result = dal.SaveStudent(obj) }; message = Request.CreateResponse(HttpStatusCode.OK, dynobj); } catch (Exception ex) { message = Request.CreateResponse(HttpStatusCode.BadRequest, new { msgText = "something Wrong.Try Again!" }); } return(message); }