public async Task <IHttpActionResult> GetUserName(MessageToCompany Model)
{
//List<User> user = db.Users.ToList();
var user = db.Users.Where(c => c.Id == Model.UserId);
return(Ok(user.Select(c => new UserProfileDTO()
{
FirstName = c.FirstName, LastName = c.LastName, ID = c.Id
})));
}
//[ResponseType(typeof(CompanySocialMediaLinksDTO))]
public async Task <IHttpActionResult> MessageToCompany(CompanyMessage companymessage)
{
string userName = User.Identity.Name;
User authenticatedUser = db.Users.Where(_user => _user.UserName == userName).SingleOrDefault();
if (authenticatedUser == null)
{
throw new HttpResponseException(HttpStatusCode.Unauthorized);
}
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
Company company = db.Companies.Find(companymessage.CompanyId);
if (company == null)
{
throw new HttpResponseException(HttpStatusCode.NotFound);
}
MessageToCompany MessageObj = new MessageToCompany();
MessageObj.CompanyId = companymessage.CompanyId;
MessageObj.Message = companymessage.Message;
MessageObj.Date = DateTime.Now;
MessageObj.LinkUrl = companymessage.LinkUrl;
MessageObj.Image = companymessage.Image;
MessageObj.UserId = authenticatedUser.Id;
db.MessageToCompanies.Add(MessageObj);
try
{
db.SaveChanges();
}
catch (Exception e)
{
}
return(Ok());
}
public async Task <IHttpActionResult> GetCompanyMessage(MessageToCompany Company)
{
string userName = User.Identity.Name;
User authenticatedUser = db.Users.Where(_user => _user.UserName == userName).SingleOrDefault();
if (authenticatedUser == null)
{
throw new HttpResponseException(HttpStatusCode.Unauthorized);
}
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
Company company = db.Companies.Find(Company.CompanyId);
if (company == null)
{
throw new HttpResponseException(HttpStatusCode.NotFound);
}
try
{
//var Messages = db.MessageToCompanies.ToList().Where(c=>c.CompanyId == Company.CompanyId).OrderByDescending(c=> c.MessageId);
var query = (from p in db.MessageToCompanies
join s in db.Users on p.UserId equals s.Id where s.Id == p.UserId && p.CompanyId == Company.CompanyId
select new { s.FirstName, s.LastName, p.UserId, p.MessageId, p.LinkUrl, p.Image, p.Message, p.Date, p.CompanyId }).OrderByDescending(c => c.MessageId);
//select new
//{
// ContactNo = to == null ? String.Empty : to.Table1.ContactNo
//};
//var result = new { Messages, userName };
return(Ok(query));
}
catch (Exception e) {
return(Ok());
}
}
