private bool checkedspr()
{
bool ok = false;
Fpspreadpop.SaveChanges();
try
{
for (ik = 0; ik < Fpspreadpop.Sheets[0].RowCount; ik++)
{
byte check = Convert.ToByte(Fpspreadpop.Sheets[0].Cells[ik, 1].Value);
if (check == 1)
{
ok = true;
}
}
}
catch { }
return(ok);
}
protected void btnexcel_Click(object sender, EventArgs e)
{
try
{
Fpspreadpop.SaveChanges();
string reportname = txtexcel.Text;
if (reportname.ToString().Trim() != "")
{
txtexcel.Text = "";
d2.printexcelreport(Fpspreadpop, reportname);
lblsmserror.Visible = false;
}
else
{
lblsmserror.Text = "Please Enter Your Report Name";
lblsmserror.Visible = true;
}
btnprintmaster.Focus();
}
catch { }
}
protected void btndelete_Click(object sender, EventArgs e)
{
try
{
if (checkedspr())
{
lblpoperr.Visible = false;
Fpspreadpop.SaveChanges();
string delq = "";
int delcount = 0;
for (ik = 0; ik < Fpspreadpop.Sheets[0].RowCount; ik++)
{
byte check = Convert.ToByte(Fpspreadpop.Sheets[0].Cells[ik, 1].Value);
if (check == 1)
{
string staffcode = Convert.ToString(Fpspreadpop.Sheets[0].Cells[ik, 2].Text);
delq = "update staffmaster set Fingerprint1='' where staff_code='" + staffcode + "'";
int upcount = d2.update_method_wo_parameter(delq, "Text");
if (upcount > 0)
{
delcount++;
}
}
}
if (delcount > 0)
{
alertpopwindow.Visible = true;
lblalerterr.Text = "Deleted Successfully!";
}
}
else
{
lblpoperr.Visible = true;
lblpoperr.Text = "Please Select Any Staff!";
}
}
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 { }
}
