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); } } }