public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
StID rpt = new StID();
rpt.Site = this.Site;
return(rpt);
}
private void btnSearch_Click(object sender, EventArgs e)
{
StID myid = new StID();
crystalReportViewer1.SelectionFormula = "{tblperson1.studentnumber} = '" + txtSearch.Text + "' ";
crystalReportViewer1.ReportSource = myid;
crystalReportViewer1.RefreshReport();
}
private void btnSave_Click(object sender, EventArgs e)
{
var nums = "0123456789";
var stringChars = new char[4];
var random = new Random();
for (int i = 0; i < stringChars.Length; i++)
{
stringChars[i] = nums[random.Next(nums.Length)];
}
var finalString = new String(stringChars);
var prefix = "C20";
var mychar = "ABCDEFGHIJKLMNOPQRSTUVWXYZ";
var chars = new char[1];
for (int i = 0; i < stringChars.Length; i++)
{
stringChars[i] = mychar[random.Next(mychar.Length)];
}
var postfix = new String(chars);
string studentNum = prefix + finalString;
// var year = "20";
idNumber.Text = studentNum;
FileStream fs;
BinaryReader br;
try
{
// string FileName = picPath.Text;
//'" + studentNum + "','" + txtName.Text + "','" + txtSurname.Text +"','"+
//drpProg.Text + "'," + txtLevel.Text + ",'" + txtSemester.Text +"'," + bacrode + ",'"+ImageData+"'
if (txtLevel.Text == "" && txtName.Text == "" && txtSurname.Text == "" && txtSurname.Text == "" && cmbPro.Text == "")
{
MessageBox.Show("Name should not be empty");
return;
}
else
{
byte[] ImageData = null;
fs = new FileStream(imgPath.Text, FileMode.Open, FileAccess.Read);
br = new BinaryReader(fs);
ImageData = br.ReadBytes((int)fs.Length);
br.Close();
fs.Close();
string cmdString = "INSERT INTO tblperson (studentnumber,name,surname,programme,level,semester,barcode,photo)" +
" Values(@studentNumber, @name, @surname, @programme, @lvl, @semester, @barcode, @photo)";
cmd = new MySqlCommand(cmdString, con);
cmd.Parameters.Add("@studentNumber", MySqlDbType.VarChar);
cmd.Parameters.Add("@name", MySqlDbType.VarChar);
cmd.Parameters.Add("@surname", MySqlDbType.VarChar);
cmd.Parameters.Add("@programme", MySqlDbType.VarChar);
cmd.Parameters.Add("@lvl", MySqlDbType.VarChar);
cmd.Parameters.Add("@semester", MySqlDbType.VarChar);
cmd.Parameters.Add("@barcode", MySqlDbType.VarChar);
cmd.Parameters.Add("@photo", MySqlDbType.Blob);
cmd.Parameters["@studentNumber"].Value = studentNum;
cmd.Parameters["@name"].Value = txtName.Text;
cmd.Parameters["@surname"].Value = txtSurname.Text;
cmd.Parameters["@programme"].Value = cmbPro.Text;
cmd.Parameters["@lvl"].Value = txtLevel.Text;
cmd.Parameters["@semester"].Value = txtSemester.Text;
cmd.Parameters["@barcode"].Value = studentNum;
cmd.Parameters["@photo"].Value = ImageData;
// qry.SaveData(qry.sqladd);
con.Open();
int RowsAffected = cmd.ExecuteNonQuery();
if (RowsAffected > 0)
{
MessageBox.Show("Image saved sucessfully!");
}
StID myid = new StID();
crystalReportViewer1.SelectionFormula = "{tblperson1.studentnumber} = '" + idNumber.Text + "'";
crystalReportViewer1.ReportSource = myid;
crystalReportViewer1.RefreshReport();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
