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