protected void Page_Init(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Request.QueryString["alert"] == "notpass")
{
Response.Write("<script>alert('لم يتم الحفظ');</script>");
}
Session["Table"] = null;
if (Convert.ToInt32(Request.QueryString["id"].ToString()) > 0)
{
ExcelSheets excelSheets = new ExcelSheets();
DataTable dt = excelSheets.getSheetItemsByID(Convert.ToInt32(Request.QueryString["id"].ToString()));
grid.DataSource = dt;
grid.KeyFieldName = "ID";
grid.DataBind();
btnEdit.Visible = true;
btnSave.Visible = false;
DataColumn colid = dt.Columns["ID"];
dt.PrimaryKey = new DataColumn[] { colid };
colid.ReadOnly = true;
Session["Table"] = dt;
}
else
{
grid.DataSource = GetTable();
grid.KeyFieldName = "ID";
grid.DataBind();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.Cookies["user"] == null)
{
Response.Redirect("~/Default.aspx");
}
else
{
if (!new UserSecurity().CheckFormPermission((int)Global.formSecurity.ViewsheetStyle, Request.Cookies["user"]["Permission"].ToString()))
{
Response.Redirect("~/HR/UnAuthorized.aspx");
}
}
if (!IsPostBack)
{
if (Convert.ToInt32(Request.QueryString["id"].ToString()) > 0)
{
ExcelSheets excelSheets = new ExcelSheets();
excelSheets.get(Convert.ToInt32(Request.QueryString["id"].ToString()));
txtName.Text = excelSheets.SheetStyleName;
DataTable dt = excelSheets.SheetItems;
grid.DataSource = dt;
grid.DataBind();
}
}
}
/// <summary>
/// Froms the excel.
/// </summary>
/// <typeparam name="TEntity">The type of the entity.</typeparam>
/// <typeparam name="TEntityDetail">The type of the entity detail.</typeparam>
/// <param name="excelfile">The excelfile.</param>
/// <param name="sheetNames">The sheet names.</param>
/// <param name="cellExistin">The cell existin.</param>
/// <param name="startRows">The start rows.</param>
/// <returns>FromExcel</returns>
public dynamic FromExcel <TEntity, TEntityDetail>(System.IO.FileInfo excelfile, string[] sheetNames, Dictionary <string, IEnumerable <string> > cellExistin = null, int[] startRows = null)
where TEntity : class
where TEntityDetail : class
{
if (startRows == null)
{
startRows = new int[] { 3, 3 };
}
if (cellExistin == null)
{
cellExistin = new Dictionary <string, IEnumerable <string> >();
}
var excelSheets = new ExcelSheets <TEntity, TEntityDetail>();
using (ExcelPackage package = new ExcelPackage(excelfile))
{
var excelSheet = new ExcelSheet <TEntity>();
excelSheet.Name = sheetNames[0];
if (package.Workbook.Worksheets.Count == 0)
{
excelSheet.Status = false;
excelSheet.Message = $"{sheetNames[0]} not Found in Excel File.";
return(excelSheets);
}
ExcelWorksheet workSheet1 = package.Workbook.Worksheets.FirstOrDefault(x => x.Name.ToLower().Trim() == sheetNames[0].ToLower().Trim());
ExcelWorksheet workSheet2;
if (package.Workbook.Worksheets.Where(x => x.Name.ToLower().Trim() == sheetNames[1].ToLower().Trim()).Count() > 0)
{
excelSheets.IsSingleSheet = false;
workSheet2 = package.Workbook.Worksheets.FirstOrDefault(x => x.Name.ToLower().Trim() == sheetNames[1].ToLower().Trim());
}
else
{
startRows[1] = startRows[0];
excelSheets.IsSingleSheet = true;
workSheet2 = workSheet1;
}
excelSheets.WorkSheet1 = this.FromExcelSheet <TEntity>(workSheet1, sheetNames[0], cellExistin, startRows[0]);
excelSheets.WorkSheet2 = this.FromExcelSheet <TEntityDetail>(workSheet2, sheetNames[1], cellExistin, startRows[1]);
return(excelSheets);
}
}
/// <summary>
/// Load Excel WorkSheets
/// </summary>
private void LoadExcelWorkSheets()
{
// Clear the Excel Sheets
App.CallMethodInUISynchronizationContext(ClearExcelSheets, null);
// Clear Selected Sheet to empty
SelectedExcelSheet = string.Empty;
string filePath = ExcelFilePath;
// Get the List of Name of Worksheets
List <string> worksheets = ExcelParser.GetWorksheetNames(filePath);
//If List of worksheet names is not working then add them to ExcelWorksheets
if (worksheets.Count > 0)
{
foreach (string worksheet in worksheets)
{
ExcelSheets.Add(worksheet);
}
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
ExcelSheets excelSheets = new ExcelSheets();
excelSheets.SheetStyleName = txtName.Text;
excelSheets.OperatorID = 1;
excelSheets.SheetItems = Session["Table"] as DataTable;
HttpCookie myCookie = Request.Cookies["user"];
excelSheets.OperatorID = Convert.ToInt32(myCookie.Values["userid"].ToString());
int id = excelSheets.save();
Session["Table"] = null;
if (id > 0)
{
Response.Redirect("~/HR/ExcelSheetStyle.aspx?alert=success");
}
else
{
Response.Redirect("~/HR/CreatesheetStyle.aspx?id=0&&alret=notpass");
}
}
private void ClearExcelSheets(object obj)
{
ExcelSheets.Clear();
}
