/// <summary>
/// Static method to call the DLL which has the
/// processing of the image.
/// </summary>
/// <param name="img">is the object with image information with a resolution of 320x240</param>
public static void Execute(MyImg img)
{
if (cpy == null || cpy.Length != img.Length)
{
cpy = new byte[img.Length];
}
YSobel(img.Length, img.Width, img.Height, img.ImageData, cpy);
}
private void OpenImageFile()
{
if (OFD.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
try
{
//bmp = new Bitmap(OFD.FileName);
img = new MyImg(new Bitmap(OFD.FileName));
PCT_BOX.Image = img.Image;
}
catch (Exception) { }
}
}
void camera_NewFrame(object sender, EventArgs e)
{
Invalidate();
if (camera != null)
{
try
{
camera.Lock();
img = new MyImg(camera.LastFrame);
g.DrawImage(img.Image, 0, 0, 320, 240);
img = new MyImg(bmp);
Booster.Execute(img);
PCT_BOX.Image = img.Image;
}
catch (Exception)
{
}
finally
{
camera.Unlock();
}
}
}
/// <summary>
/// 实时获取鼠标所在的当前位置，实时显示柱形图的提示
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void MyImg_MouseMove(object sender, EventArgs e)
{
if (lst_chartItems.Count == 0)
{
return;
}
Point mousePoint = MyImg.PointToClient(Control.MousePosition);
if (oldMousePoint.Equals(mousePoint))
{
return;
}
var findItem = lst_chartItems.Where(w => (mousePoint.X >= w.X) && (mousePoint.X <= w.X + w.Width) && (mousePoint.Y <= w.Y + w.Height) && (mousePoint.Y >= w.Y)).FirstOrDefault();
if (findItem != null)
{
toolTip.Show(findItem.ToolTipString, MyImg);
}
else
{
toolTip.Hide(MyImg);
}
oldMousePoint = mousePoint;
}
public void logo_set()
{
FpSpread1.Sheets[0].RowCount = 0;
FpSpread1.Sheets[0].Columns[0].Width = 50;
FpSpread1.Sheets[0].Columns[0].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].Columns[1].Width = 150;
FpSpread1.Sheets[0].Columns[2].Width = 40;
FpSpread1.Sheets[0].Columns[2].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].Columns[3].Width = 40;
FpSpread1.Sheets[0].Columns[3].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].Columns[4].Width = 30;
FpSpread1.Sheets[0].Columns[4].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].Columns[5].Width = 30;
FpSpread1.Sheets[0].Columns[5].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].Columns[6].Width = 30;
FpSpread1.Sheets[0].Columns[6].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].Columns[7].Width = 30;
FpSpread1.Sheets[0].Columns[7].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].Columns[8].Width = 30;
FpSpread1.Sheets[0].Columns[8].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].Columns[9].Width = 30;
FpSpread1.Sheets[0].Columns[9].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].Columns[10].Width = 30;
FpSpread1.Sheets[0].Columns[10].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].Columns[11].Width = 30;
FpSpread1.Sheets[0].Columns[11].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].ColumnHeaderSpanModel.Add(6, 0, 2, 1);
FpSpread1.Sheets[0].ColumnHeader.Cells[6, 0].Text = "Batch";
FpSpread1.Sheets[0].ColumnHeaderSpanModel.Add(6, 1, 2, 1);
FpSpread1.Sheets[0].ColumnHeader.Cells[6, 1].Text = "Branch";
FpSpread1.Sheets[0].ColumnHeaderSpanModel.Add(6, 2, 2, 1);
FpSpread1.Sheets[0].ColumnHeader.Cells[6, 2].Text = "Semester";
FpSpread1.Sheets[0].ColumnHeaderSpanModel.Add(6, 3, 2, 1);
FpSpread1.Sheets[0].ColumnHeader.Cells[6, 3].Text = "Total No.of Student";
FpSpread1.Sheets[0].ColumnHeaderSpanModel.Add(6, 4, 1, 2);
FpSpread1.Sheets[0].ColumnHeader.Cells[6, 4].Text = "Registered";
FpSpread1.Sheets[0].ColumnHeader.Cells[7, 4].Text = "No.";
FpSpread1.Sheets[0].ColumnHeader.Cells[7, 5].Text = "%";
FpSpread1.Sheets[0].ColumnHeaderSpanModel.Add(6, 6, 1, 2);
FpSpread1.Sheets[0].ColumnHeader.Cells[6, 6].Text = "Pass";
FpSpread1.Sheets[0].ColumnHeader.Cells[7, 6].Text = "No.";
FpSpread1.Sheets[0].ColumnHeader.Cells[7, 7].Text = "%";
FpSpread1.Sheets[0].ColumnHeaderSpanModel.Add(6, 8, 1, 2);
FpSpread1.Sheets[0].ColumnHeader.Cells[6, 8].Text = "Fail";
FpSpread1.Sheets[0].ColumnHeader.Cells[7, 8].Text = "No.";
FpSpread1.Sheets[0].ColumnHeader.Cells[7, 9].Text = "%";
FpSpread1.Sheets[0].ColumnHeaderSpanModel.Add(6, 10, 1, 2);
FpSpread1.Sheets[0].ColumnHeader.Cells[6, 10].Text = "Absent";
FpSpread1.Sheets[0].ColumnHeader.Cells[7, 10].Text = "No.";
FpSpread1.Sheets[0].ColumnHeader.Cells[7, 11].Text = "%";
FpSpread1.Sheets[0].ColumnHeader.Rows[6].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].ColumnHeader.Rows[7].HorizontalAlign = HorizontalAlign.Center;
//=header
FarPoint.Web.Spread.StyleInfo style = new FarPoint.Web.Spread.StyleInfo();
style.Font.Size = 10;
style.Font.Bold = true;
FpSpread1.Sheets[0].SheetCornerStyle = new FarPoint.Web.Spread.StyleInfo(style);
FpSpread1.Sheets[0].ColumnHeader.DefaultStyle = new FarPoint.Web.Spread.StyleInfo(style);
MyImg mi = new MyImg();
mi.ImageUrl = "~/images/10BIT001.jpeg";
mi.ImageUrl = "Handler/Handler2.ashx?";
MyImg1 mi2 = new MyImg1();
mi2.ImageUrl = "~/images/10BIT001.jpeg";
mi2.ImageUrl = "Handler/Handler5.ashx?";
string str = "select isnull(collname, ' ') as collname,isnull(category,'') as category,isnull(affliatedby,'') as affliated,isnull(address1, ' ') as address1,isnull(address2,' ') as address2,isnull(address3, ' ') as address3,isnull(district, ' ') as district,isnull(pincode,' ') as pincode from collinfo where college_code='" + Session["collegecode"].ToString() + "'";
con1.Close();
con1.Open();
SqlCommand comm = new SqlCommand(str, con1);
SqlDataReader drr = comm.ExecuteReader();
drr.Read();
string coll_name = Convert.ToString(drr["collname"]);
string coll_address1 = Convert.ToString(drr["address1"]);
string coll_address2 = Convert.ToString(drr["address2"]);
string coll_address3 = Convert.ToString(drr["address3"]);
string district = Convert.ToString(drr["district"]);
string pin_code = Convert.ToString(drr["pincode"]);
string catgory = drr["category"].ToString();
catgory = "(An " + catgory + " Institution" + " " + "-" + "";
string affliatedby = drr["affliated"].ToString();
string affliatedbynew = Regex.Replace(affliatedby, ",", " ");
string affiliated = catgory + " " + "Affiliated to" + " " + affliatedbynew + ")";
string address = coll_address1 + "," + " " + coll_address2 + "," + " " + district + "-" + " " + pin_code + ".";
FpSpread1.Sheets[0].ColumnHeaderSpanModel.Add(1, 0, 5, 1);
FpSpread1.Sheets[0].ColumnHeader.Cells[1, 1].Text = coll_name;
FpSpread1.Sheets[0].ColumnHeaderSpanModel.Add(1, 1, 1, FpSpread1.Sheets[0].ColumnCount - 3);
FpSpread1.Sheets[0].ColumnHeader.Cells[1, 1].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].ColumnHeader.Cells[1, 1].Border.BorderColorBottom = Color.White;
FpSpread1.Sheets[0].ColumnHeader.Cells[2, 1].Text = address;
FpSpread1.Sheets[0].ColumnHeaderSpanModel.Add(2, 1, 1, FpSpread1.Sheets[0].ColumnCount - 3);
FpSpread1.Sheets[0].ColumnHeader.Cells[2, 1].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].ColumnHeader.Cells[2, 1].Border.BorderColorBottom = Color.White;
FpSpread1.Sheets[0].ColumnHeader.Cells[3, 1].Text = affiliated;
FpSpread1.Sheets[0].ColumnHeaderSpanModel.Add(3, 1, 1, FpSpread1.Sheets[0].ColumnCount - 3);
FpSpread1.Sheets[0].ColumnHeader.Cells[3, 1].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].ColumnHeader.Cells[3, 1].Border.BorderColorBottom = Color.White;
FpSpread1.Sheets[0].ColumnHeader.Cells[4, 1].Text = "Result Analysis";
FpSpread1.Sheets[0].ColumnHeaderSpanModel.Add(4, 1, 1, FpSpread1.Sheets[0].ColumnCount - 3);
FpSpread1.Sheets[0].ColumnHeader.Cells[4, 1].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].ColumnHeader.Cells[4, 1].Border.BorderColorBottom = Color.White;
FpSpread1.Sheets[0].ColumnHeaderSpanModel.Add(5, 1, 1, FpSpread1.Sheets[0].ColumnCount - 3);
FpSpread1.Sheets[0].ColumnHeader.Cells[5, 1].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].ColumnHeader.Cells[5, 1].ForeColor = Color.FromArgb(64, 64, 255);
FpSpread1.Sheets[0].ColumnHeader.Rows[0].Border.BorderColorBottom = Color.White;
FpSpread1.Sheets[0].ColumnHeader.Rows[0].Border.BorderColorRight = Color.White;
// FpSpread1.Sheets[0].ColumnHeader.Cells[1, 16].Border.BorderColorBottom = Color.Black;
FpSpread1.Sheets[0].ColumnHeader.Cells[5, 1].Border.BorderColorBottom = Color.Black;
FpSpread1.Sheets[0].ColumnHeader.Cells[1, 0].Border.BorderColorBottom = Color.Black;
FpSpread1.Sheets[0].ColumnHeader.Cells[1, 0].Border.BorderColorRight = Color.White;
FpSpread1.Sheets[0].ColumnHeader.Cells[1, 1].Border.BorderColorRight = Color.White;
FpSpread1.Sheets[0].ColumnHeader.Cells[2, 1].Border.BorderColorRight = Color.White;
FpSpread1.Sheets[0].ColumnHeader.Cells[3, 1].Border.BorderColorRight = Color.White;
FpSpread1.Sheets[0].ColumnHeader.Cells[4, 1].Border.BorderColorRight = Color.White;
FpSpread1.Sheets[0].ColumnHeader.Cells[5, 1].Border.BorderColorRight = Color.White;
FpSpread1.Sheets[0].ColumnHeader.Rows[6].BackColor = Color.FromArgb(214, 235, 255);
FpSpread1.Sheets[0].ColumnHeader.Rows[6].Font.Bold = true;
FpSpread1.Sheets[0].ColumnHeader.Rows[6].Font.Size = FontUnit.Medium;
FpSpread1.Sheets[0].ColumnHeader.Rows[7].BackColor = Color.FromArgb(214, 235, 255);
FpSpread1.Sheets[0].ColumnHeader.Rows[7].Font.Bold = true;
FpSpread1.Sheets[0].ColumnHeader.Rows[7].Font.Size = FontUnit.Medium;
FpSpread1.Sheets[0].ColumnHeader.Cells[1, 0].CellType = mi;
FpSpread1.Sheets[0].ColumnHeaderSpanModel.Add(1, FpSpread1.Sheets[0].ColumnCount - 2, 5, 2);
FpSpread1.Sheets[0].ColumnHeader.Cells[1, FpSpread1.Sheets[0].ColumnCount - 2].CellType = mi2;
}
public void logo_settings()
{
FarPoint.Web.Spread.StyleInfo style = new FarPoint.Web.Spread.StyleInfo();
style.Font.Size = 10;
style.Font.Bold = true;
FpSpread1.Sheets[0].SheetCornerStyle = new FarPoint.Web.Spread.StyleInfo(style);
FpSpread1.Sheets[0].ColumnHeader.DefaultStyle = new FarPoint.Web.Spread.StyleInfo(style);
FpSpread1.Sheets[0].AllowTableCorner = true;
FpSpread1.ActiveSheetView.ColumnHeader.DefaultStyle.Font.Name = "Book Antiqua";
FpSpread1.ActiveSheetView.ColumnHeader.DefaultStyle.Font.Size = FontUnit.Medium;
FpSpread1.ActiveSheetView.ColumnHeader.DefaultStyle.Font.Bold = true;
FpSpread1.Sheets[0].DefaultStyle.Font.Name = "Book Antiqua";
FpSpread1.ActiveSheetView.DefaultStyle.Font.Size = FontUnit.Medium;
FpSpread1.Sheets[0].ColumnHeader.RowCount = 5;
FpSpread1.Sheets[0].ColumnCount = 4;
MyImg mi = new MyImg();
mi.ImageUrl = "~/images/10BIT001.jpeg";
mi.ImageUrl = "Handler/Handler2.ashx?";
MyImg mi2 = new MyImg();
mi2.ImageUrl = "~/images/10BIT001.jpeg";
mi2.ImageUrl = "Handler/Handler5.ashx?";
con_header.Close();
con_header.Open();
query_header = "select collname,category,affliatedby,address1,address2,address3,phoneno,faxno,email,website from collinfo where college_code=" + Session["collegecode"] + "";
SqlCommand com_header = new SqlCommand(query_header, con_header);
SqlDataReader sdr_header;
sdr_header = com_header.ExecuteReader();
while (sdr_header.Read())
{
FpSpread1.Sheets[0].ColumnHeaderSpanModel.Add(0, 0, 5, 1);
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 0].CellType = mi;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 0].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].ColumnHeaderSpanModel.Add(0, 1, 1, 2);
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 1].Text = sdr_header["collname"].ToString();
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 1].Font.Size = 10;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 1].Font.Bold = true;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 1].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 1].Border.BorderColorBottom = Color.White;
FpSpread1.Sheets[0].ColumnHeaderSpanModel.Add(1, 1, 1, 2);
string cc =
FpSpread1.Sheets[0].ColumnHeader.Cells[1, 1].Text = sdr_header["category"].ToString() + ", Affliated to" + sdr_header["affliatedby"].ToString();
FpSpread1.Sheets[0].ColumnHeader.Cells[1, 1].Font.Size = 10;
FpSpread1.Sheets[0].ColumnHeader.Cells[1, 1].Font.Bold = true;
FpSpread1.Sheets[0].ColumnHeader.Cells[1, 1].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].ColumnHeader.Cells[1, 1].Border.BorderColorBottom = Color.White;
FpSpread1.Sheets[0].ColumnHeaderSpanModel.Add(2, 1, 1, 2);
FpSpread1.Sheets[0].ColumnHeader.Cells[2, 1].Text = sdr_header["address1"].ToString() + "-" + sdr_header["address2"].ToString() + "-" + sdr_header["address1"].ToString();
FpSpread1.Sheets[0].ColumnHeader.Cells[2, 1].Font.Size = 10;
FpSpread1.Sheets[0].ColumnHeader.Cells[2, 1].Font.Bold = true;
FpSpread1.Sheets[0].ColumnHeader.Cells[2, 1].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].ColumnHeader.Cells[2, 1].Border.BorderColorBottom = Color.White;
FpSpread1.Sheets[0].ColumnHeaderSpanModel.Add(3, 1, 1, 2);
FpSpread1.Sheets[0].ColumnHeader.Cells[3, 1].Text = "Phone : " + sdr_header["phoneno"].ToString() + " Fax : " + sdr_header["faxno"].ToString();
FpSpread1.Sheets[0].ColumnHeader.Cells[3, 1].Font.Size = 10;
FpSpread1.Sheets[0].ColumnHeader.Cells[3, 1].Font.Bold = true;
FpSpread1.Sheets[0].ColumnHeader.Cells[3, 1].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].ColumnHeader.Cells[3, 1].Border.BorderColorBottom = Color.White;
FpSpread1.Sheets[0].ColumnHeaderSpanModel.Add(4, 1, 1, 2);//5th row span
FpSpread1.Sheets[0].ColumnHeader.Cells[4, 1].Text = "E-Mail : " + sdr_header["email"].ToString() + " Web Site : " + sdr_header["website"].ToString();
FpSpread1.Sheets[0].ColumnHeader.Cells[4, 1].Font.Size = 10;
FpSpread1.Sheets[0].ColumnHeader.Cells[4, 1].Font.Bold = true;
FpSpread1.Sheets[0].ColumnHeader.Cells[4, 1].HorizontalAlign = HorizontalAlign.Center;
FpSpread1.Sheets[0].ColumnHeaderSpanModel.Add(0, 3, 5, 1);
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 3].CellType = mi2;
FpSpread1.Sheets[0].ColumnHeader.Cells[0, 3].HorizontalAlign = HorizontalAlign.Center;
}
}
protected void Button1_Click(object sender, EventArgs e)
{
individualsubstud.Sheets[0].ColumnCount = 6;
individualsubstud.Sheets[0].Columns[0].Locked = true;
individualsubstud.Sheets[0].Columns[1].Locked = true;
individualsubstud.Sheets[0].Columns[2].Locked = true;
individualsubstud.Sheets[0].Columns[3].Locked = true;
individualsubstud.Sheets[0].Columns[4].Locked = true;
individualsubstud.Sheets[0].Columns[5].Locked = true;
individualsubstud.Visible = false;
individualsubstud.Sheets[0].SheetCorner.RowCount = 11;
individualsubstud.Sheets[0].ColumnHeaderSpanModel.Add(6, 1, 1, 5);
individualsubstud.Sheets[0].ColumnHeaderSpanModel.Add(7, 1, 1, 5);
individualsubstud.Sheets[0].ColumnHeaderSpanModel.Add(8, 1, 1, 5);
individualsubstud.Sheets[0].ColumnHeaderSpanModel.Add(9, 1, 1, 5);
individualsubstud.Sheets[0].Columns[0].Width = 70;
individualsubstud.Sheets[0].Columns[1].Width = 100;
individualsubstud.Sheets[0].Columns[2].Width = 150;
individualsubstud.Sheets[0].Columns[3].Width = 100;
individualsubstud.Sheets[0].Columns[4].Width = 170;
individualsubstud.Sheets[0].Columns[5].Width = 70;
individualsubstud.Sheets[0].AutoPostBack = true;
//if (Session["Rollflag"] == "0")
//{
// individualsubstud.Width = 700;
// individualsubstud.Sheets[0].Columns[1].Visible = false;
//}
if (Session["Regflag"] == "0")
{
individualsubstud.Width = 510;
individualsubstud.Sheets[0].Columns[2].Visible = false;
}
if (Session["Studflag"].ToString() == "0")
{
individualsubstud.Width = 570;
individualsubstud.Sheets[0].Columns[3].Visible = false;
}
if (Session["Regflag"].ToString() == "0" && Session["Rollflag"].ToString() == "0" && Session["Studflag"].ToString() == "0")
{
individualsubstud.Width = 510;
individualsubstud.Sheets[0].Columns[1].Width = 200;
individualsubstud.Sheets[0].Columns[1].Visible = true;
}
FarPoint.Web.Spread.StyleInfo style = new FarPoint.Web.Spread.StyleInfo();
style.Font.Size = 10;
style.Font.Bold = true;
individualsubstud.Sheets[0].SheetCornerStyle = new FarPoint.Web.Spread.StyleInfo(style);
individualsubstud.Sheets[0].ColumnHeader.DefaultStyle = new FarPoint.Web.Spread.StyleInfo(style);
individualsubstud.Sheets[0].AllowTableCorner = true;
individualsubstud.Sheets[0].SheetCorner.Cells[0, 0].Text = " ";
MyImg mi = new MyImg();
mi.ImageUrl = "~/images/10BIT001.jpeg";
mi.ImageUrl = "Handler/Handler2.ashx?";
MyImg mi1 = new MyImg();
mi1.ImageUrl = "~/images/10BIT001.jpeg";
mi1.ImageUrl = "Handler/Handler5.ashx?";
string str = "select isnull(collname, ' ') as collname,isnull(address1, ' ') as address1,isnull(address2,' ') as address2,isnull(address3, ' ') as address3,isnull(pincode,' ') as pincode from collinfo where college_code='" + Session["collegecode"].ToString() + "'";
con1.Close();
con1.Open();
SqlCommand comm = new SqlCommand(str, con1);
SqlDataReader drr = comm.ExecuteReader();
drr.Read();
string coll_name = Convert.ToString(drr["collname"]);
string coll_address1 = Convert.ToString(drr["address1"]);
string coll_address2 = Convert.ToString(drr["address2"]);
string coll_address3 = Convert.ToString(drr["address3"]);
string pin_code = Convert.ToString(drr["pincode"]);
individualsubstud.Sheets[0].ColumnHeaderSpanModel.Add(0, 0, 6, 1);
individualsubstud.Sheets[0].ColumnHeaderSpanModel.Add(0, individualsubstud.Sheets[0].ColumnCount - 1, 1, 6);
individualsubstud.Sheets[0].ColumnHeader.Cells[0, 1].Text = coll_name;
individualsubstud.Sheets[0].ColumnHeaderSpanModel.Add(0, 1, 1, individualsubstud.Sheets[0].ColumnCount - 2);
individualsubstud.Sheets[0].ColumnHeader.Cells[0, 1].HorizontalAlign = HorizontalAlign.Center;
individualsubstud.Sheets[0].ColumnHeader.Cells[0, 1].Border.BorderColorBottom = Color.White;
individualsubstud.Sheets[0].ColumnHeader.Cells[1, 1].Text = coll_address1;
individualsubstud.Sheets[0].ColumnHeaderSpanModel.Add(1, 1, 1, individualsubstud.Sheets[0].ColumnCount - 2);
individualsubstud.Sheets[0].ColumnHeader.Cells[1, 1].HorizontalAlign = HorizontalAlign.Center;
individualsubstud.Sheets[0].ColumnHeader.Cells[1, 1].Border.BorderColorBottom = Color.White;
individualsubstud.Sheets[0].ColumnHeader.Cells[2, 1].Text = coll_address2;
individualsubstud.Sheets[0].ColumnHeaderSpanModel.Add(2, 1, 1, individualsubstud.Sheets[0].ColumnCount - 2);
individualsubstud.Sheets[0].ColumnHeader.Cells[2, 1].HorizontalAlign = HorizontalAlign.Center;
individualsubstud.Sheets[0].ColumnHeader.Cells[2, 1].Border.BorderColorBottom = Color.White;
individualsubstud.Sheets[0].ColumnHeader.Cells[3, 1].Text = coll_address3 + "-" + " " + pin_code + ".";
individualsubstud.Sheets[0].ColumnHeaderSpanModel.Add(3, 1, 1, individualsubstud.Sheets[0].ColumnCount - 2);
individualsubstud.Sheets[0].ColumnHeader.Cells[3, 1].HorizontalAlign = HorizontalAlign.Center;
individualsubstud.Sheets[0].ColumnHeader.Cells[3, 1].Border.BorderColorBottom = Color.White;
//individualsubstud.Sheets[0].ColumnHeader.Cells[4, 1].Text = "Salary Summary For-" + monname + "--" + cblbatchyear.Text + "";
individualsubstud.Sheets[0].ColumnHeaderSpanModel.Add(4, 1, 1, individualsubstud.Sheets[0].ColumnCount - 2);
individualsubstud.Sheets[0].ColumnHeaderSpanModel.Add(5, 1, 1, individualsubstud.Sheets[0].ColumnCount - 2);
individualsubstud.Sheets[0].ColumnHeader.Cells[4, 1].HorizontalAlign = HorizontalAlign.Center;
individualsubstud.Sheets[0].ColumnHeader.Cells[4, 1].ForeColor = Color.FromArgb(64, 64, 255);
individualsubstud.Sheets[0].ColumnHeader.Cells[4, 1].Border.BorderColorBottom = Color.White;
individualsubstud.Sheets[0].ColumnHeader.Rows[10].BackColor = Color.FromArgb(214, 235, 255);
individualsubstud.Sheets[0].ColumnHeader.Rows[10].Font.Bold = true;
individualsubstud.Sheets[0].ColumnHeader.Rows[10].Font.Size = FontUnit.Medium;
individualsubstud.Sheets[0].ColumnHeader.Cells[0, 0].CellType = mi;
individualsubstud.Sheets[0].ColumnHeaderSpanModel.Add(0, individualsubstud.Sheets[0].ColumnCount - 1, 6, 1);
individualsubstud.Sheets[0].ColumnHeader.Cells[0, individualsubstud.Sheets[0].ColumnCount - 1].CellType = mi1;
individualsubstud.Sheets[0].DefaultStyle.Font.Size = FontUnit.Medium;
individualsubstud.Sheets[0].ColumnHeader.DefaultStyle.Font.Size = FontUnit.Medium;
individualsubstud.Sheets[0].ColumnHeader.DefaultStyle.Font.Name = "Book Antiqua";
individualsubstud.Sheets[0].ColumnHeader.DefaultStyle.Font.Bold = true;
individualsubstud.Sheets[0].RowCount = 0;
individualsubstud.Sheets[0].ColumnHeaderSpanModel.Add(10, 4, 1, 2);
individualsubstud.Sheets[0].ColumnHeader.Rows[10].HorizontalAlign = HorizontalAlign.Center;
individualsubstud.Sheets[0].ColumnHeader.Cells[10, 0].Text = "S.No";
individualsubstud.Sheets[0].ColumnHeader.Cells[10, 1].Text = "Roll No";
individualsubstud.Sheets[0].ColumnHeader.Cells[10, 2].Text = "Reg No";
individualsubstud.Sheets[0].ColumnHeader.Cells[10, 3].Text = "Student Type";
individualsubstud.Sheets[0].ColumnHeader.Cells[10, 4].Text = "Student Name";
individualsubstud.Sheets[0].RowHeader.Visible = false;
HAllSpread.SaveChanges();
int sno = 0;
int count = 0;
for (int res = 1; res <= Convert.ToInt32(HAllSpread.Sheets[0].RowCount) - 1; res++)
{
int isval = 0;
string s = HAllSpread.Sheets[0].Cells[res, 9].Text;
isval = Convert.ToInt32(HAllSpread.Sheets[0].Cells[res, 9].Value);
if (isval == 1)
{
string year1 = "";
string semester1 = "";
string degreecourse1 = "";
string subject1 = "";
string subject_no = HAllSpread.Sheets[0].Cells[res, 5].Note;
int semester = Convert.ToInt32(HAllSpread.Sheets[0].Cells[res, 4].Text);
//individualsubstud.Sheets[0].AutoPostBack = true;
individualsubstud.CommandBar.Visible = true;
//string activerow = "";
//string activecol = "";
//activerow = HAllSpread.ActiveSheetView.ActiveRow.ToString();
//activecol = HAllSpread.ActiveSheetView.ActiveColumn.ToString();
//string subject_no = HAllSpread.Sheets[0].Cells[Convert.ToInt32(activerow), 5].Note;
//int semester = Convert.ToInt32(HAllSpread.Sheets[0].Cells[Convert.ToInt32(activerow), 4].Text);
string year = HAllSpread.Sheets[0].Cells[res, 1].Text;
string degree = HAllSpread.Sheets[0].Cells[res, 2].Text;
string course = HAllSpread.Sheets[0].Cells[res, 3].Text;
string courseacro = HAllSpread.Sheets[0].Cells[res, 3].Note;
string subject = HAllSpread.Sheets[0].Cells[res, 5].Text;
string arreartag = Convert.ToString(HAllSpread.Sheets[0].Cells[res, 5].Tag);
string degreecourse = degree + "-" + courseacro;
individualsubstud.Sheets[0].ColumnHeader.Cells[6, 0].Text = "Year";
individualsubstud.Sheets[0].ColumnHeader.Cells[7, 0].Text = "Branch";
individualsubstud.Sheets[0].ColumnHeader.Cells[8, 0].Text = "Semester";
individualsubstud.Sheets[0].ColumnHeader.Cells[9, 0].Text = "Subject";
if (hashyear.Contains(year))
{
}
else
{
hashyear.Add(year, count);
count++;
}
foreach (DictionaryEntry parameter in hashyear)
{
string selectyear = Convert.ToString(parameter.Key);
if (year1 == "")
{
year1 = selectyear;
}
else if (year1 != "")
{
if (year1 != year)
{
year1 = year1 + "," + " " + selectyear;
}
}
}
if (hash.Contains(degreecourse))
{
}
else
{
hash.Add(degreecourse, count);
count++;
}
foreach (DictionaryEntry parameter in hash)
{
string selectdegreecourse = Convert.ToString(parameter.Key);
if (degreecourse1 == "")
{
degreecourse1 = selectdegreecourse;
}
else if (degreecourse1 != "")
{
if (degreecourse1 != degreecourse)
{
degreecourse1 = degreecourse1 + "," + " " + selectdegreecourse;
}
}
}
if (hashsubject.Contains(subject))
{
}
else
{
hashsubject.Add(subject, count);
count++;
}
foreach (DictionaryEntry parameter in hashsubject)
{
string selectsubject = Convert.ToString(parameter.Key);
if (subject1 == "")
{
subject1 = selectsubject;
}
else if (subject1 != "")
{
if (subject1 != subject)
{
subject1 = subject1 + "," + " " + selectsubject;
}
}
}
if (hashsemester.Contains(semester))
{
}
else
{
hashsemester.Add(semester, count);
count++;
}
foreach (DictionaryEntry parameter in hashsemester)
{
string selectsemester = Convert.ToString(parameter.Key);
if (semester1 == "")
{
semester1 = Convert.ToString(selectsemester);
}
else if (semester1 != "")
{
if (semester1 != Convert.ToString(semester))
{
semester1 = semester1 + "," + Convert.ToString(selectsemester);
}
}
}
individualsubstud.Sheets[0].ColumnHeader.Cells[6, 1].Text = ":" + " " + year1;
individualsubstud.Sheets[0].ColumnHeader.Cells[7, 1].Text = ":" + " " + degreecourse1;
individualsubstud.Sheets[0].ColumnHeader.Cells[8, 1].Text = ":" + " " + semester1;
individualsubstud.Sheets[0].ColumnHeader.Cells[9, 1].Text = ":" + " " + subject1;
individualsubstud.Sheets[0].ColumnHeader.Rows[6].Border.BorderColorBottom = Color.White;
individualsubstud.Sheets[0].ColumnHeader.Rows[7].Border.BorderColorBottom = Color.White;
individualsubstud.Sheets[0].ColumnHeader.Rows[8].Border.BorderColorBottom = Color.White;
individualsubstud.Sheets[0].ColumnHeader.Rows[6].Border.BorderColorRight = Color.White;
individualsubstud.Sheets[0].ColumnHeader.Rows[7].Border.BorderColorRight = Color.White;
individualsubstud.Sheets[0].ColumnHeader.Rows[8].Border.BorderColorRight = Color.White;
individualsubstud.Sheets[0].ColumnHeader.Rows[9].Border.BorderColorRight = Color.White;
string type = "0";
int i = 0;
int j = 0;
// string type1 = "";
if (Session["Stud_Type"] != "0" && Session["Stud_Type1"] != "0")
{
j = 2;
}
if (Session["Stud_Type"] != "1" && Session["Stud_Type1"] != "1")
{
j = 2;
}
if (j != 2)
{
if (Session["Stud_Type1"] != "Hostler")
{
i = 1;
type = Session["Stud_Type1"].ToString();
}
else if (Session["Stud_Type"] != "Day Scholar")
{
i = 1;
type = Session["Stud_Type"].ToString();
}
}
if (arreartag == "0")
{
SqlCommand studentscmd = new SqlCommand("procindividualsubstud", con);
studentscmd.CommandType = CommandType.StoredProcedure;
studentscmd.Parameters.AddWithValue("@subject_no", subject_no);
studentscmd.Parameters.AddWithValue("@semester", semester);
if (type != "")
{
studentscmd.Parameters.AddWithValue("@stud_type", type);
}
studentscmd.Parameters.AddWithValue("@i", i);
//studentscmd.Parameters.AddWithValue("@stud_type1", type1);
SqlDataAdapter studentsda = new SqlDataAdapter(studentscmd);
DataSet studentsds = new DataSet();
studentsda.Fill(studentsds);
if (studentsds.Tables[0].Rows.Count > 0)
{
individualsubstud.Visible = true;
for (int dd = 0; dd < studentsds.Tables[0].Rows.Count; dd++)
{
sno++;
individualsubstud.Sheets[0].RowCount = individualsubstud.Sheets[0].RowCount + 1;
individualsubstud.Sheets[0].SpanModel.Add(individualsubstud.Sheets[0].RowCount - 1, 4, 1, 2);
individualsubstud.Sheets[0].Cells[individualsubstud.Sheets[0].RowCount - 1, 0].Text = sno + "";
individualsubstud.Sheets[0].Cells[individualsubstud.Sheets[0].RowCount - 1, 1].Text = studentsds.Tables[0].Rows[dd]["roll_no"].ToString();
individualsubstud.Sheets[0].Cells[individualsubstud.Sheets[0].RowCount - 1, 1].HorizontalAlign = HorizontalAlign.Center;
individualsubstud.Sheets[0].Cells[individualsubstud.Sheets[0].RowCount - 1, 2].Text = studentsds.Tables[0].Rows[dd]["reg_no"].ToString();
individualsubstud.Sheets[0].Cells[individualsubstud.Sheets[0].RowCount - 1, 2].HorizontalAlign = HorizontalAlign.Center;
individualsubstud.Sheets[0].Cells[individualsubstud.Sheets[0].RowCount - 1, 3].Text = studentsds.Tables[0].Rows[dd]["Stud_type"].ToString();
individualsubstud.Sheets[0].Cells[individualsubstud.Sheets[0].RowCount - 1, 4].Text = studentsds.Tables[0].Rows[dd]["Stud_name"].ToString();
individualsubstud.Sheets[0].Cells[individualsubstud.Sheets[0].RowCount - 1, 0].HorizontalAlign = HorizontalAlign.Center;
}
}
}
if (arreartag == "1")
{
SqlCommand studentscmdforarrear = new SqlCommand("procindividualsubstudforarrear", con);
studentscmdforarrear.CommandType = CommandType.StoredProcedure;
studentscmdforarrear.Parameters.AddWithValue("@subject_no", subject_no);
if (type != "")
{
studentscmdforarrear.Parameters.AddWithValue("@stud_type", type);
}
studentscmdforarrear.Parameters.AddWithValue("@i", i);
SqlDataAdapter studentsdaforarrear = new SqlDataAdapter(studentscmdforarrear);
DataSet studentsdsforarrear = new DataSet();
studentsdaforarrear.Fill(studentsdsforarrear);
if (studentsdsforarrear.Tables[0].Rows.Count > 0)
{
individualsubstud.Visible = true;
for (int dd2 = 0; dd2 < studentsdsforarrear.Tables[0].Rows.Count; dd2++)
{
sno++;
individualsubstud.Sheets[0].RowCount = individualsubstud.Sheets[0].RowCount + 1;
individualsubstud.Sheets[0].SpanModel.Add(individualsubstud.Sheets[0].RowCount - 1, 4, 1, 2);
individualsubstud.Sheets[0].Cells[individualsubstud.Sheets[0].RowCount - 1, 0].Text = sno + "";
individualsubstud.Sheets[0].Cells[individualsubstud.Sheets[0].RowCount - 1, 1].Text = studentsdsforarrear.Tables[0].Rows[dd2]["roll_no"].ToString();
individualsubstud.Sheets[0].Cells[individualsubstud.Sheets[0].RowCount - 1, 2].Text = studentsdsforarrear.Tables[0].Rows[dd2]["reg_no"].ToString();
individualsubstud.Sheets[0].Cells[individualsubstud.Sheets[0].RowCount - 1, 3].Text = studentsdsforarrear.Tables[0].Rows[dd2]["Stud_type"].ToString();
individualsubstud.Sheets[0].Cells[individualsubstud.Sheets[0].RowCount - 1, 4].Text = studentsdsforarrear.Tables[0].Rows[dd2]["Stud_name"].ToString();
individualsubstud.Sheets[0].Cells[individualsubstud.Sheets[0].RowCount - 1, 0].HorizontalAlign = HorizontalAlign.Center;
}
}
}
int totalrows = individualsubstud.Sheets[0].RowCount;
individualsubstud.Sheets[0].PageSize = totalrows * 100;
individualsubstud.Height = totalrows + 50 * 15;
}
}
}
public void logo_settings()
{
string query_header = "";
FarPoint.Web.Spread.StyleInfo style = new FarPoint.Web.Spread.StyleInfo();
style.Font.Size = 10;
style.Font.Bold = true;
sprdviewrcrd.Sheets[0].SheetCornerStyle = new FarPoint.Web.Spread.StyleInfo(style);
sprdviewrcrd.Sheets[0].ColumnHeader.DefaultStyle = new FarPoint.Web.Spread.StyleInfo(style);
sprdviewrcrd.Sheets[0].AllowTableCorner = true;
sprdviewrcrd.ActiveSheetView.ColumnHeader.DefaultStyle.Font.Name = "Book Antiqua";
sprdviewrcrd.ActiveSheetView.ColumnHeader.DefaultStyle.Font.Size = FontUnit.Medium;
sprdviewrcrd.ActiveSheetView.ColumnHeader.DefaultStyle.Font.Bold = true;
sprdviewrcrd.Sheets[0].DefaultStyle.Font.Name = "Book Antiqua";
sprdviewrcrd.ActiveSheetView.DefaultStyle.Font.Size = FontUnit.Medium;
sprdviewrcrd.Sheets[0].ColumnHeader.Rows[5].BackColor = Color.AliceBlue;
col_cnt = Convert.ToInt32(Session["col_cnt"].ToString());
sprdviewrcrd.Sheets[0].ColumnCount = 4 + col_cnt;
MyImg mi = new MyImg();
mi.ImageUrl = "~/images/10BIT001.jpeg";
mi.ImageUrl = "Handler/Handler2.ashx?";
MyImg mi2 = new MyImg();
mi2.ImageUrl = "~/images/10BIT001.jpeg";
mi2.ImageUrl = "Handler/Handler5.ashx?";
con_header.Close();
con_header.Open();
query_header = "select collname,address3,pincode from collinfo where college_code=" + Session["collegecode"] + "";
SqlCommand com_header = new SqlCommand(query_header, con_header);
SqlDataReader sdr_header;
sdr_header = com_header.ExecuteReader();
while (sdr_header.Read())
{
sprdviewrcrd.Sheets[0].ColumnHeaderSpanModel.Add(0, 0, 5, 2);
sprdviewrcrd.Sheets[0].ColumnHeader.Cells[0, 0].CellType = mi;
sprdviewrcrd.Sheets[0].ColumnHeaderSpanModel.Add(0, 2, 1, sprdviewrcrd.Sheets[0].ColumnCount - 3);
sprdviewrcrd.Sheets[0].ColumnHeader.Cells[0, 2].Text = sdr_header.GetString(0) + ".";
sprdviewrcrd.Sheets[0].ColumnHeader.Cells[0, 2].HorizontalAlign = HorizontalAlign.Center;
sprdviewrcrd.Sheets[0].ColumnHeader.Cells[0, 2].Border.BorderColorBottom = Color.White;
sprdviewrcrd.Sheets[0].ColumnHeaderSpanModel.Add(1, 2, 1, sprdviewrcrd.Sheets[0].ColumnCount - 3);
sprdviewrcrd.Sheets[0].ColumnHeader.Cells[1, 2].Text = sdr_header.GetString(1) + " - " + sdr_header.GetString(2) + ".";
sprdviewrcrd.Sheets[0].ColumnHeader.Cells[1, 2].HorizontalAlign = HorizontalAlign.Center;
sprdviewrcrd.Sheets[0].ColumnHeader.Cells[1, 2].Border.BorderColorBottom = Color.White;
sprdviewrcrd.Sheets[0].ColumnHeaderSpanModel.Add(2, 2, 1, sprdviewrcrd.Sheets[0].ColumnCount - 3);
sprdviewrcrd.Sheets[0].ColumnHeader.Cells[2, 2].Text = "";
sprdviewrcrd.Sheets[0].ColumnHeader.Cells[2, 2].Border.BorderColorBottom = Color.White;
sprdviewrcrd.Sheets[0].ColumnHeaderSpanModel.Add(3, 2, 1, sprdviewrcrd.Sheets[0].ColumnCount - 3);
sprdviewrcrd.Sheets[0].ColumnHeader.Cells[3, 2].Text = "Students Arrear Status";
sprdviewrcrd.Sheets[0].ColumnHeader.Cells[3, 2].HorizontalAlign = HorizontalAlign.Center;
sprdviewrcrd.Sheets[0].ColumnHeader.Cells[3, 2].Border.BorderColorBottom = Color.White;
sprdviewrcrd.Sheets[0].ColumnHeaderSpanModel.Add(4, 2, 1, sprdviewrcrd.Sheets[0].ColumnCount - 3);//5th row span
sprdviewrcrd.Sheets[0].ColumnHeader.Cells[4, 2].Text = "";
sprdviewrcrd.Sheets[0].ColumnHeader.Cells[4, 2].ForeColor = Color.White;
sprdviewrcrd.Sheets[0].ColumnHeaderSpanModel.Add(0, sprdviewrcrd.Sheets[0].ColumnCount - 1, 5, 1);
sprdviewrcrd.Sheets[0].ColumnHeader.Cells[0, sprdviewrcrd.Sheets[0].ColumnCount - 1].CellType = mi2;
}
}
