protected void DeleteAssocCategory(object sender, GridViewDeleteEventArgs e)
{
int AssocCategoryId = 0;
int rowindexval = e.RowIndex;
int count = 0;
bool result = false;
AdviserAssociateCategorySetupBo AdviserAssociateCategorySetup = new AdviserAssociateCategorySetupBo();
AdvisorBranchBo advisorBranchBo = new AdvisorBranchBo();
if (gvAssocCatSetUpBounded.DataKeys[rowindexval].Value != System.DBNull.Value)
{
AssocCategoryId = Convert.ToInt32(gvAssocCatSetUpBounded.DataKeys[rowindexval].Value);
}
count = advisorBranchBo.CheckAssociateBranchCategory(AssocCategoryId);
if (count > 0)
{
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "pageloadscript", "alert('Sorry, This category cannot be deleted as this is associated with one or more branches !');", true);
}
else
{
result = AdviserAssociateCategorySetup.DeleteAdviserAssociateCategory(AssocCategoryId);
}
if (result)
{
//Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "pageloadscript", "loadcontrol('AdviserAssociateCategorySetup','login');", true);
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "pageloadscript", "alert('Deleted Successfully !');", true);
FillGrid();
}
}
private void FillGrid()
{
DataSet ds;
int num = 0;
AdviserAssociateCategorySetupBo AdviserAssociateCategorySetup = new AdviserAssociateCategorySetupBo();
ds = AdviserAssociateCategorySetup.GetAdviserAssociateCategory(adviserVo.advisorId);
num = ds.Tables[0].Rows.Count;
//IF num is 0 then load grid with deafult values.
if (num == 0)
{
trAssignNumber.Visible = true;
trUnboundedgrid.Visible = true;
btnSave.Visible = false;
}
else
{
ds.Tables[0].Columns.Add("RowNumber");
int i = 1;
foreach (DataRow dr in ds.Tables[0].Rows)
{
dr["RowNumber"] = i;
i++;
}
ViewState["CurrentTable"] = ds.Tables[0];
trBoundedgrid.Visible = true;
gvAssocCatSetUpBounded.DataSource = ds;
gvAssocCatSetUpBounded.DataBind();
DataBoundedFromDb = true;
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
AssociateCategoryVo associatecategory = new AssociateCategoryVo();
AdviserAssociateCategorySetupBo AdviserAssociateCategorySetup = new AdviserAssociateCategorySetupBo();
associatecategory.AdviserId = adviserVo.advisorId;
if (gvAssocCatSetUpBounded.Rows.Count > 0)
{
foreach (GridViewRow dr in gvAssocCatSetUpBounded.Rows)
{
associatecategory.AssociateCategoryCode = ((TextBox)dr.FindControl("TextBox1")).Text;
associatecategory.AssociateCategoryName = ((TextBox)dr.FindControl("TextBox2")).Text;
if (gvAssocCatSetUpBounded.DataKeys[dr.RowIndex].Value != System.DBNull.Value)
{
associatecategory.AssociateCategoryId = Convert.ToInt32(gvAssocCatSetUpBounded.DataKeys[dr.RowIndex].Value);
}
else
{
associatecategory.AssociateCategoryId = 0;
associatecategory.CreatedBy = userVo.UserId;
associatecategory.CreatedOn = DateTime.Now;
}
associatecategory.ModifiedBy = userVo.UserId;
associatecategory.Modifiedon = DateTime.Now;
bool result = AdviserAssociateCategorySetup.UpdateAdviserAssociateCategory(associatecategory);
}
FillGrid();
}
else if (gvAssocCatSetUp.Rows.Count > 0)
{
foreach (GridViewRow dr in gvAssocCatSetUp.Rows)
{
associatecategory.AssociateCategoryCode = ((TextBox)dr.FindControl("TextBox1")).Text;
associatecategory.AssociateCategoryName = ((TextBox)dr.FindControl("TextBox2")).Text;
associatecategory.CreatedBy = userVo.UserId;
associatecategory.CreatedOn = DateTime.Now;
associatecategory.ModifiedBy = userVo.UserId;
associatecategory.Modifiedon = DateTime.Now;
bool result = AdviserAssociateCategorySetup.InsertAdviserAssociateCategory(associatecategory);
}
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "pageloadscript", "loadcontrol('AdviserAssociateCategorySetup','login');", true);
//FillGrid();
}
}
