public void loadstage() { FarPoint.Web.Spread.TextCellType tb = new FarPoint.Web.Spread.TextCellType(); //FpSpreadstage.Sheets[0].AutoPostBack = true; //FpSpreadstage.ActiveSheetView.SheetCorner.Cells[0, 0].Text = "S.No"; //FpSpreadstage.ActiveSheetView.SheetCorner.DefaultStyle.Font.Bold = true; FpSpreadstage.ActiveSheetView.DefaultRowHeight = 25; FpSpreadstage.ActiveSheetView.Rows.Default.Font.Name = "MS Sans Serif"; FpSpreadstage.ActiveSheetView.Rows.Default.Font.Size = FontUnit.Small; FpSpreadstage.ActiveSheetView.Rows.Default.Font.Bold = false; FpSpreadstage.ActiveSheetView.Columns.Default.Font.Bold = false; FpSpreadstage.Sheets[0].RowHeader.Visible = false; FpSpreadstage.ActiveSheetView.Columns.Default.Font.Name = "MS Sans Serif"; FpSpreadstage.ActiveSheetView.Columns.Default.Font.Size = FontUnit.Small; FpSpreadstage.ActiveSheetView.ColumnHeader.DefaultStyle.Font.Bold = true; FpSpreadstage.ActiveSheetView.ColumnHeader.DefaultStyle.Font.Name = "MS Sans Serif"; FpSpreadstage.ActiveSheetView.ColumnHeader.DefaultStyle.Font.Size = FontUnit.Small; FpSpreadstage.VerticalScrollBarPolicy = FarPoint.Web.Spread.ScrollBarPolicy.AsNeeded; FpSpreadstage.HorizontalScrollBarPolicy = FarPoint.Web.Spread.ScrollBarPolicy.AsNeeded; FarPoint.Web.Spread.ButtonCellType btnmodify = new FarPoint.Web.Spread.ButtonCellType(); FarPoint.Web.Spread.CheckBoxCellType cbxd = new FarPoint.Web.Spread.CheckBoxCellType(); FarPoint.Web.Spread.ComboBoxCellType cf = new FarPoint.Web.Spread.ComboBoxCellType(); cf.AutoPostBack = true; cbxd.AutoPostBack = true; btnmodify.Text = "Remove"; FpSpreadstage.Sheets[0].RowCount = 0; FpSpreadstage.Sheets[0].ColumnCount = 5; FpSpreadstage.Sheets[0].ColumnHeader.Cells[0, 0].Text = "S.No"; FpSpreadstage.Sheets[0].ColumnHeader.Cells[0, 1].Text = "District"; FpSpreadstage.Sheets[0].Columns[1].CellType = cf; FpSpreadstage.Sheets[0].ColumnHeader.Cells[0, 2].Text = "Stage Name"; FpSpreadstage.Sheets[0].ColumnHeader.Cells[0, 3].Text = "Address"; FpSpreadstage.Sheets[0].ColumnHeader.Cells[0, 4].Text = "Select"; FpSpreadstage.Sheets[0].Columns[4].CellType = cbxd; //FpSpreadstage.Sheets[0].Columns[2].CellType = btnmodify; FpSpreadstage.Sheets[0].Columns[3].Visible = true; FpSpreadstage.Sheets[0].Columns[0].HorizontalAlign = HorizontalAlign.Center; FpSpreadstage.Sheets[0].Columns[4].HorizontalAlign = HorizontalAlign.Center; //FpSpreadstage.Sheets[0].Columns[2].Font.Bold = true; FpSpreadstage.Sheets[0].Columns[0].Width = 40; FpSpreadstage.Sheets[0].Columns[1].Width = 200; FpSpreadstage.Sheets[0].Columns[2].Width = 350; FpSpreadstage.Sheets[0].Columns[3].Width = 340; FpSpreadstage.Sheets[0].Columns[4].Width = 50; FpSpreadstage.Sheets[0].PageSize = 100; FpSpreadstage.Width = 1000; FpSpreadstage.Height = 391; FpSpreadstage.SaveChanges(); FpSpreadstage.CommandBar.Visible = false; }
public void FpSpread2_UpdateCommand(object sender, FarPoint.Web.Spread.SpreadCommandEventArgs e)//del { FarPoint.Web.Spread.ButtonCellType btn = new FarPoint.Web.Spread.ButtonCellType(); FarPoint.Web.Spread.DoubleCellType txtserialNo = new FarPoint.Web.Spread.DoubleCellType(); txtserialNo.ErrorMessage = "Allow only numbers"; btn.ButtonType = FarPoint.Web.Spread.ButtonType.LinkButton; btn.Text = "Quota Settings"; string clgDetails = string.Empty; string actrow = FpSpread1.Sheets[0].ActiveRow.ToString(); string actcol = FpSpread1.Sheets[0].ActiveColumn.ToString(); if (actrow.Trim() != "" && actcol.Trim() != "") { clgDetails = Convert.ToString(FpSpread1.Sheets[0].Cells[Convert.ToInt32(actrow), Convert.ToInt32(actcol)].Text); if (clgDetails == "Quota") { btn.Text = "Quota Settings"; FpSpread1.Sheets[0].Cells[Convert.ToInt32(actrow), 4].CellType = btn; } //else //{ // string[] prefix = new string[2]; // prefix[0] = "Prefix"; // prefix[1] = "Suffix"; // FarPoint.Web.Spread.ComboBoxCellType dropdown2 = new FarPoint.Web.Spread.ComboBoxCellType(prefix, prefix); // FpSpread1.Sheets[0].Cells[Convert.ToInt32(actrow), 4].CellType = dropdown2; //} if (clgDetails == "Serial No") { string start = FpSpread1.Sheets[0].Cells[Convert.ToInt32(actrow), 1].Text; string end = FpSpread1.Sheets[0].Cells[Convert.ToInt32(actrow), 2].Text; int difference = 0, startVal = 0, endVal = 0; int.TryParse(start, out startVal); int.TryParse(end, out endVal); difference = endVal - startVal; double maxValue = Math.Pow(10, difference); FpSpread1.Sheets[0].Cells[Convert.ToInt32(actrow), 4].CellType = txtserialNo; txtserialNo.MinimumValue = 0; txtserialNo.MaximumValue = maxValue - 1; txtserialNo.ErrorMessage = "Must Enter Between 0 and " + (maxValue - 1); txtserialNo.CssClass = "txtbgColor"; FarPoint.Web.Spread.StyleInfo darkstyle = new FarPoint.Web.Spread.StyleInfo(); darkstyle.BackColor = ColorTranslator.FromHtml("#0BA6CB"); darkstyle.ForeColor = Color.White; } if (checkSchoolSetting() == 0) { if (clgDetails == "College Acr" || clgDetails == "Department Acr" || clgDetails == "College Code" || clgDetails == "Year" || clgDetails == "Batch Year" || clgDetails == "Sem") { string[] prefix = new string[2]; prefix[0] = "Prefix"; prefix[1] = "Suffix"; FarPoint.Web.Spread.ComboBoxCellType dropdown2 = new FarPoint.Web.Spread.ComboBoxCellType(prefix, prefix); FpSpread1.Sheets[0].Cells[Convert.ToInt32(actrow), 4].CellType = dropdown2; } if (actcol == "4") { if (btn.Text == "Quota Settings") { gridquota_DataBound(); alertpopwindow.Visible = true; } } } else { if (clgDetails == "School Acr" || clgDetails == "Department Acr" || clgDetails == "Class Code" || clgDetails == "Year" || clgDetails == "Batch Year" || clgDetails == "Term") { string[] prefix = new string[2]; prefix[0] = "Prefix"; prefix[1] = "Suffix"; FarPoint.Web.Spread.ComboBoxCellType dropdown2 = new FarPoint.Web.Spread.ComboBoxCellType(prefix, prefix); FpSpread1.Sheets[0].Cells[Convert.ToInt32(actrow), 4].CellType = dropdown2; } if (actcol == "4") { if (btn.Text == "Quota Settings") { gridquota_DataBound(); alertpopwindow.Visible = true; } } } } }
protected void Generate_Click(object sender, EventArgs e) { try { lblerror.Visible = false; DataSet ds = new DataSet(); string clgcode = Session["collegecode"].ToString(); FpSpread1.Sheets[0].RowHeader.Visible = false; FpSpread1.Sheets[0].AutoPostBack = false; FpSpread1.CommandBar.Visible = false; FpSpread1.Sheets[0].RowCount = 0; FpSpread1.Sheets[0].ColumnCount = 0; FpSpread1.Sheets[0].ColumnHeader.RowCount = 1; FpSpread1.Sheets[0].Columns.Count = 5; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 0].Text = "S.No"; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 0].Font.Bold = true; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 0].Font.Name = "Book Antiqua"; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 0].Font.Size = FontUnit.Medium; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 0].HorizontalAlign = HorizontalAlign.Center; FpSpread1.Columns[0].Width = 100; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 1].Text = "From Digit"; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 1].Font.Bold = true; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 1].Font.Name = "Book Antiqua"; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 1].Font.Size = FontUnit.Medium; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 1].HorizontalAlign = HorizontalAlign.Center; FpSpread1.Columns[1].Width = 100; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 2].Text = "To Digit"; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 2].Font.Bold = true; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 2].Font.Name = "Book Antiqua"; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 2].Font.Size = FontUnit.Medium; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 2].HorizontalAlign = HorizontalAlign.Center; FpSpread1.Columns[2].Width = 100; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 3].Text = "Select"; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 3].Font.Bold = true; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 3].Font.Name = "Book Antiqua"; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 3].Font.Size = FontUnit.Medium; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 3].HorizontalAlign = HorizontalAlign.Center; FpSpread1.Columns[3].Width = 100; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 4].Text = "Prefix/Suffix"; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 4].Font.Bold = true; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 4].Font.Name = "Book Antiqua"; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 4].Font.Size = FontUnit.Medium; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 4].HorizontalAlign = HorizontalAlign.Center; FpSpread1.Columns[4].Width = 130; FarPoint.Web.Spread.StyleInfo darkstyle = new FarPoint.Web.Spread.StyleInfo(); darkstyle.BackColor = ColorTranslator.FromHtml("#0BA6CB"); darkstyle.ForeColor = Color.White; FpSpread1.ActiveSheetView.ColumnHeader.DefaultStyle = darkstyle; int val = 0; Int32.TryParse(txtsize.Text, out val); string[] item = new string[0]; if (val > 0) { for (int v = 0; v <= val; v++) { Array.Resize(ref item, item.Length + 1); item[item.Length - 1] = Convert.ToString(v); } } FarPoint.Web.Spread.ComboBoxCellType dropdown1 = new FarPoint.Web.Spread.ComboBoxCellType(); string query = "select distinct MasterCode,MasterValue from CO_MasterValues where MasterCriteria='ApplicationNumberGeneration' and CollegeCode='" + clgcode + "'"; ds.Clear(); ds = d2.select_method_wo_parameter(query, "Text"); if (ds.Tables[0].Rows.Count > 0) { dropdown1.DataSource = ds; dropdown1.DataTextField = "MasterValue"; dropdown1.DataValueField = "MasterCode"; } dropdown1.AutoPostBack = false; FarPoint.Web.Spread.ButtonCellType btn = new FarPoint.Web.Spread.ButtonCellType(); string[] prefix = new string[2]; prefix[0] = "Prefix"; prefix[1] = "Suffix"; FarPoint.Web.Spread.ComboBoxCellType dropdown = new FarPoint.Web.Spread.ComboBoxCellType(item, item); FarPoint.Web.Spread.ComboBoxCellType dropdown2 = new FarPoint.Web.Spread.ComboBoxCellType(prefix, prefix); FarPoint.Web.Spread.DoubleCellType txtserialNo = new FarPoint.Web.Spread.DoubleCellType(); btn.CssClass = "textbox btn"; btn.ButtonType = FarPoint.Web.Spread.ButtonType.LinkButton; btn.Text = "+"; DataSet CodeGenDS = d2.select_method_wo_parameter(" select NumberType,NumberLength,ag.collegeCode,FRange,TRange,DifferentRange,HeaderCode, Case when convert(varchar(max), startNo)!=0 then convert(varchar(max),startNo) else (case when PrefixOrSufix=1 then 'Prefix' when PrefixOrSufix=2 then 'Suffix' end) end as PrefixOrSufix,GenerationNumber,NumberSize,upper(MasterValue) as type,startNo from AdmissionNoGeneration ag,CO_MasterValues m where ag.collegecode='" + Convert.ToString(ddlclg.SelectedItem.Value) + "' and ag.headercode=m.MasterCode and MasterCriteria='ApplicationNumberGeneration' order by frange,trange ", "text");//ag.collegecode=m.collegecode and string Frange = string.Empty; string Trange = string.Empty; string HeaderCode = string.Empty; string PrefixOrSufix = string.Empty; string NumberSize = string.Empty; string type = string.Empty; int rangeDiff = 0; int StartNo = 0; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { FpSpread1.Sheets[0].RowCount++; FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].Text = Convert.ToString(FpSpread1.Sheets[0].RowCount); FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 0].HorizontalAlign = HorizontalAlign.Center; FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].CellType = dropdown; FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].HorizontalAlign = HorizontalAlign.Center; FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 2].CellType = dropdown; FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 2].HorizontalAlign = HorizontalAlign.Center; dropdown1.ShowButton = true; dropdown1.AutoPostBack = true; dropdown1.UseValue = true; FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 3].CellType = dropdown1; FpSpread1.Sheets[0].Columns[3].CellType = dropdown1; FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 3].HorizontalAlign = HorizontalAlign.Center; FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 4].CellType = dropdown2; FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 4].HorizontalAlign = HorizontalAlign.Center; if (CodeGenDS.Tables != null)//24.01.18 barath { if (i < CodeGenDS.Tables[0].Rows.Count) { if (CodeGenDS.Tables[0].Rows.Count > 0) { Frange = Convert.ToString(CodeGenDS.Tables[0].Rows[i]["FRange"]); Trange = Convert.ToString(CodeGenDS.Tables[0].Rows[i]["TRange"]); HeaderCode = Convert.ToString(CodeGenDS.Tables[0].Rows[i]["HeaderCode"]); PrefixOrSufix = Convert.ToString(CodeGenDS.Tables[0].Rows[i]["PrefixOrSufix"]); int.TryParse(Convert.ToString(CodeGenDS.Tables[0].Rows[i]["DifferentRange"]), out rangeDiff); int.TryParse(Convert.ToString(CodeGenDS.Tables[0].Rows[i]["startNo"]), out StartNo); NumberSize = Convert.ToString(CodeGenDS.Tables[0].Rows[i]["GenerationNumber"]); type = Convert.ToString(CodeGenDS.Tables[0].Rows[i]["type"]); FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 1].Text = Frange; FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 2].Text = Trange; FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 3].Text = HeaderCode; FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 4].Text = PrefixOrSufix; if (type == "QUOTA") { btn.Text = "Quota Settings"; FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 4].CellType = btn; } else if (type == "SERIAL NO") { FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 4].CellType = txtserialNo; //string sd = generateApplicationNumber(StartNo, rangeDiff); FpSpread1.Sheets[0].Cells[FpSpread1.Sheets[0].RowCount - 1, 4].Text = PrefixOrSufix; } } } } FpSpread1.SaveChanges(); } FpSpread1.Sheets[0].PageSize = FpSpread1.Sheets[0].RowCount; FpSpread1.SaveChanges(); FpSpread1.Height = 270; FpSpread1.Width = 568; FpSpread1.Visible = true; btnSave.Visible = true; } catch (Exception ex) { } }