public DataTable FindUserDetail(UserDetailBO oUserDetailBO)
{
try
{
query = @"SELECT * FROM UserDetail
WHERE name LIKE '%' + @name +'%'
ORDER BY name DESC";
dad = new SqlDataAdapter(query, con);
if (con.State == ConnectionState.Closed)
{
con.Open();
}
dad.SelectCommand.Parameters.AddWithValue("@name", oUserDetailBO.name);
dt = new DataTable();
dad.Fill(dt);
return dt;
}
catch
{
throw;
}
finally
{
con.Close();
}
}
public string[] LoginValidity(UserDetailBO oUserDetailBO)
{
try
{
return oUserDetailDAL.LoginValidity(oUserDetailBO);
}
catch
{
throw;
}
finally
{
}
}
public string InsertUserDetail(UserDetailBO oUserDetailBO)
{
try
{
return oUserDetailDAL.InsertUserDetail(oUserDetailBO);
}
catch
{
throw;
}
finally
{
}
}
public DataTable FindUserDetail(UserDetailBO oUserDetailBO)
{
try
{
return oUserDetailDAL.FindUserDetail(oUserDetailBO);
}
catch
{
throw;
}
finally
{
}
}
public void DeleteUserDetail(UserDetailBO oUserDetailBO)
{
try
{
oUserDetailDAL.DeleteUserDetail(oUserDetailBO);
}
catch
{
throw;
}
finally
{
}
}
public void DeleteUserDetail(UserDetailBO oUserDetailBO)
{
try
{
query = "DELETE FROM UserDetail WHERE userID=@UserID";
cmd = new SqlCommand(query, con);
if (con.State == ConnectionState.Closed)
{
con.Open();
}
cmd.Parameters.AddWithValue("@UserID", oUserDetailBO.userID);
cmd.ExecuteNonQuery();
}
catch
{
throw;
}
finally
{
con.Close();
}
}
public string InsertUserDetail(UserDetailBO oUserDetailBO)
{
try
{
cmd = new SqlCommand("InsertUserDetail", con);
cmd.CommandType = CommandType.StoredProcedure;
if (con.State == ConnectionState.Closed)
{
con.Open();
}
cmd.Parameters.AddWithValue("@employeeID", oUserDetailBO.employeeID);
cmd.Parameters.AddWithValue("@name", oUserDetailBO.name);
cmd.Parameters.AddWithValue("@designation", oUserDetailBO.designation);
cmd.Parameters.AddWithValue("@email", oUserDetailBO.email);
cmd.Parameters.AddWithValue("@mobileNo", oUserDetailBO.mobileNo);
cmd.Parameters.AddWithValue("@username", oUserDetailBO.username);
cmd.Parameters.AddWithValue("@password", oUserDetailBO.password);
cmd.Parameters.AddWithValue("@isAdmin", oUserDetailBO.isAdmin);
cmd.Parameters.AddWithValue("@status", oUserDetailBO.status);
SqlParameter message = cmd.Parameters.Add("@message", SqlDbType.VarChar, 500);
message.Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
return message.Value.ToString();
}
catch
{
throw;
}
finally
{
con.Close();
}
}
public void UpdateUserDetail(UserDetailBO oUserDetailBO)
{
try
{
query = "UPDATE UserDetail set status=@status WHERE userID=@userID";
cmd = new SqlCommand(query, con);
if (con.State == ConnectionState.Closed)
{
con.Open();
}
cmd.Parameters.AddWithValue("@userID", oUserDetailBO.userID);
cmd.Parameters.AddWithValue("@status", oUserDetailBO.status);
cmd.ExecuteNonQuery();
}
catch
{
throw;
}
finally
{
con.Close();
}
}
public string[] LoginValidity(UserDetailBO oUserDetailBO)
{
try
{
cmd = new SqlCommand("LoginValidity", con);
cmd.CommandType = CommandType.StoredProcedure;
if (con.State == ConnectionState.Closed)
{
con.Open();
}
cmd.Parameters.AddWithValue("@username", oUserDetailBO.username);
cmd.Parameters.AddWithValue("@password", oUserDetailBO.password);
SqlParameter userID = cmd.Parameters.Add("@userID", SqlDbType.VarChar, 500);
userID.Direction = ParameterDirection.Output;
SqlParameter isAdmin = cmd.Parameters.Add("@isAdmin", SqlDbType.VarChar, 500);
isAdmin.Direction = ParameterDirection.Output;
SqlParameter message = cmd.Parameters.Add("@message", SqlDbType.VarChar, 500);
message.Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
string[] outParm = new string[3];
outParm[0] = userID.Value.ToString();
outParm[1] = isAdmin.Value.ToString();
outParm[2] = message.Value.ToString();
return outParm;
}
catch
{
throw;
}
finally
{
con.Close();
}
}
