private PagedList <HistoryViewModels> Journals(HistoryViewModels model)
{
var page = new PagedList <HistoryViewModels>();
page.Content = HistoryBusinessLogic.getInstance().TodaysJournal(model);
return(page);
}
public async Task <IActionResult> History()
{
_logger.LogInformation("View history");
var viewModel = new HistoryViewModels
{
History = history.GetHistory()
};
return(this.View(viewModel));
}
public List <HistoryViewModels> TodaysJournal(HistoryViewModels model)
{
List <HistoryViewModels> list = new List <HistoryViewModels>();
try
{
string account = model.Account, bankAccount = model.BankAccount, sortBy = model.SortBy;
DateTime?startDate = null, endDate = null;
if (!String.IsNullOrEmpty(model.Date))
{
startDate = Convert.ToDateTime(model.Date.Split('-')[0].Trim());
endDate = Convert.ToDateTime(model.Date.Split('-')[1].Trim());
}
var journalList = _db.sp_HistoryJournal(SessionManager.userId(), startDate, endDate, model.Account, model.BankAccount, model.SortBy);
foreach (var item in journalList)
{
model = new HistoryViewModels();
DateTime?trxDate = item.TransactionDate;
string strTrxDate = trxDate.Value.ToString("dd MMM yyyy");
model.PettyCashId = item.PettyCashId;
model.Date = strTrxDate;
model.Account = item.AccountName;
model.BankAccount = item.FacilityName;
model.Description = item.Description;
model.CashIn = item.Cash_In.ToString();
model.CashOut = item.Cash_Out.ToString();
model.Balance = item.Balance.ToString();
model.Maker = item.Maker;
model.CheckedBy = item.CheckedBy;
model.ApprovalBy = item.ApprovalBy;
model.RejectedBy = item.RejectedBy;
model.Department = item.DepartmentName;
list.Add(model);
}
//model.Date = string.Format("{0} - {1}", startDate, endDate);
//model.Account = account;
//model.BankAccount = bankAccount;
//model.SortBy = sortBy;
}
catch (Exception e)
{
Logging.getInstance().CreateLogError(e);
throw e;
}
return(list);
}
public ActionResult Index(string sd, string ed, string acc, string bnk, string srt)
{
HistoryViewModels model = new HistoryViewModels();
string strDate = DateTime.Now.AddMonths(-1).ToString("MM/dd/yyyy");
string endDate = DateTime.Now.ToString("MM/dd/yyyy");
model.Date = string.Format("{0}{1}", sd == null ? strDate : sd, ed == null ? " - " + endDate : " - " + ed);
model.Account = acc == null ? string.Empty : acc;
model.BankAccount = bnk == null ? string.Empty : bnk;
model.SortBy = srt == null ? string.Empty : srt;
model.TodaysJournal = Journals(model);
ViewBag.AccountList = common.ToSelectList(AccountDetailsBusinessLogic.getInstance().getAccountDetailDDL(), "ID", "NAME", string.Empty);
ViewBag.BankFacilityList = common.ToSelectList(BankFacilityBusinessLogic.getInstance().getBankFacilityDDL(), "ID", "NAME", model.BankAccount);
ViewBag.SortByList = common.ToSelectList(OutputBusinessLogic.getInstance().getSortByDDL(), "ID", "NAME", string.Empty);
return(View(model));
}
public ActionResult Index(string Submit, HistoryViewModels model)
{
model.TodaysJournal = Journals(model);
ViewBag.AccountList = common.ToSelectList(AccountDetailsBusinessLogic.getInstance().getAccountDetailDDL(), "ID", "NAME", model.Account);
ViewBag.BankFacilityList = common.ToSelectList(BankFacilityBusinessLogic.getInstance().getBankFacilityDDL(), "ID", "NAME", model.BankAccount);
ViewBag.SortByList = common.ToSelectList(OutputBusinessLogic.getInstance().getSortByDDL(), "ID", "NAME", model.SortBy);
if (!String.IsNullOrEmpty(Submit))
{
if (Submit.Equals("PDF"))
{
GeneratePdf(model);
}
else if (Submit.Equals("Excel"))
{
GenerateExcel(model);
}
else if (Submit.Equals("Print"))
{
}
}
return(View(model));
}
private void GeneratePdf(HistoryViewModels model)
{
MemoryStream ms = new MemoryStream();
iTextSharp.text.Rectangle rec = new iTextSharp.text.Rectangle(PageSize.A4);
rec.BackgroundColor = new BaseColor(System.Drawing.Color.Olive);
Document doc = new Document(rec);
doc.SetPageSize(iTextSharp.text.PageSize.A4);
PdfWriter writer = PdfWriter.GetInstance(doc, ms);
doc.Open();
BaseFont arial = BaseFont.CreateFont(Server.MapPath(fontPath) + "ARIALN.TTF", BaseFont.CP1252, BaseFont.NOT_EMBEDDED);
Paragraph prgHeading = new Paragraph();
prgHeading.Alignment = Element.ALIGN_CENTER;
prgHeading.Add(new Chunk("DIPO INVESTAMA", new iTextSharp.text.Font(arial, 16, iTextSharp.text.Font.BOLD, BaseColor.BLACK)));
doc.Add(prgHeading);
prgHeading = new Paragraph();
prgHeading.Alignment = Element.ALIGN_CENTER;
prgHeading.Add(new Chunk(" ", new iTextSharp.text.Font(arial, 16, iTextSharp.text.Font.BOLD, BaseColor.BLACK)));
doc.Add(prgHeading);
PdfPTable table = new PdfPTable(7);
table.WidthPercentage = 100;
table.SetWidthPercentage(new float[] { 15, 15, 15, 25, 10, 10, 10 }, new iTextSharp.text.Rectangle(doc.PageSize.Width / 6, doc.PageSize.Height));
PdfPCell cell = new PdfPCell();
cell.Phrase = new Phrase("Date"
, new iTextSharp.text.Font(arial, 9, iTextSharp.text.Font.BOLD, new BaseColor(System.Drawing.ColorTranslator.FromHtml("#000000"))));
cell.HorizontalAlignment = Element.ALIGN_LEFT;
cell.Border = 1;
table.AddCell(cell);
cell = new PdfPCell();
cell.Phrase = new Phrase("Account"
, new iTextSharp.text.Font(arial, 9, iTextSharp.text.Font.BOLD, new BaseColor(System.Drawing.ColorTranslator.FromHtml("#000000"))));
cell.HorizontalAlignment = Element.ALIGN_LEFT;
cell.Border = 1;
table.AddCell(cell);
cell = new PdfPCell();
cell.Phrase = new Phrase("Bank"
, new iTextSharp.text.Font(arial, 9, iTextSharp.text.Font.BOLD, new BaseColor(System.Drawing.ColorTranslator.FromHtml("#000000"))));
cell.HorizontalAlignment = Element.ALIGN_LEFT;
cell.Border = 1;
table.AddCell(cell);
cell = new PdfPCell();
cell.Phrase = new Phrase("Description"
, new iTextSharp.text.Font(arial, 9, iTextSharp.text.Font.BOLD, new BaseColor(System.Drawing.ColorTranslator.FromHtml("#000000"))));
cell.HorizontalAlignment = Element.ALIGN_LEFT;
cell.Border = 1;
table.AddCell(cell);
cell = new PdfPCell();
cell.Phrase = new Phrase("Cash Out"
, new iTextSharp.text.Font(arial, 9, iTextSharp.text.Font.BOLD, new BaseColor(System.Drawing.ColorTranslator.FromHtml("#000000"))));
cell.HorizontalAlignment = Element.ALIGN_LEFT;
cell.Border = 1;
table.AddCell(cell);
cell = new PdfPCell();
cell.Phrase = new Phrase("Cash In"
, new iTextSharp.text.Font(arial, 9, iTextSharp.text.Font.BOLD, new BaseColor(System.Drawing.ColorTranslator.FromHtml("#000000"))));
cell.HorizontalAlignment = Element.ALIGN_LEFT;
cell.Border = 1;
table.AddCell(cell);
cell = new PdfPCell();
cell.Phrase = new Phrase("Balance"
, new iTextSharp.text.Font(arial, 9, iTextSharp.text.Font.BOLD, new BaseColor(System.Drawing.ColorTranslator.FromHtml("#000000"))));
cell.HorizontalAlignment = Element.ALIGN_LEFT;
cell.Border = 1;
table.AddCell(cell);
foreach (var item in model.TodaysJournal.Content)
{
cell = new PdfPCell();
cell.Phrase = new Phrase(item.Date
, new iTextSharp.text.Font(arial, 9, iTextSharp.text.Font.BOLD, new BaseColor(System.Drawing.ColorTranslator.FromHtml("#000000"))));
cell.HorizontalAlignment = Element.ALIGN_LEFT;
cell.Border = 1;
table.AddCell(cell);
cell = new PdfPCell();
cell.Phrase = new Phrase(item.Account
, new iTextSharp.text.Font(arial, 9, iTextSharp.text.Font.BOLD, new BaseColor(System.Drawing.ColorTranslator.FromHtml("#000000"))));
cell.HorizontalAlignment = Element.ALIGN_LEFT;
cell.Border = 1;
table.AddCell(cell);
cell = new PdfPCell();
cell.Phrase = new Phrase(item.BankAccount
, new iTextSharp.text.Font(arial, 9, iTextSharp.text.Font.BOLD, new BaseColor(System.Drawing.ColorTranslator.FromHtml("#000000"))));
cell.HorizontalAlignment = Element.ALIGN_LEFT;
cell.Border = 1;
table.AddCell(cell);
cell = new PdfPCell();
cell.Phrase = new Phrase(item.Description
, new iTextSharp.text.Font(arial, 9, iTextSharp.text.Font.BOLD, new BaseColor(System.Drawing.ColorTranslator.FromHtml("#000000"))));
cell.HorizontalAlignment = Element.ALIGN_LEFT;
cell.Border = 1;
table.AddCell(cell);
cell = new PdfPCell();
cell.Phrase = new Phrase(item.CashIn
, new iTextSharp.text.Font(arial, 9, iTextSharp.text.Font.BOLD, new BaseColor(System.Drawing.ColorTranslator.FromHtml("#000000"))));
cell.HorizontalAlignment = Element.ALIGN_LEFT;
cell.Border = 1;
table.AddCell(cell);
cell = new PdfPCell();
cell.Phrase = new Phrase(item.CashOut
, new iTextSharp.text.Font(arial, 9, iTextSharp.text.Font.BOLD, new BaseColor(System.Drawing.ColorTranslator.FromHtml("#000000"))));
cell.HorizontalAlignment = Element.ALIGN_LEFT;
cell.Border = 1;
table.AddCell(cell);
cell = new PdfPCell();
cell.Phrase = new Phrase(item.Balance
, new iTextSharp.text.Font(arial, 9, iTextSharp.text.Font.BOLD, new BaseColor(System.Drawing.ColorTranslator.FromHtml("#000000"))));
cell.HorizontalAlignment = Element.ALIGN_LEFT;
cell.Border = 1;
table.AddCell(cell);
}
doc.Add(table);
doc.Close();
byte[] result = ms.ToArray();
System.Web.HttpResponse response = System.Web.HttpContext.Current.Response;
response.Clear();
response.Buffer = true;
response.Charset = "";
response.ContentType = MimeMapping.GetMimeMapping("Journals_.pdf");
response.AddHeader("content-disposition", "attachment;filename=Journals_" + DateTime.Now.ToString("ddMMyyyyHHmmss") + ".pdf");
response.BinaryWrite(result);
response.End();
}
private void GenerateExcel(HistoryViewModels model)
{
ExcelPackage Package = new ExcelPackage();
ExcelWorksheet ws = Package.Workbook.Worksheets.Add("Data");
Color colFromHex = System.Drawing.ColorTranslator.FromHtml("#00b0f0");
OfficeOpenXml.Style.ExcelBorderStyle DefaultBorder = OfficeOpenXml.Style.ExcelBorderStyle.Thin;
ws.Cells["A1"].LoadFromText("Date");
ws.Cells["A1"].Style.Font.SetFromFont(new System.Drawing.Font("Cambria", 10));
ws.Cells["A1"].Style.Font.Color.SetColor(Color.White);
ws.Cells["A1"].Style.Font.Bold = true;
ws.Cells["A1"].Style.Fill.PatternType = ExcelFillStyle.Solid;
ws.Cells["A1"].Style.Fill.BackgroundColor.SetColor(colFromHex);
ws.Cells["A1"].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center;
ws.Cells["A1"].Style.VerticalAlignment = OfficeOpenXml.Style.ExcelVerticalAlignment.Center;
ws.Cells["A1"].Style.Border.Bottom.Style = DefaultBorder;
ws.Cells["A1"].Style.Border.Left.Style = DefaultBorder;
ws.Cells["A1"].Style.Border.Top.Style = DefaultBorder;
ws.Cells["A1"].Style.Border.Right.Style = DefaultBorder;
ws.Cells["B1"].LoadFromText("Account");
ws.Cells["B1"].Style.Font.SetFromFont(new System.Drawing.Font("Cambria", 10));
ws.Cells["B1"].Style.Font.Color.SetColor(Color.White);
ws.Cells["B1"].Style.Font.Bold = true;
ws.Cells["B1"].Style.Fill.PatternType = ExcelFillStyle.Solid;
ws.Cells["B1"].Style.Fill.BackgroundColor.SetColor(colFromHex);
ws.Cells["B1"].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center;
ws.Cells["B1"].Style.VerticalAlignment = OfficeOpenXml.Style.ExcelVerticalAlignment.Center;
ws.Cells["B1"].Style.Border.Bottom.Style = DefaultBorder;
ws.Cells["B1"].Style.Border.Left.Style = DefaultBorder;
ws.Cells["B1"].Style.Border.Top.Style = DefaultBorder;
ws.Cells["B1"].Style.Border.Right.Style = DefaultBorder;
ws.Cells["C1"].LoadFromText("Bank");
ws.Cells["C1"].Style.Font.SetFromFont(new System.Drawing.Font("Cambria", 10));
ws.Cells["C1"].Style.Font.Color.SetColor(Color.White);
ws.Cells["C1"].Style.Font.Bold = true;
ws.Cells["C1"].Style.Fill.PatternType = ExcelFillStyle.Solid;
ws.Cells["C1"].Style.Fill.BackgroundColor.SetColor(colFromHex);
ws.Cells["C1"].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center;
ws.Cells["C1"].Style.VerticalAlignment = OfficeOpenXml.Style.ExcelVerticalAlignment.Center;
ws.Cells["C1"].Style.Border.Bottom.Style = DefaultBorder;
ws.Cells["C1"].Style.Border.Left.Style = DefaultBorder;
ws.Cells["C1"].Style.Border.Top.Style = DefaultBorder;
ws.Cells["C1"].Style.Border.Right.Style = DefaultBorder;
ws.Cells["D1"].LoadFromText("Description");
ws.Cells["D1"].Style.Font.SetFromFont(new System.Drawing.Font("Cambria", 10));
ws.Cells["D1"].Style.Font.Color.SetColor(Color.White);
ws.Cells["D1"].Style.Font.Bold = true;
ws.Cells["D1"].Style.Fill.PatternType = ExcelFillStyle.Solid;
ws.Cells["D1"].Style.Fill.BackgroundColor.SetColor(colFromHex);
ws.Cells["D1"].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center;
ws.Cells["D1"].Style.VerticalAlignment = OfficeOpenXml.Style.ExcelVerticalAlignment.Center;
ws.Cells["D1"].Style.Border.Bottom.Style = DefaultBorder;
ws.Cells["D1"].Style.Border.Left.Style = DefaultBorder;
ws.Cells["D1"].Style.Border.Top.Style = DefaultBorder;
ws.Cells["D1"].Style.Border.Right.Style = DefaultBorder;
ws.Cells["E1"].LoadFromText("Cash Out");
ws.Cells["E1"].Style.Font.SetFromFont(new System.Drawing.Font("Cambria", 10));
ws.Cells["E1"].Style.Font.Color.SetColor(Color.White);
ws.Cells["E1"].Style.Font.Bold = true;
ws.Cells["E1"].Style.Fill.PatternType = ExcelFillStyle.Solid;
ws.Cells["E1"].Style.Fill.BackgroundColor.SetColor(colFromHex);
ws.Cells["E1"].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center;
ws.Cells["E1"].Style.VerticalAlignment = OfficeOpenXml.Style.ExcelVerticalAlignment.Center;
ws.Cells["E1"].Style.Border.Bottom.Style = DefaultBorder;
ws.Cells["E1"].Style.Border.Left.Style = DefaultBorder;
ws.Cells["E1"].Style.Border.Top.Style = DefaultBorder;
ws.Cells["E1"].Style.Border.Right.Style = DefaultBorder;
ws.Cells["F1"].LoadFromText("Cash In");
ws.Cells["F1"].Style.Font.SetFromFont(new System.Drawing.Font("Cambria", 10));
ws.Cells["F1"].Style.Font.Color.SetColor(Color.White);
ws.Cells["F1"].Style.Font.Bold = true;
ws.Cells["F1"].Style.Fill.PatternType = ExcelFillStyle.Solid;
ws.Cells["F1"].Style.Fill.BackgroundColor.SetColor(colFromHex);
ws.Cells["F1"].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center;
ws.Cells["F1"].Style.VerticalAlignment = OfficeOpenXml.Style.ExcelVerticalAlignment.Center;
ws.Cells["F1"].Style.Border.Bottom.Style = DefaultBorder;
ws.Cells["F1"].Style.Border.Left.Style = DefaultBorder;
ws.Cells["F1"].Style.Border.Top.Style = DefaultBorder;
ws.Cells["F1"].Style.Border.Right.Style = DefaultBorder;
ws.Cells["G1"].LoadFromText("Balance");
ws.Cells["G1"].Style.Font.SetFromFont(new System.Drawing.Font("Cambria", 10));
ws.Cells["G1"].Style.Font.Color.SetColor(Color.White);
ws.Cells["G1"].Style.Font.Bold = true;
ws.Cells["G1"].Style.Fill.PatternType = ExcelFillStyle.Solid;
ws.Cells["G1"].Style.Fill.BackgroundColor.SetColor(colFromHex);
ws.Cells["G1"].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center;
ws.Cells["G1"].Style.VerticalAlignment = OfficeOpenXml.Style.ExcelVerticalAlignment.Center;
ws.Cells["G1"].Style.Border.Bottom.Style = DefaultBorder;
ws.Cells["G1"].Style.Border.Left.Style = DefaultBorder;
ws.Cells["G1"].Style.Border.Top.Style = DefaultBorder;
ws.Cells["G1"].Style.Border.Right.Style = DefaultBorder;
int idx = 1;
foreach (var item in model.TodaysJournal.Content)
{
idx++;
ws.Cells["A" + idx.ToString()].LoadFromText(item.Date);
ws.Cells["A" + idx.ToString()].Style.Font.SetFromFont(new System.Drawing.Font("Cambria", 10));
ws.Cells["A" + idx.ToString()].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center;
ws.Cells["A" + idx.ToString()].Style.VerticalAlignment = OfficeOpenXml.Style.ExcelVerticalAlignment.Center;
ws.Cells["A" + idx.ToString()].Style.Border.Bottom.Style = DefaultBorder;
ws.Cells["A" + idx.ToString()].Style.Border.Left.Style = DefaultBorder;
ws.Cells["A" + idx.ToString()].Style.Border.Top.Style = DefaultBorder;
ws.Cells["A" + idx.ToString()].Style.Border.Right.Style = DefaultBorder;
ws.Cells["B" + idx.ToString()].LoadFromText(item.Account);
ws.Cells["B" + idx.ToString()].Style.Font.SetFromFont(new System.Drawing.Font("Cambria", 10));
ws.Cells["B" + idx.ToString()].Style.Numberformat.Format = "dd MMM yy HH:mm";
ws.Cells["B" + idx.ToString()].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center;
ws.Cells["B" + idx.ToString()].Style.VerticalAlignment = OfficeOpenXml.Style.ExcelVerticalAlignment.Center;
ws.Cells["B" + idx.ToString()].Style.Border.Bottom.Style = DefaultBorder;
ws.Cells["B" + idx.ToString()].Style.Border.Left.Style = DefaultBorder;
ws.Cells["B" + idx.ToString()].Style.Border.Top.Style = DefaultBorder;
ws.Cells["B" + idx.ToString()].Style.Border.Right.Style = DefaultBorder;
ws.Cells["C" + idx.ToString()].LoadFromText(item.BankAccount);
ws.Cells["C" + idx.ToString()].Style.Font.SetFromFont(new System.Drawing.Font("Cambria", 10));
ws.Cells["C" + idx.ToString()].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center;
ws.Cells["C" + idx.ToString()].Style.VerticalAlignment = OfficeOpenXml.Style.ExcelVerticalAlignment.Center;
ws.Cells["C" + idx.ToString()].Style.Border.Bottom.Style = DefaultBorder;
ws.Cells["C" + idx.ToString()].Style.Border.Left.Style = DefaultBorder;
ws.Cells["C" + idx.ToString()].Style.Border.Top.Style = DefaultBorder;
ws.Cells["C" + idx.ToString()].Style.Border.Right.Style = DefaultBorder;
ws.Cells["D" + idx.ToString()].LoadFromText(item.Description);
ws.Cells["D" + idx.ToString()].Style.Font.SetFromFont(new System.Drawing.Font("Cambria", 10));
ws.Cells["D" + idx.ToString()].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center;
ws.Cells["D" + idx.ToString()].Style.VerticalAlignment = OfficeOpenXml.Style.ExcelVerticalAlignment.Center;
ws.Cells["D" + idx.ToString()].Style.Border.Bottom.Style = DefaultBorder;
ws.Cells["D" + idx.ToString()].Style.Border.Left.Style = DefaultBorder;
ws.Cells["D" + idx.ToString()].Style.Border.Top.Style = DefaultBorder;
ws.Cells["D" + idx.ToString()].Style.Border.Right.Style = DefaultBorder;
ws.Cells["E" + idx.ToString()].LoadFromText(item.CashOut);
ws.Cells["E" + idx.ToString()].Style.Numberformat.Format = "##0";
ws.Cells["E" + idx.ToString()].Style.Font.SetFromFont(new System.Drawing.Font("Cambria", 10));
ws.Cells["E" + idx.ToString()].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center;
ws.Cells["E" + idx.ToString()].Style.VerticalAlignment = OfficeOpenXml.Style.ExcelVerticalAlignment.Center;
ws.Cells["E" + idx.ToString()].Style.Border.Bottom.Style = DefaultBorder;
ws.Cells["E" + idx.ToString()].Style.Border.Left.Style = DefaultBorder;
ws.Cells["E" + idx.ToString()].Style.Border.Top.Style = DefaultBorder;
ws.Cells["E" + idx.ToString()].Style.Border.Right.Style = DefaultBorder;
ws.Cells["F" + idx.ToString()].LoadFromText(item.CashIn);
ws.Cells["F" + idx.ToString()].Style.Numberformat.Format = "##0";
ws.Cells["F" + idx.ToString()].Style.Font.SetFromFont(new System.Drawing.Font("Cambria", 10));
ws.Cells["F" + idx.ToString()].Style.Numberformat.Format = "#,#0 Liter";
ws.Cells["F" + idx.ToString()].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center;
ws.Cells["F" + idx.ToString()].Style.VerticalAlignment = OfficeOpenXml.Style.ExcelVerticalAlignment.Center;
ws.Cells["F" + idx.ToString()].Style.Border.Bottom.Style = DefaultBorder;
ws.Cells["F" + idx.ToString()].Style.Border.Left.Style = DefaultBorder;
ws.Cells["F" + idx.ToString()].Style.Border.Top.Style = DefaultBorder;
ws.Cells["F" + idx.ToString()].Style.Border.Right.Style = DefaultBorder;
ws.Cells["G" + idx.ToString()].LoadFromText(item.Balance);
ws.Cells["G" + idx.ToString()].Style.Numberformat.Format = "##0";
ws.Cells["G" + idx.ToString()].Style.Font.SetFromFont(new System.Drawing.Font("Cambria", 10));
ws.Cells["G" + idx.ToString()].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center;
ws.Cells["G" + idx.ToString()].Style.VerticalAlignment = OfficeOpenXml.Style.ExcelVerticalAlignment.Center;
ws.Cells["G" + idx.ToString()].Style.Border.Bottom.Style = DefaultBorder;
ws.Cells["G" + idx.ToString()].Style.Border.Left.Style = DefaultBorder;
ws.Cells["G" + idx.ToString()].Style.Border.Top.Style = DefaultBorder;
ws.Cells["G" + idx.ToString()].Style.Border.Right.Style = DefaultBorder;
}
Response.Clear();
Response.Buffer = true;
Response.Charset = "";
Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
Response.AddHeader("content-disposition", "attachment;filename=Journals_" + DateTime.Now.ToString("ddMMyyyyhhmmss") + ".xlsx");
Response.BinaryWrite(Package.GetAsByteArray());
Response.End();
}
public List <HistoryViewModels> getActivitiesLog(string IDUser)
{
//ReviewFilmsBus reviewFilmsBus = new ReviewFilmsBus();
List <HistoryViewModels> result = new List <HistoryViewModels>();
CommentBus commentBus = new CommentBus();
ReviewFilmsBus reviewBus = new ReviewFilmsBus();
AccountBus accBus = new AccountBus();
FilmBus filmBus = new FilmBus();
ThanhVien thanhVien = accBus.getMemberByUserId(IDUser);
List <BinhLuan> lstBinhLuan = commentBus.getMyComments(IDUser);
foreach (BinhLuan binhLuan in lstBinhLuan)
{
HistoryViewModels temp = new HistoryViewModels();
BaiNhanXet baiNhanXet = reviewBus.getReview((int)binhLuan.MS_BaiNhanXet);
Phim phim = filmBus.getFilmByID(baiNhanXet.MS_Phim.ToString());
temp.tenBaiNhanXet = baiNhanXet.TieuDe;
temp.MS_BaiNhanXet = (int)binhLuan.MS_BaiNhanXet;
temp.tenPhim = phim.TenPhim;
temp.MS_Phim = (int)phim.MaSo;
temp.action = "Comment";
temp.Hoten = thanhVien.HoTen;
temp.content = binhLuan.NoiDung;
temp.dateAction = (DateTime)binhLuan.NgayDang;
result.Add(temp);
}
FilmLikeBus filmLikeBus = new FilmLikeBus();
List <DanhSachPhimYeuThich> lstPhimYeuThich = filmLikeBus.getMyListFilmLike(IDUser);
foreach (DanhSachPhimYeuThich phimYeuThich in lstPhimYeuThich)
{
HistoryViewModels temp = new HistoryViewModels();
Phim p = filmBus.getFilmByID(phimYeuThich.MS_Phim.ToString());
temp.tenPhim = p.TenPhim;
temp.MS_Phim = p.MaSo;
temp.Hoten = thanhVien.HoTen;
temp.action = "Like";
temp.content = thanhVien.HoTen + " đã thích " + p.TenPhim;
temp.dateAction = (DateTime)phimYeuThich.ThoiGian;
result.Add(temp);
}
List <BaiNhanXet> lstNhanXet = reviewBus.getMyListReview(IDUser);
foreach (BaiNhanXet baiNhanXet in lstNhanXet)
{
HistoryViewModels temp = new HistoryViewModels();
Phim p = filmBus.getFilmByID(baiNhanXet.MS_Phim.ToString());
temp.tenPhim = p.TenPhim;
temp.MS_Phim = p.MaSo;
temp.tenBaiNhanXet = baiNhanXet.TieuDe;
temp.MS_BaiNhanXet = baiNhanXet.MaSo;
temp.Hoten = thanhVien.HoTen;
temp.action = "Post";
temp.content = thanhVien.HoTen + " đã thêm bài nhận xét ...." + baiNhanXet.MS_Phim;
temp.dateAction = (DateTime)baiNhanXet.NgayDang;
result.Add(temp);
}
result.Sort((x, y) => y.dateAction.CompareTo(x.dateAction));
return(result);
}