protected void FpSpread1_UpdateCommand(object sender, FarPoint.Web.Spread.SpreadCommandEventArgs e)
{
//Fpspread2.Visible = true;
try
{
actrow = FpSpread1.Sheets[0].ActiveRow.ToString();
actcol = FpSpread1.Sheets[0].ActiveColumn.ToString();
arow = Convert.ToInt32(actrow);
acol = Convert.ToInt32(actcol);
if (actrow.Trim() != "" && actrow.Trim() == "0")
{
if (FpSpread1.Sheets[0].RowCount > 0)
{
int checkval = Convert.ToInt32(FpSpread1.Sheets[0].Cells[arow, acol].Value);
if (checkval == 0)
{
for (int i = 1; i < FpSpread1.Sheets[0].RowCount; i++)
{
FpSpread1.Sheets[0].Cells[i, acol].Value = 1;
}
}
if (checkval == 1)
{
for (int i = 1; i < FpSpread1.Sheets[0].RowCount; i++)
{
FpSpread1.Sheets[0].Cells[i, acol].Value = 0;
}
}
}
}
}
catch (Exception ex) { d2.sendErrorMail(ex, userCollegeCode, "News_Paper_Entry"); }
}
protected void FpSpread1_ButtonCommand(object sender, FarPoint.Web.Spread.SpreadCommandEventArgs e)
{
try
{
string activrow = "";
activrow = FpSpread1.Sheets[0].ActiveRow.ToString();
string activecol = FpSpread1.Sheets[0].ActiveColumn.ToString();
int actcol = Convert.ToInt16(activecol);
int hy_order = 0;
for (int i = 0; i <= Convert.ToInt16(FpSpread1.Sheets[0].RowCount) - 1; i++)
{
int isval = Convert.ToInt32(FpSpread1.Sheets[0].Cells[i, actcol].Value);
if (isval == 1)
{
hy_order++;
FpSpread1.Sheets[0].Cells[Convert.ToInt32(activrow), actcol].Locked = true;
}
}
FpSpread1.Sheets[0].Cells[Convert.ToInt32(activrow), actcol + 1].Text = hy_order.ToString();
FpSpread1.Sheets[0].Cells[Convert.ToInt32(activrow), actcol + 1].HorizontalAlign = HorizontalAlign.Center;
}
catch
{
}
}
protected void Fpload1_UpdateCommand(object sender, FarPoint.Web.Spread.SpreadCommandEventArgs e)
{
//Fpspread2.Visible = true;
try
{
string actrow = Fpload1.Sheets[0].ActiveRow.ToString();
string actcol = Fpload1.Sheets[0].ActiveColumn.ToString();
if (actrow.Trim() == "0" && actcol.Trim() == "1")
{
if (Fpload1.Sheets[0].RowCount > 0)
{
int checkval = Convert.ToInt32(Fpload1.Sheets[0].Cells[0, 1].Value);
if (checkval == 0)
{
for (int i = 1; i < Fpload1.Sheets[0].RowCount; i++)
{
Fpload1.Sheets[0].Cells[i, 1].Value = 1;
}
}
if (checkval == 1)
{
for (int i = 1; i < Fpload1.Sheets[0].RowCount; i++)
{
Fpload1.Sheets[0].Cells[i, 1].Value = 0;
}
}
}
}
}
catch (Exception ex)
{
//d2.sendErrorMail(ex, collegecode, "Individual_StudentFeeStatus");
}
}
protected void FpSpreadstage_ButtonCommand(object sender, FarPoint.Web.Spread.SpreadCommandEventArgs e)
{
//string ar = e.SheetView.ActiveRow.ToString();
//string ac = e.SheetView.ActiveColumn.ToString();
//int actrow = Convert.ToInt32(ar);
//int actcol = Convert.ToInt32(ac);
//string stageidd = Convert.ToString(FpSpreadstage.Sheets[0].Cells[actrow, 0].Tag);
//if (stageidd != "")
//{
// if (actcol == 2)
// {
// con.Close();
// con.Open();
// string deletequery = "";
// deletequery = "delete from Stage_Master where Stage_id = '" + stageidd + "'";
// SqlCommand del = new SqlCommand(deletequery, con);
// del.ExecuteNonQuery();
// con.Close();
// FpSpreadstage.Sheets[0].RemoveRows(actrow, 1);
// }
//}
//else
//{
// FpSpreadstage.Sheets[0].RemoveRows(actrow, 1);
//}
}
protected void Fpspread2_Command(object sender, FarPoint.Web.Spread.SpreadCommandEventArgs e)
{
try
{
string actrow = Fpspread2.Sheets[0].ActiveRow.ToString();
string actcol = Fpspread2.Sheets[0].ActiveColumn.ToString();
if (actrow.Trim() == "0" && actcol.Trim() == "1")
{
if (Fpspread2.Sheets[0].RowCount > 0)
{
int checkval = Convert.ToInt32(Fpspread2.Sheets[0].Cells[0, 1].Value);
if (checkval == 0)
{
for (int i = 1; i < Fpspread2.Sheets[0].RowCount; i++)
{
Fpspread2.Sheets[0].Cells[i, 1].Value = 1;
}
}
if (checkval == 1)
{
for (int i = 1; i < Fpspread2.Sheets[0].RowCount; i++)
{
Fpspread2.Sheets[0].Cells[i, 1].Value = 0;
}
}
}
}
}
catch
{
}
}
protected void FSpread1_CellClick(object sender, FarPoint.Web.Spread.SpreadCommandEventArgs e)
{
try
{
Cellclick = true;
}
catch (Exception ex)
{ }
}
protected void sprdHallMaster_ButtonCommand(object sender, FarPoint.Web.Spread.SpreadCommandEventArgs e)
{
for (int mm = 1; mm < sprdHallMaster.Sheets[0].RowCount; mm++)
{
int selectvalue = Convert.ToInt32(sprdHallMaster.Sheets[0].Cells[mm, 7].Value.ToString());
if (selectvalue == 1)
{
totlselectedseats++;
}
}
lbltotseats.Text = Convert.ToString(totlselectedseats);
}
protected void FpSpread_Command(object sender, FarPoint.Web.Spread.SpreadCommandEventArgs e)
{
try
{
FpSpread.SaveChanges();
Dictionary <string, string> diclea = new Dictionary <string, string>();
// int countvalue1 = Convert.ToInt32(Session["item_Value"]);
// countvalue1 = countvalue1 + 3;
string actrow = FpSpread.Sheets[0].ActiveRow.ToString(); //e.SheetView.ActiveRow.ToString();
string actcol = FpSpread.Sheets[0].ActiveColumn.ToString(); //e.SheetView.ActiveColumn.ToString();
string txtval = Convert.ToString(FpSpread.Sheets[0].Cells[Convert.ToInt32(actrow), Convert.ToInt32(actcol)].Text);
string last = e.CommandArgument.ToString();
if (actrow != "0")
{
if (actrow == last)
{
flag_true = false;
}
else
{
flag_true = true;
}
}
if (actcol == "1")
{
if (actrow == last)
{
flag_true = false;
}
else
{
flag_true = true;
}
}
if (flag_true == false)
{
string setval = "select * from leave_category where college_code='" + Session["collegecode"].ToString() + "'";
DataSet dsleavval = d2.select_method_wo_parameter(setval, "text");
for (int li = 0; li < dsleavval.Tables[0].Rows.Count; li++)
{
if (!diclea.ContainsKey(dsleavval.Tables[0].Rows[li]["shortname"].ToString().Trim().ToLower()))
{
diclea.Add(dsleavval.Tables[0].Rows[li]["shortname"].ToString().Trim().ToLower(), dsleavval.Tables[0].Rows[li]["shortname"].ToString().Trim().ToLower());
}
}
}
}
catch (Exception ex)
{
}
}
protected void FpSpreadstage_UpdateCommand(object sender, FarPoint.Web.Spread.SpreadCommandEventArgs e)
{
for (int i = 0; i < Convert.ToInt16(FpSpreadstage.Sheets[0].RowCount); i++)
{
string actrow1;
actrow1 = e.SheetView.ActiveRow.ToString();
int actrow = Convert.ToInt32(actrow1);
string actrow11 = e.SheetView.ActiveRow.ToString();
string actcol = e.SheetView.ActiveColumn.ToString();
if (actrow.ToString() != "-1" && actrow11 != "-1" && actcol != "-1")
{
//if (actrow1 == "0")
if (FpSpreadstage.Sheets[0].Cells[actrow, 4].Value != null)
{
//{
if (i == 0)
{
Buttondelete.Enabled = true;
if (FpSpreadstage.Sheets[0].Cells[actrow, 4].Value.ToString() == "0")
{
for (int j = 0; j < Convert.ToInt16(FpSpreadstage.Sheets[0].RowCount); j++)
{
if (j == 0)
{
FpSpreadstage.Sheets[0].Cells[actrow, 4].Value = 1;
}
//}
}
}
else
{
for (int j = 0; j < Convert.ToInt16(FpSpreadstage.Sheets[0].RowCount); j++)
{
if (j == 0)
{
FpSpreadstage.Sheets[0].Cells[actrow, 4].Value = 0;
}
}
}
}
}
//}
}
}
}
protected void Fpstudents_UpdateCommand(object sender, FarPoint.Web.Spread.SpreadCommandEventArgs e)
{
string actrow = e.SheetView.ActiveRow.ToString();
if (flag_true == false && actrow == "0")
{
for (int j = 1; j < Convert.ToInt16(Fpstudents.Sheets[0].RowCount); j++)
{
string actcol = e.SheetView.ActiveColumn.ToString();
string seltext = e.EditValues[Convert.ToInt16(actcol)].ToString();
if (seltext != "System.Object")
{
Fpstudents.Sheets[0].Cells[j, Convert.ToInt16(actcol)].Text = seltext.ToString();
}
}
flag_true = true;
}
}
protected void Fpspread1_Command(object sender, FarPoint.Web.Spread.SpreadCommandEventArgs e)
{
try
{
Fpspread1.SaveChanges();
string activerow = "";
string activecol = "";
activerow = Fpspread1.ActiveSheetView.ActiveRow.ToString();
activecol = Fpspread1.ActiveSheetView.ActiveColumn.ToString();
countnew = 0;
if (activecol == "4")
{
for (int i = 0; i < Fpspread1.Sheets[0].Rows.Count; i++)
{
if (Convert.ToInt32(Fpspread1.Sheets[0].Cells[Convert.ToInt32(i), Convert.ToInt32(activecol)].Value) == 1)
{
countnew++;
}
else
{
//countnew--;
for (int k = 0; k < Fpspread1.Columns.Count; k++)
{
Fpspread1.Sheets[0].Cells[Convert.ToInt32(i), k].BackColor = ColorTranslator.FromHtml("White");
}
}
}
}
if (countnew > 1)
{
countnew--;
Fpspread1.Sheets[0].Cells[Convert.ToInt32(activerow), Convert.ToInt32(activecol)].Value = 0;
imgdiv2.Visible = true;
lbl_alerterr.Text = "Only One Finance Year Is Allowed";
}
}
catch
{
}
}
protected void fpspread_UpdateCommand(object sender, FarPoint.Web.Spread.SpreadCommandEventArgs e)
{
try
{
string ctrlname = Page.Request.Params["__EVENTTARGET"];
if (ctrlname != null && ctrlname != String.Empty)
{
string[] spiltspreadname = ctrlname.Split('$');
if (spiltspreadname.GetUpperBound(0) > 1)
{
string getrowxol = spiltspreadname[3].ToString().Trim();
string[] spr = getrowxol.Split(',');
if (spr.GetUpperBound(0) == 1)
{
int arow = Convert.ToInt32(spr[0]);
int acol = Convert.ToInt32(spr[1]);
if (arow == 0 && acol == 4)
{
string setval = e.EditValues[acol].ToString();
int setvalcel = 0;
if (setval.Trim().ToLower() == "true" || setval.Trim() == "1")
{
setvalcel = 1;
}
for (int r = 1; r < fpspread.Sheets[0].RowCount; r++)
{
fpspread.Sheets[0].Cells[r, acol].Value = setvalcel;
}
}
}
}
}
}
catch (Exception ex)
{
lblerr1.Visible = true;
lblerr1.Text = ex.ToString();
}
}
protected void Fpspread1_Command(object sender, FarPoint.Web.Spread.SpreadCommandEventArgs e)
{
try
{
Fpspread1.SaveChanges();
string activerow = "";
string activecol = "";
activerow = Fpspread1.ActiveSheetView.ActiveRow.ToString();
activecol = Fpspread1.ActiveSheetView.ActiveColumn.ToString();
int countnew = 0;
if (activecol == "7")
{
for (int i = 0; i < Fpspread1.Sheets[0].Rows.Count; i++)
{
if (Convert.ToInt32(Fpspread1.Sheets[0].Cells[Convert.ToInt32(i), Convert.ToInt32(activecol)].Value) == 1)
{
countnew++;
}
else
{
for (int k = 0; k < Fpspread1.Columns.Count; k++)
{
Fpspread1.Sheets[0].Cells[Convert.ToInt32(i), k].BackColor = ColorTranslator.FromHtml("White");
}
}
}
}
if (countnew > 1)
{
countnew--;
Fpspread1.Sheets[0].Cells[Convert.ToInt32(activerow), Convert.ToInt32(activecol)].Value = 0;
ScriptManager.RegisterStartupScript(this, typeof(Page), UniqueID, "alert('Only One User Should Be Selected')", true);
}
}
catch
{
}
}
protected void Fpspread1_command(object sender, FarPoint.Web.Spread.SpreadCommandEventArgs e)
{
try
{
Fpspread1.SaveChanges();
byte Check = Convert.ToByte(Fpspread1.Sheets[0].Cells[0, 1].Value);
if (Check == 1)
{
for (int s = 0; s < Fpspread1.Sheets[0].Rows.Count; s++)
{
Fpspread1.Sheets[0].Cells[s, 1].Value = 1;
}
}
else
{
for (int s = 0; s < Fpspread1.Sheets[0].Rows.Count; s++)
{
Fpspread1.Sheets[0].Cells[s, 1].Value = 0;
}
}
}
catch { }
}
protected void Fpspreadpop_ButtonCommand(object sender, FarPoint.Web.Spread.SpreadCommandEventArgs e)
{
Fpspreadpop.SaveChanges();
try
{
byte check = Convert.ToByte(Fpspreadpop.Sheets[0].Cells[0, 1].Value);
if (check == 1)
{
for (ik = 1; ik < Fpspreadpop.Sheets[0].RowCount; ik++)
{
Fpspreadpop.Sheets[0].Cells[ik, 1].Value = 1;
}
}
else
{
for (ik = 1; ik < Fpspreadpop.Sheets[0].RowCount; ik++)
{
Fpspreadpop.Sheets[0].Cells[ik, 1].Value = 0;
}
}
}
catch { }
}
protected void FpSpread1_InsertCommand(object sender, FarPoint.Web.Spread.SpreadCommandEventArgs e)
{
e.EditValues[12] = DateTime.Now;
e.EditValues[13] = DateTime.Now;
}
protected void fpcammarkstaff_CellClick(object sender, FarPoint.Web.Spread.SpreadCommandEventArgs e)
{
cellclick = true;
Accordion1.SelectedIndex = 1;
}
protected void FpSpread1_ErrorCommand(object sender, FarPoint.Web.Spread.SpreadCommandEventArgs e)
{
}
protected void FpSpread1_UpdateCommand(object sender, FarPoint.Web.Spread.SpreadCommandEventArgs e)
{
try
{
string actrow1;
actrow1 = e.SheetView.ActiveRow.ToString();
if (flag_true == false && actrow1 == "0")
{
for (int j = 1; j < Convert.ToInt16(FpSpread2.Sheets[0].RowCount); j++)
{
string actcol1 = e.SheetView.ActiveColumn.ToString();
string seltext = e.EditValues[Convert.ToInt16(actcol1)].ToString();
if (seltext != "System.Object")
{
FpSpread2.Sheets[0].Cells[j, Convert.ToInt16(actcol1)].Text = seltext.ToString();
}
}
flag_true = true;
}
else if (actrow1 != "0")
{
string number = "True";
int actcol = Convert.ToInt16(e.SheetView.ActiveColumn.ToString());
int actrow = Convert.ToInt16(e.SheetView.ActiveRow.ToString());
string st1;
string st;
st = FpSpread2.GetEditValue(actrow, actcol).ToString();
// string sssshhs = sprdHallMaster.GetEditValue(1, 7).ToString();
st1 = e.EditValues[actcol].ToString();
if (st == number)
{
if (p == "")
{
p = actrow.ToString();
}
else
{
p = p + "-" + actrow.ToString();
}
ss = p.Split(new char[] { '-' });
int cnt12 = 0;
for (int i = 0; i < ss.Length; i++)
{
if (ss[i] != "")
{
cnt12 = cnt12 + 1;
FpSpread2.Sheets[0].Cells[Convert.ToInt16(ss[i]), 4].Text = cnt12.ToString();
}
}
}
else
{
for (int j = 0; j < ss.Length; j++)
{
int n;
if (ss[j] == "")
{
n = 0;
}
else
{
n = Convert.ToInt16(ss[j]);
}
if (n == actrow)
{
FpSpread2.Sheets[0].Cells[n, 4].Text = "";
ss[j] = "";
}
else
{
if (ss2 == "")
{
ss2 = ss[j].ToString();
}
else
{
ss2 = ss2 + "-" + ss[j].ToString();
}
}
}
int ccnt = 0;
ss1 = ss2.Split(new char[] { '-' });
for (int s = 0; s < ss1.Length; s++)
{
if (ss1[s] != "")
{
ccnt = ccnt + 1;
FpSpread2.Sheets[0].Cells[Convert.ToInt16(ss1[s]), 4].Text = ccnt.ToString();
}
}
p = ss2;
}
}
}
catch (Exception ex)
{
}
}
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;
}
}
}
}
}
