protected void dg1_ItemCommand(object source, DataGridCommandEventArgs e)
{
try
{
if (e.CommandName == "AddANewRow")
{
var db = new Pizza15Model();
TextBox txtName = e.Item.FindControl("txtNamesF") as TextBox;
TextBox txtTitle = e.Item.FindControl("txttitleF") as TextBox;
TextBox txtReview = e.Item.FindControl("txtReviewF") as TextBox;
bool IsVerified = false;
CheckBox cbVerify = e.Item.FindControl("cbverify") as CheckBox;
if (txtName != null && txtTitle != null && txtReview != null)
{
var strQueryMax = db.tbl_ClientReviews.Max(x => x.ReviewID);
int nMaxID = Convert.ToInt32(strQueryMax);
var strQuery = new tbl_ClientReviews();
if (nMaxID != 0)
{
strQuery.ReviewID = nMaxID + 1;
}
else
{
strQuery.ReviewID = 1;
}
strQuery.ClientNames = txtName.Text;
strQuery.ClientReview = Server.HtmlDecode(txtReview.Text);
strQuery.ClientTitle = txtTitle.Text;
IsVerified = true;
strQuery.ReviewIsVerified = IsVerified;
strQuery.CreateDates = DateTime.Now;
db.tbl_ClientReviews.Add(strQuery);
db.SaveChanges();
}
else
{
lblError.Text = "Error finding the Testimonials";
}
Session["Testimonial"] = null;
GetData();
}
}
catch (Exception ex)
{
lblError.Text = ex.Message;
}
}
protected void dg1_UpdateCommand(object source, DataGridCommandEventArgs e)
{
try
{
string strID = dg1.DataKeys[e.Item.ItemIndex].ToString();
int nStrID = Convert.ToInt32(strID);
TextBox txtName = e.Item.FindControl("txtNamesE") as TextBox;
TextBox txtTitle = e.Item.FindControl("txttitleE") as TextBox;
TextBox txtReview = e.Item.FindControl("txtReviewE") as TextBox;
CheckBox cbVerify = e.Item.FindControl("cbVerifyE") as CheckBox;
if (txtName != null && txtTitle != null && txtReview != null)
{
var db = new Pizza15Model();
tbl_ClientReviews UpdateTestimonials = db.tbl_ClientReviews.FirstOrDefault(x => x.ReviewID.Equals(nStrID));
if (UpdateTestimonials != null)
{
UpdateTestimonials.ClientNames = txtName.Text.Trim();
UpdateTestimonials.ClientReview = Server.HtmlDecode(txtReview.Text.Trim());
UpdateTestimonials.ClientTitle = txtTitle.Text.Trim();
UpdateTestimonials.ReviewIsVerified = Convert.ToBoolean(cbVerify.Checked);
UpdateTestimonials.CreateDates = DateTime.Now;
db.SaveChanges();
}
}
else
{
lblError.Text = "Error finding the Testimonials";
}
dg1.EditItemIndex = -1;
dg1.ShowFooter = true;
Session["Testimonial"] = null;
GetData();
}
catch (Exception ex)
{
lblError.Text = ex.Message;
}
}
