public HttpResponseMessage UpdateFQuestion(FQuestion_Model _obj) { try { int id = obj.Save_Update_Delete_FQuestion(_obj); if (id > 0) { return(Request.CreateResponse(HttpStatusCode.OK, id)); } else { return(Request.CreateResponse(HttpStatusCode.MultipleChoices, "FQuestion already exists")); } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public HttpResponseMessage DeleteFQuestion(FQuestion_Model _obj) { try { int id = obj.Save_Update_Delete_FQuestion(_obj); if (id > 0) { return(Request.CreateResponse(HttpStatusCode.OK, id)); } else { return(Request.CreateResponse(HttpStatusCode.NotFound, "FQuestion not found.")); } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public int Save_Update_Delete_FQuestion(FQuestion_Model _obj) { int id = 0; try { cmd = new SqlCommand("Fquestion", cmd.Connection); cmd.Connection = DbConnect.CreateConnection(); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@FQuestionId", _obj.FQuestionId); cmd.Parameters.AddWithValue("@FQuestion", _obj.FQuestion); cmd.Parameters.AddWithValue("@CreatedBy", SessionInfo.UserId); cmd.Parameters.AddWithValue("@Action", _obj.Action); cmd.Connection.Open(); id = Convert.ToInt32(cmd.ExecuteScalar()); cmd.Connection.Close(); return(id); } catch (Exception ex) { return(id); } }
public int Save_Update_Delete_FQuestion(FQuestion_Model _obj) { return(obj.Save_Update_Delete_FQuestion(_obj)); }