public void Update(ContactsRole item)
{
SqlConnectionStringBuilder conn = Connections.connectToDB();
bool isAdmin = GetRoledetails(item.CONTACTID);
if (isAdmin)
{
using (var connection = new SqlConnection(conn.ConnectionString))
{
string search = "select * from contacts where ContactId=@ContactId";
connection.Open();
SqlCommand cmd = new SqlCommand(search, connection);
cmd.Parameters.AddWithValue("@contactId", item.CONTACTID);
if (cmd.ExecuteReader().Read())
{
int contactId = item.CONTACTID;
string contactRole = item.CONTACTROLE;
string update = "UPDATE dbo.ContactRole SET ContactRole =@contactRole WHERE Contactid=@contactId';";
SqlCommand command = new SqlCommand(update, connection);
command.Parameters.AddWithValue("@contactId", item.CONTACTID);
command.Parameters.AddWithValue("@contactRole", item.CONTACTROLE);
command.ExecuteReader();
connection.Close();
}
}
}
}
public void Add(ContactsRole item)
{
SqlConnectionStringBuilder conn = Connections.connectToDB();
//bool isAdmin = GetRoledetails(item.CONTACTID);
//if (isAdmin)
//{
using (var connection = new SqlConnection(conn.ConnectionString))
{
//Search if a contact with provided ID exists in db or not if exists update Contact Role else terminate with status code 404.
string search = "select * from contacts where ContactId=@ContactId";
connection.Open();
SqlCommand cmd = new SqlCommand(search, connection);
cmd.Parameters.AddWithValue("@contactId", item.CONTACTID);
// cmd.ExecuteReader();
while (cmd.ExecuteReader().Read())
{
String query = "INSERT INTO dbo.ContactRole (ContactId, ContactRole) VALUES ('" + Convert.ToInt32(item.CONTACTID)
+ "','" + item.CONTACTROLE.ToString()
+ "');";
SqlCommand cmd1 = new SqlCommand(query, connection);
cmd1.ExecuteNonQuery();
connection.Close();
}
if (!cmd.ExecuteReader().Read())
{
//return HttpStatusCode.NotFound;
}
}
// }
}
public IActionResult Create([FromBody] ContactsRole item)
{
if (item == null)
{
return(BadRequest());
}
ContactsRoleRepo.Add(item);
return(CreatedAtRoute("GetContactsRole", new { Controller = "ContactsRoleController", id = item.CONTACTID }, item));
}
public IActionResult Create([FromBody] Contacts item)
{
if (item == null)
{
return(BadRequest());
}
string contactId = ContactsRepo.Add(item);
if (!string.IsNullOrEmpty(contactId))
{
ContactsRole cr = new ContactsRole();
cr.CONTACTID = int.Parse(contactId);
cr.CONTACTROLE = item.ROLE;
string contactroleURI = "https://onlineshoppingcontactsapi.azurewebsites.net/api/ContactsRole";//"http://localhost:5000/api/ContactsRole" ;
var response1 = string.Empty;
HttpContent c = new StringContent(JsonConvert.SerializeObject(cr), Encoding.UTF8, "application/json");
using (var client = new HttpClient())
{
HttpRequestMessage request = new HttpRequestMessage
{
Method = HttpMethod.Post,
RequestUri = new Uri(contactroleURI),
Content = c
};
HttpResponseMessage result = client.SendAsync(request).Result;
if (result.IsSuccessStatusCode)
{
string responsereceived = result.StatusCode.ToString();
}
}
}
CreatedAtRoute("GetContacts", new { Controller = "Contacts", id = item.CONTACTID }, item);
return(CreatedAtRoute("GetContacts", new { Controller = "Contacts", id = item.CONTACTID }, item));
}
public void Update(ContactsRole item)
{
ContactsRoleRepository conRep = new ContactsRoleRepository();
Update(item);
}
