public ActionResult Insert(t_empresa model)
{
madrigaldev_testEntities context = new madrigaldev_testEntities();
var added = context.t_empresa.Add(model);
context.SaveChanges();
CustomerHub.BroadcastData();
return(View("Insert"));
}
void sqlDep_OnChange(object sender, SqlNotificationEventArgs e)
{
//or you can also check => if (e.Info == SqlNotificationInfo.Insert) , if you want notification only for inserted record
if (e.Type == SqlNotificationType.Change)
{
SqlDependency sqlDep = sender as SqlDependency;
sqlDep.OnChange -= sqlDep_OnChange;
//from here we will send notification message to client
var notificationHub = GlobalHost.ConnectionManager.GetHubContext <CustomerHub>();
notificationHub.Clients.All.notify("added");
CustomerHub.BroadcastData();
//re-register notification
RegisterNotification(DateTime.Now);
}
}
public ActionResult Delete(int id)
{
int result = 0;
try
{
object[] parameters = { id };
result = objCust.Delete(parameters);
if (result == 1)
{
//Notify to all
CustomerHub.BroadcastData();
}
}
catch { }
return(View("Index"));
}
public ActionResult Update(Customer model)
{
int result = 0;
try
{
object[] parameters = { model.Id, model.CustName, model.CustEmail };
result = objCust.Update(parameters);
if (result == 1)
{
//Notify to all
CustomerHub.BroadcastData();
}
}
catch { }
return(View("Index"));
}
public ActionResult Insert(CustomerDTO model)
{
//int result = 0;
//try
//{
// if (ModelState.IsValid)
// {
// object[] parameters = { model.CustName, model.CustEmail };
// result = objCust.Insert(parameters);
// if (result == 1)
// {
// //Notify to all
// CustomerHub.BroadcastData();
// }
// }
//}
//catch { }
//return View("Index");
using (var client = new HttpClient())
{
client.BaseAddress = new Uri("http://localhost:56775/api/customer");
var postTask = client.PostAsJsonAsync <CustomerDTO>("customer", model);
postTask.Wait();
var postResult = postTask.Result;
if (postResult.IsSuccessStatusCode)
{
CustomerHub.BroadcastData();
}
}
ModelState.AddModelError(string.Empty, "Server Error. Please contact administrator.");
Customer cus = new Customer()
{
Id = model.Id,
CustName = model.CustName,
CustEmail = model.CustEmail
};
return(View(cus));
}
public ActionResult Insert(Customer model)
{
int result = 0;
try
{
if (ModelState.IsValid)
{
object[] parameters = { model.CustName, model.CustEmail };
result = objCust.Insert(parameters);
if (result == 1)
{
//Notify to all
CustomerHub.BroadcastData();
}
}
}
catch { }
return(View("Index"));
}