private void WriteDetailSingleData(HSSFWorkbook wb, ICellStyle cellStyle, Items data,
ISheet sheet1, int rowCount, int rowIndex, ICellStyle cellStyleData)
{
IRow row = sheet1.CreateRow(rowIndex);
int col = 0;
NPOIWriter.createCellText(row, cellStyle, col++, data.ITEM_CODE);
NPOIWriter.createCellText(row, cellStyle, col++, data.ITEM_NAME);
NPOIWriter.createCellText(row, cellStyle, col++, data.ITEM_UM);
sheet1.AutoSizeColumn(0);
}
private void WriteDetailSingleData(HSSFWorkbook wb, ICellStyle cellStyle, PakAnass data,
ISheet sheet1, int rowCount, int rowIndex, ICellStyle cellStyleData)
{
IRow row = sheet1.CreateRow(rowIndex);
int col = 0;
NPOIWriter.createCellText(row, cellStyle, col++, data.org_code);
NPOIWriter.createCellText(row, cellStyle, col++, data.org_name);
sheet1.AutoSizeColumn(0);
}
private void WriteDetailSingleData(HSSFWorkbook wb, ICellStyle cellStyle, Approval data,
ISheet sheet1, int rowCount, int rowIndex, ICellStyle cellStyleData)
{
IRow row = sheet1.CreateRow(rowIndex);
int col = 0;
NPOIWriter.createCellText(row, cellStyle, col++, data.po_no);
NPOIWriter.createCellText(row, cellStyle, col++, data.pr_no);
NPOIWriter.createCellText(row, cellStyle, col++, data.PO_DATE_STR);
NPOIWriter.createCellText(row, cellStyle, col++, data.supplier_code);
sheet1.AutoSizeColumn(0);
}
public void WriteDetail(HSSFWorkbook wb, ISheet sheet1, int startRow,
ICellStyle cellStyleHeader, ICellStyle cellStyleData,
IList <PakAnass> employeeList)
{
int rowIdx = startRow;
int itemCount = 0;
NPOIWriter.CreateSingleColHeader(wb, sheet1, 0, 0, cellStyleHeader, "org_code");
NPOIWriter.CreateSingleColHeader(wb, sheet1, 0, 1, cellStyleHeader, "org_name");
rowIdx = 1;
foreach (PakAnass st in employeeList)
{
WriteDetailSingleData(wb, cellStyleData, st, sheet1, ++itemCount, rowIdx++,
cellStyleData);
}
}
public void WriteDetail(HSSFWorkbook wb, ISheet sheet1, int startRow,
ICellStyle cellStyleHeader, ICellStyle cellStyleData,
IList <Items> ItemList)
{
int rowIdx = startRow;
int itemCount = 0;
NPOIWriter.CreateSingleColHeader(wb, sheet1, 0, 0, cellStyleHeader, "Item Code");
NPOIWriter.CreateSingleColHeader(wb, sheet1, 0, 1, cellStyleHeader, "Item Name");
NPOIWriter.CreateSingleColHeader(wb, sheet1, 0, 2, cellStyleHeader, "Item Um");
rowIdx = 1;
foreach (Items st in ItemList)
{
WriteDetailSingleData(wb, cellStyleData, st, sheet1, ++itemCount, rowIdx++,
cellStyleData);
}
}
public void WriteDetail(HSSFWorkbook wb, ISheet sheet1, int startRow,
ICellStyle cellStyleHeader, ICellStyle cellStyleData,
IList <Approval> PoList)
{
int rowIdx = startRow;
int itemCount = 0;
NPOIWriter.CreateSingleColHeader(wb, sheet1, 0, 0, cellStyleHeader, "Purchase Order No");
NPOIWriter.CreateSingleColHeader(wb, sheet1, 0, 1, cellStyleHeader, "Purchase Repeat No");
NPOIWriter.CreateSingleColHeader(wb, sheet1, 0, 2, cellStyleHeader, "Purchase Order Date");
NPOIWriter.CreateSingleColHeader(wb, sheet1, 0, 3, cellStyleHeader, "Supplier Code");
rowIdx = 1;
foreach (Approval st in PoList)
{
WriteDetailSingleData(wb, cellStyleData, st, sheet1, ++itemCount, rowIdx++,
cellStyleData);
}
}
/*
* public IList<Items> SearchCommon(Items o, ViewDataDictionary v, string pageModelViewData, string listViewData)
* {
* Type t = o.GetType();
*
* int pDot = t.Namespace.LastIndexOf(".");
* int pLen = t.Namespace.Length;
*
* string dir = (pDot > 1 && (pDot < (pLen - 1))) ? (t.Namespace.Substring(pDot + 1, pLen - pDot - 1) + "/") : "";
*
* string qCount = dir + t.Name + "_Count";
* string qList = dir + t.Name + "_List";
*
* IDBContext db = BaseRepo.Db;
*
* long count = db.SingleOrDefault<int>(qCount, o);
*
* BaseModel m = o as BaseModel;
* PagingModel pmodel = null;
* if (m.RowsPerPage <= 0)
* {
* pmodel = new PagingModel(count, 1, PagingModel.DEFAULT_RECORD_PER_PAGE);
* }
* else
* {
* pmodel = new PagingModel(count, m.CurrentPage, m.RowsPerPage);
* }
*
* v[pageModelViewData] = pmodel;
*
* IList<Items> l = db.Fetch<Items>(qList, o);
*
* return l;
* }
*/
#endregion
#region DownloadTemplate
public void DownloadTemplate()
{
string fileName = "DownloadTemplateItemToUpload.xls";
string filesTMp = HttpContext.Request.MapPath("~" +
CommonConstant.TEMPLATE_EXCEL_DIR + "/" + fileName);
FileStream ftmp = new FileStream(filesTMp, FileMode.Open, FileAccess.Read);
byte[] result = null;
HSSFWorkbook workbook = new HSSFWorkbook(ftmp);
ICellStyle cellStyleData = NPOIWriter.createCellStyleData(workbook);
//ICellStyle cellStyleHeader = NPOIWriter.createCellStyleColumnHeader(workbook);
HSSFSheet sheet = (HSSFSheet)workbook.GetSheetAt(0);
int row = DATA_ROW_INDEX_START;
IRow Hrow;
for (int i = 1; i <= 100; i++)
{
Hrow = sheet.CreateRow(row);
for (int x = 0; x <= 2; x++)
{
Hrow.CreateCell(x);
Hrow.GetCell(x).CellStyle = cellStyleData;
}
row++;
}
int rowMin = row - 1;
ftmp.Close();
using (MemoryStream ms = new MemoryStream())
{
workbook.Write(ms);
result = ms.GetBuffer();
}
this.SendDataAsAttachment(fileName, result);
}
private byte[] CreateFile(IList <Approval> PoList)
{
Dictionary <string, string> headers = null;
ISheet sheet1 = null;
HSSFWorkbook workBook = null;
byte[] result;
int startRow = 0;
workBook = new HSSFWorkbook();
IDataFormat dataFormat = workBook.CreateDataFormat();
short dateTimeFormat = dataFormat.GetFormat("dd/MM/yyy HH:mm:ss");
ICellStyle cellStyleData = NPOIWriter.createCellStyleData(workBook);
ICellStyle cellStyleHeader =
NPOIWriter.createCellStyleColumnHeader(workBook);
ICellStyle cellStyleDateTime =
NPOIWriter.createCellStyleDataDate(workBook, dateTimeFormat);
sheet1 = workBook.CreateSheet(
NPOIWriter.EscapeSheetName(SHEET_NAME_EMPLOYEE_MASTER));
sheet1.FitToPage = false;
//Write Header manually
headers = new Dictionary <string, string>();
WriteDetail(workBook, sheet1, startRow,
cellStyleHeader, cellStyleData, PoList);
using (MemoryStream buffer = new MemoryStream())
{
workBook.Write(buffer);
result = buffer.GetBuffer();
}
workBook = null;
return(result);
}
