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