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