protected void btnok_Click(object sender, EventArgs e)
{
if (checkNull())
{
if (FUCPic.FileBytes.Length > 0)
{
uploadPic();
}
Entity.WorkBranchNewsInfo workbranch = new Entity.WorkBranchNewsInfo();
workbranch.WorkBranchNews_Name= txttitle.Text.ToString();
workbranch.Date_End = txtdate.Text.ToString();
workbranch.WorkBranchNews_Detail = editor.Content.ToString();
workbranch.WorkBranchNews_Path = picturPath;
workbranch.Create_user = Session["userid"].ToString();
workbranch.Update_user = Session["userid"].ToString();
bool insert = BLL.WorkBranchNews.insertWorkBranchNews(workbranch);
if (insert)
{
ShowMessageWeb("บันทึกข้อมูลเรียบร้อย! ");
clearValue();
}
else
{
ShowMessageWeb("บันทึกข้อมูลล้มเหลว !");
if (FUCPic.FileBytes.Length > 0)
{
System.IO.File.Delete(Server.MapPath(picturPath));
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
string requestID = Request["id"].ToString();
string sub = requestID.Substring(0,1);
string query = requestID.Substring(1, requestID.Length-1);
if (sub== "1") {
lbltitle.Text = "ข่าวสาขา";
Entity.BranchNewsInfo branch = new Entity.BranchNewsInfo();
branch = BLL.BranchNews.selectBranchNewsShowDetailNewsPage(query);
lblheader.Text = branch.BranchNews_Name;
detail.InnerHtml = branch.Branch_Detail;
//imgPic.ImageUrl = branch.Branch_Path;
imgPic.ImageUrl = "../../image/slideshow/11.png";
lbltime.Text = branch.Update_date;
}
else if (sub == "2") {
lbltitle.Text = "ข่าวฝึกอบรม";
Entity.TrainingNewsInfo train = new Entity.TrainingNewsInfo();
train = BLL.TrainingNews.selectTrainingNewsShowDetailNewsPage(query);
lblheader.Text = train.Training_Name;
detail.InnerHtml = train.Training_Detail;
imgPic.ImageUrl = train.Training_Path;
lbltime.Text = train.Update_date;
}
else if (sub == "3") {
lbltitle.Text = "ผลงานสาขา";
Entity.WorkBranchNewsInfo workbranch = new Entity.WorkBranchNewsInfo();
workbranch = BLL.WorkBranchNews.selectTrainingNewsShowDetailNewsPage(query);
lblheader.Text = workbranch.WorkBranchNews_Name;
detail.InnerHtml = workbranch.WorkBranchNews_Detail;
imgPic.ImageUrl = workbranch.WorkBranchNews_Path;
lbltime.Text = workbranch.Update_date;
}
else if (sub == "4") {
lbltitle.Text = "กิจกรรมนักศึกษา";
lblheader.Text = query;
Entity.StudentNewsInfo stdNews = new Entity.StudentNewsInfo();
stdNews = BLL.StudentNews.selectTrainingNewsShowDetailNewsPage(query);
lblheader.Text = stdNews.StudentNews_Name;
detail.InnerHtml = stdNews.StudentNews_Detail;
imgPic.ImageUrl = stdNews.StudentNews_Path;
lbltime.Text = stdNews.Update_date;
}
else if (sub == "5")
{
lbltitle.Text = "ข่าวประกาศ";
lblheader.Text = query;
Entity.SlideShow slide = new Entity.SlideShow();
slide = BLL.SlideShow.selectBranchNewsShowDetailNewsPage(query);
lblheader.Text = slide.SlideShow_Name;
detail.InnerHtml = slide.SlideShow_Detail;
imgPic.ImageUrl = slide.SlideShow_Path;
lbltime.Text = slide.Update_date;
}
}
protected void btnsave_Click(object sender, EventArgs e)
{
Entity.WorkBranchNewsInfo update = new Entity.WorkBranchNewsInfo();
update.Create_user = Session["userid"].ToString();
update.Update_user = Session["userid"].ToString();
update.WorkBranchNews_ID = WorkBranch_ID.ToString();
update.WorkBranchNews_Name = txtPoPtitle.Text.ToString();
update.WorkBranchNews_Detail = editorPopup.Content.ToString();
update.Date_End = txtPopdate.Text.ToString();
if (FUCPic.FileBytes.Length > 0)
{
uploadPic();
update.WorkBranchNews_Path = picturPath;
}
else update.WorkBranchNews_Path = imgID.ToString();
if (ddlStatus.SelectedIndex == 0) { update.WorkBranchNews_status = "A"; }
else { update.WorkBranchNews_status = "U"; }
bool checkStatusUpdate = BLL.WorkBranchNews.UpdateWorkBranchNews(update);
if (checkStatusUpdate)
{
if (FUCPic.FileBytes.Length > 0 && imgID.ToString().Length>0)
{
System.IO.File.Delete(Server.MapPath(imgID.ToString()));
}
ShowMessageWeb("บันทึกข้อมูลเรียบร้อย ! ");
}
else
{
ShowMessageWeb("บันทึกข้อมูลล้มเหลว ! ");
System.IO.File.Delete(Server.MapPath(picturPath));
}
this.ImageButton1_Click(null, null);
}
protected void gvWorkBranch_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
if (e.CommandName == "updateBranch")
{
WorkBranch_ID =e.CommandArgument.ToString();
Entity.WorkBranchNewsInfo workBranch = new Entity.WorkBranchNewsInfo();
workBranch = BLL.WorkBranchNews.selectShowPopup(WorkBranch_ID.ToString());
txtPoPtitle.Text = workBranch.WorkBranchNews_Name;
editorPopup.Content = workBranch.WorkBranchNews_Detail;
pathImage = workBranch.WorkBranchNews_Path.ToString();
imgID = pathImage;
if (pathImage.Length > 0)
{
imgPopPic.ImageUrl = pathImage;
imgPopPic.Visible = true;
}
else imgPopPic.Visible = false;
string status = workBranch.WorkBranchNews_status;
if (status == "A") { ddlStatus.SelectedIndex = 0; }
else { ddlStatus.SelectedIndex = 1; }
txtPopdate.Text = workBranch.Date_End;
mdlpopup.Show();
}
else if (e.CommandName=="deleteBranch")
{
setWorkBranchDdelete=e.CommandArgument.ToString();
mdlpopupmsg.Show();
}
}
catch (Exception ex)
{
ShowMessageWeb("เกิดข้อผิดพลาด : " + ex);
}
}
public static Entity.WorkBranchNewsInfo selectShowPopup(string id)
{
try
{
SqlDataReader dtReader;
Entity.WorkBranchNewsInfo branch = new Entity.WorkBranchNewsInfo();
string sqlString = "SELECT WorkBranchNews_Name, WorkBranchNews_Detail, WorkBranchNews_Path,WorkBranchNews_Status, convert(datetime, Date_End, 103) as date FROM WorkBranchNews where WorkBranchNews_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.WorkBranchNews_Name = dtReader["WorkBranchNews_Name"].ToString();
branch.WorkBranchNews_Detail = dtReader["WorkBranchNews_Detail"].ToString();
branch.WorkBranchNews_Path = dtReader["WorkBranchNews_Path"].ToString();
branch.WorkBranchNews_status = dtReader["WorkBranchNews_Status"].ToString();
branch.Date_End = dtReader["date"].ToString();
}
dtReader.Close();
objConn.Close();
return branch;
}
catch (Exception)
{
return null;
}
}
public static Entity.WorkBranchNewsInfo selectTrainingNewsShowDetailNewsPage(string query)
{
ClassConnectDB conn = new ClassConnectDB();
Entity.WorkBranchNewsInfo workbranch = new Entity.WorkBranchNewsInfo();
try
{
string sql = "SELECT * FROM WorkBranchNews WHERE WorkBranchNews_ID=@id";
string Addvalue = "@id";
string value = query;
SqlDataReader drrShow = conn.SelectWhereSqlDataReader(sql, Addvalue, value);
if (drrShow.Read())
{
workbranch.WorkBranchNews_Name = drrShow["WorkBranchNews_Name"].ToString();
workbranch.WorkBranchNews_Detail = drrShow["WorkBranchNews_Detail"].ToString();
workbranch.Update_date = drrShow["Update_date"].ToString();
workbranch.WorkBranchNews_Path = drrShow["WorkBranchNews_Path"].ToString();
}
conn.Close();
return workbranch;
}
catch (Exception)
{
return null;
}
}
