public static int InsertUpdateResources(GroupPages grp)
{
int res = 0;
List <SqlParameter> parm = new List <SqlParameter>();
try
{
using (DbManager db = DbManager.GetDbManager())
{
if (grp.intResourceID == 0)
{
parm.Add(db.MakeInParam("@intResourceId", SqlDbType.Int, 0, 0));
parm.Add(db.MakeInParam("@dtmDateModified", SqlDbType.DateTime, 0, DBNull.Value));
parm.Add(db.MakeInParam("@intModifiedBy", SqlDbType.Int, 0, 0));
parm.Add(db.MakeInParam("@bitIsDeleted", SqlDbType.Bit, 0, 0));
}
else
{
parm.Add(db.MakeInParam("@intResourceId", SqlDbType.Int, 0, grp.intResourceID));
parm.Add(db.MakeInParam("@dtmDateModified", SqlDbType.DateTime, 0, DateTime.Now));
parm.Add(db.MakeInParam("@intModifiedBy", SqlDbType.Int, 0, 1));
parm.Add(db.MakeInParam("@bitIsDeleted", SqlDbType.Bit, 0, 0));
}
parm.Add(db.MakeInParam("@vchName", SqlDbType.VarChar, 250, grp.vchName));
parm.Add(db.MakeInParam("@intCreatedBy", SqlDbType.Int, 0, grp.intCreatedBy));
parm.Add(db.MakeInParam("@vchPath", SqlDbType.VarChar, 500, grp.vchPath));
parm.Add(db.MakeInParam("@intparentid", SqlDbType.Int, 0, grp.intParentID));
res = db.RunProc("up_InsertUpdateResources", parm.ToArray());
return(res);
}
}
catch (Exception exp)
{
new SqlLog().InsertSqlLog(0, "GroupPages.Insert", exp);
return(0);
}
}
protected void gvPages_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
if (e.CommandName == "Edit")
{
pageid = Convert.ToInt32(e.CommandArgument);
}
else if (e.CommandName == "Delete")
{
if (Convert.ToBoolean(hdfactive.Value) == true)
GroupPages.ActiveDeactiveGroupPage(Convert.ToInt32(e.CommandArgument), false);
else
GroupPages.ActiveDeactiveGroupPage(Convert.ToInt32(e.CommandArgument), true);
loadPages();
}
else if (e.CommandName == "AddMore")
{
LinkButton lnkbtnAddMorePage = gvPages.FooterRow.FindControl("lnkbtnAddMore") as LinkButton;
LinkButton lnkbtnAddPage = gvPages.FooterRow.FindControl("lnkbtnAddPage") as LinkButton;
LinkButton lnkbtnCancelPage = gvPages.FooterRow.FindControl("lnkbtnCancelPage") as LinkButton;
lnkbtnAddPage.Visible = true;
lnkbtnAddMorePage.Visible = false;
lnkbtnCancelPage.Visible = true;
TextBox txtPageNamefoot = gvPages.FooterRow.FindControl("txtPageNamefooter") as TextBox;
DropDownList ddlDomainNamefoot = gvPages.FooterRow.FindControl("ddlTypeFooter") as DropDownList;
TextBox txtPagePathfoot = gvPages.FooterRow.FindControl("txtPagePathfooter") as TextBox;
txtPageNamefoot.Visible = true;
ddlDomainNamefoot.Visible = true;
txtPagePathfoot.Visible = true;
ddlDomainNamefoot.Items.Insert(0, new ListItem("--Select Domain--", "0"));
Utils.GetLookUpData<DropDownList>(ref ddlDomainNamefoot, LookUps.MainResources, true);
}
else if (e.CommandName == "CancelPage")
{
gvPages.EditIndex = -1;
loadPages();
}
else if (e.CommandName == "Insert")
{
TextBox txtPageName = gvPages.FooterRow.FindControl("txtPageNamefooter") as TextBox;
DropDownList ddlDomainName = gvPages.FooterRow.FindControl("ddlTypeFooter") as DropDownList;
TextBox txtPagePath = gvPages.FooterRow.FindControl("txtPagePathfooter") as TextBox;
GroupPages grp = new GroupPages();
grp.vchName = txtPageName.Text;
grp.vchPath = txtPagePath.Text;
grp.intParentID = Convert.ToInt32(ddlDomainName.SelectedItem.Value);
grp.intResourceID = 0;
GroupPages.InsertUpdateResources(grp);
loadPages();
}
}
catch (Exception ex)
{
new SqlLog().InsertSqlLog(0, "Addpages.aspx.gvPages_RowCommand", ex);
}
}
protected void lnkbtnAddPage_Click(object sender, EventArgs e)
{
try
{
GroupPages grp = new GroupPages();
grp.intResourceID = 0;
grp.vchName = txtPageNamefooter.Text + "(" + ddlTypeFooter.SelectedItem.Text + ")";
grp.intParentID = Convert.ToInt32(ddlTypeFooter.SelectedItem.Value);
grp.vchPath = txtPagePathfooter.Text;
GroupPages.InsertUpdateResources(grp);
loadPages();
}
catch (Exception ex)
{
new SqlLog().InsertSqlLog(0, "Addpages.aspx.lnkbtnAddPage_Click", ex);
}
}
protected void gvPages_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
try
{
TextBox txtPageName = (TextBox)gvPages.Rows[e.RowIndex].FindControl("txtPageName");
DropDownList ddlDomainName = gvPages.Rows[e.RowIndex].FindControl("ddlType") as DropDownList;
TextBox txtPagePath = (TextBox)gvPages.Rows[e.RowIndex].FindControl("txtPagePath");
GroupPages grp = new GroupPages();
grp.intResourceID = Convert.ToInt32(gvPages.DataKeys[e.RowIndex].Values[0].ToString());
grp.vchName = txtPageName.Text + "(" + ddlDomainName.SelectedItem.Text + ")";
grp.intParentID = Convert.ToInt32(ddlDomainName.SelectedItem.Value);
grp.vchPath = txtPagePath.Text;
GroupPages.InsertUpdateResources(grp);
gvPages.EditIndex = -1;
loadPages();
}
catch (Exception ex)
{
new SqlLog().InsertSqlLog(0, "Addpages.aspx.gvPages_RowUpdating", ex);
}
}
public static int InsertUpdateResources(GroupPages grp)
{
int res = 0;
List<SqlParameter> parm = new List<SqlParameter>();
try
{
using (DbManager db = DbManager.GetDbManager())
{
if (grp.intResourceID == 0)
{
parm.Add(db.MakeInParam("@intResourceId", SqlDbType.Int, 0, 0));
parm.Add(db.MakeInParam("@dtmDateModified", SqlDbType.DateTime, 0, DBNull.Value));
parm.Add(db.MakeInParam("@intModifiedBy", SqlDbType.Int, 0, 0));
parm.Add(db.MakeInParam("@bitIsDeleted", SqlDbType.Bit, 0, 0));
}
else
{
parm.Add(db.MakeInParam("@intResourceId", SqlDbType.Int, 0, grp.intResourceID));
parm.Add(db.MakeInParam("@dtmDateModified", SqlDbType.DateTime, 0, DateTime.Now));
parm.Add(db.MakeInParam("@intModifiedBy", SqlDbType.Int, 0, 1));
parm.Add(db.MakeInParam("@bitIsDeleted", SqlDbType.Bit, 0, 0));
}
parm.Add(db.MakeInParam("@vchName", SqlDbType.VarChar, 250, grp.vchName));
parm.Add(db.MakeInParam("@intCreatedBy", SqlDbType.Int, 0, grp.intCreatedBy));
parm.Add(db.MakeInParam("@vchPath", SqlDbType.VarChar, 500, grp.vchPath));
parm.Add(db.MakeInParam("@intparentid", SqlDbType.Int, 0, grp.intParentID));
res = db.RunProc("up_InsertUpdateResources", parm.ToArray());
return res;
}
}
catch (Exception exp)
{
new SqlLog().InsertSqlLog(0, "GroupPages.Insert", exp);
return 0;
}
}