public static DataTable Loadds() { SqlConnection con = SQLConnectionData.KetnoiCSDL(); SqlCommand cmd = new SqlCommand("Loadds", con); cmd.CommandType = CommandType.StoredProcedure; SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dtb = new DataTable(); da.Fill(dtb); return(dtb); }
public static void Delete_notice(string userPrimary, string userReference) { SqlConnection con = SQLConnectionData.KetnoiCSDL(); SqlCommand cmd = new SqlCommand("delete_notice", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@userPrimary", SqlDbType.NChar, 30); cmd.Parameters.Add("@userReference", SqlDbType.NChar, 30); cmd.Parameters["@userPrimary"].Value = userPrimary; cmd.Parameters["@userReference"].Value = userReference; con.Open(); cmd.ExecuteNonQuery(); con.Close(); }
public static DataTable Kiemtra_dangki(string account, string username) { SqlConnection con = SQLConnectionData.KetnoiCSDL(); SqlCommand cmd = new SqlCommand("kiemtra_dangki", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@account", SqlDbType.NChar, 30); cmd.Parameters.Add("@username", SqlDbType.NChar, 30); cmd.Parameters["@account"].Value = account; cmd.Parameters["@username"].Value = username; SqlDataAdapter ds = new SqlDataAdapter(cmd); DataTable dtb = new DataTable(); ds.Fill(dtb); return(dtb); }
public static DataTable Dangnhap(string account, string password) { SqlConnection con = SQLConnectionData.KetnoiCSDL(); SqlCommand cmd = new SqlCommand("dangnhap", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@account", SqlDbType.NChar, 30); cmd.Parameters.Add("@password", SqlDbType.NChar, 30); cmd.Parameters["@account"].Value = account; cmd.Parameters["@password"].Value = password; SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dtb = new DataTable(); da.Fill(dtb); return(dtb); }
public static DataTable Load_message(int count, string userPrimary, string userReferences) { SqlConnection con = SQLConnectionData.KetnoiCSDL(); SqlCommand cmd = new SqlCommand("LoadMessage", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@count", SqlDbType.Int); cmd.Parameters.Add("@userPrimary", SqlDbType.NChar, 30); cmd.Parameters.Add("@userReferences", SqlDbType.NChar, 30); cmd.Parameters["@count"].Value = count; cmd.Parameters["@userPrimary"].Value = userPrimary; cmd.Parameters["@userReferences"].Value = userReferences; SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); return(dt); }
public static void Change_information(string username, string email, byte[] image, byte[] status) { SqlConnection con = SQLConnectionData.KetnoiCSDL(); SqlCommand cmd = new SqlCommand("ChangeData", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@username", SqlDbType.NChar, 30); cmd.Parameters.Add("@email", SqlDbType.NChar, 30); cmd.Parameters.Add("@image", SqlDbType.Image); cmd.Parameters.Add("@status", SqlDbType.VarBinary, 50); cmd.Parameters["@username"].Value = username; cmd.Parameters["@email"].Value = email; cmd.Parameters["@image"].Value = image; cmd.Parameters["@status"].Value = status; con.Open(); cmd.ExecuteNonQuery(); con.Close(); }
public static void Save_message(string _userPrimaryTemp, string _userReference, byte[] _content, byte[] _font, string _time) { SqlConnection con = SQLConnectionData.KetnoiCSDL(); SqlCommand cmd = new SqlCommand("savemessage", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@userPrimary", SqlDbType.NChar, 30); cmd.Parameters.Add("@userReferences", SqlDbType.NChar, 30); cmd.Parameters.Add("@contentMessage", SqlDbType.Image); cmd.Parameters.Add("@font", SqlDbType.Image); cmd.Parameters.Add("@Time", SqlDbType.SmallDateTime); cmd.Parameters["@userPrimary"].Value = _userPrimaryTemp; cmd.Parameters["@userReferences"].Value = _userReference; cmd.Parameters["@contentMessage"].Value = _content; cmd.Parameters["@font"].Value = _font; cmd.Parameters["@Time"].Value = _time; con.Open(); cmd.ExecuteNonQuery(); con.Close(); }
public static DataTable Add_notice(NOTICE_DTO notice) { SqlConnection con = SQLConnectionData.KetnoiCSDL(); SqlCommand cmd = new SqlCommand("add_notice", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@userPrimary", SqlDbType.NChar, 30); cmd.Parameters.Add("@userReferences", SqlDbType.NChar, 30); cmd.Parameters.Add("@type", SqlDbType.NChar, 1); cmd.Parameters.Add("@content", SqlDbType.NChar, 255); cmd.Parameters.Add("@Time", SqlDbType.SmallDateTime); cmd.Parameters["@userPrimary"].Value = notice.UserPrimary; cmd.Parameters["@userReferences"].Value = notice.UserReference; cmd.Parameters["@type"].Value = notice.Type; cmd.Parameters["@content"].Value = notice.Content; cmd.Parameters["@Time"].Value = notice.Time; SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); return(dt); }