public void BindHierarchyGrid(int adviserId)
{
try
{
dsHierarchyClusterDetails = new DataSet();
PSBo = new ProductgroupSetupBo();
//getting dataset for grid and the rm ddl and the Hierarchy name ddl
dsHierarchyClusterDetails = PSBo.GetHierarchyDetails(advisorVo.advisorId);//, Convert.ToInt32(rcbShow.SelectedValue));
gvHirarchy.DataSource = dsHierarchyClusterDetails;
gvHirarchy.DataBind();
//set the visibility for export button
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "AdviserHierarchyCluster.ascx: BindHierarchyGrid(int adviserId)");
object[] objects = new object[3];
objects[0] = adviserId;
objects[1] = type;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
}
protected void gvHirarchy_NeedDataSource(object source, GridNeedDataSourceEventArgs e)
{
DataTable dtGvSchemeDetails = new DataTable();
try
{
dsHierarchyClusterDetails = new DataSet();
PSBo = new ProductgroupSetupBo();
//getting dataset for grid and the rm ddl and the Hierarchy name ddl
dsHierarchyClusterDetails = PSBo.GetHierarchyDetails(advisorVo.advisorId);//, Convert.ToInt32(rcbShow.SelectedValue));
gvHirarchy.DataSource = dsHierarchyClusterDetails;
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "ProductgroupSetup.ascx:gvHirarchy_NeedDataSource(object source, GridNeedDataSourceEventArgs e)");
object[] objects = new object[3];
objects[0] = dtGvSchemeDetails;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
}
protected void btnChannelSubmit_Click(object sender, EventArgs e)
{
//bool IsInserted = false;
ProductgroupSetupBo pgsAddchannelBo = new ProductgroupSetupBo();
if (txtChannel.Text != "")
{
pgsAddchannelBo.AddChannel(txtChannel.Text);
Response.Write(@"<script language='javascript'>alert('Channel inserted successfully');</script>");
Response.Write("<script>window.close();</" + "script>");
BindHierarchyGrid(advisorVo.advisorId);
}
}
private bool ChkHirarchy(String Titlename, int Chanelid)
{
bool result = false;
DataTable dt = new DataTable();
PSBo = new ProductgroupSetupBo();
dt = PSBo.GetHirarchy(Chanelid, advisorVo.advisorId).Tables[0];
if (dt != null)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
if (Titlename.ToUpper() == dt.Rows[i]["AH_HierarchyName"].ToString().ToUpper())
{
result = true;
return(result);
}
}
}
return(result);
}
private bool ChkSeq(int Chanelid, String Seqno)
{
bool result = false;
DataTable dt = new DataTable();
PSBo = new ProductgroupSetupBo();
dt = PSBo.GetSeq(Chanelid, advisorVo.advisorId).Tables[0];
if (dt != null)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
if (Seqno == dt.Rows[i]["AH_Sequence"].ToString())
{
result = true;
return(result);
}
}
}
return(result);
}
protected void rcbChanel_SelectedIndexChanged(object sender, RadComboBoxSelectedIndexChangedEventArgs e)
{
try
{
int SeqNNo;
PSBo = new ProductgroupSetupBo();
RadComboBox RadComboBox = (RadComboBox)sender;
GridEditableItem editedItem = RadComboBox.NamingContainer as GridEditableItem;
RadComboBox rcbChanel = editedItem.FindControl("rcbChanel") as RadComboBox;
//RadComboBox rcbTeamm = editedItem.FindControl("rcbTeamm") as RadComboBox;
RadComboBox rcbReportingTo = editedItem.FindControl("rcbReportingTo") as RadComboBox;
//RadComboBox rcbTitles = editedItem.FindControl("rcbTitles") as RadComboBox;
TextBox TxtSeq = (TextBox)editedItem.FindControl("TxtSeq");
RangeValidator RNGVLD1 = (RangeValidator)editedItem.FindControl("RNGVLD1");
dtSequenceNumber = PSBo.GetMinMaxSeqNo(advisorVo.advisorId, Convert.ToInt32(rcbChanel.SelectedValue)).Tables[0];
int minSequenceNo = Convert.ToInt32(dtSequenceNumber.Rows[0]["MinSequence"]);
int maxSequenceNo = Convert.ToInt32(dtSequenceNumber.Rows[0]["MaxSequence"]);
RNGVLD1.MinimumValue = null;
RNGVLD1.MaximumValue = null;
RNGVLD1.MinimumValue = minSequenceNo.ToString();
RNGVLD1.MaximumValue = maxSequenceNo.ToString();
RNGVLD1.ErrorMessage = "Enter Sequence Number between " + minSequenceNo.ToString() + " and " + maxSequenceNo.ToString();
//SeqNNo = PSBo.GetTopSeqNo(advisorVo.advisorId);
//if (SeqNNo != 0 & SeqNNo != 1)
//{
//SeqNNo = PSBo.GetSeqNoinChanel(Convert.ToInt32(rcbChanel.SelectedValue), advisorVo.advisorId).Tables[0];;
////}
//TxtSeq.Text = SeqNNo.ToString();
//dtTeam = PSBo.GetTeam().Tables[0];
//rcbTeamm.DataSource = dtTeam;
//rcbTeamm.DataTextField = "WHLM_Name";
//rcbTeamm.DataValueField = "WHLM_Id";
//rcbTeamm.DataBind();
//dtChanel = PSBo.GetChanel().Tables[0];
//rcbChanel.DataSource = dtChanel;
//rcbChanel.DataTextField = "WHLM_Name";
//rcbChanel.DataValueField = "WHLM_Id";
//rcbChanel.DataBind();
dtReportingTo = PSBo.GetReportsTo(Convert.ToInt32(rcbChanel.SelectedValue), advisorVo.advisorId).Tables[0];
rcbReportingTo.DataSource = dtReportingTo;
rcbReportingTo.DataTextField = "AH_HierarchyName";
rcbReportingTo.DataValueField = "AH_TitleId";
//rcbReportingTo.DataTextField = "WHLM_Name";
//rcbReportingTo.DataValueField = "WHLM_Id";
rcbReportingTo.DataBind();
//dtHirarchy = PSBo.GetHirarchy().Tables[0];
//rcbTitles.DataSource = dtHirarchy;
//rcbTitles.DataTextField = "WHLM_Name";
//rcbTitles.DataValueField = "WHLM_Id";
//rcbTitles.DataBind();
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "AdviserHierarchyCluster.ascx:rcbSetup_SelectedIndexChanged(object sender, RadComboBoxSelectedIndexChangedEventArgs e)");
object[] objects = new object[3];
objects[0] = sender;
objects[1] = e;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
}
protected void gvHirarchy_ItemDataBound(object sender, GridItemEventArgs e)
{
dsRMAndHierarchyDetails = new DataSet();
PSBo = new ProductgroupSetupBo();
if (e.Item is GridDataItem && e.Item.ItemIndex != -1)
{
}
if (e.Item is GridEditFormInsertItem && e.Item.OwnerTableView.IsItemInserted)
{
GridEditFormInsertItem item = (GridEditFormInsertItem)e.Item;
DataTable dtAccType = new DataTable();
DataTable dtTeam = new DataTable();
DataTable dtChanel = new DataTable();
GridEditFormItem gefi = (GridEditFormItem)e.Item;
RadComboBox rcbChanel = (RadComboBox)gefi.FindControl("rcbChanel");
RadComboBox rcbTeamm = (RadComboBox)gefi.FindControl("rcbTeamm");
//rcbSetup_SelectedIndexChanged(null , null);
RadComboBoxItem defaultItem = new RadComboBoxItem();
//setting default for radcombobox
defaultItem.Text = "";
defaultItem.Value = "";
int SeqNNo;
PSBo = new ProductgroupSetupBo();
//GridEditableItem editedItem = RadComboBox.NamingContainer as GridEditableItem;
RadComboBox rcbReportingTo = e.Item.FindControl("rcbReportingTo") as RadComboBox;
RadComboBox rcbTitles = e.Item.FindControl("rcbTitles") as RadComboBox;
TextBox TxtSeq = (TextBox)e.Item.FindControl("TxtSeq");
Label Lb1Report = (Label)e.Item.FindControl("Label4");
dtTeam = PSBo.GetTeam().Tables[0];
rcbTeamm.DataSource = dtTeam;
rcbTeamm.DataTextField = "WHLM_Name";
rcbTeamm.DataValueField = "WHLM_Id";
rcbTeamm.DataBind();
rcbTeamm.SelectedValue = "13";
rcbTeamm.Enabled = false;
dtChanel = PSBo.GetChanel().Tables[0];
rcbChanel.DataSource = dtChanel;
rcbChanel.DataTextField = "WHLM_Name";
rcbChanel.DataValueField = "WHLM_Id";
rcbChanel.DataBind();
rcbChanel.Items.Insert(0, new RadComboBoxItem("--SELECT--", "0"));
rcbChanel.SelectedValue = "0";
dtReportingTo = PSBo.GetReportsTo(Convert.ToInt32(rcbChanel.SelectedValue), advisorVo.advisorId).Tables[0];
rcbReportingTo.DataSource = dtReportingTo;
rcbReportingTo.DataTextField = "AH_HierarchyName";
rcbReportingTo.DataValueField = "AH_TitleId";
rcbReportingTo.DataBind();
}
if (e.Item is GridEditFormItem && e.Item.IsInEditMode && e.Item.ItemIndex != -1)
{
//finding data key names for type , name and Hierarchy to fill the ddl respectively
string Hid = gvHirarchy.MasterTableView.DataKeyValues[e.Item.ItemIndex]["AH_Id"].ToString();
GridEditFormItem editedItem = (GridEditFormItem)e.Item;
//finding control for ddl type , head and Hierarchy
RadComboBox rcbSetup = (RadComboBox)e.Item.FindControl("rcbSetup");
RadComboBox rcbChanel = (RadComboBox)e.Item.FindControl("rcbChanel");
TextBox txtHierarchy = (TextBox)e.Item.FindControl("txtHierarchy");
RadComboBox rcbTeamm = (RadComboBox)e.Item.FindControl("rcbTeamm");
RadComboBox rcbReportingTo = (RadComboBox)e.Item.FindControl("rcbReportingTo");
RadComboBox Radops = (RadComboBox)e.Item.FindControl("Radops");
RadComboBox rcbTitles = e.Item.FindControl("rcbTitles") as RadComboBox;
TextBox TxtSeq = (TextBox)e.Item.FindControl("TxtSeq");
string TitleId = gvHirarchy.MasterTableView.DataKeyValues[e.Item.ItemIndex]["AH_TitleId"].ToString();
string TeamId = gvHirarchy.MasterTableView.DataKeyValues[e.Item.ItemIndex]["AH_TeamId"].ToString();
string ReportsToId = gvHirarchy.MasterTableView.DataKeyValues[e.Item.ItemIndex]["AH_ReportsToId"].ToString();
string ChannelId = gvHirarchy.MasterTableView.DataKeyValues[e.Item.ItemIndex]["AH_ChannelId"].ToString();
string RoleName = gvHirarchy.MasterTableView.DataKeyValues[e.Item.ItemIndex]["AH_HierarchyName"].ToString();
SeqNO = Convert.ToInt32(gvHirarchy.MasterTableView.DataKeyValues[e.Item.ItemIndex]["AH_Sequence"]);
DataTable dtReportsTo = new DataTable();
//AH_HierarchyName,AH_TitleId,AH_Teamname,AH_TeamId,AH_ReportsToId,AH_ReportsTo,AH_ChannelName
dtTeam = PSBo.GetTeam().Tables[0];
dtChanel = PSBo.GetChanel().Tables[0];
if (rcbSetup.Text == "Team" | rcbSetup.Text == "team")
{
rcbSetup.SelectedValue = "0";
}
else
{
rcbSetup.SelectedValue = "1";
}
//filling the data for Hierarchy ddl
rcbTeamm.DataSource = dtTeam;
rcbTeamm.DataTextField = "WHLM_Name";
rcbTeamm.DataValueField = "WHLM_Id";
rcbTeamm.DataBind();
//filling the data from rm ddl
rcbChanel.DataSource = dtChanel;
rcbChanel.DataTextField = "WHLM_Name";
rcbChanel.DataValueField = "WHLM_Id";
rcbChanel.DataBind();
rcbChanel.Items.Insert(0, new RadComboBoxItem("--SELECT--", "0"));
dtReportingTo = PSBo.GetReportsTo(Convert.ToInt32(rcbChanel.SelectedValue), advisorVo.advisorId).Tables[0];
rcbReportingTo.DataSource = dtReportingTo;
rcbReportingTo.DataTextField = "AH_HierarchyName";
rcbReportingTo.DataValueField = "AH_TitleId";
//rcbReportingTo.DataTextField = "WHLM_Name";
//rcbReportingTo.DataValueField = "WHLM_Id";
rcbReportingTo.DataBind();
dtHirarchy = PSBo.GetHirarchy(Convert.ToInt32(rcbChanel.SelectedValue), advisorVo.advisorId).Tables[0];
//rcbTitles.DataSource = dtHirarchy;
//rcbTitles.DataTextField = "WHLM_Name";
//rcbTitles.DataValueField = "WHLM_Id";
//rcbTitles.DataBind();
TxtSeq.Text = SeqNO.ToString();
txtHierarchy.Text = RoleName;
rcbReportingTo.SelectedValue = ReportsToId;
rcbTitles.SelectedValue = TitleId;
rcbChanel.SelectedValue = ChannelId;
rcbTeamm.SelectedValue = TeamId;
}
}
protected void gvHirarchy_ItemCommand(object source, GridCommandEventArgs e)
{
string description = string.Empty;
string name = string.Empty;
string insertType = string.Empty;
if (e.CommandName == RadGrid.UpdateCommandName)
{
int AZOC_HierarchyId = 0;
PSBo = new ProductgroupSetupBo();
bool isUpdated = false;
GridEditableItem gridEditableItem = (GridEditableItem)e.Item;
RadComboBox rcbSetup = (RadComboBox)e.Item.FindControl("rcbSetup");
RadComboBox rcbChanel = (RadComboBox)e.Item.FindControl("rcbChanel");
TextBox txtHierarchy = (TextBox)e.Item.FindControl("txtHierarchy");
RadComboBox rcbTeamm = (RadComboBox)e.Item.FindControl("rcbTeamm");
RadComboBox rcbReportingTo = (RadComboBox)e.Item.FindControl("rcbReportingTo");
RadComboBox Radops = (RadComboBox)e.Item.FindControl("Radops");
RadComboBox rcbTitles = e.Item.FindControl("rcbTitles") as RadComboBox;
TextBox TxtSeq = (TextBox)e.Item.FindControl("TxtSeq");
CheckBox chkIsSeqChange = (CheckBox)e.Item.FindControl("chkIsSeqChange");
int Hid = Convert.ToInt32(gvHirarchy.MasterTableView.DataKeyValues[e.Item.ItemIndex]["AH_Id"].ToString());
int SeqsNo = Convert.ToInt32(gvHirarchy.MasterTableView.DataKeyValues[e.Item.ItemIndex]["AH_Sequence"].ToString());
if (SeqsNo == Convert.ToInt32(TxtSeq.Text))
{
isUpdated = PSBo.HierarchyDetailsAddEditDelete(advisorVo.advisorId, Hid, txtHierarchy.Text, Convert.ToInt32(rcbTitles.SelectedValue), rcbTeamm.Text, Convert.ToInt32(rcbTeamm.SelectedValue), Convert.ToInt32(rcbReportingTo.SelectedValue), rcbReportingTo.Text, rcbChanel.Text, Convert.ToInt32(rcbChanel.SelectedValue), Convert.ToInt32(TxtSeq.Text), rcbSetup.Text, Convert.ToInt32(chkIsSeqChange.Checked), e.CommandName);
}
else
{
//if (ChkSeq(Convert.ToInt32(rcbChanel.SelectedValue), TxtSeq.Text) == true)
//{
// Response.Write(@"<script language='javascript'>alert('This Sequence alerady entered');</script>");
// return;
//}
//else
//{
isUpdated = PSBo.HierarchyDetailsAddEditDelete(advisorVo.advisorId, Hid, txtHierarchy.Text, Convert.ToInt32(rcbTitles.SelectedValue), rcbTeamm.Text, Convert.ToInt32(rcbTeamm.SelectedValue), Convert.ToInt32(rcbReportingTo.SelectedValue), rcbReportingTo.Text, rcbChanel.Text, Convert.ToInt32(rcbChanel.SelectedValue), Convert.ToInt32(TxtSeq.Text), rcbSetup.Text, Convert.ToInt32(chkIsSeqChange.Checked), e.CommandName);
//}
}
// if (AZOC_Type != "Hierarchy")
// {
// AZOC_HierarchyId = Convert.ToInt32(rcbPickAHierarchy.SelectedValue);
// }
// string HierarchyName = txtName.Text;
// int AZOC_HierarchyClusterId = Convert.ToInt32(gvHirarchy.MasterTableView.DataKeyValues[e.Item.ItemIndex]["AZOC_HierarchyClusterId"].ToString());
// type = Convert.ToInt32(rcbEditFormAddType.SelectedValue);
// if (type == 1)
// insertType = "Hierarchy";
// else
// insertType = "Cluster";
// //check if update then show the message
//// isUpdated = PSBo.HierarchyClusterDetailsAddEditDelete(advisorVo.advisorId, Convert.ToInt32(rcbHead.SelectedValue), AZOC_HierarchyClusterId, AZOC_HierarchyId, txtDescription.Text, txtName.Text, insertType, 0, UserVo.UserId, DateTime.MinValue, DateTime.Now, e.CommandName);
if (isUpdated == false)
{
Response.Write(@"<script language='javascript'>alert('The error updating Hierarchy : \n" + "" + "');</script>");
}
else
{
Response.Write(@"<script language='javascript'>alert('The Hierarchy: \n" + "" + " updated successfully.');</script>");
}
}
if (e.CommandName == RadGrid.PerformInsertCommandName)
{
PSBo = new ProductgroupSetupBo();
bool isInserted = false;
GridEditableItem gridEditableItem = (GridEditableItem)e.Item;
RadComboBox rcbSetup = (RadComboBox)e.Item.FindControl("rcbSetup");
RadComboBox rcbChanel = (RadComboBox)e.Item.FindControl("rcbChanel");
TextBox txtHierarchy = (TextBox)e.Item.FindControl("txtHierarchy");
RadComboBox rcbTeamm = (RadComboBox)e.Item.FindControl("rcbTeamm");
RadComboBox rcbReportingTo = (RadComboBox)e.Item.FindControl("rcbReportingTo");
RadComboBox Radops = (RadComboBox)e.Item.FindControl("Radops");
RadComboBox rcbTitles = e.Item.FindControl("rcbTitles") as RadComboBox;
TextBox TxtSeq = (TextBox)e.Item.FindControl("TxtSeq");
CheckBox chkIsSeqChange = (CheckBox)e.Item.FindControl("chkIsSeqChange");
int Rid;
int RTitId;
int RChanelid;
int RTeamid;
if (rcbReportingTo.Items.Count > 0)
{
Rid = Convert.ToInt32(rcbReportingTo.SelectedValue);
}
else
{
Rid = 0;
}
if (rcbTeamm.SelectedValue == "")
{
RTeamid = 0;
}
else
{
RTeamid = Convert.ToInt32(rcbTeamm.SelectedValue);
}
if (rcbChanel.SelectedValue == "")
{
RChanelid = 0;
}
else
{
RChanelid = Convert.ToInt32(rcbChanel.SelectedValue);
}
//if (ChkSeq(RChanelid, TxtSeq.Text) == true)
//{
// Response.Write(@"<script language='javascript'>alert('Sequence alerady exist');</script>");
// return;
//}
if (ChkHirarchy(txtHierarchy.Text, RChanelid))
{
Response.Write(@"<script language='javascript'>alert('Title name alerady exist for this chanel');</script>");
return;
}
else
{
// Convert.ToInt32(rcbTitles.SelectedValue)
isInserted = PSBo.HierarchyDetailsAddEditDelete(advisorVo.advisorId, 0, txtHierarchy.Text, 0, rcbTeamm.Text, RTeamid, Rid, rcbReportingTo.Text, rcbChanel.Text, RChanelid, Convert.ToInt32(TxtSeq.Text), rcbSetup.Text, Convert.ToInt32(chkIsSeqChange.Checked), e.CommandName);
if (isInserted == false)
{
Response.Write(@"<script language='javascript'>alert('Error inserting records');</script>");
}
else
{
Response.Write(@"<script language='javascript'>alert('Records inserted successfully');</script>");
}
}
}
if (e.CommandName == RadGrid.DeleteCommandName)
{
bool isDeleted = false;
PSBo = new ProductgroupSetupBo();
GridDataItem dataItem = (GridDataItem)e.Item;
TableCell HirarchyIdForDelete = dataItem["AH_Id"];
//string HierarchyName = gvHirarchy.MasterTableView.DataKeyValues[e.Item.ItemIndex]["AZOC_Name"].ToString();
int HId = int.Parse(HirarchyIdForDelete.Text);
//string deleteType = gvHirarchy.MasterTableView.DataKeyValues[e.Item.ItemIndex]["AZOC_Type"].ToString();
//check if deleted then show message
// isDeleted = PSBo.HierarchyDetailsDetailsAddEditDelete(advisorVo.advisorId, HId, "", 0, string.Empty, 0, 0, string.Empty, "", 0, 0, "",0, e.CommandName);
if (isDeleted == false)
{
Response.Write(@"<script language='javascript'>alert('The Hierarchy : \n" + "" + " Cannot be deleted since it is attached to a Hierarchy.');</script>");
}
else
{
Response.Write(@"<script language='javascript'>alert('The Hierarchy: \n" + "" + " deleted successfully.');</script>");
}
}
//bind the grid to get the edit form mode
BindHierarchyGrid(advisorVo.advisorId);
}
