private void button3_Click(object sender, EventArgs e)
{
string type = "none";
string followVisit = "none";
string followPhone = "none";
type = (typePhoneChk.Checked) ? "Phone" : "Visit";
type = (typeVisitChk.Checked) ? "Visit" : "Phone";
followVisit = (visitChk.Checked) ? "Yes" : "No";
followPhone = (phoneChk.Checked) ? "Yes" : "No";
string id = Guid.NewGuid().ToString();
Follow i = new Follow(FollowID, CustomerID, UserID, ItemID, type, diagnosisTxt.Text, hospitalTxt.Text, sourceTxt.Text, lengthTxt.Text, needTxt.Text, goalTxt.Text, resultTxt.Text, "", followVisit, followPhone, nextTxt.Text, puTxt.Text, authSignatureTxt.Text, authoriserTxt.Text, relationTxt.Text, reasonTxt.Text, DateTime.Now.ToString("dd-MM-yyyy H:m:s"), "false", Helper.CompanyID);
if (MySQL.Insert(i) != "")
{
foreach (ItemReview t in GenericCollection.itemReviews)
{
ItemReview c = new ItemReview(t.Id, FollowID, t.Title, t.Status, t.Status, t.Created, "false", Helper.CompanyID);
MySQL.Insert(c);
}
foreach (ItemStatus t in GenericCollection.itemStatus)
{
ItemStatus c = new ItemStatus(t.Id, FollowID, t.Title, t.Status, t.Status, t.Created, "false", Helper.CompanyID);
MySQL.Insert(c);
}
foreach (PatientStatus t in GenericCollection.patientStatus)
{
PatientStatus c = new PatientStatus(t.Id, FollowID, t.Title, t.Status, t.Status, t.Created, "false", Helper.CompanyID);
MySQL.Insert(c);
}
MessageBox.Show("Information Saved");
this.Close();
}
}
public ActionResult PushReview(int itemId, string title, int rating, string text)
{
var userId = User.Identity.GetUserId().ToString();
var customer = _context.Customers.SingleOrDefault(c => c.ApplicationUserId == userId);
var item = _context.Items.SingleOrDefault(i => i.Id == itemId);
var itemReview = _context.ItemReviews.SingleOrDefault(ir => ir.ItemId == itemId && ir.CustomerId == customer.Id);
if (itemReview == null)
{
itemReview = new ItemReview();
itemReview.CustomerId = customer.Id;
itemReview.ItemId = itemId;
itemReview.Title = title;
itemReview.Note = rating;
itemReview.Text = text;
itemReview.Date = DateTime.Now;
_context.ItemReviews.Add(itemReview);
}
else
{
itemReview.Note = rating;
itemReview.Text = text;
itemReview.Title = title;
itemReview.Date = DateTime.Now;
}
_context.SaveChanges();
var rates = _context.ItemReviews.Where(r => r.ItemId == item.Id).Select(r => r.Note).ToArray();
item.AverageRating = (decimal)rates.Sum() / rates.Count();
_context.SaveChanges();
return(RedirectToAction(item.LinkName, "Item"));
}
public async Task <IActionResult> Edit(int id, [Bind("ItemReviewId,Comments,Rate")] ItemReview itemReview)
{
if (id != itemReview.ItemReviewId)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(itemReview);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!ItemReviewExists(itemReview.ItemReviewId))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(itemReview));
}
private void LoadEdit(string id)
{
FollowID = id;
o = new Follow();//.Select(UsersID);
o = Follow.Select(id);
CustomerID = o.CustomerID;
customerCbx.Text = CustomerDictionary.First(e => e.Value == o.CustomerID).Key;
customerCbx_SelectedIndexChanged(null, null);
UserID = o.UserID;
userCbx.Text = UserDictionary.First(e => e.Value == o.UserID).Key;
userCbx_SelectedIndexChanged(null, null);
ItemID = o.ItemID;
productCbx.Text = ProductDictionary.First(e => e.Value == o.ItemID).Key;
productCbx_SelectedIndexChanged(null, null);
typePhoneChk.Checked = (o.Type == "Phone") ? true : false;
typeVisitChk.Checked = (o.Type == "Visit") ? true : false;
diagnosisTxt.Text = o.Diagnosis;
hospitalTxt.Text = o.Hospitalisation;
sourceTxt.Text = o.Source;
foreach (ItemReview i in Model.ItemReview.List(o.Id))
{
ItemReview t = new ItemReview(id, i.FollowID, i.Title, i.Status, i.Details, DateTime.Now.ToString("dd-MM-yyyy H:m:s"), "false", Helper.CompanyID);
GenericCollection.itemReviews.Add(t);
}
LoadItemReview();
foreach (ItemStatus i in Model.ItemStatus.List(o.Id))
{
ItemStatus t = new ItemStatus(id, i.FollowID, i.Title, i.Status, i.Details, DateTime.Now.ToString("dd-MM-yyyy H:m:s"), "false", Helper.CompanyID);
GenericCollection.itemStatus.Add(t);
}
LoadItemStatus();
foreach (PatientStatus i in Model.PatientStatus.List(o.Id))
{
PatientStatus t = new PatientStatus(id, i.FollowID, i.Title, i.Status, i.Details, DateTime.Now.ToString("dd-MM-yyyy H:m:s"), "false", Helper.CompanyID);
GenericCollection.patientStatus.Add(t);
}
LoadPatientStatus();
lengthTxt.Text = o.Length;
needTxt.Text = o.Need;
goalTxt.Text = o.Goal;
resultTxt.Text = o.Results;
visitChk.Checked = (o.FollowVisit == "Yes") ? true : false;
phoneChk.Checked = (o.FollowPhone == "Yes") ? true : false;
nextTxt.Text = o.Next;
puTxt.Text = o.Pu;
authoriserTxt.Text = o.Authoriser;
employeeTxt.Text = o.Signature;
reasonTxt.Text = o.Reason;
authSignatureTxt.Text = o.Authoriser;
}
private void button3_Click(object sender, EventArgs e)
{
if (currentDialog == "ItemReview")
{
if (Helper.ItemReview.ContainsKey(detailsCbx.Text + ":" + detailsTxt.Text))
{
MessageBox.Show("Selection exists !");
return;
}
if (stateCbx.Text == "Yes")
{
Helper.ItemReview.Add(detailsCbx.Text + ":" + detailsTxt.Text, true);
}
if (stateCbx.Text == "No")
{
Helper.ItemReview.Add(detailsCbx.Text + ":" + detailsTxt.Text, false);
}
string id = Guid.NewGuid().ToString();
ItemReview t = new ItemReview(id, FollowID, detailsCbx.Text, stateCbx.Text, detailsTxt.Text, DateTime.Now.ToString("dd-MM-yyyy H:m:s"), "false", Helper.CompanyID);
GenericCollection.itemReviews.Add(t);
this.DialogResult = DialogResult.OK;
this.Dispose();
return;
}
if (currentDialog == "PatientStatus")
{
if (Helper.PatientStatus.ContainsKey(detailsCbx.Text + ":" + detailsTxt.Text))
{
MessageBox.Show("Selection exists !");
return;
}
Helper.PatientStatus.Add(detailsCbx.Text + ":" + detailsTxt.Text, stateCbx.Text);
string id = Guid.NewGuid().ToString();
PatientStatus t = new PatientStatus(id, FollowID, detailsCbx.Text, stateCbx.Text, detailsTxt.Text, DateTime.Now.ToString("dd-MM-yyyy H:m:s"), "false", Helper.CompanyID);
GenericCollection.patientStatus.Add(t);
this.DialogResult = DialogResult.OK;
this.Dispose();
return;
}
if (currentDialog == "ItemSetting")
{
if (Helper.ItemSetting.ContainsKey(detailsCbx.Text + ":" + detailsTxt.Text))
{
MessageBox.Show("Selection exists !");
return;
}
Helper.ItemSetting.Add(detailsCbx.Text + ":" + detailsTxt.Text, stateCbx.Text);
string id = Guid.NewGuid().ToString();
ItemStatus t = new ItemStatus(id, FollowID, detailsCbx.Text, stateCbx.Text, detailsTxt.Text, DateTime.Now.ToString("dd-MM-yyyy H:m:s"), "false", Helper.CompanyID);
GenericCollection.itemStatus.Add(t);
this.DialogResult = DialogResult.OK;
this.Dispose();
return;
}
}
public async Task <IActionResult> Create([Bind("ItemReviewId,Comments,Rate")] ItemReview itemReview)
{
if (ModelState.IsValid)
{
_context.Add(itemReview);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(itemReview));
}
public IHttpActionResult PostItemReview(ItemReview itemreview)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.ItemReviews.Add(itemreview);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = itemreview.ID }, itemreview));
}
public static void ItemStatuses()
{
q = ItemStatus.ListUpload("SELECT * FROM productStatus ");
AdvancedForm._Form1.FeedBack("Uploading product status... " + q.Count);
foreach (var h in q)
{
string Query = "DELETE from productStatus WHERE id ='" + h.Id + "'";
MySQL.Query(Query);
ItemStatus p = new ItemStatus(h.Id, h.FollowID, h.Title, h.Status, h.Details, DateTime.Now.ToString("dd-MM-yyyy H:m:s"), "true", Helper.CompanyID);
if (MySQL.Insert(p) != "")
{
AdvancedForm._Form1.FeedBack("Uploading ... " + h.Details.ToString());
ItemReview u = new ItemReview(h.Id, h.FollowID, h.Title, h.Status, h.Details, DateTime.Now.ToString("dd-MM-yyyy H:m:s"), "true", Helper.CompanyID);
DBConnect.UpdateMySql(u, h.Id);
AdvancedForm._Form1.FeedBack("Updating .. " + h.Details.ToString());
}
}
AdvancedForm._Form1.FeedBack("Uploading product status Complete");
}
public static void ItemReviews()
{
w = ItemReview.ListOnline("SELECT * FROM itemReview WHERE companyID ='" + Helper.CompanyID + "' ");
ProcessWindow._Form1.FeedBack("Downloading product reviews... " + w.Count);
foreach (var h in w)
{
string Query = "DELETE from itemReview WHERE id ='" + h.Id + "'";
MySQL.Query(Query);
ItemReview p = new ItemReview(h.Id, h.FollowID, h.Title, h.Status, h.Details, DateTime.Now.ToString("dd-MM-yyyy H:m:s"), "true", Helper.CompanyID);
if (MySQL.Insert(p) != "")
{
ProcessWindow._Form1.FeedBack("Downloading ... " + h.Details.ToString());
ItemReview u = new ItemReview(h.Id, h.FollowID, h.Title, h.Status, h.Details, DateTime.Now.ToString("dd-MM-yyyy H:m:s"), "true", Helper.CompanyID);
DBConnect.UpdateMySql(u, h.Id);
ProcessWindow._Form1.FeedBack("Updating .. " + h.Details.ToString());
}
}
ProcessWindow._Form1.FeedBack("Downloading product reviews Complete");
}
void ImportReview(Models.Item item, IEnumerable <Review> reviews)
{
foreach (var reviewData in reviews)
{
var applicationUser = _context.Users.Single(u => u.Email == reviewData.Email);
var customer = _context.Customers.Single(c => c.ApplicationUserId == applicationUser.Id);
var review = _context.ItemReviews.SingleOrDefault(r => r.ItemId == item.Id && r.CustomerId == customer.Id);
if (review == null)
{
review = new ItemReview();
review.ItemId = item.Id;
review.CustomerId = customer.Id;
_context.ItemReviews.Add(review);
}
review.Title = reviewData.Title;
review.Text = reviewData.Text;
review.Note = reviewData.Rate;
review.Date = DateTime.Now;
_context.SaveChanges();
}
}
/// <summary>
/// Initializes a new instance of the <see cref="ItemsResult" /> class.
/// </summary>
public ItemReviewsResult()
{
ItemReviews = new ItemReview[] { };
}
