protected void GetUserGroupById(string userGroupId)
        {
            UserGroupBLL userGroup = new UserGroupBLL();

            try
            {
                DataTable dt = userGroup.GetUserGroupById(userGroupId);

                if (dt.Rows.Count > 0)
                {
                    userGroupNameLabel.Text = dt.Rows[0]["UserGroupName"].ToString();
                    descriptionLabel.Text = dt.Rows[0]["Description"].ToString();
                }
                else
                {
                    msgbox.Attributes.Add("Class", "alert alert-warning"); msgbox.Visible = true; msgTitleLabel.Text = "Data Not Found!!!"; msgDetailLabel.Text = "";
                }
            }
            catch (Exception ex)
            {
                msgbox.Attributes.Add("Class", "alert alert-warning"); msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = ex.Message;
            }
            finally
            {
                userGroup = null;
            }
        }
        protected void saveButton_Click(object sender, EventArgs e)
        {
            UserGroupBLL userGroup = new UserGroupBLL();

            try
            {
                if (userGroupNameTextBox.Text == "")
                {
                    msgbox.Attributes.Add("Class", "alert alert-warning"); msgbox.Visible = true; msgTitleLabel.Text = "Validation!!!"; msgDetailLabel.Text = "User Group Name field is required.";
                }
                else if (descriptionTextBox.Text == "")
                {
                    msgbox.Attributes.Add("Class", "alert alert-warning"); msgbox.Visible = true; msgTitleLabel.Text = "Validation!!!"; msgDetailLabel.Text = "Description field is required.";
                }
                else
                {
                    userGroup.UserGroupName = userGroupNameTextBox.Text.Trim();
                    userGroup.Description = descriptionTextBox.Text.Trim();

                    if (!userGroup.CheckDuplicateUserGroup(userGroup.UserGroupName.Trim()))
                    {
                        DataTable dt = userGroup.SaveUserGroup();

                        if (dt.Rows.Count > 0)
                        {
                           // MyAlertBox("alert(\"User Group Created Successfully with User Group ID: " + dt.Rows[0][0].ToString() + " \"); window.location=\"/HRUI/UserGroup/List.aspx\"");

                            string message = " <span class='actionTopic'>" + " User Group Created Successfully with User Group ID: " + dt.Rows[0][0].ToString() + "</span>.";
                            MyAlertBox("var callbackOk = function () { window.location = \"/setting/UserGroup/List.aspx\"; }; SuccessAlert(\"" + "Process Succeed" + "\", \"" + message + "\", callbackOk);");

                        }
                        else
                        {
                            msgbox.Attributes.Add("Class", "alert alert-warning"); msgbox.Visible = true; msgTitleLabel.Text = "Failed to Create User Group!!!"; msgDetailLabel.Text = "";
                        }
                    }
                    else
                    {
                        msgbox.Attributes.Add("Class", "alert alert-warning"); msgbox.Visible = true; msgTitleLabel.Text = "Data Duplicate!!!"; msgDetailLabel.Text = "This User Group already exist, try another one.";
                    }
                }
            }
            catch (Exception ex)
            {
                msgbox.Attributes.Add("Class", "alert alert-warning"); msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = ex.Message;
            }
            finally
            {
                userGroup = null;
            }
        }
        protected void deactivateLinkButton_Click(object sender, EventArgs e)
        {
            try
            {
                LinkButton lnkBtn = (LinkButton)sender;
                GridViewRow row = (GridViewRow)lnkBtn.NamingContainer;

                UserGroupBLL userGroup = new UserGroupBLL();
                userGroup.UpdateUserGroupActivation(userGroupListGridView.Rows[row.RowIndex].Cells[0].Text.ToString(), "False");

              //  MyAlertBox("alert(\"User Group Deactivated Successfully.\"); window.location=\"/HRUI/UserGroup/List.aspx\"");

                GetUserGroupList();
                string message = " <span class='actionTopic'>" + " User Group Deactivated Successfully.</span>.";
                MyAlertBox("var callbackOk = function () { window.location = \"/setting/UserGroup/List.aspx\"; }; SuccessAlert(\"" + "Process Succeed" + "\", \"" + message + "\", callbackOk);");

            }
            catch (Exception ex)
            {
                msgbox.Attributes.Add("Class", "alert alert-warning"); msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = ex.Message;
            }
        }
        protected void GetUserGroupList()
        {
            UserGroupBLL userGroup = new UserGroupBLL();

            try
            {
                DataTable dt = userGroup.GetUserGroupList();
                userGroupListGridView.DataSource = dt;
                userGroupListGridView.DataBind();
                gridviewStyleSet();
                if (dt.Rows.Count < 1)
                {
                    msgbox.Attributes.Add("Class", "alert alert-warning"); msgbox.Visible = true; msgTitleLabel.Text = "Data Not Found!!!"; msgDetailLabel.Text = "";
                }
            }
            catch (Exception ex)
            {
                msgbox.Attributes.Add("Class", "alert alert-warning"); msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = ex.Message;
            }
            finally
            {
                userGroup = null;
            }
        }
        protected void updateButton_Click(object sender, EventArgs e)
        {
            UserGroupBLL userGroup = new UserGroupBLL();

            try
            {
                if (userGroupIdForUpdateHiddenField.Value.Trim() == "")
                {
                    msgbox.Attributes.Add("Class", "alert alert-warning"); msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = "User Group not found to update.";
                }
                else if (userGroupNameTextBox.Text == "")
                {
                    msgbox.Attributes.Add("Class", "alert alert-warning"); msgbox.Visible = true; msgTitleLabel.Text = "Validation!!!"; msgDetailLabel.Text = "User Group Name field is required.";
                }
                else if (descriptionTextBox.Text == "")
                {
                    msgbox.Attributes.Add("Class", "alert alert-warning"); msgbox.Visible = true; msgTitleLabel.Text = "Validation!!!"; msgDetailLabel.Text = "Description field is required.";
                }
                else
                {
                    userGroup.UserGroupId = userGroupIdForUpdateHiddenField.Value.Trim();
                    userGroup.UserGroupName = userGroupNameTextBox.Text.Trim();
                    userGroup.Description = descriptionTextBox.Text.Trim();

                    if (!userGroup.CheckDuplicateUserGroup(userGroupNameTextBox.Text.Trim()))
                    {
                        userGroup.UpdateUserGroup();

                        userGroupNameForUpdateHiddenField.Value = "";
                        userGroupIdForUpdateHiddenField.Value = "";

                        string message = " <span class='actionTopic'>" + " User Group Updated Successfully</span>.";
                        MyAlertBox("var callbackOk = function () { window.location = \"/setting/UserGroup/List.aspx\"; }; SuccessAlert(\"" + "Process Succeed" + "\", \"" + message + "\", callbackOk);");

                    }
                    else
                    {
                        if (userGroupNameForUpdateHiddenField.Value == userGroupNameTextBox.Text.Trim())
                        {
                            userGroup.UserGroupName = "WithOut";
                            userGroup.UpdateUserGroup();

                            userGroupNameForUpdateHiddenField.Value = "";
                            userGroupIdForUpdateHiddenField.Value = "";
                            //MyAlertBox("alert(\"User Group Updated Successfully.\"); window.location=\"/HRUI/UserGroup/List.aspx\"");

                            string message = " <span class='actionTopic'>" + " User Group Updated Successfully.</span>.";
                            MyAlertBox("var callbackOk = function () { window.location = \"/setting/UserGroup/List.aspx\"; }; SuccessAlert(\"" + "Process Succeed" + "\", \"" + message + "\", callbackOk);");

                        }
                        else
                        {
                            msgbox.Attributes.Add("Class", "alert alert-warning"); msgbox.Visible = true; msgTitleLabel.Text = "Data Duplicate!!!"; msgDetailLabel.Text = "This User Group already exist, try another one.";
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                msgbox.Attributes.Add("Class", "alert alert-warning"); msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = ex.Message;
            }
            finally
            {
                userGroup = null;
            }
        }
        private void LoadUserGroups()
        {
            try
            {

                UserGroupBLL usergroupbll = new UserGroupBLL();
                DataTable dt = usergroupbll.GetActiveUserGroupList();
                drpdownGroup.DataTextField = "UserGroupName";
                drpdownGroup.DataValueField = "UserGroupId";
                drpdownGroup.DataSource = dt;
                drpdownGroup.DataBind();
                drpdownGroup.Items.Insert(0, "Select Group");
                drpdownGroup.SelectedIndex = 0;
                drpdownGroup.Items[0].Value = "";

            }
            catch (Exception ex)
            {

                string message = ex.Message;
                if (ex.InnerException != null) { message += " --> " + ex.InnerException.Message; }
                MyAlertBox("ErrorAlert(\"" + ex.GetType() + "\", \"" + message + "\", \"\");");

            }
        }
        protected void LoadUserGroups()
        {
            UserGroupBLL userGroup = new UserGroupBLL();

            try
            {
                DataTable dt = userGroup.GetActiveUserGroupList();

                drpdownGroup.DataSource = dt;
                drpdownGroup.DataValueField = "UserGroupId";
                drpdownGroup.DataTextField = "UserGroupName";
                drpdownGroup.DataBind();
                drpdownGroup.Items.Insert(0, "----------Select----------");
                drpdownGroup.SelectedIndex = 0;
            }
            catch (Exception ex)
            {
                msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = ex.Message;
                msgbox.Attributes.Add("Class", "alert alert-warning");
            }
            finally
            {
                userGroup = null;
            }
        }
 public void UpdateUserGroup(UserGroupBLL userGroup, LumexDBPlayer db)
 {
     try
     {
         db.AddParameters("@UserGroupId", userGroup.UserGroupId.Trim());
         db.AddParameters("@UserGroupName", userGroup.UserGroupName.Trim());
         db.AddParameters("@Description", userGroup.Description.Trim());
         db.AddParameters("@ModifiedBy", LumexSessionManager.Get("ActiveUserId"));
         db.AddParameters("@ModifiedFrom", LumexLibraryManager.GetTerminal());
         db.AddParameters("@GroupOrder","1");
         db.ExecuteNonQuery("UPDATE_USER_GROUP_BY_ID", true);
     }
     catch (Exception)
     {
         throw;
     }
     finally
     {
         userGroup = null;
     }
 }
 public DataTable SaveUserGroup(UserGroupBLL userGroup, LumexDBPlayer db)
 {
     try
     {
         db.AddParameters("@UserGroupName", userGroup.UserGroupName.Trim());
         db.AddParameters("@Description", userGroup.Description.Trim());
         db.AddParameters("@CreatedBy", LumexSessionManager.Get("ActiveUserId"));
         db.AddParameters("@CreatedFrom", LumexLibraryManager.GetTerminal());
         db.AddParameters("@BranchId", LumexSessionManager.Get("UserBranchId"));
         db.AddParameters("@GroupOrder","1");
         DataTable dt = db.ExecuteDataTable("INSERT_USER_GROUP", true);
         return dt;
     }
     catch (Exception)
     {
         throw;
     }
     finally
     {
         userGroup = null;
     }
 }
        protected void LoadUserGroups()
        {
            UserGroupBLL userGroup = new UserGroupBLL();

            try
            {
                DataTable dt = userGroup.GetActiveUserGroupList();

                userGroupDropDownList.DataSource = dt;
                userGroupDropDownList.DataValueField = "UserGroupId";
                userGroupDropDownList.DataTextField = "UserGroupName";
                userGroupDropDownList.DataBind();
                userGroupDropDownList.Items.Insert(0, "--Select Group--");
                userGroupDropDownList.SelectedIndex = 1;

                if (dt.Rows.Count < 1)
                {
                    msgbox.Visible = true; msgTitleLabel.Text = "User Group Data Not Found!!!"; msgDetailLabel.Text = "";
                    msgbox.Attributes.Add("class", "alert alert-warning");
                }
            }
            catch (Exception ex)
            {
                string message = ex.Message;
                if (ex.InnerException != null) { message += " --> " + ex.InnerException.Message; }
                MyAlertBox("ErrorAlert(\"" + ex.GetType() + "\", \"" + message + "\", \"\");");
            }
            finally
            {
                userGroup = null;
            }
        }