protected void BtnUploadClick1(object sender, EventArgs e) { _objCommon = new Common(); try { var objClsOledbdatalayer = new ClsOleDBDataWrapper(); var path = MapPath(fulUploadExcel.FileName); fulUploadExcel.SaveAs(path); var excelSheets = objClsOledbdatalayer.CountTotalSheets(path); if (excelSheets.Length <= 0) { return; } foreach (string t in excelSheets) { DataSet ds = objClsOledbdatalayer.getdata(path, t); if (ds != null && ds.Tables.Count > 0) { for (int j = 0; j <= ds.Tables[0].Rows.Count - 1; j++) { var errMsg = ""; _objNewsDetails = new NewsArticleProperty { NewsSubject = ds.Tables[0].Rows[j]["NewsSubject"].ToString(), NewsUrl = ds.Tables[0].Rows[j]["NewsUrl"].ToString(), NewsTitle = ds.Tables[0].Rows[j]["NewsTitle"].ToString(), NewsTag = ds.Tables[0].Rows[j]["NewsTag"].ToString(), NewsMetaDesc = ds.Tables[0].Rows[j]["NewsMetaDesc"].ToString(), NewsDesc = ds.Tables[0].Rows[j]["NewsDesc"].ToString(), NewsImage = ds.Tables[0].Rows[j]["NewsImage"].ToString(), NewsShortDesc = ds.Tables[0].Rows[j]["NewsShortDesc"].ToString(), NewsStatus = ds.Tables[0].Rows[j]["NewsStatus"].ToString() == "True" ? true : false, NewsBy = ds.Tables[0].Rows[j]["NewsBy"].ToString(), NewsDate = ds.Tables[0].Rows[j]["NewsDate"].ToString() == "" ? DateTime.Now : Convert.ToDateTime(ds.Tables[0].Rows[j]["NewsDate"].ToString()), }; var result = NewsArticleNoticeProvider.Instance.InsertNewsDetails(_objNewsDetails, LoggedInUserId, out errMsg); } } } } catch (Exception EX) { } }
public abstract int UpdateArticleDetails(NewsArticleProperty objNewsArticle, int modifiedBy, out string errmsg);
public abstract int InsertArticleDetails(NewsArticleProperty objNewsArticle, int createdBy, out string errmsg);
private void InsertUpdateNewsDetails() { try { int result; string errMsg; var fileName = this.FlUpload.UploadedImageName; if (fileName != null) { hdnFileName.Value = fileName; } _objNewsDetails = new NewsArticleProperty { NewsSubject = txtNewsSubject.Text.Trim().TrimEnd('-'), NewsUrl = txtNewsUrl.Text.Trim().TrimEnd('-'), NewsTitle = txtNewsTitle.Text.Trim().TrimEnd('-'), NewsTag = txtNewsMetaTag.Text.Trim(), NewsMetaDesc = txtNewsMetaDesc.Text.Trim().TrimEnd('-'), NewsDesc = fckNewsDesc.FckValue.Trim().TrimEnd('-'), NewsImage = hdnFileName.Value, NewsShortDesc = txtShortDesc.Text.Trim().TrimEnd('-'), NewsStatus = chkStatus.Checked, NewsBy = txtNewsBy.Text.Trim(), NewsDate = txtNewsDate.Text == "" ? DateTime.Now : Convert.ToDateTime(txtNewsDate.Text.Trim()), }; if (btnSave.Text == "Save") { result = NewsArticleNoticeProvider.Instance.InsertNewsDetails(_objNewsDetails, LoggedInUserId, out errMsg); if (result <= 0) { return; } Response.Redirect("NewsAndArticles.aspx"); } else { _objNewsDetails.NewsId = Convert.ToInt16((Request.QueryString["NewsId"])); result = NewsArticleNoticeProvider.Instance.UpdateNewsDetails(_objNewsDetails, LoggedInUserId, out errMsg); if (result <= 0) { return; } Response.Redirect("NewsAndArticles.aspx", true); } } catch (Exception ex) { var err = ex.Message; if (ex.InnerException != null) { err = err + " :: Inner Exception :- " + ex.InnerException.Message; } const string addInfo = "Error while executing InsertUpdateNewsDetails in AddNewsAndArticles.aspx :: -> "; var objPub = new ClsExceptionPublisher(); objPub.Publish(err, addInfo); } }