public bool Update(UserbLL u)
{
//create a boolean variable and set its default value to false
bool isSuccess = false;
//create an object of sql connection to connect database
SqlConnection conn = new SqlConnection(myconstn);
try
{
//create the string variable to hold the sql query
string SQL = "UPDATE userTbl SET userName=@userName,email=@email,upassword=@upassword,ucpassword=@ucpassword,contact=@contact,uaddress=@uaddress,addDate=@addDate,Gender=@Gender,imSource=@imSource WHERE userId=@userId ";
//create a sql command to pass the value in query
SqlCommand cmd = new SqlCommand(SQL, conn);
//now pass the vale to sql query
cmd.Parameters.AddWithValue("@userName", u.UserName);
cmd.Parameters.AddWithValue("@email", u.UserEmail);
cmd.Parameters.AddWithValue("@upassword", u.UserPassword);
cmd.Parameters.AddWithValue("@ucpassword", u.UserCfrmPassword);
cmd.Parameters.AddWithValue("@contact", u.UserConatct);
cmd.Parameters.AddWithValue("@uaddress", u.UserAddress);
cmd.Parameters.AddWithValue("@addDate", u.AddDate);
cmd.Parameters.AddWithValue("@Gender", u.Gender);
cmd.Parameters.AddWithValue("@imSource", u.ImageSource);
cmd.Parameters.AddWithValue("@userId", u.UserId);
//open database connection
conn.Open();
//create a variable to hold the value after query executed
int rows = cmd.ExecuteNonQuery();
if (rows > 0)
{
//query executed successfully
isSuccess = true;
}
else
{
//failed to execute query
isSuccess = false;
}
}
catch (Exception Ex)
{
//dispose error message if there is any exceptional error
MessageBox.Show(Ex.Message);
}
finally
{
//close database connection
conn.Close();
}
return(isSuccess);
}
public bool InsertC(UserbLL u)
{
//create a boolean variable and set its default value to false
bool isSuccess = false;
//create an object of sql connection to connect database
SqlConnection conn = new SqlConnection(myconstn);
try
{
//create a string variable to store the insert Query
string SQL = "INSERT INTO ContactTbl(FullName,email,Cmessage) VALUES(@full,@email,@msg)";
//create a sql command to pass the value in query
SqlCommand cmd = new SqlCommand(SQL, conn);
//create the parameters to pass get the value from UI and pass it on sql query above
cmd.Parameters.AddWithValue("@full", u.UserName);
cmd.Parameters.AddWithValue("@email", u.UserEmail);
cmd.Parameters.AddWithValue("@msg", u.msg);
//open database connection
conn.Open();
//create a variable to hold the value after query executed
int rows = cmd.ExecuteNonQuery();
//the value of rows will be greater then 0 if query executed successfully
//else it will be 0
if (rows > 0)
{
//query executed successfully
isSuccess = true;
}
else
{
//failed to execute query
isSuccess = false;
}
}
catch (Exception Ex)
{
//dispose error message if there is any exceptional error
MessageBox.Show(Ex.Message);
}
finally
{
//close database connection
conn.Close();
}
return(isSuccess);
}
public bool Delete(UserbLL u)
{
//create a boolean variable and set its default value to false
bool isSuccess = false;
//create an object of sql connection to connect database
SqlConnection conn = new SqlConnection(myconstn);
try
{
//create the string variable to hold the sql query to delete data
string SQL = "DELETE userTbl WHERE userId=@userId ";
//create a sql command to pass the value in query
SqlCommand cmd = new SqlCommand(SQL, conn);
//now pass the vale to sql query
cmd.Parameters.AddWithValue("@userId", u.UserId);
//create a variable to hold the value after query executed
int rows = cmd.ExecuteNonQuery();
if (rows > 0)
{
//query executed successfully
isSuccess = true;
}
else
{
//failed to execute query
isSuccess = false;
}
}
catch (Exception Ex)
{
//dispose error message if there is any exceptional error
MessageBox.Show(Ex.Message);
}
finally
{
//close database connection
conn.Close();
}
return(isSuccess);
}
public bool Insert(UserbLL u)
{
//create a boolean variable and set its default value to false
bool isSuccess = false;
//create an object of sql connection to connect database
SqlConnection conn = new SqlConnection(myconstn);
try
{
//create a string variable to store the insert Query
string SQL = "INSERT INTO userTbl(urole,userName,email,upassword,ucpassword,contact,uaddress,addDate,Gender,imSource) VALUES(@urole,@userName,@email,@upassword,@ucpassword,@contact,@uaddress,@addDate,@Gender,@imSource)";
//create a sql command to pass the value in query
SqlCommand cmd = new SqlCommand(SQL, conn);
//create the parameters to pass get the value from UI and pass it on sql query above
cmd.Parameters.AddWithValue("@urole", u.UserRole);
cmd.Parameters.AddWithValue("@userName", u.UserName);
cmd.Parameters.AddWithValue("@email", u.UserEmail);
cmd.Parameters.AddWithValue("@upassword", u.UserPassword);
cmd.Parameters.AddWithValue("@ucpassword", u.UserCfrmPassword);
cmd.Parameters.AddWithValue("@contact", u.UserConatct);
cmd.Parameters.AddWithValue("@uaddress", u.UserAddress);
cmd.Parameters.AddWithValue("@addDate", u.AddDate);
cmd.Parameters.AddWithValue("@Gender", u.Gender);
cmd.Parameters.AddWithValue("@imSource", u.ImageSource);
//open database connection
conn.Open();
//create a variable to hold the value after query executed
int rows = cmd.ExecuteNonQuery();
//the value of rows will be greater then 0 if query executed successfully
//else it will be 0
if (rows > 0)
{
//query executed successfully
isSuccess = true;
}
else
{
//failed to execute query
isSuccess = false;
}
}
catch (Exception Ex)
{
//dispose error message if there is any exceptional error
MessageBox.Show(Ex.Message);
}
finally
{
//close database connection
conn.Close();
}
return(isSuccess);
}
public bool Valid(UserbLL u)
{
//create a boolean variable and set its default value to false
bool isSuccess = false;
//create an object of sql connection to connect database
SqlConnection conn = new SqlConnection(myconstn);
try
{
//create the string variable to hold the sql query to get data
string SQL = "SELECT * FROM [dbo].[UserTbl] WHERE (urole=@urole) and (userName=@userName or email=@email) and (upassword=@upassword) ";
//create a sql command to pass the value in query
SqlCommand cmd = new SqlCommand(SQL, conn);
//open connection
conn.Open();
//now pass the vale to sql query
cmd.Parameters.AddWithValue("@urole", u.UserRole);
cmd.Parameters.AddWithValue("@email", u.UserEmail);
cmd.Parameters.AddWithValue("@upassword", u.UserPassword);
cmd.Parameters.AddWithValue("@userName", u.UserName);
//create sql date adapter to hold the date from database temporarily
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
//transfer data from sql data adapter to datat table
sda.Fill(dt);
//create a variable to hold the value after query executed
cmd.ExecuteNonQuery();
if (dt.Rows.Count > 0)
{
//store data in global variable to later use
welcomeUPass = u.UserPassword;
WelcomeUEmail = u.UserEmail;
welcomeUser = u.UserName;
//query executed successfully
isSuccess = true;
}
else
{
//failed to execute query
MessageBox.Show("Please Enter Correct (Role) or (User Name or Email) or (Passward) !!!");
isSuccess = false;
}
}
catch (Exception Ex)
{
//dispose error message if there is any exceptional error
MessageBox.Show(Ex.Message);
}
finally
{
//close database connection
conn.Close();
}
return(isSuccess);
}
public bool POPUP(UserbLL u)
{
//create a boolean variable and set its default value to false
bool isSuccess = false;
//create an object of sql connection to connect database
SqlConnection conn = new SqlConnection(myconstn);
try
{
//create the string variable to hold the sql query to get data
string SQL = "SELECT * FROM [dbo].[UserTbl] WHERE email=@email and upassword=@upassword";
//create a sql command to pass the value in query
SqlCommand cmd = new SqlCommand(SQL, conn);
//open connection
conn.Open();
MessageBox.Show(u.UserEmail);
MessageBox.Show(u.ImageSource);
//now pass the vale to sql query
cmd.Parameters.AddWithValue("@email", u.UserEmail);
cmd.Parameters.AddWithValue("@upassword", u.UserPassword);
//create sql date adapter to hold the date from database temporarily
SqlDataAdapter sda = new SqlDataAdapter();
DataTable dt = new DataTable();
//transfer data from sql data adapter to datat table
sda.Fill(dt);
//create a variable to hold the value after query executed
int rows = cmd.ExecuteNonQuery();
if (rows > 0)
{
//query executed successfully
isSuccess = true;
//store user name to retrieve further data in login page
welcomeUser = u.UserName;
//store user email to retrieve further data in login page
WelcomeUEmail = u.UserEmail;
//store user email to retrieve further data in login page
welcomeUImg = u.ImageSource;
}
else
{
//failed to execute query
isSuccess = false;
}
}
catch (Exception Ex)
{
//dispose error message if there is any exceptional error
MessageBox.Show(Ex.Message);
}
finally
{
//close database connection
conn.Close();
}
return(isSuccess);
}
