protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
Label lblid = ((Label)GridView1.Rows[e.RowIndex].FindControl("Label6"));
//DropDownList cid = (DropDownList)GridView1.Rows[e.RowIndex].FindControl("DropDownList1");
TextBox txtnews = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txtnews");
TextBox txtNDate = (TextBox)GridView1.Rows[e.RowIndex].FindControl("TextBox2");
int tid = Convert.ToInt16(lblid.Text);
NewsMaster data = db.NewsMasters.Where(d => d.NewsId == tid).FirstOrDefault();
data.News = txtnews.Text;
data.NewsDate = Convert.ToDateTime(txtNDate.Text);
// data.EndDate = Convert.ToDateTime(txtEdate.Text);
db.SubmitChanges();
//db.manage_newsmaster(Convert.ToInt16(lblid.Text),txtnews.Text,Convert.ToInt16(cid.SelectedValue),true,2);
GridView1.EditIndex = -1;
bindgrid();
}
public static int SaveNews(NewsMaster _NewsMaster)
{
using (SportyFYEntities model = new SportyFYEntities())
{
model.NewsMasters.Add(new NewsMaster
{
NewsId = _NewsMaster.NewsId,
CategoryId = _NewsMaster.CategoryId,
SubCategoryId = _NewsMaster.SubCategoryId,
NewsTitle = _NewsMaster.NewsTitle,
NewsContent = _NewsMaster.NewsContent,
NewsAuthor = _NewsMaster.NewsAuthor,
NewsCreateDate = _NewsMaster.NewsCreateDate,
IsDel = _NewsMaster.IsDel,
Userid = _NewsMaster.Userid,
NewsDate = _NewsMaster.NewsDate
});
return(model.SaveChanges());
}
}
public void EditpostNews(NewsVM z)
{
NewsMaster news = new NewsMaster();
news.ModifiedBy = 1;
news.ModifiedDate = DateTime.Now;
news.CategoryId = z.CategoryId;
news.NewsDescription = z.NewsDetail;
news.NewsId = z.NewsId;
news.PublishingDate = z.NewsPublishingDate;
news.NewsTitle = z.NewsTitle;
news.NewsUrl = z.NewsURL;
news.IsActive = z.IsActive;
news.CreatedBy = z.CreatedBy;
news.CreatedDate = z.CreatedDate;
news.Keywords = z.MetaKeywords;
news.MetaTitle = z.MetaTitle;
news.MetaDescritpion = z.MetaDescription;
//JavaScriptSerializer serializer = new JavaScriptSerializer();
//var s = serializer.Serialize(news);
//NewsMaster newsmaster = serializer.Deserialize<NewsMaster>(s);
try
{
db.Entry(news).State = EntityState.Modified;
db.SaveChanges();
}
catch (DbEntityValidationException ex)
{
foreach (var validationError in ex.EntityValidationErrors)
{
foreach (var validationerrors in validationError.ValidationErrors)
{
System.Console.WriteLine("property name{0}", validationerrors.PropertyName);
}
}
}
}
public static string SaveNews(ContentPlaceHolder _refContentPlaceHolder)
{
try
{
if (_refContentPlaceHolder.Controls.Count > 0)
{
TextBox txt = null;
DropDownList ddl = null;
NewsMaster _NewsMaster = new NewsMaster();
List <string> lstTags = new List <string>();
Guid _newsID = Guid.NewGuid();
_NewsMaster.NewsId = _newsID;
_NewsMaster.IsDel = false;
_NewsMaster.Userid = RoleAuth.GetUserID();
_NewsMaster.NewsCreateDate = DateTime.Now;
foreach (var item in _refContentPlaceHolder.Controls)
{
if (item is DropDownList)
{
ddl = item as DropDownList;
if (ddl.ID == "ddl_NewsCategory")
{
if (ddl.SelectedItem.Value == "-1")
{
// validate the data and return message
throw new Exception("there is no category selected!");
}
else
{
// creating the NewsMaster data
_NewsMaster.CategoryId = int.Parse(ddl.SelectedItem.Value.Trim());
}
}
else if (ddl.ID == "ddl_newsSubCategory")
{
ddl = item as DropDownList;
if (ddl.SelectedItem.Value == "-1")
{
// validate the data and return message
throw new Exception("there is no sub category selected!");
}
else
{
// creating the NewsMaster data
_NewsMaster.SubCategoryId = int.Parse(ddl.SelectedItem.Value.Trim());
}
}
}
else if (item is TextBox)
{
txt = item as TextBox;
if (txt.ID == "txtTitle")
{
if (txt.Text == "")
{
// validate the data and return message
throw new Exception("please enter title!");
}
else
{
// creating the NewsMaster data
_NewsMaster.NewsTitle = txt.Text.Trim();
}
}
else if (txt.ID == "txtNewsDate")
{
if (txt.Text == "")
{
// validate the data and return message
throw new Exception("please select date!");
}
else
{
// creating the NewsMaster data
_NewsMaster.NewsDate = DateTime.Parse(txt.Text.Trim());
}
}
else if (txt.ID == "txtAuthor")
{
if (txt.Text == "")
{
// validate the data and return message
throw new Exception("please enter Author Name!");
}
else
{
// creating the NewsMaster data
_NewsMaster.NewsAuthor = txt.Text.Trim();
}
}
else if (txt.ID == "txtContent")
{
if (txt.Text == "")
{
// validate the data and return message
throw new Exception("please enter news content!");
}
else
{
// creating the NewsMaster data
_NewsMaster.NewsContent = txt.Text;
}
}
else if (txt.ID == "txtTags")
{
if (txt.Text == "")
{
// validate the data and return message
lstTags = null;
}
else
{
// creating the NewsMaster data
string[] tags = txt.Text.Trim().Split(',').ToArray();
for (int i = 0; i < tags.Length; i++)
{
lstTags.Add(tags[i].Trim());
}
}
}
}
}
// Save into NewsMaster Table
int t = EDM_NewsMaster.SaveNews(_NewsMaster);
if (t > 0)
{
if (lstTags != null && lstTags.Count > 0)
{
for (int i = 0; i < lstTags.Count; i++)
{
t = BAL_NewsTags.SaveNewsTags(_newsID, lstTags[i].Trim());
}
}
else if (lstTags == null)
{
//TODO
}
return("Success");
}
else
{
return("Faliure");
}
}
else
{
throw new Exception("Null Data");
}
}
catch (Exception ex)
{
throw ex;
}
}
