public JsonResult EditLine(GridLineBusModel model)
{
using (var logic = new LineLogic())
{
switch ((GridOperation)Enum.Parse(typeof(GridOperation), model.Oper, true))
{
//case GridOperation.add:
// logic.SaveLine(model.ToDbModel());
// break;
case GridOperation.edit:
var existingLine = logic.GetLine(model.Id);
if (existingLine != null)
{
//model.UpdateDbModel(existingLine);
//logic.SaveChanges();
logic.UpdateBusToLine(model.Id, model.Bus);
}
break;
case GridOperation.del:
logic.DeleteLine(model.Id);
break;
}
}
return(new JsonResult {
Data = true
});
}
public GridLineBusModel[] GetPrint(bool _search, string nd, int rows, int page, string sidx, string sord, string filters = "")
{
var lines = new GridLineBusModel[] { };
var totalRecords = 0;
using (var logic = new LineLogic())
{
totalRecords = logic.Lines.Count();
lines = logic.GetPaged(_search, totalRecords, 1, sidx, sord, filters)
.Select(z => new GridLineBusModel(z)).ToArray();
}
return(lines);
}
public HttpResponseMessage GetExcel(bool _search, string nd, int rows, int page, string sidx, string sord, string filters = "")
{
var lines = new GridLineBusModel[] {};
var totalRecords = 0;
using (var logic = new LineLogic())
{
totalRecords = logic.Lines.Count();
lines = logic.GetPaged(_search, totalRecords, 1, sidx, sord, filters)
.Select(z => new GridLineBusModel(z)).ToArray();
}
string Name = "BusesToLines";
var workbook = new XLWorkbook();
var worksheet = workbook.Worksheets.Add(Name + " Sheet");
worksheet.Outline.SummaryVLocation = XLOutlineSummaryVLocation.Top;
worksheet.Cell(1, 1).Value = DictExpressionBuilderSystem.Translate("Line.LineName");
worksheet.Cell(1, 2).Value = DictExpressionBuilderSystem.Translate("Line.LineNumber");
worksheet.Cell(1, 3).Value = DictExpressionBuilderSystem.Translate("Line.Direction");
worksheet.Cell(1, 4).Value = DictExpressionBuilderSystem.Translate("Line.IsActive");
worksheet.Cell(1, 5).Value = DictExpressionBuilderSystem.Translate("Line.totalStudents");
worksheet.Cell(1, 6).Value = DictExpressionBuilderSystem.Translate("Line.Duration");
worksheet.Cell(1, 7).Value = DictExpressionBuilderSystem.Translate("Bus.Id");
worksheet.Cell(1, 7).Value = DictExpressionBuilderSystem.Translate("Bus.BusId");
worksheet.Cell(1, 8).Value = DictExpressionBuilderSystem.Translate("Bus.PlateNumber");
worksheet.Cell(1, 9).Value = DictExpressionBuilderSystem.Translate("BusCompany.Name");
worksheet.Cell(1, 10).Value = DictExpressionBuilderSystem.Translate("Bus.seats");
worksheet.Cell(1, 11).Value = DictExpressionBuilderSystem.Translate("Bus.price");
for (int i = 0; i < lines.Length; i++)
{
var row = 2 + i;
worksheet.Cell(row, 1).SetValue <string>(lines[i].LineName);
worksheet.Cell(row, 2).SetValue <string>(lines[i].LineNumber);
worksheet.Cell(row, 3).SetValue <string>(DictExpressionBuilderSystem.Translate("General." + lines[i].Direction));
worksheet.Cell(row, 4).SetValue <bool>(lines[i].IsActive);
worksheet.Cell(row, 5).SetValue <int>(lines[i].totalStudents);
worksheet.Cell(row, 6).SetValue <string>(Convert.ToString(lines[i].Duration));
worksheet.Cell(row, 7).SetValue <int>(lines[i].Bus);
worksheet.Cell(row, 7).SetValue <string>(lines[i].BusId);
worksheet.Cell(row, 8).SetValue <string>(lines[i].PlateNumber);
worksheet.Cell(row, 9).SetValue <string>(lines[i].BusCompanyName);
worksheet.Cell(row, 10).SetValue <int?>(lines[i].seats);
worksheet.Cell(row, 11).SetValue <double?>(lines[i].price);
}
var totalRowIndex = lines.Length + 2;
worksheet.Cell(totalRowIndex, 1).Value = DictExpressionBuilderSystem.Translate("grid.Total");
worksheet.Cell(totalRowIndex, 5).SetFormulaA1(string.Format("=SUM(E2:E{0})", totalRowIndex - 1));
worksheet.Cell(totalRowIndex, 10).SetFormulaA1(string.Format("=SUM(J2:J{0})", totalRowIndex - 1));
worksheet.Cell(totalRowIndex, 11).SetFormulaA1(string.Format("=SUM(K2:K{0})", totalRowIndex - 1));
worksheet.RangeUsed().Style.Border.InsideBorder = XLBorderStyleValues.Thin;
worksheet.RangeUsed().Style.Border.OutsideBorder = XLBorderStyleValues.None;
worksheet.Columns().AdjustToContents();
var result = new HttpResponseMessage(HttpStatusCode.OK);
using (var memoryStream = new MemoryStream())
{
workbook.SaveAs(memoryStream);
memoryStream.Position = 0;
result.Content = new ByteArrayContent(memoryStream.ToArray());
result.Content.Headers.ContentDisposition = new System.Net.Http.Headers.ContentDispositionHeaderValue("attachment")
{
FileName = Name + ".xlsx"
};
result.Content.Headers.ContentType = new MediaTypeHeaderValue("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
}
return(result);
}
