protected void btnSubmit_Click(object sender, EventArgs e) { if (!ValidateForm()) { return; } using (TransactionScope scope = new TransactionScope()) { var probesqtyInfoEntity = new ProbesQty().FindQty(); if (probesqtyInfoEntity != null) { try { var userEntity = (UserEntity)Session["ID"]; new ProbesQty { Entity = new PQuantityEntity { ID = probesqtyInfoEntity.ID, Qty = Convert.ToInt32(txtQty.Text), Createdby = userEntity.ID, } }.Update(); MessageBox.MessageShow(this.GetType(), "Successfully Updated.", ClientScript); btnSubmit.Text = "Update"; scope.Complete(); } catch (Exception ex) { throw ex; } } else { try { var userEntity = (UserEntity)Session["ID"]; new ProbesQty { Entity = new PQuantityEntity { ID = GeneralUtility.GeneratedKey, Qty = Convert.ToInt32(txtQty.Text), Createdby = userEntity.ID, } }.Save(); MessageBox.MessageShow(this.GetType(), "Successfully Save.", ClientScript); btnSubmit.Text = "Update"; scope.Complete(); } catch (Exception ex) { throw ex; } } } // txtQty.Text = ""; }
private void DisplayData() { var probesqtyInfoEntity = new ProbesQty().FindQty(); if (probesqtyInfoEntity != null) { this.txtQty.Text = probesqtyInfoEntity.Qty.ToString(); btnSubmit.Text = "Update"; } }
protected void btnExport_Click(object sender, EventArgs e) { if (txtMonth.Text != "" && txtMonth.Text != null) { #region "For Under 96%+5K" var branchcode = string.Empty; if (ddlCenterName.SelectedItem.Value != "All") { branchcode = ddlCenterName.SelectedValue.ToString(); } fromDate = GeneralUtility.ConvertSystemDateStringFormat(txtFromDate.Text); toDate = GeneralUtility.ConvertSystemDateStringFormat(txtToDate.Text); string fromYear = fromDate.Substring(0, 4); string fromMonth = fromDate.Substring(4, 2); string toYear = toDate.Substring(0, 4); string toMonth = toDate.Substring(4, 2); if (fromYear == toYear && fromMonth == toMonth) { Month1 = fromYear + fromMonth; Month2 = string.Empty; FromDate2 = string.Empty; ToDate2 = string.Empty; } else { //string comparedate = new AccuracyPercentage().FindMonthAndYear(fromDate); //string comparemonth = comparedate.Substring(3, 2); //string compareyear = comparedate.Substring(6, 4); string comparedate = new AccuracyPercentage().FindMonthAndYear(fromDate); DateTime fromtime = DateTime.Parse(comparedate); var fdate = GeneralUtility.ConvertSystemDateStringFormat(fromtime); string comparemonth = fdate.Substring(4, 2); string compareyear = fdate.Substring(0, 4); if (compareyear != toYear || comparemonth != toMonth) { MessageBox.MessageShow(this.GetType(), "Please Check FromDate and ToDate!.", ClientScript); return; } Month1 = fromYear + fromMonth; Month2 = compareyear + comparemonth; FromDate2 = Month2 + "01"; ToDate2 = toDate; toDate = new AccuracyPercentage().FindLastDayOfMonth(fromDate); } int probesQty = 7500; var probesqtyInfoEntity = new ProbesQty().FindQty(); if (probesqtyInfoEntity != null) { probesQty = probesqtyInfoEntity.Qty; } var finalAccuracyList = new AccuracyPercentage().FindByMonthForUnder96P(branchcode, Month1, probesQty, 96, fromDate, toDate, Month2, FromDate2, ToDate2); DataTable attTbl = new DataTable(); attTbl.Clear(); attTbl.Columns.Clear(); var result = (from dd in finalAccuracyList orderby dd.QAT select dd).ToList(); // Convert to DataTable. DataTable table = ConvertToDataTable(result); table.Columns.Remove("RQuality"); //table.Columns.Remove("AmountforProbes"); //table.Columns.Remove("AmountforAccuracy"); //table.Columns.Remove("PPPA"); //table.Columns.Remove("Center"); table.Columns.Remove("Month"); //int sum = finalProbesdt.AsEnumerable().Sum(s => s.Field<int>("Total Probes")); var yrm = GeneralUtility.ConvertMonthYearStringFormat(txtMonth.Text.Trim()); int yr = Convert.ToInt32(yrm.Substring(0, 4).ToString()); int mth = Convert.ToInt32(yrm.Substring(4, 2).ToString()); DateTime date = new DateTime(yr, mth, 1); var mm = date.ToString("MMMM"); var yy = date.ToString("yy"); if (result.Count().Equals(0)) { MessageBox.MessageShow(GetType(), "No Export Data.!", ClientScript); } else { var fileName = "AccuracyUnder96% " + mm + "'" + yy + ".xlsx"; int count = 0; Response.Clear(); Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"; //Response.AddHeader("content-disposition", "attachment;filename=" + HttpUtility.UrlEncode("Probes_List_Export.xlsx", System.Text.Encoding.UTF8)); this.Response.AddHeader( "content-disposition", string.Format("attachment; filename={0}", fileName)); ExcelPackage pkg = new ExcelPackage(); using (pkg) { ExcelWorksheet ws = pkg.Workbook.Worksheets.Add("Under 96%"); ws.Cells["A1"].LoadFromDataTable(table, true); #region "No need region" // using (ExcelRange rng = ws.Cells["A1:W1"]) // using (ExcelRange r = workSheet.Cells[startRowFrom, 1, startRowFrom, dataTable.Columns.Count]) using (ExcelRange rng = ws.Cells[1, 1, 1, table.Columns.Count]) { rng.Style.Font.Bold = true; //Set Pattern for the background to Solid rng.Style.Fill.PatternType = ExcelFillStyle.Solid; //Set color to dark blue rng.Style.Fill.BackgroundColor.SetColor(System.Drawing.Color.FromArgb(79, 129, 189)); // rng.Style.Fill.BackgroundColor.SetColor(System.Drawing.Color.FromArgb(122,160,205)); rng.Style.Font.Color.SetColor(System.Drawing.Color.White); } //string PersentageCellFormat = "#0.00%"; //string PersentageCellFormat = "#0.00%"; //using (ExcelRange Rng = ws.Cells["D2"]) //{ // Rng.Style.Numberformat.Format = PersentageCellFormat; // // Rng.Value = Convert.ToDecimal(39.9); //} //ws.Cells[2, 4].Style.Numberformat.Format = "0.00\\%"; // ws.Cells[2, 4].Style.Numberformat.Format = "#0.00%"; // ws.Cells[2, 4].Style.Numberformat.Format = "#0\\.00%"; //ws.Cells["A1:MT"].Style.Font.Bold = true; ////ws.Cells["A1"].Style.Font.Bold = true; //using (ExcelRange rng = ws.Cells["A1:U" + (colcount - 1)]) //{ // rng.Style.Font.Bold = true; //} //var headerCell = ws.Cells["A5:MT"]; //headerCell.Style.Fill.PatternType = ExcelFillStyle.Solid; //headerCell.Style.Fill.BackgroundColor.SetColor(System.Drawing.Color.BurlyWood); //var headerFont = headerCell.Style.Font; //headerFont.Bold = true; //ws.Cells[1, 30].Style.Fill.PatternType = ExcelFillStyle.Solid; //ws.Cells[1, 30].Style.Fill.BackgroundColor.SetColor(System.Drawing.Color.LightBlue); //ws.Cells[1, 30].Style.VerticalAlignment = ExcelVerticalAlignment.Center; //ws.Cells[1, 30].Style.HorizontalAlignment = ExcelHorizontalAlignment.Center; #endregion if (result.Count() > 0) { count = result.Count() + 2; // pkg.Workbook.Worksheets.FirstOrDefault().Cells[count, 3].Value = sum;//result.Sum(x => x.TotalProbes); // pkg.Workbook.Worksheets.FirstOrDefault().Cells[count, 3].Style.Font.Bold = true; // pkg.Workbook.Worksheets.FirstOrDefault().Cells[count, 3].Style.Font.UnderLine = true; // pkg.Workbook.Worksheets.FirstOrDefault().Cells[count, 3].Style.Font.Color.SetColor(System.Drawing.Color.Blue); // pkg.Workbook.Worksheets.FirstOrDefault().Cells[count, 3].Style.Border.BorderAround(ExcelBorderStyle.Thin); } pkg.Workbook.Worksheets.FirstOrDefault().DefaultColWidth = 20; pkg.Workbook.Worksheets.FirstOrDefault().Row(1).Height = 25; // using (ExcelRange r = workSheet.Cells[startRowFrom + 1, 1, startRowFrom + dataTable.Rows.Count, dataTable.Columns.Count]) // var modelTable = pkg.Workbook.Worksheets.FirstOrDefault().Cells["A1:MP" + (count - 1)]; //+ (count - 1) var modelTable = pkg.Workbook.Worksheets.FirstOrDefault().Cells[ws.Dimension.Start.Row, 1, ws.Dimension.Start.Row + table.Rows.Count, table.Columns.Count]; //+ (count - 1) var border = modelTable.Style.Border.Top.Style = modelTable.Style.Border.Left.Style = modelTable.Style.Border.Right.Style = modelTable.Style.Border.Bottom.Style = ExcelBorderStyle.Thin; pkg.Workbook.Properties.Title = "Attempts"; this.Response.BinaryWrite(pkg.GetAsByteArray()); this.Response.End(); } } // End Export Block #endregion // End Probes } else { MessageBox.MessageShow(this.GetType(), "Please Choose Export Date!.", ClientScript); } }