protected void dg_UpdateCommand(object source, DataGridCommandEventArgs e)
{
try
{
string strID = dg.DataKeys[e.Item.ItemIndex].ToString();
int nStrID = Convert.ToInt32(strID);
TextBox txtNewsE = e.Item.FindControl("txtNewsE") as TextBox;
CheckBox chkActiveE = e.Item.FindControl("chkActiveE") as CheckBox;
if (txtNewsE != null && chkActiveE != null)
{
var db = new Pizza15Model();
tblNewsEvent Events = db.tblNewsEvents.FirstOrDefault(x => x.NewsID.Equals(nStrID));
if (Events != null)
{
Events.News = txtNewsE.Text;
Events.Active = Convert.ToBoolean(chkActiveE.Checked);
db.SaveChanges();
}
}
else
{
lblError.Text = "Error finding the News & Event";
}
dg.EditItemIndex = -1;
dg.ShowFooter = true;
Session["Event"] = null;
GetData();
}
catch (Exception ex)
{
lblError.Text = ex.Message;
}
}
private void SwapIndex(int nNewsID1, int nIndex1, int nNewsID2, int nIndex2)
{
try
{
var db = new Pizza15Model();
tblNewsEvent Events = db.tblNewsEvents.Single(x => x.NewsID.Equals(nNewsID1));
if (Events != null)
{
Events.Indx = nIndex2;
db.SaveChanges();
}
tblNewsEvent NewsEvents = db.tblNewsEvents.Single(x => x.NewsID.Equals(nNewsID2));
if (NewsEvents != null)
{
NewsEvents.Indx = nIndex1;
db.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
protected void dg_ItemCommand(object source, DataGridCommandEventArgs e)
{
try
{
if (e.CommandName == "AddANewRow")
{
var db = new Pizza15Model();
TextBox txtNewsF = e.Item.FindControl("txtNewsF") as TextBox;
CheckBox chkActiveF = e.Item.FindControl("chkActiveF") as CheckBox;
if (txtNewsF != null && chkActiveF != null)
{
int nMaxID = 0;
try
{
var strQueryMax = db.tblNewsEvents.Max(x => x.NewsID);
nMaxID = Convert.ToInt32(strQueryMax);
}
catch
{
nMaxID = 0;
}
var strQuery = new tblNewsEvent();
if (nMaxID != 0)
{
strQuery.NewsID = nMaxID + 1;
}
else
{
strQuery.NewsID = 1;
}
strQuery.News = txtNewsF.Text;
strQuery.Indx = nMaxID + 1;
strQuery.Active = Convert.ToBoolean(chkActiveF.Checked);
db.tblNewsEvents.Add(strQuery);
db.SaveChanges();
}
else
{
lblError.Text = "Error finding the News & Events";
}
Session["Event"] = null;
GetData();
}
if (e.CommandName == "MoveUp")
{
if (e.Item.ItemIndex == 0)
{
lblError.Text = "This item cannot be moved further up";
}
else
{
int nNewsID = Convert.ToInt32((e.Item.FindControl("lblNewsID") as Label).Text);
int nIndex = Convert.ToInt32((e.Item.FindControl("lblIndex") as Label).Text);
int nNewsIDAbove = Convert.ToInt32((dg.Items[e.Item.ItemIndex - 1].FindControl("lblNewsID") as Label).Text);
int nIndexAbove = Convert.ToInt32((dg.Items[e.Item.ItemIndex - 1].FindControl("lblIndex") as Label).Text);
SwapIndex(nNewsIDAbove, nIndexAbove, nNewsID, nIndex);
Session["Event"] = null;
GetData();
}
}
if (e.CommandName == "MoveDown")
{
if (e.Item.ItemIndex == (dg.Items.Count - 1))
{
lblError.Text = "This item cannot be moved further down";
}
else
{
int nNewsID = Convert.ToInt32((e.Item.FindControl("lblNewsID") as Label).Text);
int nIndex = Convert.ToInt32((e.Item.FindControl("lblIndex") as Label).Text.Trim().ToString());
int nNewsIDBelow = Convert.ToInt16((dg.Items[e.Item.ItemIndex + 1].FindControl("lblNewsID") as Label).Text);
int nIndexBelow = Convert.ToInt16((dg.Items[e.Item.ItemIndex + 1].FindControl("lblIndex") as Label).Text.Trim().ToString());
SwapIndex(nNewsID, nIndex, nNewsIDBelow, nIndexBelow);
Session["Event"] = null;
GetData();
}
}
}
catch (Exception ex)
{
throw ex;
//lblError.Text = ex.Message;
}
}
