public JsonResult SaveDetail(InfoInventoryViewModel model)
{
Response response;
try
{
using (var db = new KiaGalleryContext())
{
var date = DateUtility.GetDateTime(model.date);
var userId = GetAuthenticatedUserId();
model.dailyInventoryDetailViewModelList.ForEach(x =>
{
if (db.InventoryDetail.Where(y => y.CategoryInventoryReportMemberId == x.categoryInventoryReportMemberId && y.Date == date).Count() > 0)
{
var entity = db.InventoryDetail.Where(y => y.CategoryInventoryReportMemberId == x.categoryInventoryReportMemberId && y.Date == date).Single();
entity.Count = x.count;
entity.Weight = x.weight;
entity.Title = x.title;
entity.ModifyUserId = userId;
entity.ModifyDate = DateTime.Now;
}
else
{
var item = new InventoryDetail()
{
Count = x.count,
CategoryInventoryReportMemberId = x.categoryInventoryReportMemberId,
Weight = x.weight,
Title = x.title,
Date = date,
CreateUserId = userId,
ModifyUserId = userId,
CreateDate = DateTime.Now,
ModifyDate = DateTime.Now,
Ip = Request.UserHostAddress,
};
db.InventoryDetail.Add(item);
}
});
db.SaveChanges();
}
response = new Response()
{
status = 200,
message = "عنوان جدید ثبت شد",
};
}
catch (Exception ex)
{
response = Core.GetExceptionResponse(ex);
}
return(Json(response, JsonRequestBehavior.AllowGet));
}
public JsonResult ReturnDataValue(InfoInventoryViewModel model)
{
Response response;
try
{
var fromDate = DateUtility.GetDateTime(model.date);
var firstDayOfMonth = new DateTime(fromDate.Value.Year, fromDate.Value.Month, 1);
fromDate = firstDayOfMonth;
string[] datePart = model.date.Split('/');
string Month = datePart[1];
int numberMonth = Convert.ToInt32(Month);
var toDate = fromDate.Value.AddDays(30);
if (numberMonth <= 6)
{
toDate = fromDate.Value.AddDays(31);
}
using (var db = new KiaGalleryContext())
{
List <DailyInventoryDetailViewModel> item;
item = db.InventoryDetail.Where(x => x.CreateDate >= fromDate && x.CreateDate <= toDate).Select(x => new DailyInventoryDetailViewModel
{
date = x.Date,
}).ToList();
item.ForEach(x =>
{
x.persianDate = DateUtility.GetPersianDate(x.date);
});
response = new Response()
{
status = 200,
data = new
{
list = item,
}
};
}
}
catch (Exception ex)
{
response = Core.GetExceptionResponse(ex);
}
return(Json(response, JsonRequestBehavior.AllowGet));
}
