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);
}
