public static bool Edit_User(Account_DTO a)
{
String query = " update ACOUNT set ID = N'" + a.Id + "', USERNAME = '******',FULLNAME = '" + a.Fullname + " ',RIGHTS = '" + a.Right + "',PASS = '******' WHERE ID = N'" + a.Id + "'";
using (SqlConnection connect = DataProvider.CONNECT())
{
try
{
DataProvider.Excute_Query(query, connect);
return(true);
}
catch (Exception ex)
{
return(false);
}
}
}
public static bool Delete_Account(Account_DTO a)
{
String query = "delete from ACOUNT where ID=N'" + a.Id + "'";
using (SqlConnection connect = DataProvider.CONNECT())
{
try
{
DataProvider.Excute_Query(query, connect);
return(true);
}
catch (Exception ex)
{
return(false);
}
}
}
public static bool Add_USER(Account_DTO a)
{
String query = "insert into ACOUNT values(N'" + a.Id + "',N'" + a.Username + "',N'" + a.Fullname + "',N'" + a.Right + "',N'" + a.Password + "')";
using (SqlConnection connect = DataProvider.CONNECT())
{
try
{
DataProvider.Excute_Query(query, connect);
return(true);
}
catch (Exception ex)
{
return(false);
}
}
}
