public static bool insertComment(string id, string comment, string createUser,string usertype)
{
try
{
SqlConnection objConn;
SqlCommand objCmd;
string sqlInsert = @"INSERT INTO KmCommentPost
(KmPost_ID, ComPost_Detail, Create_date, Create_time, Create_user_id,Create_user_type)
VALUES(@postID,@detail,GetDate(),GetDate(),@createuser,@createType)";
ConnectDB connpath = new ConnectDB();
objConn = new SqlConnection();
objConn.ConnectionString = connpath.connectPath();
objConn.Open();
objCmd = new SqlCommand(sqlInsert, objConn);
objCmd.Parameters.Add("@detail", SqlDbType.NVarChar).Value = comment;
objCmd.Parameters.Add("@createuser", SqlDbType.NVarChar).Value = createUser;
objCmd.Parameters.Add("@postID", SqlDbType.Int).Value = id;
objCmd.Parameters.Add("@createType", SqlDbType.NVarChar).Value = usertype;
objCmd.ExecuteNonQuery();
return true;
}
catch (Exception ex)
{
return false;
}
}
public static bool insertPicture(Entity.Picture picture)
{
try
{
string sqlInsert = @"INSERT INTO Picture(Album_ID,Picture_Name,Picture_Detail,Picture_Path, Picture_Status, Create_date)
VALUES(@albunID,@pictureName,@pictureDetail,@picturePath,'A',GetDate())";
ConnectDB connpath = new ConnectDB();
objConn = new SqlConnection();
objConn.ConnectionString = connpath.connectPath();
objConn.Open();
objCmd = new SqlCommand(sqlInsert, objConn);
objCmd.Parameters.Add("@albunID", SqlDbType.Int).Value = picture.Album_ID;
objCmd.Parameters.Add("@pictureName", SqlDbType.NVarChar).Value = picture.Picture_Name.ToString();
objCmd.Parameters.Add("@pictureDetail", SqlDbType.NVarChar).Value = picture.Picture_Detail.ToString();
objCmd.Parameters.Add("@picturePath", SqlDbType.NVarChar).Value = picture.Picture_Path.ToString();
objCmd.ExecuteNonQuery();
objConn.Close();
return true;
}
catch (Exception ex)
{
return false;
}
}
public static bool insertBranch(Entity.BranchNewsInfo branch)
{
try
{
string sqlInsert = @"INSERT INTO BranchNews (BranchNews_Name, BranchNews_Detail, BranchNews_Path,BranchNews_Status, Create_date, Date_End, Create_user,Update_date,Update_user)
VALUES(@title,@branchDetail,@branchPath,'A',GetDate(),convert(datetime, @endDate, 103),@user,GetDate(),@userupdate)";
ConnectDB connpath = new ConnectDB();
objConn = new SqlConnection();
objConn.ConnectionString = connpath.connectPath();
objConn.Open();
objCmd = new SqlCommand(sqlInsert, objConn);
objCmd.Parameters.Add("@title", SqlDbType.NVarChar).Value = branch.BranchNews_Name.ToString();
// objCmd.Parameters.Add("@picture", SqlDbType.NVarChar).Value = branch.Branch_Picture.ToString();
objCmd.Parameters.Add("@branchDetail", SqlDbType.NVarChar).Value = branch.Branch_Detail.ToString();
objCmd.Parameters.Add("@branchPath", SqlDbType.NVarChar).Value = branch.Branch_Path.ToString();
// objCmd.Parameters.Add("@branchNum", SqlDbType.Int).Value = branch.Branch_Num;
objCmd.Parameters.Add("@endDate", SqlDbType.NVarChar).Value = branch.Date_End.ToString();
objCmd.Parameters.Add("@user", SqlDbType.Int).Value = branch.Create_user;
objCmd.Parameters.Add("@userupdate", SqlDbType.Int).Value = branch.Update_user;
objCmd.ExecuteNonQuery();
return true;
}catch(Exception ex ){
return false;
}
objConn.Close();
}
public static bool insertAlbum(Entity.AlbumPicture album)
{
try
{
string sqlInsert = @"INSERT INTO AlbumPicture(Album_Name,Create_User,Create_date)
VALUES(@albumName,@createUser,getdate())";
ConnectDB connpath = new ConnectDB();
objConn = new SqlConnection();
objConn.ConnectionString = connpath.connectPath();
objConn.Open();
objCmd = new SqlCommand(sqlInsert, objConn);
objCmd.Parameters.Add("@albumName", SqlDbType.NVarChar).Value = album.Album_Name.ToString();
objCmd.Parameters.Add("@createUser", SqlDbType.NVarChar).Value = album.Create_User.ToString();
objCmd.ExecuteNonQuery();
objConn.Close();
return true;
}
catch (Exception ex)
{
return false;
}
}
public static DataTable LoadAll(string search)
{
try
{
string sqlString = "SELECT * FROM BranchNews INNER JOIN Employee ON BranchNews.Update_user = Employee.Emp_ID ";
if (!string.IsNullOrEmpty(search))
{
sqlString += " WHERE BranchNews_Name like '%" + search + "%' ";
}
sqlString += " order by Update_date DESC";
ConnectDB connja = new ConnectDB();
SqlDataAdapter dtAdapter;
DataTable dt = new DataTable();
objConn = new SqlConnection();
objConn.ConnectionString = connja.connectPath();
objConn.Open();
dtAdapter = new SqlDataAdapter(sqlString, objConn);
dtAdapter.Fill(dt);
return dt;
objConn.Close();
}
catch (Exception) {
return null;
}
}
public static DataTable CountAlbum()
{
try
{
string sqlString = "SELECT COUNT(Album_ID) + 1 AS COUNT_ID FROM AlbumPicture";
ConnectDB connja = new ConnectDB();
SqlDataAdapter dtAdapter;
DataTable dt = new DataTable();
objConn = new SqlConnection();
objConn.ConnectionString = connja.connectPath();
objConn.Open();
dtAdapter = new SqlDataAdapter(sqlString, objConn);
dtAdapter.Fill(dt);
objConn.Close();
return dt;
}
catch (Exception)
{
return null;
}
}
public static DataTable LoadAlbum(string search)
{
try
{
string sqlString = "SELECT * FROM AlbumPicture WHERE Create_User = '******'";
ConnectDB connja = new ConnectDB();
SqlDataAdapter dtAdapter;
DataTable dt = new DataTable();
objConn = new SqlConnection();
objConn.ConnectionString = connja.connectPath();
objConn.Open();
dtAdapter = new SqlDataAdapter(sqlString, objConn);
dtAdapter.Fill(dt);
objConn.Close();
return dt;
}
catch (Exception)
{
return null;
}
}
public static bool insertStudent(Entity.StudentNewsInfo stdNews)
{
try
{
string sqlInsert = @"INSERT INTO StudentNews(StudentNews_Name,StudentNews_Detail, StudentNews_Path,Student_Status, Create_date, Date_End, Create_user,Update_date,Update_user)
VALUES(@title,@Detail,@Path,'A',GetDate(),convert(datetime, @endDate, 103),@user,GetDate(),@userupdate)";
ConnectDB connpath = new ConnectDB();
objConn = new SqlConnection();
objConn.ConnectionString = connpath.connectPath();
objConn.Open();
objCmd = new SqlCommand(sqlInsert, objConn);
objCmd.Parameters.Add("@title", SqlDbType.NVarChar).Value = stdNews.StudentNews_Name.ToString();
objCmd.Parameters.Add("@Detail", SqlDbType.NVarChar).Value = stdNews.StudentNews_Detail.ToString();
objCmd.Parameters.Add("@Path", SqlDbType.NVarChar).Value = stdNews.StudentNews_Path.ToString();
objCmd.Parameters.Add("@endDate", SqlDbType.NVarChar).Value =stdNews.Date_End.ToString();
objCmd.Parameters.Add("@user", SqlDbType.Int).Value = stdNews.Create_user;
objCmd.Parameters.Add("@userupdate", SqlDbType.Int).Value = stdNews.Update_user;
objCmd.ExecuteNonQuery();
objConn.Close();
return true;
}
catch (Exception ex)
{
return false;
}
}
public ClassConnectDB()
{
#region ConnectWebApp
//strConnString = System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"];
#endregion
#region ConnectWinApp
// strConnString = "Data Source=POOM_MON-PC\\POOM;Initial Catalog=WebComSciDB;Integrated Security=True";
ConnectDB connpath = new ConnectDB();
objConn = new SqlConnection();
strConnString = connpath.connectPath();
#endregion
}
public static Entity.BranchNewsInfo selectShowPopup(string id)
{
try
{
SqlDataReader dtReader;
Entity.BranchNewsInfo branch = new Entity.BranchNewsInfo();
string sqlString = "SELECT BranchNews_Name, BranchNews_Detail, BranchNews_Path, BranchNews_Status, convert(datetime, Date_End, 103) as date FROM BranchNews where BranchNews_ID=@id";
ConnectDB connpath = new ConnectDB();
objConn = new SqlConnection();
objConn.ConnectionString = connpath.connectPath();
objConn.Open();
objCmd = new SqlCommand(sqlString, objConn);
objCmd.Parameters.Add("@id", SqlDbType.Int).Value = Convert.ToInt32(id);
dtReader = objCmd.ExecuteReader();
if (dtReader.Read())
{
branch.BranchNews_Name = dtReader["BranchNews_Name"].ToString();
branch.Branch_Detail = dtReader["BranchNews_Detail"].ToString();
branch.Branch_Path = dtReader["BranchNews_Path"].ToString();
branch.Branch_status = dtReader["BranchNews_Status"].ToString();
branch.Date_End = dtReader["date"].ToString();
}
dtReader.Close();
objConn.Close();
return branch;
}catch(Exception ){
return null;
}
}
public static string selectPicturePath(string setBranchIDdelete)
{
string path ="";
try
{
SqlDataReader dtReader;
string sqlString = "SELECT * FROM BranchNews where BranchNews_ID=@id";
ConnectDB connpath = new ConnectDB();
objConn = new SqlConnection();
objConn.ConnectionString = connpath.connectPath();
objConn.Open();
objCmd = new SqlCommand(sqlString, objConn);
objCmd.Parameters.Add("@id", SqlDbType.Int).Value = Convert.ToInt32(setBranchIDdelete);
dtReader = objCmd.ExecuteReader();
if (dtReader.Read())
{
path= dtReader["BranchNews_Path"].ToString();
}
dtReader.Close();
objConn.Close();
return path;
}
catch (Exception)
{
return null;
}
}
public static bool deleteBranch(string branchID)
{
try
{
string sqlUpdate = "DELETE FROM BranchNews Where BranchNews_ID=@id";
ConnectDB connpath = new ConnectDB();
objConn = new SqlConnection();
objConn.ConnectionString = connpath.connectPath();
objConn.Open();
objCmd = new SqlCommand(sqlUpdate, objConn);
objCmd.Parameters.Add("@id", SqlDbType.Int).Value = Convert.ToInt32(branchID);
objCmd.ExecuteNonQuery();
objConn.Close();
return true;
}
catch (Exception)
{
return false;
}
}
public static bool updateBranch(Entity.BranchNewsInfo update)
{
try
{
string sqlUpdate = @"UPDATE BranchNews SET BranchNews_Name =@title, BranchNews_Detail =@detail,
BranchNews_Path =@path, BranchNews_Status =@status, Update_date =GetDate(), Update_user =@user, Date_End = convert(datetime,@endDate, 103) where BranchNews_ID=@id";
ConnectDB connpath = new ConnectDB();
objConn = new SqlConnection();
objConn.ConnectionString = connpath.connectPath();
objConn.Open();
objCmd = new SqlCommand(sqlUpdate, objConn);
objCmd.Parameters.Add("@id", SqlDbType.Int).Value = update.BranchNews_ID.ToString();
objCmd.Parameters.Add("@title", SqlDbType.NVarChar).Value = update.BranchNews_Name.ToString();
objCmd.Parameters.Add("@detail", SqlDbType.NVarChar).Value = update.Branch_Detail.ToString();
objCmd.Parameters.Add("@path", SqlDbType.NVarChar).Value = update.Branch_Path.ToString();
objCmd.Parameters.Add("@status", SqlDbType.NVarChar).Value = update.Branch_status.ToString();
objCmd.Parameters.AddWithValue("@endDate",update.Date_End.ToString());
objCmd.Parameters.Add("@user", SqlDbType.Int).Value = update.Update_user;
objCmd.ExecuteNonQuery();
objConn.Close();
return true;
}
catch (Exception)
{
return false;
}
}
public static Entity.SlideShow selectShowNews()
{
try
{
SqlDataReader dtReader;
Entity.SlideShow branch = new Entity.SlideShow();
string sqlString = "SELECT SlideShow_Name, SlideShow_Detail, SlideShow_Path, SlideShow_Status, convert(datetime, Date_End, 103) as date FROM SlideShow ";
ConnectDB connpath = new ConnectDB();
objConn = new SqlConnection();
objConn.ConnectionString = connpath.connectPath();
objConn.Open();
objCmd = new SqlCommand(sqlString, objConn);
// objCmd.Parameters.Add("@id", SqlDbType.Int).Value = Convert.ToInt32(id);
dtReader = objCmd.ExecuteReader();
while (dtReader.Read())
{
branch.SlideShow_Name = dtReader["SlideShow_Name"].ToString();
branch.SlideShow_Detail = dtReader["SlideShow_Detail"].ToString();
branch.SlideShow_Path = dtReader["SlideShow_Path"].ToString();
branch.SlideShow_status = dtReader["SlideShow_Status"].ToString();
branch.Date_End = dtReader["date"].ToString();
}
dtReader.Close();
objConn.Close();
return branch;
}
catch (Exception)
{
return null;
}
}
public static DataTable table_DotThi(String dotThi)
{
string cmd = "select * from DotThi where MaBT='" + dotThi + "'";
return(ConnectDB.execAdapter(cmd));
}
public static bool insertPostKm(string title, string detail, string link,string user,string type)
{
try
{
SqlConnection objConn;
SqlCommand objCmd;
string sqlInsert = @"INSERT INTO KmPost
(KmPost_Name, KmPost_Detail, KmPost_Link, KmPost_date, KmPost_time, KmPost_Status, Create_user_id, Create_user_type)
VALUES(@name,@detail ,@link,GetDate(),GetDate(),'N',@user,@type)";
ConnectDB connpath = new ConnectDB();
objConn = new SqlConnection();
objConn.ConnectionString = connpath.connectPath();
objConn.Open();
objCmd = new SqlCommand(sqlInsert, objConn);
objCmd.Parameters.Add("@name", SqlDbType.NVarChar).Value = title;
objCmd.Parameters.Add("@detail", SqlDbType.NVarChar).Value =detail;
//objCmd.Parameters.Add("@pic", SqlDbType.NVarChar).Value = picturPath;
objCmd.Parameters.Add("@link", SqlDbType.NVarChar).Value = link;
objCmd.Parameters.Add("@user", SqlDbType.NVarChar).Value = user;
objCmd.Parameters.Add("@type", SqlDbType.NVarChar).Value = type;
objCmd.ExecuteNonQuery();
return true;
}
catch (Exception ex)
{
return false;
}
}
public static bool MyPost(string userid, string usertype, string post)
{
try
{
SqlConnection objConn;
SqlCommand objCmd;
string sqlInsert = @"INSERT INTO Post
(Post_Detail, Create_date, Create_time, Create_user_id,Create_user_type)
VALUES (@post,GetDate(),GetDate(),@userid,@usertype)";
ConnectDB connpath = new ConnectDB();
objConn = new SqlConnection();
objConn.ConnectionString = connpath.connectPath();
objConn.Open();
objCmd = new SqlCommand(sqlInsert, objConn);
objCmd.Parameters.Add("@post", SqlDbType.NVarChar).Value = post;
objCmd.Parameters.Add("@userid", SqlDbType.NVarChar).Value = userid;
objCmd.Parameters.Add("@usertype", SqlDbType.NVarChar).Value = usertype;
objCmd.ExecuteNonQuery();
objConn.Close();
return true;
}
catch (Exception ex)
{
return false;
}
}
public static DataTable table_ThiSinh(String thisinh)
{
string cmd = "select * from ThiSinh where MsThiSinh='" + thisinh + "'";
return(ConnectDB.execAdapter(cmd));
}
public static DataTable table_BaiThi(String MsThiSinh, String MsBaiThi)
{
string cmd = "select * from KiemtraMBT('" + MsThiSinh + "','" + MsBaiThi + "') ";
return(ConnectDB.execAdapter(cmd));
}
