public string CalculateNextNumber()
{
try
{
string query = "select empNo from dbo.empMaster1 order by empNo desc";
var dr = db.GetDataReader(query);
while (dr.Read())
{
employeeNo = (dr.GetInt32(0) + 1).ToString();
break;
}
db.CloseCon();
}
catch (InvalidCastException)
{
MessageBox.Show("Invalid Casting or Explicit Conversion", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (SqlException)
{
MessageBox.Show("Check the Database Connecton", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (Exception)
{
MessageBox.Show("Error", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
return(employeeNo);
}
public string GetDesignation(string uName, string pass)
{
this.userName = uName; this.password = pass;
try
{
string Query = "select * from EmpMaster where userName= '******'and password = '******'";
var dr = db.GetDataReader(Query);
dr.Read();
designation = (dr["designation"].ToString());
db.CloseCon();
}
catch (InvalidOperationException)
{
MessageBox.Show("Invalid Operation", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (SqlException)
{
MessageBox.Show("Check the Database Connecton", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (Exception)
{
MessageBox.Show("Error", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
return(designation);
}
