public string UpdateMessages(Messages objMessage)
{
string messages = string.Empty;
using (var connection = new SqlConnection(_connString))
{
connection.Open();
using (var command = new SqlCommand("sp_Update_Messages", connection))
{
command.Notification = null;
var dependency = new SqlDependency(command);
dependency.OnChange += new OnChangeEventHandler(dependency_OnChange);
SignleRUOW <Messages> objSigMessage = new SignleRUOW <Messages>();
objSigMessage.Add(objMessage);
objSigMessage.Committ();
if (objMessage.Status1 == "Success")
{
messages = "Success";
MessagesHub.UpdateStatus(objMessage.ID, "Updated");
}
else
{
messages = "Failed";
}
}
}
return(messages);
}
public JsonResult DeleteUser(int GridId)
{
MessagesRepository _messageRepository = new MessagesRepository();
string msgReturn = _messageRepository.DeleteMessages(GridId);
string msgName = "deleted Record";
MessagesHub.UpdateStatus(GridId, msgName);
var data = msgReturn;
return(Json(new { data }, JsonRequestBehavior.AllowGet));
}
public Messages GetAllMessagesByID(int Id)
{
var messages = new Messages();
using (var connection = new SqlConnection(_connString))
{
connection.Open();
using (var command = new SqlCommand("sp_select_All_By_Id", connection))
{
command.Notification = null;
var dependency = new SqlDependency(command);
dependency.OnChange += new OnChangeEventHandler(dependency_OnChange);
if (connection.State == ConnectionState.Closed)
{
connection.Open();
}
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@Id", Id);
var reader = command.ExecuteReader();
//messages.Add(item: new Messages { ID = (int)reader["ID"], CampaignName = (string)reader["CampaignName"], MessageDate = Convert.ToDateTime(reader["Date"]), Clicks = (int)reader["Clicks"], Conversions = (int)reader["Conversions"], Impressions = (int)reader["Impressions"], AffiliateName = (string)reader["AffiliateName"] });
while (reader.Read())
{
messages.ID = (int)reader["ID"];
messages.CampaignName = (string)reader["CampaignName"];
messages.MessageDate = Convert.ToDateTime(reader["Date"]);
messages.Clicks = (int)reader["Clicks"];
messages.Impressions = (int)reader["Impressions"];
messages.Conversions = (int)reader["Conversions"];
messages.AffiliateName = (string)reader["AffiliateName"];
MessagesHub.UpdateStatus(messages.ID, "Editing");
}
}
}
return(messages);
}