/// <summary>
/// 获取备注信息支出收入明细
/// </summary>
/// <param name="start"></param>
/// <param name="end"></param>
/// <returns></returns>
public NoteDetailViewModel GetNoteDetails(DateTime start, DateTime end)
{
var result = new NoteDetailViewModel();
var details = DetailService.GetAll(d => d.Date >= start.Date && d.Date <= end.Date, d => d.Date, SqlSugar.OrderByType.Desc);
//按照支出收入进行分类且将支出类型明细的涉及金额变为负数
result.Expend = details.Where(d => d.Type == Type.支出).Select(d =>
{
var model = new NoteDetailItem()
{
Amount = d.Amount > 0 ? -d.Amount : d.Amount,
Note = d.Note,
TagID = d.TagID.ToString(),
TagInfo = d.TagInfo,
Type = d.Type
};
return(model);
}).ToList();
result.Income = details.Where(d => d.Type == Type.收入).Select(d =>
{
var model = new NoteDetailItem()
{
Amount = d.Amount,
Note = d.Note,
TagID = d.TagID.ToString(),
TagInfo = d.TagInfo,
Type = d.Type
};
return(model);
}).ToList();
return(result);
}
// GET: NoteDetail
public ActionResult NoteDetail(int?NoteID)
{
if (Session["ID"] != null)
{
int id = Convert.ToInt32(Session["ID"]);
int RoleMember = Convert.ToInt32(Enums.UserRoleId.Member);
User user = db.Users.Where(x => x.ID == id).FirstOrDefault();
if (user.RoleID != RoleMember)
{
NoteDetailViewModel model = new NoteDetailViewModel();
model.sellNote = db.SellNotes.Where(x => x.ID == NoteID).FirstOrDefault();
model.noteReviews = db.NoteReviews.Where(x => x.NoteID == NoteID).ToList();
model.ReviewCount = model.noteReviews.Count();
model.ReportCount = db.NoteReports.Where(x => x.NoteID == NoteID).Count();
if (model.ReviewCount != 0)
{
model.Rating = (decimal)db.NoteReviews.Where(x => x.NoteID == NoteID).Select(x => x.Ratings).Average();
}
else
{
model.Rating = 0;
}
return(View(model));
}
else
{
return(RedirectToAction("Index", "Home"));
}
}
else
{
return(RedirectToAction("Login", "Account"));
}
}
public ActionResult AddPost(NoteDetailViewModel model)
{
if (ModelState.IsValid)
{
_service.Create(model, User.Identity.GetUserId());
return(RedirectToAction("Index"));
}
return(View(model));
}
public ActionResult NoteDetails(int id)
{
ViewBag.navClass = "white-nav";
ViewBag.SearchNotes = "active";
ViewBag.SadminPhone = db.SystemConfigurations.FirstOrDefault(x => x.Key == "SupportContactNumber").Value;
if (Session["ID"] != null)
{
var user = db.Users.FirstOrDefault(x => x.Email == User.Identity.Name);
//check user enter detail of profile or not
if (user.RoleID == 3 || user.RoleID == 4)
{
ViewBag.isAdmin = user.RoleID;
}
}
var totalReportedIssue = db.SellerNotesReportedIssues.Where(x => x.NoteID == id).Count();
//total review
var rating = db.SellerNotesReviews.Where(x => x.NoteID == id && x.IsActive == true).Average(x => (int?)x.Ratings) ?? 0;
var totalreview = db.SellerNotesReviews.Where(x => x.NoteID == id && x.IsActive == true).Count();
//fetch country name
var country = db.SellerNotes.FirstOrDefault(x => x.ID == id).Country;
ViewBag.countryName = db.Countries.FirstOrDefault(x => x.ID == country && x.IsActive == true).Name;
//Querystring
IEnumerable <ReviewsModel> reviews = from review in db.SellerNotesReviews
join users in db.Users on review.ReviewedByID equals users.ID
join userprofile in db.UserProfile on review.ReviewedByID equals userprofile.UserID
where review.NoteID == id && review.IsActive == true
orderby review.Ratings descending, review.CreatedDate descending
select new ReviewsModel {
sellerNotesReviews = review, users = users, userProfiles = userprofile
};
NoteDetailViewModel detail = new NoteDetailViewModel();
detail.sellnote = db.SellerNotes.FirstOrDefault(x => x.ID == id);
detail.reportedIssue = totalReportedIssue;
detail.TotalReview = totalreview;
detail.AvgRating = (int)rating;
detail.notesreview = reviews;
//show popup box
if (TempData["Requested"] != null)
{
ViewBag.Requested = "Requested";
}
return(View(detail));
}
// GET: Notes/Create
public ActionResult Create(int id)
{
NoteDetailViewModel noteDetailViewModel = new NoteDetailViewModel();
noteDetailViewModel.CustomerId = id;
noteDetailViewModel.Active = true;
noteDetailViewModel.CreatedDate = DateTime.Now;
noteDetailViewModel.ModifiedDate = DateTime.Now;
return(View(noteDetailViewModel));
}
public ActionResult Edit([Bind(Include = "NoteId,Value,CreatedDate,ModifiedDate,Active,CustomerId")] NoteDetailViewModel noteDetailViewModel)
{
if (ModelState.IsValid)
{
Note note = db.Notes.Find(noteDetailViewModel.NoteId);
note.Value = noteDetailViewModel.Value;
note.ModifiedDate = DateTime.Now;
db.Entry(note).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Edit", "Customers", new { id = note.Customer.CustomerId }));
}
return(View(noteDetailViewModel));
}
public IHttpActionResult Put(Guid key, NoteDetailViewModel delta)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
using (var unitOfWork = _unitOfWorkManager.NewUnitOfWork())
{
_noteDetail.UpdateNoteDetail(delta);
unitOfWork.Commit();
return(StatusCode(HttpStatusCode.OK));
}
}
public NoteDetailPage(Note note)
{
_viewModel = new NoteDetailViewModel();
InitializeComponent();
_viewModel.CurrentNoteId = note.NoteId;
_viewModel.NoteTitle = note.Title;
_viewModel.Content = note.Content;
_viewModel.Category = note.Category;
_viewModel.Date = note.CreatedDate;
_viewModel.Time = note.CreatedDate.TimeOfDay;
_viewModel.AccessLevel = note.AccessLevel;
BindingContext = _viewModel;
}
public bool Create(NoteDetailViewModel model, string requestingUserId)
{
using (var context = Dependencies.DataContext)
{
context.Notes.Add(new Note()
{
ApplicationUserId = requestingUserId,
NoteId = model.Id,
Title = model.Title,
Contents = model.Content,
DateCreated = DateTime.Now,
DateModified = DateTime.Now
});
return(1 == context.SaveChanges());
}
}
public ActionResult NoteDetail(int?noteId)
{
NoteDetailViewModel model = new NoteDetailViewModel();
model.sellNote = db.SellNotes.Where(x => x.ID == noteId).FirstOrDefault();
model.noteReviews = db.NoteReviews.Where(x => x.NoteID == noteId).ToList();
model.ReviewCount = model.noteReviews.Count();
model.ReportCount = db.NoteReports.Where(x => x.NoteID == noteId).Count();
if (model.ReviewCount != 0)
{
model.Rating = (decimal)db.NoteReviews.Where(x => x.NoteID == noteId).Select(x => x.Ratings).Average();
}
else
{
model.Rating = 0;
}
return(View(model));
}
public bool UpdateNoteDetail(NoteDetailViewModel model)
{
var NoteDetail = Find(model.Id.Value);
if (NoteDetail != null)
{
NoteDetail.Price = model.Price;
NoteDetail.Quantity = model.Quantity;
NoteDetail.User = _userRepository.Find(HttpContext.Current.User.Identity.GetUserId());
NoteDetail.Product = _product.Find(model.ProductId);
NoteDetail.LastModifiedDate = DateTime.Now;
Update(NoteDetail);
return(true);
}
else
{
throw new Exception("Không tìm thấy chi tiết phiếu");
}
}
public ActionResult Details(int id)
{
NoteDTO note = _bl.Notes.GetItemById(id);
if (note != null)
{
note.Category = _bl.Categories.GetItemById(note.CategoryId)?.Name;
note.Owner = _bl.Users.GetItemById(note.OwnerId)?.NameOrLogin;
IMapper mapper = new MapperConfiguration(c => c.CreateMap <NoteDTO, NoteDetailViewModel>()).CreateMapper();
NoteDetailViewModel model = mapper.Map <NoteDTO, NoteDetailViewModel>(note);
model.References = new List <NoteReferenceViewModel>();
mapper = new MapperConfiguration(c => c.CreateMap <NoteReferenceDTO, NoteReferenceViewModel>()).CreateMapper();
model.References = mapper.Map <IEnumerable <NoteReferenceDTO>, List <NoteReferenceViewModel> >(_bl.NoteReferences.GetReferencesTo(id));
return(PartialView("Details", model));
}
else
{
ErrorViewModel error = new ErrorViewModel("Запись заметки не найдена");
return(PartialView("PartialError", error));
}
}
// POST: odata/Warehouse
public IHttpActionResult Post(NoteDetailViewModel delta)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
// TODO: Add create logic here.
using (var unitOfWork = _unitOfWorkManager.NewUnitOfWork())
{
var result = _noteDetail.AddNoteDetail(delta);
unitOfWork.Commit();
var resultObject = new NoteDetailViewModel()
{
Id = result.Id,
Price = result.Price,
ProductName = result.Product.ProductName,
Quantity = result.Quantity
};
return(Created(resultObject));
}
}
public ActionResult getNotesByPatientID(int patientID, int?skip)
{
var noteDetail = _iPatientService.getNotesByPatientID(patientID, skip.Value, GlobalConst.Records.LandingTake);
NoteDetailViewModel _objNote = new NoteDetailViewModel();
_objNote.NotesDetails = Mapper.Map <IEnumerable <NoteDetail> >(noteDetail.NotesDetails);
foreach (NoteDetail viewmodel in _objNote.NotesDetails)
{
Regex regex = new Regex("\\<[^\\>]*\\>");
viewmodel.ShortNotes = regex.Replace(HttpUtility.HtmlDecode(viewmodel.Notes), String.Empty);
if (viewmodel.ShortNotes.Length > 25)
{
viewmodel.ShortNotes = regex.Replace(HttpUtility.HtmlDecode(viewmodel.Notes), String.Empty).Substring(0, 25) + "...";
viewmodel.ShortNotes = viewmodel.ShortNotes.Replace(" ", "") + "...";
}
else
{
viewmodel.ShortNotes = viewmodel.ShortNotes.Replace(" ", "") + "...";
}
}
_objNote.TotalCount = noteDetail.TotalCount;
return(Json(_objNote));
}
public NoteDetail AddNoteDetail(NoteDetailViewModel model)
{
if (Queryable().Any(x => x.Id == model.Id))
{
throw new Exception("Đã tồn tại Id");
}
else
{
var result = new NoteDetail();
result.Price = model.Price;
result.Quantity = model.Quantity;
result.User = _userRepository.Find(HttpContext.Current.User.Identity.GetUserId());
result.Note = _note.Find(model.NoteId);
result.Product = _product.Find(model.ProductId);
result.CreatedDate = DateTime.Now;
result.LastModifiedDate = DateTime.Now;
var note = _note.Find(model.NoteId);
note.Total = Queryable().Where(x => x.Note.Id == note.Id && x.Delete == false).Sum(x => x.Quantity * x.Price) + (model.Quantity * model.Price);
_note.Update(note);
_note.SaveChanges();
return(result);
}
}
public NoteDetailPage()
{
InitializeComponent();
BindingContext = new NoteDetailViewModel();
}
public ActionResult UploadNote()
{
Request.RequestContext.HttpContext.Response.AddHeader("Access-Control-Allow-Origin", "*");
Request.RequestContext.HttpContext.Response.AddHeader("Access-Control-Allow-Headers", "*");
if (Request.Files.Count > 0)
{
try
{
var NoteList = new List <NoteViewModel>();
// Get all files from Request object
string firstfname = "";
string fname;
HttpFileCollectionBase files = Request.Files;
for (int i = 0; i < files.Count; i++)
{
HttpPostedFileBase file = files[i];
// Checking for Internet Explorer
if (Request.Browser.Browser.ToUpper() == "IE" || Request.Browser.Browser.ToUpper() == "INTERNETEXPLORER")
{
string[] testfiles = file.FileName.Split(new char[] { '\\' });
fname = testfiles[testfiles.Length - 1];
}
else
{
fname = file.FileName;
}
// Get the complete folder path and store the file inside it.
fname = Path.Combine(Server.MapPath("~/Uploads/"), fname);
firstfname = fname;
file.SaveAs(fname);
}
using (XLWorkbook wb = new XLWorkbook(firstfname))
{
var ws = wb.Worksheet(1);
var sheet = wb.Worksheet(1).RowsUsed();
var usedColumn = wb.Worksheet(1).ColumnsUsed();
var ExceptRow = 1;
foreach (var dataRow in sheet)
{
var Note = new NoteViewModel();
if (ExceptRow == 1)
{
ExceptRow++;
}
else
{
var NoteType = ws.Cell(1, 1).Value.ToString();
switch (NoteType)
{
case "NK":
{
Note.Code = "NK" + DateTime.Now.ToString("yy") + DateTime.Now.ToString("MM") + (_note.Queryable().Where(mi => mi.Source.Id == null && mi.CreatedDate.Month == DateTime.Now.Month &&
mi.CreatedDate.Year == DateTime.Now.Year).Count() + 1).ToString("D3");
Note.Source = null;
var destCode = dataRow.Cell("A").Value.ToString();
Note.DestinationId = _warehouse.Queryable().Where(x => x.WarehouseCode.Equals(destCode)).Select(x => x.Id).FirstOrDefault();
Note.DestinationWarehouse = _warehouse.Queryable().Where(x => x.WarehouseCode.Equals(destCode)).Select(x => x.Name).FirstOrDefault();
Note.Details = new List <NoteDetailViewModel>();
for (int i = 2; i < usedColumn.Count(); i++)
{
if (!(dataRow.Cell(i).Value.ToString() == ""))
{
var detail = new NoteDetailViewModel();
var NumberProduct = (double)dataRow.Cell(i).Value;
var detailCode = ws.Cell(1, i).Value.ToString();
var price = _product.Queryable().Where(p => p.ProductName.Equals(detailCode)).Select(p => p.Price).FirstOrDefault();
detail.Price = price;
detail.Quantity = (int)NumberProduct;
detail.ProductId = _product.Queryable().Where(p => p.ProductName.Equals(detailCode)).Select(p => p.Id).FirstOrDefault();
detail.ProductName = _product.Queryable().Where(p => p.ProductName.Equals(detailCode)).Select(p => p.ProductName).FirstOrDefault();
detail.Unit = _product.Queryable().Where(p => p.ProductName.Equals(detailCode)).Select(p => p.Unit).FirstOrDefault();
Note.Details.Add(detail);
}
}
Note.Noted = ws.Cell(ExceptRow, usedColumn.Count()).Value.ToString();
Note.Total = Note.Details.Sum(x => x.Price * x.Quantity);
NoteList.Add(Note);
ExceptRow++;
break;
}
case "XK":
{
Note.Code = "XK" + DateTime.Now.ToString("yy") + DateTime.Now.ToString("MM") + (_note.Queryable().Where(mi => mi.Destination.Id == null && mi.CreatedDate.Month == DateTime.Now.Month &&
mi.CreatedDate.Year == DateTime.Now.Year).Count() + 1).ToString("D3");
var sourceCode = dataRow.Cell("A").Value.ToString();
Note.SourceId = _warehouse.Queryable().Where(s => s.WarehouseCode.Equals(sourceCode)).Select(s => s.Id).FirstOrDefault();
Note.Destination = null;
Note.SourceWarehouse = _warehouse.Queryable().Where(s => s.WarehouseCode.Equals(sourceCode)).Select(s => s.Name).FirstOrDefault();
Note.Details = new List <NoteDetailViewModel>();
for (int i = 2; i < usedColumn.Count(); i++)
{
if (!(dataRow.Cell(i).Value.ToString() == ""))
{
var detail = new NoteDetailViewModel();
var NumberProduct = (double)dataRow.Cell(i).Value;
var detailCode = ws.Cell(1, i).Value.ToString();
var price = _product.Queryable().Where(p => p.ProductName.Equals(detailCode)).Select(p => p.Price).FirstOrDefault();
detail.Price = price;
detail.Quantity = (int)NumberProduct;
detail.ProductId = _product.Queryable().Where(p => p.ProductName.Equals(detailCode)).Select(p => p.Id).FirstOrDefault();
detail.ProductName = _product.Queryable().Where(p => p.ProductName.Equals(detailCode)).Select(p => p.ProductName).FirstOrDefault();
detail.Unit = _product.Queryable().Where(p => p.ProductName.Equals(detailCode)).Select(p => p.Unit).FirstOrDefault();
Note.Details.Add(detail);
}
}
Note.Noted = ws.Cell(ExceptRow, usedColumn.Count()).Value.ToString();
Note.Total = Note.Details.Sum(x => x.Price * x.Quantity);
NoteList.Add(Note);
ExceptRow++;
break;
}
case "CK":
{
break;
}
}
}
}
//using (MemoryStream stream = new MemoryStream())
//{
// wb.SaveAs(stream);
// return File(stream.ToArray(), "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", "PhieuNhapKho.xlsx");
//}
}
// Returns message that successfully uploaded
return(Json(NoteList, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json("Error occurred. Error details: " + ex.Message));
}
}
else
{
return(Json("No files selected."));
}
}
public NoteDetailPage()
{
InitializeComponent(); BindingContext = _viewModel = App.Current.Services.GetService <NoteDetailViewModel>();
}
public ItemDetailPage(NoteDetailViewModel viewModel)
{
InitializeComponent();
BindingContext = _viewModel = viewModel;
}
