public int Delete()
{
string strDeleteQuery = string.Empty;
strDeleteQuery = "DELETE FROM [dbo].[EmployeeDetails] WHERE UserName = '******'";
objSQL = new SQL();
return objSQL.ExecutiveNonQuery(strDeleteQuery);
}
public bool IsValidUser()
{
string strQuery = "SELECT * FROM [dbo].[EmployeeDetails] WHERE UserName = '******' and Pass_word = '" + strPass_word + "'";
objSQL = new SQL();
DataTable dtUserInformation = new DataTable();
dtUserInformation = objSQL.GetData(strQuery);
bool bValid = false;
if (dtUserInformation != null)
{
if (dtUserInformation.Rows.Count > 0)
{
bValid = true;
}
}
return bValid;
}
public int Insert()
{
string strInsertyQuery = "INSERT INTO [dbo].[EmployeeDetails] (";
string strColumns = string.Empty;
string strValues = string.Empty;
strColumns = "UserName,";
strValues = "'" + strUserName + "',";
strColumns = strColumns + "FirstName,";
strValues = strValues + "'" + strfirstname + "',";
strColumns = strColumns + "LastName,";
strValues = strValues + "'" + strlastname + "',";
strColumns = strColumns + "Pass_word,";
strValues = strValues + "'" + strPass_word + "',";
strColumns = strColumns + "Gender,";
strValues = strValues + "'" + strGender + "',";
strColumns = strColumns + "DateOfBirth,";
strValues = strValues + "'" + strDateOfBirth + "',";
strColumns = strColumns + "Email,";
strValues = strValues + "'" + strEmail + "',";
strColumns = strColumns + "Mobile";
strValues = strValues + "'" + strMobile + "'";
strInsertyQuery = strInsertyQuery + strColumns + ") VALUES (" + strValues + ")";
objSQL = new SQL();
return objSQL.ExecutiveNonQuery(strInsertyQuery);
}
public DataTable GetDataWithWhere(string type, string keyword)
{
string strQuery = "SELECT * FROM [dbo].[EmployeeDetails] WHERE " + type + "= "+"'" + keyword + "'";
objSQL = new SQL();
return objSQL.GetData(strQuery);
}
public DataTable GetDataByColumn(string columnName)
{
string strQuery = "SELECT "+columnName+ " FROM [dbo].[EmployeeDetails]";
objSQL = new SQL();
return objSQL.GetData(strQuery);
}
public DataTable GetData()
{
string strQuery = "SELECT * FROM [dbo].[EmployeeDetails]";
objSQL = new SQL();
return objSQL.GetData(strQuery);
}
