public int Delete()
{
string strDeleteQuery = string.Empty;
strDeleteQuery = "DELETE FROM [dbo].[EmployeeDetails] WHERE UserName = '******'";
objSQL = new SQL();
return objSQL.ExecutiveNonQuery(strDeleteQuery);
}
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);
}
