public ActionResult SummaryReport(string dateFrom, string dateTo)
{
CNGDBContext context = new CNGDBContext();
VehicleStockTransferItemRepository vstItemRepo = new VehicleStockTransferItemRepository(context);
DateTime dtDateFrom = DateTime.Now.Date;
DateTime dtDateTo = DateTime.Now;
if (!String.IsNullOrEmpty(dateFrom))
{
dtDateFrom = Convert.ToDateTime(dateFrom);
}
if (!String.IsNullOrEmpty(dateTo))
{
dtDateTo = Convert.ToDateTime(dateTo);
}
int comp = Convert.ToInt32(Sessions.CompanyId.Value);
var lstSt = from st in vstRepo.List().Where(st => st.CompanyId == comp &&
(System.Data.Entity.DbFunctions.TruncateTime(st.Date) <= dtDateTo &&
System.Data.Entity.DbFunctions.TruncateTime(st.Date) >= dtDateFrom)).ToList()
join stItem in vstItemRepo.List() on st.Id equals stItem.VehicleStockTransferId
into r
select new
{
Date = st.Date.ToShortDateString(),
TransferNo = st.No,
ItemDesc = r.FirstOrDefault().Item.Description,
Quantity = r.FirstOrDefault().Quantity,
VehicleFrom = r.FirstOrDefault().VehicleFrom.LicenseNo,
VehicleTo = r.FirstOrDefault().VehicleTo.LicenseNo,
Mechanic = st.RequestedBy,
Remarks = r.FirstOrDefault().Remarks,
};
ReportViewer reportViewer = new ReportViewer();
reportViewer.ProcessingMode = ProcessingMode.Local;
ReportDataSource _rds = new ReportDataSource();
_rds.Name = "DataSet1";
_rds.Value = lstSt;
reportViewer.KeepSessionAlive = false;
reportViewer.LocalReport.DataSources.Clear();
reportViewer.LocalReport.ReportPath = Request.MapPath(Request.ApplicationPath) + @"Views\VehicleStockTransfer\Report\rptSummaryReport.rdlc";
reportViewer.LocalReport.DataSources.Add(_rds);
List <ReportParameter> _parameter = new List <ReportParameter>();
_parameter.Add(new ReportParameter("DateRange", dtDateFrom.ToString("MMMM dd, yyyy") + " - " + dtDateTo.ToString("MMMM dd, yyyy")));
_parameter.Add(new ReportParameter("CompanyName", companyRepo.GetById(Sessions.CompanyId.Value).Name));
_parameter.Add(new ReportParameter("CompanyAddress", companyRepo.GetById(Sessions.CompanyId.Value).Address));
reportViewer.LocalReport.SetParameters(_parameter);
reportViewer.LocalReport.Refresh();
ViewBag.ReportViewer = reportViewer;
ViewBag.DateFrom = dtDateFrom.ToString("MM/dd/yyyy");
ViewBag.DateTo = dtDateTo.ToString("MM/dd/yyyy");
ViewBag.CompanyName = companyRepo.GetById(Sessions.CompanyId.Value).Name;
return(View());
}
static void Main(string[] args)
{
ItemRepository itemRepo = new ItemRepository();
TransactionLogRepository transLogRepo = new TransactionLogRepository();
ItemAssignmentRepository itemAssignementRepo = new ItemAssignmentRepository();
CNGDBContext context = new CNGDBContext();
List <ItemDTO> lstItemDTO = new List <ItemDTO>();
const Int32 BufferSize = 128;
using (var fileStream = File.OpenRead(@"C:\fmt_inventory.csv"))
using (var streamReader = new StreamReader(fileStream, Encoding.UTF8, true, BufferSize))
{
String line;
int lineCnt = 1;
while ((line = streamReader.ReadLine()) != null)
{
//if (lineCnt > 3)
//{
string[] strLine = line.Split(',');
//string itemCode = Convert.ToString(strLine[0]);
string itemDesc = Convert.ToString(strLine[0]);
//int n;
//bool isNumeric = int.TryParse(itemCode, out n);
Item item = new Item();
//item.Code = itemCode.PadLeft(3, '0');
item.Description = Convert.ToString(strLine[0]);
item.TypeId = 2;
item.ClassificationId = 1;
item.Brand = "n/a";
item.UnitCost = Convert.ToDecimal(strLine[2]);
item.Active = true;
ItemDTO itemDTO = new ItemDTO();
itemDTO.item = item;
itemDTO.Quantity = Convert.ToInt32(strLine[1]);
itemDTO.CompanyId = 4;
itemDTO.UnitCost = item.UnitCost;
lstItemDTO.Add(itemDTO);
}
lineCnt++;
//}
}
//foreach (ItemDTO _itemDTO in lstItemDTO)
//{
// int itemid = itemRepo.SaveByEncoder(_itemDTO.item);
// TransactionLog transLog = new TransactionLog
// {
// ItemId = itemid,
// CompanyId = _itemDTO.CompanyId,//cng
// TransactionMethodId = 7, //in
// Date = Convert.ToDateTime("01/01/17"),
// Quantity = _itemDTO.Quantity,
// UserId = 1 //admin
// };
// transLogRepo.Add(transLog);
// Console.WriteLine("Added " + _itemDTO.item.Code + " - " + _itemDTO.item.Description);
//}
List <ItemAssignment> lstItemAssignment = new List <ItemAssignment>();
foreach (ItemDTO item in lstItemDTO)
{
int x = 0;
if (item.item.Id == 0)
{
x = itemRepo.GetItemId(item.item.Description);
}
else
{
x = item.item.Id;
}
ItemAssignment itemAssignment = context.ItemAssignments.FirstOrDefault(p => p.ItemId == x && p.CompanyId == 4);
itemAssignment.UnitCost = item.UnitCost;
context.SaveChanges();
//ItemAssignment itemAssignment = new ItemAssignment
//{
// ItemId = x,
// CompanyId = item.CompanyId,
// UnitCost = item.UnitCost//cng
//};
//lstItemAssignment.Add(itemAssignment);
}
//itemAssignementRepo.Save(lstItemAssignment);
Console.WriteLine("Done!");
Console.ReadLine();
}
