Ejemplo n.º 1
0
        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);
        }
Ejemplo n.º 2
0
        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);
        }