protected void GetUserGroupList()
{
UserGroupBLL userGroup = new UserGroupBLL();
try
{
DataTable dt = userGroup.GetUserGroupList();
userGroupListGridView.DataSource = dt;
userGroupListGridView.DataBind();
if (dt.Rows.Count < 1)
{
msgbox.Visible = true; msgTitleLabel.Text = "User Group List 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;
}
}
protected void GetUserGroupById(string userGroupId)
{
UserGroupBLL userGroup = new UserGroupBLL();
try
{
DataTable dt = userGroup.GetUserGroupById(userGroupId);
if (dt.Rows.Count > 0)
{
userGroupNameForUpdateHiddenField.Value = userGroupNameTextBox.Text = dt.Rows[0]["UserGroupName"].ToString();
descriptionTextBox.Text = dt.Rows[0]["Description"].ToString();
}
else
{
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;
}
}
protected void saveButton_Click(object sender, EventArgs e)
{
UserGroupBLL userGroup = new UserGroupBLL();
try
{
if (userGroupNameTextBox.Text == "")
{
msgbox.Visible = true; msgTitleLabel.Text = "Validation!!!"; msgDetailLabel.Text = "User Group Name field is required.";
}
else if (descriptionTextBox.Text == "")
{
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)
{
string message = "User Group <span class='actionTopic'>Created</span> Successfully with User Group ID: <span class='actionTopic'>" + dt.Rows[0][0].ToString() + "</span>.";
MyAlertBox("var callbackOk = function () { MyOverlayStart(); window.location = \"/UI/UserGroup/List.aspx\"; }; SuccessAlert(\"" + "Process Succeed" + "\", \"" + message + "\", callbackOk);");
}
else
{
string message = "<span class='actionTopic'>Failed</span> to Create User Group.";
MyAlertBox("ErrorAlert(\"" + "Process Failed" + "\", \"" + message + "\");");
}
}
else
{
string message = "This User Group <span class='actionTopic'>already exist</span>, try another one.";
MyAlertBox("WarningAlert(\"" + "Data Duplicate" + "\", \"" + message + "\");");
}
}
}
catch (Exception ex)
{
string message = ex.Message;
if (ex.InnerException != null) { message += " --> " + ex.InnerException.Message; }
MyAlertBox("ErrorAlert(\"" + ex.GetType() + "\", \"" + message + "\", \"\");");
}
finally
{
userGroup = null;
}
}
protected void GetUserGroupList()
{
UserGroupBLL userGroup = new UserGroupBLL();
try
{
DataTable dt = userGroup.GetUserGroupList();
userGroupListGridView.DataSource = dt;
userGroupListGridView.DataBind();
for (int i = 0; i < dt.Rows.Count; i++)
{
if (dt.Rows[i]["UserGroupName"].ToString() == "Super Admin")
{
LinkButton editLinkButton = (LinkButton)userGroupListGridView.Rows[i].FindControl("editLinkButton");
LinkButton activateLinkButton = (LinkButton)userGroupListGridView.Rows[i].FindControl("activateLinkButton");
LinkButton deactivateLinkButton = (LinkButton)userGroupListGridView.Rows[i].FindControl("deactivateLinkButton");
LinkButton deleteLinkButton = (LinkButton)userGroupListGridView.Rows[i].FindControl("deleteLinkButton");
editLinkButton.Visible = false;
activateLinkButton.Visible = false;
deactivateLinkButton.Visible = false;
deleteLinkButton.Visible = false;
break;
}
}
if (userGroupListGridView.Rows.Count > 0)
{
userGroupListGridView.UseAccessibleHeader = true;
userGroupListGridView.HeaderRow.TableSection = TableRowSection.TableHeader;
}
else
{
msgbox.Visible = true; msgTitleLabel.Text = "User Group List 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;
}
}
protected void deletedListButton_Click(object sender, EventArgs e)
{
UserGroupBLL userGroup = new UserGroupBLL();
try
{
if (fromDateTextBox.Text.Trim() == "" || LumexLibraryManager.ParseAppDate(fromDateTextBox.Text.Trim()) == "False")
{
msgbox.Visible = true; msgTitleLabel.Text = "Validation!!!"; msgDetailLabel.Text = "Date From field is required.";
}
else if (toDateTextBox.Text.Trim() == "" || LumexLibraryManager.ParseAppDate(toDateTextBox.Text.Trim()) == "False")
{
msgbox.Visible = true; msgTitleLabel.Text = "Validation!!!"; msgDetailLabel.Text = "Date To field is required.";
}
else
{
string fromDate = LumexLibraryManager.ParseAppDate(fromDateTextBox.Text.Trim());
string toDate = LumexLibraryManager.ParseAppDate(toDateTextBox.Text.Trim());
DataTable dt = userGroup.GetDeletedUserGroupListByDateRangeAll(fromDate, toDate, "");
deletedListGridView.DataSource = dt;
deletedListGridView.DataBind();
if (deletedListGridView.Rows.Count > 0)
{
deletedListGridView.UseAccessibleHeader = true;
deletedListGridView.HeaderRow.TableSection = TableRowSection.TableHeader;
}
else
{
msgbox.Visible = true; msgTitleLabel.Text = "Deleted User Group List Data Not Found!!!"; msgDetailLabel.Text = "";
msgbox.Attributes.Add("class", "alert alert-info");
}
}
}
catch (Exception ex)
{
string message = ex.Message;
if (ex.InnerException != null) { message += " --> " + ex.InnerException.Message; }
MyAlertBox("ErrorAlert(\"" + ex.GetType() + "\", \"" + message + "\", \"\");");
}
finally
{
userGroup = null;
MyAlertBox("MyOverlayStop();");
}
}
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").ToString());
db.AddParameters("@CreatedFrom", LumexLibraryManager.GetTerminal());
DataTable dt = db.ExecuteDataTable("INSERT_USER_GROUP", true);
return dt;
}
catch (Exception)
{
throw;
}
finally
{
userGroup = null;
}
}
protected void deleteLinkButton_Click(object sender, EventArgs e)
{
try
{
LinkButton lnkBtn = (LinkButton)sender;
GridViewRow row = (GridViewRow)lnkBtn.NamingContainer;
UserGroupBLL userGroup = new UserGroupBLL();
string status = userGroup.DeleteUserGroup(userGroupListGridView.Rows[row.RowIndex].Cells[0].Text.ToString(), "False");
if (status == "Deleted")
{
GetUserGroupList();
string message = "User Group <span class='actionTopic'>Deleted</span> Successfully.";
MyAlertBox("SuccessAlert(\"" + "Process Succeed" + "\", \"" + message + "\", \"\");");
}
else
{
GetUserGroupList();
string message = "This User Group contains " + status + " user(s). You can't delete this User Group. You must move the user(s) first to another user group.";
MyAlertBox("WarningAlert(\"" + "Data Dependency" + "\", \"" + message + "\", \"\");");
}
}
catch (Exception ex)
{
string message = ex.Message;
if (ex.InnerException != null) { message += " --> " + ex.InnerException.Message; }
MyAlertBox("ErrorAlert(\"" + ex.GetType() + "\", \"" + message + "\", \"\");");
}
}
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");
userGroupListGridView.Rows[row.RowIndex].Cells[3].Text = "False";
string message = "User Group <span class='actionTopic'>Deactivated</span> Successfully.";
MyAlertBox("SuccessAlert(\"" + "Process Succeed" + "\", \"" + message + "\", \"\");");
}
catch (Exception ex)
{
string message = ex.Message;
if (ex.InnerException != null) { message += " --> " + ex.InnerException.Message; }
MyAlertBox("ErrorAlert(\"" + ex.GetType() + "\", \"" + message + "\", \"\");");
}
}
protected void updateButton_Click(object sender, EventArgs e)
{
UserGroupBLL userGroup = new UserGroupBLL();
try
{
if (userGroupIdForUpdateHiddenField.Value.Trim() == "")
{
msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = "User Group not found to update.";
}
else if (userGroupNameTextBox.Text == "")
{
msgbox.Visible = true; msgTitleLabel.Text = "Validation!!!"; msgDetailLabel.Text = "User Group Name field is required.";
}
else if (descriptionTextBox.Text == "")
{
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 = "User Group <span class='actionTopic'>Updated</span> Successfully.";
MyAlertBox("var callbackOk = function () { MyOverlayStart(); window.location = \"/UI/UserGroup/List.aspx\"; }; SuccessAlert(\"" + "Process Succeed" + "\", \"" + message + "\", callbackOk);");
}
else
{
if (userGroupNameForUpdateHiddenField.Value == userGroupNameTextBox.Text.Trim())
{
userGroup.UserGroupName = "WithOut";
userGroup.UpdateUserGroup();
userGroupNameForUpdateHiddenField.Value = "";
userGroupIdForUpdateHiddenField.Value = "";
string message = "User Group <span class='actionTopic'>Updated</span> Successfully.";
MyAlertBox("var callbackOk = function () { MyOverlayStart(); window.location = \"/UI/UserGroup/List.aspx\"; }; SuccessAlert(\"" + "Process Succeed" + "\", \"" + message + "\", callbackOk);");
}
else
{
string message = "This User Group <span class='actionTopic'>already exist</span>, try another one.";
MyAlertBox("WarningAlert(\"" + "Data Duplicate" + "\", \"" + message + "\");");
}
}
}
}
catch (Exception ex)
{
string message = ex.Message;
if (ex.InnerException != null) { message += " --> " + ex.InnerException.Message; }
MyAlertBox("ErrorAlert(\"" + ex.GetType() + "\", \"" + message + "\", \"\");");
}
finally
{
userGroup = null;
}
}
//protected void LoadSalesCenters()
//{
// SalesCenterBLL salesCenter = new SalesCenterBLL();
// try
// {
// DataTable dt = salesCenter.GetActiveSalesCenterListByUser();
// salesCenterDropDownList.DataSource = dt;
// salesCenterDropDownList.DataValueField = "SalesCenterId";
// salesCenterDropDownList.DataTextField = "SalesCenterName";
// salesCenterDropDownList.DataBind();
// salesCenterDropDownList.Items.Insert(0, "Please Select");
// salesCenterDropDownList.SelectedIndex = 0;
// if (dt.Rows.Count < 1)
// {
// msgbox.Visible = true; msgTitleLabel.Text = "Joining Sales Center 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
// {
// salesCenter = 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, "Please Select");
userGroupDropDownList.SelectedIndex = 0;
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;
}
}
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").ToString());
db.AddParameters("@ModifiedFrom", LumexLibraryManager.GetTerminal());
db.ExecuteNonQuery("UPDATE_USER_GROUP_BY_ID", true);
}
catch (Exception)
{
throw;
}
finally
{
userGroup = null;
}
}