public List <User> EditDntType(DntType dnt) { List <User> users = new List <User>(); using (SqlConnection con = new SqlConnection(connectionString)) { SqlCommand cmd = new SqlCommand("Update_DntType", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Id", dnt.Id); cmd.Parameters.AddWithValue("@Description", dnt.Description); con.Open(); //cmd.ExecuteNonQuery(); SqlDataReader rdr = cmd.ExecuteReader(); //while (rdr.Read()) //{ // User user = new User(); // user.Id = Convert.ToInt32(rdr["Id"].ToString()); // user.FirstName = rdr["FirstName"].ToString(); // user.LastName = rdr["LastName"].ToString(); // user.Email = rdr["Email"].ToString(); // user.RegNo = rdr["RegNo"].ToString(); // user.UserType = Convert.ToInt32(rdr["UserType"].ToString()); // user.Type = rdr["Type"].ToString(); // users.Add(user); //} con.Close(); } return(users); }
public bool AddDntType(DntType dnt) { bool cookie = true; using (SqlConnection con = new SqlConnection(connectionString)) { SqlCommand cmd = new SqlCommand("Insert_DntType", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Description", dnt.Description); con.Open(); cmd.ExecuteNonQuery(); con.Close(); } return(cookie); }
public ResponseResult <Cookie> addDntType([FromBody] DntType dnt) { ResponseResult <Cookie> result = new ResponseResult <Cookie>(); try { UserService userService = new UserService(); userService.AddDntType(dnt); result.IsSuccess = true; } catch (Exception e) { result.IsSuccess = false; result.Message = e.Message; } return(result); }
public List <DntType> GetDntTypes() { List <DntType> dnts = new List <DntType>(); using (SqlConnection con = new SqlConnection(connectionString)) { SqlCommand cmd = new SqlCommand("Get_DntTypes", con); cmd.CommandType = CommandType.StoredProcedure; con.Open(); //cmd.ExecuteNonQuery(); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { DntType dnt = new DntType(); dnt.Id = Convert.ToInt32(rdr["Id"].ToString()); dnt.Description = rdr["Description"].ToString(); dnts.Add(dnt); } con.Close(); } return(dnts); }