protected void dg_ItemCommand(object source, DataGridCommandEventArgs e)
{
try
{
if (e.CommandName == "AddANewRow")
{
var db = new Pizza15Model();
TextBox txtDay = e.Item.FindControl("txtDayF") as TextBox;
TextBox txtSpecial = e.Item.FindControl("txtSpecialF") as TextBox;
if (txtDay != null && txtSpecial != null)
{
var DailySpecials = db.tblDailySpecials.Select(x => new
{
DailyID = x.DailyID,
Day = x.Day,
Special = x.Special,
}).ToList();
if (DailySpecials.Count != 0)
{
var strQueryMax = db.tblDailySpecials.Max(x => x.DailyID);
int nMaxID = Convert.ToInt32(strQueryMax);
var strQuery = new tblDailySpecial();
strQuery.DailyID = nMaxID + 1;
strQuery.Day = txtDay.Text;
strQuery.Special = txtSpecial.Text;
db.tblDailySpecials.Add(strQuery);
db.SaveChanges();
}
else
{
var strQueryMax = db.tblDailySpecials;
var strQuery = new tblDailySpecial();
strQuery.Day = txtDay.Text;
strQuery.Special = txtSpecial.Text;
db.tblDailySpecials.Add(strQuery);
db.SaveChanges();
}
}
else
{
lblError.Text = "Error finding the Daily Specials";
}
Session["DailySpecial"] = null;
GetData();
}
}
catch (Exception ex)
{
lblError.Text = ex.Message;
}
}
protected void dg_UpdateCommand(object source, DataGridCommandEventArgs e)
{
try
{
string strID = dg.DataKeys[e.Item.ItemIndex].ToString();
int nStrID = Convert.ToInt32(strID);
TextBox txtDay = e.Item.FindControl("txtDayE") as TextBox;
TextBox txtSpecial = e.Item.FindControl("txtSpecialE") as TextBox;
if (txtDay != null && txtSpecial != null)
{
var db = new Pizza15Model();
tblDailySpecial UpdateDailySpecial = db.tblDailySpecials.FirstOrDefault(x => x.DailyID.Equals(nStrID));
if (UpdateDailySpecial != null)
{
UpdateDailySpecial.Day = txtDay.Text.Trim();
UpdateDailySpecial.Special = txtSpecial.Text.Trim();
db.SaveChanges();
}
}
else
{
lblError.Text = "Error finding the Daily Special";
}
dg.EditItemIndex = -1;
dg.ShowFooter = true;
Session["DailySpecial"] = null;
GetData();
}
catch (Exception ex)
{
lblError.Text = ex.Message;
}
}
