public ActionResult AddSuggestion(string prescriptionId, string content)
{
var prescriptionRow = db.DoctorPrescriptions.Find(Convert.ToInt32(prescriptionId));
if (prescriptionRow != null)
{
prescriptionRow.DoctorSuggestions = content;
db.Entry(prescriptionRow).State = EntityState.Modified;
var rowAffected = db.SaveChanges();
if (rowAffected > 0)
{
return(Content("Update SuccessFull"));
}
}
return(null);
}
public string SetPersonalRating(string drugRating, int drugId, User user, SocialUser socialUser)
{
string message = "";
if (user != null)
{
string rating = drugRating;
int userId = user.Id;
int brandId = drugId;
if (user.OccupationsId == 1)
{
var rate = db.DrugsRatings.SingleOrDefault(c => c.UserId == userId && c.BrandId == brandId);
if (rate != null)
{
rate.ProfessionalRatting = Convert.ToInt32(rating);
db.Entry(rate).State = EntityState.Modified;
var rowAffected = db.SaveChanges();
if (rowAffected > 0)
{
message = "Save Successfull";
}
}
else
{
DrugsRating drugsRating = new DrugsRating()
{
UserId = userId,
BrandId = brandId,
ProfessionalRatting = Convert.ToInt32(rating)
};
db.DrugsRatings.Add(drugsRating);
var rowAffected = db.SaveChanges();
if (rowAffected > 0)
{
message = "Save Successfull";
}
}
}
else if (user.OccupationsId == 2)
{
var rate = db.DrugsRatings.SingleOrDefault(c => c.UserId == userId && c.BrandId == brandId);
if (rate != null)
{
rate.UserRatting = Convert.ToInt32(rating);
db.Entry(rate).State = EntityState.Modified;
var rowAffected = db.SaveChanges();
if (rowAffected > 0)
{
message = "Save Successfull";
}
}
else
{
DrugsRating drugsRating = new DrugsRating()
{
UserId = userId,
BrandId = brandId,
UserRatting = Convert.ToInt32(rating)
};
db.DrugsRatings.Add(drugsRating);
var rowAffected = db.SaveChanges();
if (rowAffected > 0)
{
message = "Save Successfull";
}
}
}
}
else if (socialUser != null)
{
string rating = drugRating;
int socialUserId = socialUser.Id;
int brandId = drugId;
var rate = db.DrugsRatings.SingleOrDefault(c => c.SocialUserId == socialUserId && c.BrandId == brandId);
if (rate != null)
{
rate.UserRatting = Convert.ToInt32(rating);
db.Entry(rate).State = EntityState.Modified;
var rowAffected = db.SaveChanges();
if (rowAffected > 0)
{
message = "Save Successfull";
}
}
else
{
DrugsRating drugsRating = new DrugsRating()
{
SocialUserId = socialUserId,
BrandId = brandId,
UserRatting = Convert.ToInt32(rating)
};
db.DrugsRatings.Add(drugsRating);
var rowAffected = db.SaveChanges();
if (rowAffected > 0)
{
message = "Save Successfull";
}
}
}
return(message);
}
