public DataTable GetUserTicket(string userEmailId, Guid ticketID)
{
var tableDataStore = new TableDataStore();
var amsEventTrackingEntity =
tableDataStore.Read <TicketAndTicketConversationRow>(
x => x.PartitionKey == userEmailId && x.RowKey == ticketID.ToString())
.FirstOrDefault();
return(ModelExtensions.GetDataTableFromObjects(new [] { amsEventTrackingEntity }));
}
public DataTable GetUserAllTickets(string userEmailId)
{
string query = "select * from Ticket where UserEmail = '" + userEmailId + "' Order by LastUpdate desc";
var tableDataStore = new TableDataStore();
var amsEventTrackingEntity =
tableDataStore.Read <TicketAndTicketConversationRow>(
x => x.PartitionKey == userEmailId)
.FirstOrDefault();
return(ModelExtensions.GetDataTableFromObjects(new[] { amsEventTrackingEntity }));
return(null);
}
public DataTable GetConversion(string userEmailId, Guid ticketId)
{
string query = "select * from TicketConversation where ticketId = '" + ticketId.ToString() + "' Order by insertDate";
// connection.Select(query);
// return new DataTable();
var tableDataStore = new TableDataStore();
var amsEventTrackingEntity =
tableDataStore.Read <TicketAndTicketConversationRow>(
x => x.PartitionKey == userEmailId && x.TicketId == ticketId && x.Kind == Kind.TicketConversation.ToString())
.FirstOrDefault();
return(ModelExtensions.GetDataTableFromObjects(new [] { amsEventTrackingEntity }));
}