public JsonResult Post(Rolet roli)
{
string query = @"
insert into Roli values
('" + roli.Roli + @"')
";
DataTable table = new DataTable();
string sqlDataSource = _configuration.GetConnectionString("ElavingApp");
SqlDataReader myReader;
using (SqlConnection myCon = new SqlConnection(sqlDataSource))
{
myCon.Open();
using (SqlCommand myCommand = new SqlCommand(query, myCon))
{
myReader = myCommand.ExecuteReader();
table.Load(myReader);;
myReader.Close();
myCon.Close();
}
}
return(new JsonResult("Added Successfully"));
}
public JsonResult Put(Rolet rol)
{
string query = @"
update Roli set
Roli = '" + rol.Roli + @"'
where Id = " + rol.Id + @"
";
DataTable table = new DataTable();
string sqlDataSource = _configuration.GetConnectionString("ElavingApp");
SqlDataReader myReader;
using (SqlConnection myCon = new SqlConnection(sqlDataSource))
{
myCon.Open();
using (SqlCommand myCommand = new SqlCommand(query, myCon))
{
myReader = myCommand.ExecuteReader();
table.Load(myReader);;
myReader.Close();
myCon.Close();
}
}
return(new JsonResult("Updated Successfully"));
}
public async Task <IActionResult> Details(int?id)
{
if (id == null)
{
ModelState.AddModelError(string.Empty, "There was an error while getting user!");
}
Users user = new Users();
using (var httpClient = new HttpClient())
{
user = await GetAPI.GetUserAsync(httpClient, id);
Rolet rolet = await GetAPI.GetRoletAsync(httpClient, id);
user.Role = rolet;
}
if (user == null)
{
ModelState.AddModelError(string.Empty, "There was an error while getting user!");
}
return(View(user));
}
public async Task <IActionResult> Create(Rolet rolet)
{
if (ModelState.IsValid)
{
Rolet receivedRolet = new Rolet();
using (var httpClient = new HttpClient())
{
StringContent content = new StringContent(JsonConvert.SerializeObject(rolet), Encoding.UTF8, "application/json");
using var response = await httpClient.PostAsync(getApi, content);
string apiResponse = await response.Content.ReadAsStringAsync();
receivedRolet = JsonConvert.DeserializeObject <Rolet>(apiResponse);
string success = response.StatusCode.ToString();
if (success == "Created")
{
return(RedirectToAction(nameof(Index)));
}
else
{
ModelState.AddModelError(string.Empty, "Ka ndodhur nje gabim gjate regjistrimit te rolit!");
}
}
return(View(receivedRolet));
}
else
{
ModelState.AddModelError(string.Empty, "Plotesoni te gjitha fushat!");
}
return(RedirectToAction(nameof(Index)));
}
public async Task <IActionResult> EditForm(int id)
{
Rolet rolet = new Rolet();
using (var httpClient = new HttpClient())
{
rolet = await GetAPI.GetRoletAsync(httpClient, id);
}
return(View(rolet));
}
public async Task <IActionResult> Details(int?id)
{
if (id == null)
{
ModelState.AddModelError(string.Empty, "Ka ndodhur nje gabim gjate marrjes te rolit!");
}
Rolet rolet = new Rolet();
using (var httpClient = new HttpClient())
{
rolet = await GetAPI.GetRoletAsync(httpClient, id);
}
if (rolet == null)
{
ModelState.AddModelError(string.Empty, "Ka ndodhur nje gabim gjate marrjes te rolit!");
}
return(View(rolet));
}
public async Task <IActionResult> Edit(Rolet rolet)
{
if (ModelState.IsValid)
{
using (var httpClient = new HttpClient())
{
using var response = await httpClient.PutAsJsonAsync <Rolet>(getApi + "/" + rolet.RoletId, rolet);
if (response.IsSuccessStatusCode)
{
ViewBag.Result = "Success";
return(RedirectToAction(nameof(Index)));
}
}
}
else
{
ModelState.AddModelError(string.Empty, "Plotesoni te gjitha fushat!");
}
return(NotFound());
}
