private CMS.AMS.Models.CustomerGroup CreateCustomerGroup()
{
CMS.AMS.Models.CustomerGroup NewCustGroup = null;
try
{
bool saved = m_CustGroup.CreateUpdateCustomerGroup(new CustomerGroup {
Name = Logix.TrimAll(functioninput.Text)
});
if (saved)
{
NewCustGroup = new CustomerGroup();
NewCustGroup = m_CustGroup.GetCustomerGroupByName(Logix.TrimAll(functioninput.Text));
if (MyCommon.LRTadoConn.State == ConnectionState.Closed)
{
MyCommon.Open_LogixRT();
}
MyCommon.Activity_Log(7, NewCustGroup.CustomerGroupID, CurrentUser.AdminUser.ID, Copient.PhraseLib.Lookup("history.cgroup-create", LanguageID));
}
}
catch (Exception err)
{
ScriptManager.RegisterStartupScript(UpdatePanelMain, UpdatePanelMain.GetType(), "AlertMessage", " AlertMessage('" + err.Message + "');", true);
}
finally
{
MyCommon.Close_LogixRT();
}
return(NewCustGroup);
}
private CMS.AMS.Models.SVProgram CreatePointsProgram()
{
CMS.AMS.Models.SVProgram NewSVPointProgram = null;
try
{
NewSVPointProgram = new CMS.AMS.Models.SVProgram {
ProgramName = Logix.TrimAll(functioninput.Text)
};
bool saved = CreateSVPointsProgram(NewSVPointProgram);
if (saved)
{
return(NewSVPointProgram);
}
else
{
return(null);
}
}
catch (Exception err)
{
ScriptManager.RegisterStartupScript(UpdatePanelMain, UpdatePanelMain.GetType(), "AlertMessage", " AlertMessage('" + err.Message + "');", true);
return(null);
}
}
protected void rptTierValues_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
Int32 TierLevel = e.Item.ItemIndex;
((Button)e.Item.FindControl("btnAdd")).Text = PhraseLib.Lookup("term.add", LanguageID);
((Button)e.Item.FindControl("btnRemove")).Text = PhraseLib.Lookup("term.remove", LanguageID);
if (NumTiers != null && NumTiers > 1)
{
((Label)e.Item.FindControl("lblTierText")).Text = "<b>" + PhraseLib.Lookup("term.tier", LanguageID) + " " + ((PreferenceTiers)(e.Item.DataItem)).TierLevel + "</b><br/>";
}
((DropDownList)e.Item.FindControl("ddlPreferenceData")).DataSource = ((PreferenceTiers)(e.Item.DataItem)).PreferenceItems.Where(p => p.Selected == false);
((DropDownList)e.Item.FindControl("ddlPreferenceData")).DataBind();
((ListBox)e.Item.FindControl("lstSelectedPreference")).DataSource = ((PreferenceTiers)(e.Item.DataItem)).PreferenceItems.Where(p => p.Selected == true);
((ListBox)e.Item.FindControl("lstSelectedPreference")).DataBind();
if ((SelectedPreference.DataTypeID == PreferenceDataType.ListBox && SelectedPreference.MultiValue == true && ((PreferenceTiers)(e.Item.DataItem)).PreferenceItems.Where(p => p.Selected == false).ToList().Count == 0) ||
(SelectedPreference.DataTypeID == PreferenceDataType.ListBox && SelectedPreference.MultiValue == false && ((PreferenceTiers)(e.Item.DataItem)).PreferenceItems.Where(p => p.Selected == true).ToList().Count > 0) ||
(SelectedPreference.DataTypeID != PreferenceDataType.ListBox && ((PreferenceTiers)(e.Item.DataItem)).PreferenceItems.Where(p => p.Selected == true).ToList().Count > 0))
{
((Button)e.Item.FindControl("btnAdd")).Enabled = false;
}
UpdatePanelMain.Update();
}
}
protected void grdViewPermissionSummary_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
int permissionId = 0;
if (e.CommandName.Equals("EditPermission"))
{
if (int.TryParse(e.CommandArgument.ToString(), out permissionId))
{
PopupDialogBindData(permissionId);
ModalPopupExtender1.Show();
PermissionDetailPopUp.Visible = true;
ViewState["PopupMode"] = "UPDATE";
}
}
else if (e.CommandName.Equals("CancelPermission"))
{
if (int.TryParse(e.CommandArgument.ToString(), out permissionId))
{
if (CancelPermission(permissionId))
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), Guid.NewGuid().ToString(), "alert('Your leave request has been cancelled successfully');", true);
BindPermissionSummaryGrid();
UpdatePanelMain.Update();
}
}
}
}
catch (Exception ex)
{
TroyLiteExceptionManager.HandleException(ex);
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
if (UpdateLeave())
{
ClearPopupData();
BindLeaveSummaryGrid();
UpdatePanelMain.Update();
}
}
protected void btnCreate_Click(object sender, EventArgs e)
{
string Name = string.Empty;
if (MyCommon.Parse_Quotes(Logix.TrimAll(functioninput.Text)) != null)
{
Name = Convert.ToString(MyCommon.Parse_Quotes(Logix.TrimAll(functioninput.Text)));
}
if (!String.IsNullOrEmpty(Name))
{
int AvailableListCount = AvailableFilteredCustomerGroup.Where(p => p.Name.Equals(functioninput.Text, StringComparison.OrdinalIgnoreCase)).ToList().Count;
int IncludedGroupCount = IncludedGroup.Where(p => p.Name.Equals(functioninput.Text, StringComparison.OrdinalIgnoreCase)).ToList().Count;
int ExcludedGroupCount = ExcludedGroup.Where(p => p.Name.Equals(functioninput.Text, StringComparison.OrdinalIgnoreCase)).ToList().Count;
bool isValidText = true;
if (functioninput.Text.ToLower().Equals(PhraseLib.Lookup("term.anycardholder", LanguageID).ToLower()) || functioninput.Text.ToLower().Equals(PhraseLib.Lookup("term.anycustomer", LanguageID).ToLower()) || functioninput.Text.ToLower().Equals(PhraseLib.Lookup("term.newcardholders", LanguageID).ToLower()))
{
isValidText = false;
}
if (!isValidText)
{
string alertMessage = Copient.PhraseLib.Lookup("term.enter", LanguageID) + " " + Copient.PhraseLib.Lookup("term.valid", LanguageID).ToLower() + " " + Copient.PhraseLib.Lookup("term.customergroup", LanguageID).ToLower() + " " + Copient.PhraseLib.Lookup("term.name", LanguageID).ToLower();
ScriptManager.RegisterStartupScript(UpdatePanelMain, UpdatePanelMain.GetType(), "AlertMessage", " AlertMessage('" + alertMessage + "'); ", true);
}
else if (IncludedGroupCount > 0 || ExcludedGroupCount > 0)
{
string alertMessage = Copient.PhraseLib.Lookup("term.customergroup", LanguageID) + ": " + Name + " " + Copient.PhraseLib.Lookup("term.is", LanguageID).ToLower() + " " + Copient.PhraseLib.Lookup("term.already", LanguageID).ToLower() + " " + Copient.PhraseLib.Lookup("term.selected", LanguageID).ToLower();
ScriptManager.RegisterStartupScript(UpdatePanelMain, UpdatePanelMain.GetType(), "AlertMessage", " AlertMessage('" + alertMessage + "');", true);
}
else if (AvailableListCount > 0)
{
string alertMessage = Copient.PhraseLib.Lookup("term.existing", LanguageID) + " " + Copient.PhraseLib.Lookup("term.customergroup", LanguageID).ToLower() + ": " + Name + " " + Copient.PhraseLib.Lookup("offer.message", LanguageID).ToLower();
ScriptManager.RegisterStartupScript(UpdatePanelMain, UpdatePanelMain.GetType(), "AlertMessage", " AlertMessage('" + alertMessage + "');", true);
IncludedGroup.Add(AvailableFilteredCustomerGroup.Where(p => p.Name.Equals(functioninput.Text, StringComparison.OrdinalIgnoreCase)).FirstOrDefault());
HandleSelectedForSpecialGroup();
SetAvailableData();
SetButtons();
}
else
{
IncludedGroup.Add(CreateCustomerGroup());
SetAvailableData();
SetButtons();
}
}
else
{
string alertMessage = Copient.PhraseLib.Lookup("term.enter", LanguageID) + " " + Copient.PhraseLib.Lookup("term.valid", LanguageID).ToLower() + " " + Copient.PhraseLib.Lookup("term.customergroup", LanguageID).ToLower() + " " + Copient.PhraseLib.Lookup("term.name", LanguageID).ToLower();
ScriptManager.RegisterStartupScript(UpdatePanelMain, UpdatePanelMain.GetType(), "AlertMessage", " AlertMessage('" + alertMessage + "');", true);
}
}
private void BindAttendanceSummaryFilterList()
{
string connection = Request.Cookies["Company"].Value;
string usernam = Request.Cookies["LoggedUserName"].Value;
BusinessLogic bl = new BusinessLogic(sDataSource);
DataTable dt = bl.GetAttendanceYearList(usernam);
if (dt != null)
{
ddlSearchCriteria.DataSource = dt;
ddlSearchCriteria.DataBind();
UpdatePanelMain.Update();
}
}
protected void btnCreate_Click(object sender, EventArgs e)
{
string Name = string.Empty;
if (MyCommon.Parse_Quotes(Logix.TrimAll(functioninput.Text)) != null)
{
Name = Convert.ToString(MyCommon.Parse_Quotes(Logix.TrimAll(functioninput.Text)));
}
if (!String.IsNullOrEmpty(Name))
{
int AvailableListCount = AvailableFilteredPointProgram.Where(p => p.ProgramName.Equals(functioninput.Text, StringComparison.OrdinalIgnoreCase)).ToList().Count;
int IncludedGroupCount = IncludedPointProgram.Where(p => p.ProgramName.Equals(functioninput.Text, StringComparison.OrdinalIgnoreCase)).ToList().Count;
if (IncludedGroupCount > 0)
{
string alertMessage = Copient.PhraseLib.Lookup("term.pointsprogram", LanguageID) + ": " + Name + " " + Copient.PhraseLib.Lookup("term.is", LanguageID).ToLower() + " " + Copient.PhraseLib.Lookup("term.already", LanguageID).ToLower() + " " + Copient.PhraseLib.Lookup("term.selected", LanguageID).ToLower();
ScriptManager.RegisterStartupScript(UpdatePanelMain, UpdatePanelMain.GetType(), "AlertMessage", " AlertMessage('" + alertMessage + "');", true);
}
else if (AvailableListCount > 0)
{
string alertMessage = Copient.PhraseLib.Lookup("term.existing", LanguageID) + " " + Copient.PhraseLib.Lookup("term.pointsprogram", LanguageID).ToLower() + ": " + Name + " " + Copient.PhraseLib.Lookup("offer.message", LanguageID).ToLower();
ScriptManager.RegisterStartupScript(UpdatePanelMain, UpdatePanelMain.GetType(), "AlertMessage", " AlertMessage('" + alertMessage + "');", true);
//First remove the selected point if exist any
IncludedPointProgram.Clear();
IncludedPointProgram.Add(AvailableFilteredPointProgram.Where(p => p.ProgramName.Equals(functioninput.Text, StringComparison.OrdinalIgnoreCase)).FirstOrDefault());
SetAvailableData();
SetButtons();
}
else
{
IncludedPointProgram.Clear();
//Then add newly created points program to the selected list
IncludedPointProgram.Add(CreatePointsProgram());
SetAvailableData();
SetButtons();
}
}
else
{
string alertMessage = Copient.PhraseLib.Lookup("term.enter", LanguageID) + " " + Copient.PhraseLib.Lookup("term.valid", LanguageID).ToLower() + " " + Copient.PhraseLib.Lookup("term.pointsprogram", LanguageID).ToLower() + " " + Copient.PhraseLib.Lookup("term.name", LanguageID).ToLower();
ScriptManager.RegisterStartupScript(UpdatePanelMain, UpdatePanelMain.GetType(), "AlertMessage", " AlertMessage('" + alertMessage + "');", true);
}
}
protected void btnApplyPermission_Click(object sender, EventArgs e)
{
string errorMsg = string.Empty;
try
{
if (ViewState["PopupMode"] != null && ViewState["PopupMode"].ToString() == "NEW")
{
if (InsertPermission(ref errorMsg))
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), Guid.NewGuid().ToString(), "alert('Your Permission request has been submitted successfully');", true);
ClearPopupData();
BindPermissionSummaryGrid();
UpdatePanelMain.Update();
}
else
{
ModalPopupExtender1.Show();
PermissionDetailPopUp.Visible = true;
ScriptManager.RegisterStartupScript(Page, Page.GetType(), Guid.NewGuid().ToString(), "alert('" + errorMsg + "');", true);
}
}
else if (ViewState["PopupMode"] != null && ViewState["PopupMode"].ToString() == "UPDATE")
{
if (UpdatePermission(ref errorMsg))
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), Guid.NewGuid().ToString(), "alert('Your Permission request has been updated successfully');", true);
ClearPopupData();
BindPermissionSummaryGrid();
UpdatePanelMain.Update();
}
else
{
ModalPopupExtender1.Show();
PermissionDetailPopUp.Visible = true;
ScriptManager.RegisterStartupScript(Page, Page.GetType(), Guid.NewGuid().ToString(), "alert('" + errorMsg + "');", true);
}
}
}
catch (Exception ex)
{
TroyLiteExceptionManager.HandleException(ex);
ModalPopupExtender1.Show();
PermissionDetailPopUp.Visible = true;
ScriptManager.RegisterStartupScript(Page, Page.GetType(), Guid.NewGuid().ToString(), "alert('" + ex.Message.ToString() + "');", true);
}
}
protected void select1_Click(object sender, EventArgs e)
{
if (lstAvailable.SelectedItem != null)
{
if (column2.Visible == false)
{
column2.Visible = true;
UpdatePanelMain.Update();
}
SelectedPreference = AllPreferences.Where(p => p.PreferenceID == lstAvailable.SelectedValue.ConvertToInt32()).SingleOrDefault();
lblDataType.Text = lstPreferenceDataTypes.Where(p => p.DataTypeID == (int)SelectedPreference.DataTypeID).FirstOrDefault().PhraseText;
lblMultiValued.Text = (SelectedPreference.MultiValue ? PhraseLib.Lookup("term.yes", LanguageID) : PhraseLib.Lookup("term.no", LanguageID));
SetAvailableData();
DisplayTierValues();
}
SetButtons();
}
private void BindTimesheetSummaryFilterList()
{
string connection = Request.Cookies["Company"].Value;
string usernam = Request.Cookies["LoggedUserName"].Value;
BusinessLogic bl = new BusinessLogic(sDataSource);
DataTable dt = bl.GetYearsConstant();
if (dt != null)
{
ddlSearchCriteria.DataSource = dt;
ddlSearchCriteria.DataTextField = "Year";
ddlSearchCriteria.DataValueField = "Year";
ddlSearchCriteria.DataBind();
ddlSearchCriteria.SelectedValue = DateTime.Today.Year.ToString();
UpdatePanelMain.Update();
}
}
private void BindLeaveSummaryGrid()
{
grdViewLeaveSummary.DataSource = null;
grdViewLeaveSummary.DataBind();
string connection = Request.Cookies["Company"].Value;
string usernam = Request.Cookies["LoggedUserName"].Value;
BusinessLogic bl = new BusinessLogic(sDataSource);
DataSet ds = bl.GetLeaveRequestsSummaryForTheSupervisor(usernam);
if (ds != null && ds.Tables.Count > 0)
{
grdViewLeaveSummary.DataSource = ds.Tables[0];
grdViewLeaveSummary.DataBind();
UpdatePanelMain.Update();
}
}
private void BindAttendanceSummaryFilterList()
{
try
{
BusinessLogic bl = new BusinessLogic(sDataSource);
DataTable dt = bl.GetAllMonths();
if (dt != null)
{
ddlMonth.DataSource = dt;
ddlMonth.DataBind();
UpdatePanelMain.Update();
}
}
catch (Exception ex)
{
TroyLiteExceptionManager.HandleException(ex);
}
}
private void BindAttendanceSummaryGrid(string attendanceYear)
{
string connection = Request.Cookies["Company"].Value;
string usernam = Request.Cookies["LoggedUserName"].Value;
BusinessLogic bl = new BusinessLogic(sDataSource);
DataSet ds = bl.GetAttendanceSummary(attendanceYear, usernam);
if (ds != null && ds.Tables.Count > 0)
{
grdViewAttendanceSummary.DataSource = ds.Tables[0];
grdViewAttendanceSummary.DataBind();
UpdatePanelMain.Update();
}
else
{
grdViewAttendanceSummary.DataSource = null;
grdViewAttendanceSummary.DataBind();
UpdatePanelMain.Update();
}
}
protected void btnApplyLeave_Click(object sender, EventArgs e)
{
try
{
if (ViewState["PopupMode"] != null && ViewState["PopupMode"].ToString() == "NEW")
{
if (InsertLeave())
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), Guid.NewGuid().ToString(), "alert('Your leave request has been submitted successfully');", true);
ClearPopupData();
BindLeaveSummaryGrid();
UpdatePanelMain.Update();
}
else
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), Guid.NewGuid().ToString(), "alert('Your leave request not saved. Please contact Administrator.');", true);
}
}
else if (ViewState["PopupMode"] != null && ViewState["PopupMode"].ToString() == "UPDATE")
{
if (UpdateLeave())
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), Guid.NewGuid().ToString(), "alert('Your leave request has been updated successfully');", true);
ClearPopupData();
BindLeaveSummaryGrid();
UpdatePanelMain.Update();
}
else
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), Guid.NewGuid().ToString(), "alert('Your leave request not saved. Please contact Administrator.');", true);
}
}
}
catch (Exception ex)
{
TroyLiteExceptionManager.HandleException(ex);
}
}
protected void rptTierValues_ItemCommand(object source, RepeaterCommandEventArgs e)
{
if (SelectedPreference == null)
{
return;
}
if (e.CommandName.ToString() == "Add" && ((DropDownList)e.Item.FindControl("ddlPreferenceData")).SelectedItem != null)
{
Byte TierLevel = e.CommandArgument.ConvertToByte();
List <PreferenceItems> lstPreferences = (from item in PreferenceTierData
where item.TierLevel == TierLevel
select item.PreferenceItems).FirstOrDefault().ToList();
if (lstPreferences != null && lstPreferences.Count > 0)
{
PreferenceItems prefitem = (from p in lstPreferences
where p.Value == ((DropDownList)e.Item.FindControl("ddlPreferenceData")).SelectedItem.Value
select p).FirstOrDefault();
if (prefitem != null)
{
prefitem.Selected = true;
}
}
((DropDownList)e.Item.FindControl("ddlPreferenceData")).DataSource = lstPreferences.Where(p => p.Selected == false);
((DropDownList)e.Item.FindControl("ddlPreferenceData")).DataBind();
((ListBox)e.Item.FindControl("lstSelectedPreference")).DataSource = lstPreferences.Where(p => p.Selected == true);
((ListBox)e.Item.FindControl("lstSelectedPreference")).DataBind();
if (SelectedPreference.DataTypeID == PreferenceDataType.ListBox)
{
((Button)e.Item.FindControl("btnAdd")).Enabled = ((SelectedPreference.MultiValue == false || lstPreferences.Where(p => p.Selected == false).ToList().Count == 0) ? false : true);
if (SelectedPreference.MultiValue == true)
{
int i = m_Preference.GetPreferenceItemslistmaxvalue(Convert.ToInt32(SelectedPreference.PreferenceID));
if (lstPreferences.Where(p => p.Selected == true).ToList().Count < i)
{
((Button)e.Item.FindControl("btnAdd")).Enabled = true;
}
else
{
((Button)e.Item.FindControl("btnAdd")).Enabled = false;
}
}
}
else
{
((Button)e.Item.FindControl("btnAdd")).Enabled = false;
}
}
else if (e.CommandName.ToString() == "Remove" && ((ListBox)e.Item.FindControl("lstSelectedPreference")).SelectedItem != null)
{
Byte TierLevel = e.CommandArgument.ConvertToByte();
List <PreferenceItems> lstPreferences = (from item in PreferenceTierData
where item.TierLevel == TierLevel
select item.PreferenceItems).FirstOrDefault().ToList();
if (lstPreferences != null && lstPreferences.Count > 0)
{
foreach (ListItem item in ((ListBox)e.Item.FindControl("lstSelectedPreference")).Items)
{
PreferenceItems prefitem = (from p in lstPreferences
where p.Value == item.Value
select p).FirstOrDefault();
if (prefitem != null)
{
prefitem.Selected = !item.Selected;
}
}
((DropDownList)e.Item.FindControl("ddlPreferenceData")).DataSource = lstPreferences.Where(p => p.Selected == false);
((DropDownList)e.Item.FindControl("ddlPreferenceData")).DataBind();
((ListBox)e.Item.FindControl("lstSelectedPreference")).DataSource = lstPreferences.Where(p => p.Selected == true);
((ListBox)e.Item.FindControl("lstSelectedPreference")).DataBind();
}
if ((SelectedPreference.DataTypeID == PreferenceDataType.ListBox && lstPreferences.Where(p => p.Selected == false).ToList().Count > 0) || SelectedPreference.DataTypeID != PreferenceDataType.ListBox)
{
((Button)e.Item.FindControl("btnAdd")).Enabled = true;
}
}
UpdatePanelMain.Update();
}
protected void grdViewLeaveSummary_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
int leaveId = 0;
if (e.CommandName.Equals("EditLeave"))
{
if (int.TryParse(e.CommandArgument.ToString(), out leaveId))
{
if (!IsLeaveApprovedOrRejected(leaveId))
{
PopupDialogBindData(leaveId);
SetBalanceLeave();
ModalPopupExtender1.Show();
LeaveDetailPopUp.Visible = true;
ViewState["PopupMode"] = "UPDATE";
}
else
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), Guid.NewGuid().ToString(), "alert('Leave request which is Accecpted/Rejected/Cancelled could not be edited');", true);
}
}
}
else if (e.CommandName.Equals("CancelLeave"))
{
if (int.TryParse(e.CommandArgument.ToString(), out leaveId))
{
if (!IsLeaveApprovedOrRejected(leaveId))
{
if (CancelLeave(leaveId))
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), Guid.NewGuid().ToString(), "alert('Your leave request has been cancelled successfully');", true);
BindLeaveSummaryGrid();
UpdatePanelMain.Update();
}
}
else
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), Guid.NewGuid().ToString(), "alert('Leave request which is Accecpted/Rejected/Cancelled could not be cancelled');", true);
}
}
}
//BusinessLogic bl = new BusinessLogic(sDataSource);
//string connection = Request.Cookies["Company"].Value;
//string usernam = Request.Cookies["LoggedUserName"].Value;
//if (bl.CheckUserHaveEdit(usernam, "LEV"))
//{
// ((ImageButton)e.Row.FindControl("btnEdit")).Visible = false;
// ((ImageButton)e.Row.FindControl("btnEditDisabled")).Visible = true;
//}
//if (bl.CheckUserHaveDelete(usernam, "LEV"))
//{
// ((ImageButton)e.Row.FindControl("btnCancelLeave")).Visible = false;
// ((ImageButton)e.Row.FindControl("btnCancelLeaveDisabled")).Visible = true;
//}
}
catch (Exception ex)
{
TroyLiteExceptionManager.HandleException(ex);
}
}
