private void BindNew() { cNews oNew = new cNews(); DataSet ds = new DataSet(); string strMessage = string.Empty; string strCriteria = string.Empty; string strActive = string.Empty; strCriteria = strCriteria + " And c_active ='Y' And new_status <> 'P' Order by d_created_date desc"; try { if (!oNew.SP_NEW_SHOW_SEL(strCriteria, ref ds, ref strMessage)) { lblError.Text = strMessage; } else { RpNew.DataSource = ds.Tables[0]; RpNew.DataBind(); } } catch (Exception ex) { lblError.Text = ex.Message.ToString(); } finally { oNew.Dispose(); ds.Dispose(); } }
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) { string strMessage = string.Empty; string strCheck = string.Empty; string strScript = string.Empty; HiddenField hddnew_id = (HiddenField)GridView1.Rows[e.RowIndex].FindControl("hddnew_id"); cNews oNews = new cNews(); try { if (!oNews.SP_NEW_DEL(hddnew_id.Value.ToString(), ref strMessage)) { lblError.Text = strMessage; } } catch (Exception ex) { lblError.Text = ex.Message.ToString(); } finally { oNews.Dispose(); } BindGridView(0); }
/// <summary> /// Creates a cNews object. It will be saved in permanent storage only /// on calling Save() /// </summary> /// <returns>cNews object</returns> public static cNews Create() { cNews oObj = new cNews(); SecurityCheck((int)enNews_Action.Create); // Create an object in memory, will be saved to storage on calling Save() oObj.m_bCreating = true; oObj.m_bInvalid = false; return(oObj); }
private void BindGridView(int nPageNo) { cNews oNews = new cNews(); DataSet ds = new DataSet(); string strMessage = string.Empty; string strCriteria = string.Empty; if (!txtCetreria.Equals("")) { strCriteria = strCriteria + " And (new_title like '%" + txtCetreria.Text.Trim() + "%') "; } try { if (!oNews.SP_NEW_SEL(strCriteria, ref ds, ref strMessage)) { lblError.Text = strMessage; } else { try { GridView1.PageIndex = nPageNo; txthTotalRecord.Value = ds.Tables[0].Rows.Count.ToString(); ds.Tables[0].DefaultView.Sort = ViewState["sort"] + " " + ViewState["direction"]; GridView1.DataSource = ds.Tables[0]; GridView1.DataBind(); } catch { GridView1.PageIndex = 0; txthTotalRecord.Value = ds.Tables[0].Rows.Count.ToString(); ds.Tables[0].DefaultView.Sort = ViewState["sort"] + " " + ViewState["direction"]; GridView1.DataSource = ds.Tables[0]; GridView1.DataBind(); } } } catch (Exception ex) { lblError.Text = ex.Message.ToString(); } finally { oNews.Dispose(); ds.Dispose(); if (GridView1.Rows.Count > 0) { GridView1.TopPagerRow.Visible = true; } } }
/// <summary> /// Ensures that an object with the specified name exists, while creating other properties are set to their default values /// </summary> /// <param name="i_sName">Name</param> /// <returns>cNews object</returns> public static cNews CreateIfRequiredAndGet(string i_sName) { cNews oObj = cNews.Get_Name(i_sName); if (oObj == null) { oObj = cNews.Create(); oObj.sName = i_sName; oObj.Save(); } return(oObj); }
private void BindData(int nNew_id) { cNews oNews = new cNews(); DataSet ds = new DataSet(); string strMessage = string.Empty; string strCriteria = string.Empty; strCriteria = strCriteria + " And (new_id =" + nNew_id + ") "; try { if (!oNews.SP_NEW_SEL(strCriteria, ref ds, ref strMessage)) { lblError.Text = strMessage; } else { ltlNew_title.Text = ds.Tables[0].Rows[0]["new_title"].ToString(); ltlNew_date.Text = ds.Tables[0].Rows[0]["d_created_date"].ToString(); //N = Normal , P = Pin , Q = Quick if (ds.Tables[0].Rows[0]["new_status"].ToString() == "N") { ltlNew_status.Text = "ข่าวทั่วไป"; } else if (ds.Tables[0].Rows[0]["new_status"].ToString() == "Q") { ltlNew_status.Text = "ข่าวด่วน"; ltlNew_status.ForeColor = System.Drawing.Color.Red; } else if (ds.Tables[0].Rows[0]["new_status"].ToString() == "P") { ltlNew_status.Text = "ปักหมุด"; } ltlNew_des.Text = ds.Tables[0].Rows[0]["new_des"].ToString(); if (ds.Tables[0].Rows[0]["new_des"].ToString() != "") { lblNew_file_name.Text = ds.Tables[0].Rows[0]["new_file_name"].ToString(); lblNew_file_name.NavigateUrl = ""; } lblNew_file_name.NavigateUrl = "~/new_attach/" + ds.Tables[0].Rows[0]["new_file_name"].ToString();; ltlNew_by.Text = ds.Tables[0].Rows[0]["c_created_by"].ToString(); } } catch (Exception ex) { lblError.Text = ex.Message.ToString(); } finally { oNews.Dispose(); ds.Dispose(); } }
/// <summary> /// Finds and return cNews objects matching the specified criteria /// </summary> /// <param name="i_oFilter">Filter criteria (WHERE clause)</param> /// <returns>cNews objects</returns> public static List <cNews> Find(cFilter i_oFilter) { DataTable dt = Find_DataTable(i_oFilter, null); List <cNews> l = new List <cNews>(); cNews oObj; for (int i = 0; i < dt.Rows.Count; i++) { oObj = new cNews(); oObj.m_iID = Convert.ToInt32(dt.Rows[i]["iID"]); oObj.m_sName = dt.Rows[i]["sName"].ToString(); oObj.m_dtCreatedOn = Convert.ToDateTime(dt.Rows[i]["dtCreatedOn"]); oObj.m_dtLastUpdatedOn = Convert.ToDateTime(dt.Rows[i]["dtLastUpdatedOn"]); oObj.m_sHeadLine = Convert.ToString(dt.Rows[i]["sHeadLine"]); oObj.m_sDescription = Convert.ToString(dt.Rows[i]["sDescription"]); oObj.m_bIsActive = Convert.ToBoolean(dt.Rows[i]["bIsActive"]); oObj.m_bInvalid = false; l.Add(oObj); } return(l); }
private void BindGridView(int nPageNo) { cNews oNews = new cNews(); DataSet ds = new DataSet(); string strMessage = string.Empty; string strCriteria = string.Empty; string strNews_title = string.Empty; string strNews_status = string.Empty; string strNews_type = string.Empty; string strActive = string.Empty; string strnews_year = string.Empty; strNews_title = txtNew_title.Text; strNews_status = cboNew_status.SelectedValue; strNews_type = cboNew_type.SelectedValue; if (!strNews_title.Equals("")) { strCriteria = strCriteria + " And (new_title like '%" + strNews_title + "%') "; } if (!strNews_type.Equals("")) { strCriteria = strCriteria + " And (new_type like '%" + strNews_type + "%')"; } if (!strNews_status.Equals("")) { strCriteria = strCriteria + " And (new_status = '" + strNews_status + "') "; } if (RadioActive.Checked) { strCriteria = strCriteria + " And (c_active ='Y') "; } else if (RadioCancel.Checked) { strCriteria = strCriteria + " And (c_active ='N') "; } try { if (!oNews.SP_NEW_SEL(strCriteria, ref ds, ref strMessage)) { lblError.Text = strMessage; } else { try { GridView1.PageIndex = nPageNo; txthTotalRecord.Value = ds.Tables[0].Rows.Count.ToString(); ds.Tables[0].DefaultView.Sort = ViewState["sort"] + " " + ViewState["direction"]; GridView1.DataSource = ds.Tables[0]; GridView1.DataBind(); } catch { GridView1.PageIndex = 0; txthTotalRecord.Value = ds.Tables[0].Rows.Count.ToString(); ds.Tables[0].DefaultView.Sort = ViewState["sort"] + " " + ViewState["direction"]; GridView1.DataSource = ds.Tables[0]; GridView1.DataBind(); } } } catch (Exception ex) { lblError.Text = ex.Message.ToString(); } finally { oNews.Dispose(); ds.Dispose(); if (GridView1.Rows.Count > 0) { GridView1.TopPagerRow.Visible = true; } } }
private void setData() { cNews oNews = new cNews(); DataSet ds = new DataSet(); string strMessage = string.Empty, strCriteria = string.Empty; string strnew_id = string.Empty, strnews_file_name = string.Empty, strnews_title = string.Empty, strnews_des = string.Empty, strnews_type = string.Empty, strnews_status = string.Empty, strC_active = string.Empty, strCreatedBy = string.Empty, strUpdatedBy = string.Empty, strCreatedDate = string.Empty, strUpdatedDate = string.Empty; try { strCriteria = " and new_id = " + ViewState["new_id"].ToString() + " "; if (!oNews.SP_NEW_SEL(strCriteria, ref ds, ref strMessage)) { lblError.Text = strMessage; } else { if (ds.Tables[0].Rows.Count > 0) { #region get Data strnew_id = ds.Tables[0].Rows[0]["new_id"].ToString(); strnews_title = ds.Tables[0].Rows[0]["new_title"].ToString(); strnews_des = ds.Tables[0].Rows[0]["new_des"].ToString(); strnews_type = ds.Tables[0].Rows[0]["new_type"].ToString(); strnews_status = ds.Tables[0].Rows[0]["new_status"].ToString(); strnews_file_name = ds.Tables[0].Rows[0]["new_file_name"].ToString(); strC_active = ds.Tables[0].Rows[0]["c_active"].ToString(); strCreatedBy = ds.Tables[0].Rows[0]["c_created_by"].ToString(); strUpdatedBy = ds.Tables[0].Rows[0]["c_updated_by"].ToString(); strCreatedDate = ds.Tables[0].Rows[0]["d_created_date"].ToString(); strUpdatedDate = ds.Tables[0].Rows[0]["d_updated_date"].ToString(); #endregion #region set Control ViewState["new_id"] = strnew_id; txtnew_title.Text = strnews_title; txtnew_des.Text = strnews_title; cboNew_type.SelectedValue = strnews_type; cboNew_status.SelectedValue = strnews_status; txtnews_file_name.Text = strnews_file_name; if (strC_active.Equals("Y")) { chkStatus.Checked = true; } else { chkStatus.Checked = false; } #endregion } } } catch (Exception ex) { lblError.Text = ex.Message.ToString(); } }
private bool saveData() { bool blnResult = false; bool blnDup = false; string strMessage = string.Empty; string strActive = string.Empty, strCreatedBy = string.Empty, strUpdatedBy = string.Empty; string strScript = string.Empty; string strnews_id = "0"; string strnews_file_name = string.Empty; cNews oNews = new cNews(); DataSet ds = new DataSet(); try { #region set Data if (txtnews_file_name.Text.Length > 0) { strnews_file_name = txtnews_file_name.Text; } if (chkStatus.Checked == true) { strActive = "Y"; } else { strActive = "N"; } strCreatedBy = Session["username"].ToString(); strUpdatedBy = Session["username"].ToString(); #endregion if (ViewState["mode"].ToString().ToLower().Equals("edit")) { #region edit if (!blnDup) { if (oNews.SP_NEW_UPD(ViewState["new_id"].ToString(), txtnew_title.Text, txtnew_des.Text, cboNew_type.SelectedValue, cboNew_status.SelectedValue, strnews_file_name, "", strActive, strUpdatedBy, ref strMessage)) { blnResult = true; } else { lblError.Text = strMessage.ToString(); } } else { ScriptManager.RegisterStartupScript(Page, Page.GetType(), "frMainPage", strScript, true); } #endregion } else { #region insert if (!blnDup) { if (oNews.SP_NEW_INS(txtnew_title.Text, txtnew_des.Text, cboNew_type.SelectedValue, cboNew_status.SelectedValue, strnews_file_name, "", strActive, strCreatedBy, ref strMessage)) { string strGetcode = " and new_title = '" + txtnew_title.Text + "' "; if (!oNews.SP_NEW_SEL(strGetcode, ref ds, ref strMessage)) { lblError.Text = strMessage; } if (ds.Tables[0].Rows.Count > 0) { strnews_id = ds.Tables[0].Rows[0]["new_id"].ToString(); } ViewState["news_id"] = strnews_id; blnResult = true; } else { lblError.Text = strMessage.ToString(); } } else { ScriptManager.RegisterStartupScript(Page, Page.GetType(), "frMainPage", strScript, true); } #endregion } } catch (Exception ex) { lblError.Text = ex.Message.ToString(); } finally { oNews.Dispose(); } return(blnResult); }
using System;
private void button1_Click(object sender, EventArgs e) { progressBar1.Value = 0; List <cNews> news; news = new List <cNews>(); foreach (var elem in ChDriver.FindElements(By.ClassName("wall_post_cont"))) { cNews toBeAddedObject = new cNews(); List <IWebElement> postTexts = FindIWIWebElementByClassName(elem, "wall_post_text"); List <IWebElement> imagLinks = FindIWIWebElementByClassName(elem, "page_post_sized_thumbs"); toBeAddedObject.Id = elem.GetAttribute("id"); if (postTexts.Any()) { toBeAddedObject.Text = postTexts[0].Text; //foreach (IWebElement link in postTexts[0].FindElements(By.TagName("a"))) //{ // if (string.IsNullOrEmpty(link.GetAttribute("href"))) // continue; // toBeAddedObject.link.Add(link.GetAttribute("href"));//linq //} toBeAddedObject.Link.AddRange((from link in postTexts[0].FindElements(By.TagName("a")) where !string.IsNullOrEmpty(link.GetAttribute("href")) select link.GetAttribute("href"))); } if (imagLinks.Any()) { foreach (IWebElement iml in imagLinks[0].FindElements(By.TagName("a"))) { string temp = iml.GetCssValue("background-image"); if (!string.IsNullOrEmpty(temp) && temp.Length > 7) { temp = temp.Substring(5); temp = temp.Remove(temp.Length - 2); toBeAddedObject.ImageLink.Add(temp); } } } if (toBeAddedObject.ImageLink.Any() || toBeAddedObject.Link.Any() || !string.IsNullOrEmpty(toBeAddedObject.Text)) { news.Add(toBeAddedObject); } } progressBar1.Value = 5; // bool[] fileIsBusy = new bool[3] { false, false, false }; string[] fileName = new string[3] { "JStext.txt", "JSlink.txt", "JSimageLink.txt" }; for (int i = 0; i < 3; i++) { if (FileOperation.IsOpen(fileName[i])) { FileOperation.DeleteLockMarker(fileName[i]); } } // writeToJson(fileName[0], 1, news, ref fileIsBusy[0]); FileOperation[] fileOperations = new FileOperation[3] { new FileOperation(fileName[0]), new FileOperation(fileName[1]), new FileOperation(fileName[2]), }; Task[] tasks = new Task[4] { new Task(() => WriteToJson(fileName[0], 1, news, ref fileOperations[0])), new Task(() => WriteToJson(fileName[1], 2, news, ref fileOperations[1])), new Task(() => WriteToJson(fileName[2], 3, news, ref fileOperations[2])), new Task(() => ReadFromJson(fileName, ref fileOperations)), }; //Task.Factory.StartNew(() => writeToJson("JStext.txt", 1, news,)); //Task.Factory.StartNew(() => writeToJson("JSlink.txt", 2, news,)); //Task.Factory.StartNew(() => writeToJson("JSimageLink.txt", 3, news,)); for (int i = 0; i < 4; i++) { tasks[i].Start(); } progressBar1.Value += 5; }