protected void lnkTest_Click(object sender, EventArgs e)
{
lblNotif.Visible = true;
lblNotif.Text = "Testing Sending Email...";
var dr = new AdministrationDAC().RetrieveEmailer();
try
{
string subject = "Healthy Club Email Notification System Tester";
string emailBody = "Please Do not Reply This Email. <br> This email was sent from Club Management Notification System to test the setting of the email server. If you receive this email, it means that email setting in Administration module is correct.";
EmailSender.SendTestEmail(txtSender.Text, dr.SMTPAccount, subject, emailBody, dr.SMTPHost, dr.SMTPPort, dr.SMTPUserName, dr.SMTPPassword, dr.SMTPSSL, dr.SMTPIIS);
lblError.Visible = false;
lblNotif.Visible = true;
lblNotif.Text = "Success sending email to " + dr.SMTPAccount + ".";
}
catch (Exception ex)
{
lblNotif.Text = "Failed Sending Email...";
lblError.Visible = true;
lblError.Text = "ERROR: " + ex.Message.ToString();
}
}
private void initDash()
{
AdministrationDAC dac = new AdministrationDAC();
int activerew = dac.RetrieveActiveRewards();
int inactiverew = dac.RetrieveInactiveRewards();
lblActiveRewards.Text = activerew.ToString();
int rewardsexp = dac.RetrieveExpiredRewards();
lblTotalRewards.Text = dac.RetrieveRewardsExplorerCount().ToString();
lblSponsors.Text = "0";
try
{
lblVisits.Text = VisitsNumber();
}
catch (Exception ex)
{
lblVisits.Text = "ERR";
lblerror.Text = ex.Message;
}
lblredempt.Text = dac.RetrieveTotalRedempted().ToString();
lblnever.Text = dac.Retrieveneverred().ToString();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Request.QueryString[SystemConstants.StateID] != null)
{
int stateID = Convert.ToInt32(Request.QueryString[SystemConstants.StateID]);
var dac = new AdministrationDAC();
AdministrationEDSC.StateDTRow dr = null;
if (stateID != 0)
{
dr = dac.RetrieveState(stateID);
StateSetupUC1.Mode = SystemConstants.FormMode.Edit;
StateSetupUC1.SetData(dr);
}
else
{
dr = new AdministrationEDSC.StateDTDataTable().NewStateDTRow();
StateSetupUC1.Mode = SystemConstants.FormMode.New;
}
}
CheckSignIn();
}
}
private void SetSponsorsTable()
{
var Sponsors = new AdministrationDAC().RetrieveSponsorsExplorer();
rptSponsors.DataSource = Sponsors;
rptSponsors.DataBind();
}
private void initDash()
{
AdministrationDAC dac = new AdministrationDAC();
int actCount = dac.RetrieveActivitiesCount((int)SystemConstants.ActivityStatus.Active, true) + dac.RetrieveActivitiesCount((int)SystemConstants.ActivityStatus.WillExpire, true);
lblApprovedActivity.Text = actCount.ToString();
lblDeletedAct.Text = dac.RetrieveActivitiesCount((int)SystemConstants.ActivityStatus.Deleting, true).ToString();
lblTotalActivity.Text = dac.RetrieveActivitiesCount().ToString();
//lblApprovedActivity.Text = dac.RetrieveApprovedActivitiesCount().ToString();
lblCat.Text = dac.RetrieveCategoriesCount().ToString();
lblMember.Text = dac.RetrieveCustomerListCount("").ToString();
lblProviders.Text = dac.RetrieveProviderListCount("").ToString();
lblWaitingActivity.Text = dac.RetrievePendingActivitiesCount().ToString();
lblExpiredAct.Text = dac.RetrieveActivitiesCount((int)SystemConstants.ActivityStatus.Expired, true).ToString();
try
{
lblstat.Text = VisitsNumber();
}
catch (Exception ex)
{
lblstat.Text = "ERR";
lblerror.Text = ex.Message;
}
}
private void SetDDL()
{
AdministrationEDSC.CategoryDTDataTable dt = new AdministrationDAC().RetrieveAllCategories();
DropDownList1.Items.Clear();
foreach (var dr in dt)
{
if (dr.ID != CurrentCategoryID && dr.Level1ParentID != CurrentCategoryID && dr.Level2ParentID != CurrentCategoryID)
{
string name = "";
if (dr.Level1ParentID != 0 && !dr.IsLevel1ParentNameNull())
{
name += dr.Level1ParentName + " >> ";
}
if (dr.Level2ParentID != 0 && !dr.IsLevel2ParentNameNull())
{
name += dr.Level2ParentName + " >> ";
}
name += dr.Name;
ListItem li = new ListItem(name, dr.ID.ToString());
DropDownList1.Items.Add(li);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
CheckSignIn();
if (Request.QueryString[SystemConstants.CouncilID] != null)
{
int councilID = Convert.ToInt32(Request.QueryString[SystemConstants.CouncilID]);
var dac = new AdministrationDAC();
AdministrationEDSC.CouncilDTRow dr = null;
if (councilID != 0)
{
dr = dac.RetrieveCouncil(councilID);
CouncilSetupUC.Mode = SystemConstants.FormMode.Edit;
CouncilSetupUC.SetDDL();
CouncilSetupUC.SetData(dr);
}
else
{
CouncilSetupUC.Mode = SystemConstants.FormMode.New;
}
}
}
}
private void SetActivitiesTable()
{
var Activities = new AdministrationDAC().RetrieveActivitiesExplorer();
rptActivities.DataSource = Activities;
rptActivities.DataBind();
}
public void SetActivityInformation()
{
if (EditMode)
{
var dr = new AdministrationDAC().RetrieveActivityExplorer(ActivityID);
txtActivityName.Text = dr.Name;
txtWebsite.Text = dr.Website;
ddlTitle.SelectedValue = dr.Title.ToString();
txtFirstName.Text = dr.FirstName;
txtLastName.Text = dr.LastName;
txtEmail.Text = txtConfirmEmailAddress.Text = dr.Email;
txtAddress1.Text = dr.Address;
ddlSuburbs.SelectedValue = dr.SuburbID.ToString();
ddlState.SelectedValue = dr.StateID.ToString();
txtPostCode.Text = dr.PostCode.ToString();
txtContactNumber.Text = dr.PhoneNumber;
txtMobile.Text = dr.MobileNumber;
ddlTitle0.SelectedValue = dr.AltTitle.ToString();
txtFirstName0.Text = dr.AltFirstName;
txtMiddleName0.Text = dr.AltMiddleName;
txtLastName0.Text = dr.AltLastName;
txtEmailalt.Text = txtConfirmEmailalt.Text = dr.AltEmail;
// txtAddress2.Text = dr.AltAddress;
//ddlSuburbs0.SelectedValue = dr.AltSuburbID.ToString();
//ddlState0.SelectedValue = dr.AltStateID.ToString();
//txtPostCode0.Text = dr.AltPostCode.ToString();
txtContactNumber0.Text = dr.AltPhoneNumber;
txtMobile0.Text = dr.AltMobileNumber;
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
int mode = 0;
AdministrationDAC dac = new AdministrationDAC();
AdministrationEDSC.KeyCollectionDTRow drKeyProperties = GetKeyProperties();
AdministrationEDSC.KeywordDTRow drKeywords = GetKeywords();
AdministrationBFC bfc = new AdministrationBFC();
if (UIMode == SystemConstants.FormMode.New.ToString())
{
mode = (int)SystemConstants.FormMode.New;
}
else if (UIMode == SystemConstants.FormMode.Edit.ToString())
{
mode = (int)SystemConstants.FormMode.Edit;
}
else if (UIMode == SystemConstants.FormMode.View.ToString())
{
mode = (int)SystemConstants.FormMode.View;
}
bfc.SaveKeywords(drKeyProperties, drKeywords, mode);
UIMode = SystemConstants.FormMode.New.ToString();
txtName.Text = "";
txtDescription.Text = "";
txtSynonims.Text = "";
hdnThesaurusID.Value = "";
hdnThesaurusKeyID.Value = "";
Refresh();
}
protected void DataList1_ItemCommand(object source, DataListCommandEventArgs e)
{
if (e.CommandName == "SetAsMainImage" || e.CommandName == "DeleteImage" || e.CommandName == "ViewImage" || e.CommandName == "SaveImage" || e.CommandName == "CancelEditImage" || e.CommandName == "EditImage")
{
LinkButton lnkDelete = e.Item.FindControl("lnkDelete") as LinkButton;
HiddenField hdnImageID = e.Item.FindControl("hdnImageID") as HiddenField;
int imageID = Convert.ToInt32(hdnImageID.Value);
AdministrationDAC dac = new AdministrationDAC();
AdministrationBFC bfc = new AdministrationBFC();
Label lblImageDescription = e.Item.FindControl("lblImageDescription") as Label;
Label lblImageTitle = e.Item.FindControl("lblImageTitle") as Label;
TextBox txtImageTitle = e.Item.FindControl("txtImageTitle") as TextBox;
TextBox ckImageDescription = e.Item.FindControl("txtImageDescription") as TextBox;
HiddenField hdnFilesize = e.Item.FindControl("hdnFilesize") as HiddenField;
if (e.CommandName == "DeleteImage")
{
string imageVirtualPath = "";
string imageThumbVirtualPath = "";
bfc.DeleteActivityImage(ActivityID, imageID, Convert.ToInt32(hdnFilesize.Value), out imageThumbVirtualPath, out imageVirtualPath);
Refresh();
}
else if (e.CommandName == "SetAsMainImage")
{
dac.UpdateActivityPrimaryImage(ActivityID, imageID);
Refresh();
foreach (DataListItem item in DataList1.Items)
{
SetDataListItemMode(item, true);
}
}
}
}
private void SetRewardsTable()
{
var Rewards = new AdministrationDAC().RetrieveRewardsExplorer();
rptRewards.DataSource = Rewards;
rptRewards.DataBind();
}
protected void lnkOk1_Click(object sender, EventArgs e)
{
AdministrationEDSC.SuburbDTRow dr = new AdministrationEDSC.SuburbDTDataTable().NewSuburbDTRow();
dr = GetData();
if (ddlCouncil.SelectedValue == "0")
{
lblerror.Visible = true;
}
else
{
string userName = SystemConstants.DevUser;
//Membership.GetUser().UserName;
AdministrationDAC dac = new AdministrationDAC();
if (Mode == SystemConstants.FormMode.New)
{
dac.CreateSuburb(userName, dr);
}
else if (Mode == SystemConstants.FormMode.Edit)
{
dac.UpdateSuburb(userName, dr);
}
Mode = SystemConstants.FormMode.View;
}
}
private void SetDDLEmail()
{
AdministrationDAC dac = new AdministrationDAC();
var dt1 = dac.RetrieveEmailTemplates();
foreach (var dr in dt1)
{
ListItem li1 = new ListItem(dr.EmailName, dr.ID.ToString());
ddEmailTemplate1.Items.Add(li1);
ListItem li2 = new ListItem(dr.EmailName, dr.ID.ToString());
ddEmailTemplate2.Items.Add(li2);
ListItem li3 = new ListItem(dr.EmailName, dr.ID.ToString());
ddEmailTemplate3.Items.Add(li3);
ListItem li4 = new ListItem(dr.EmailName, dr.ID.ToString());
ddEmailTemplate4.Items.Add(li4);
ListItem li5 = new ListItem(dr.EmailName, dr.ID.ToString());
ddEmailTemplate5.Items.Add(li5);
ListItem li6 = new ListItem(dr.EmailName, dr.ID.ToString());
ddEmailTemplate6.Items.Add(li6);
ListItem li7 = new ListItem(dr.EmailName, dr.ID.ToString());
ddEmailTemplate7.Items.Add(li7);
ListItem li8 = new ListItem(dr.EmailName, dr.ID.ToString());
ddEmailTemplate8.Items.Add(li8);
}
}
protected void ListViewAsset_ItemCommand(object sender, ListViewCommandEventArgs e)
{
if (e.CommandName == "DeleteAsset" || e.CommandName == "viewAssetDetail")
{
LinkButton lnkDelete = e.Item.FindControl("lnkDelete") as LinkButton;
HiddenField hdnAssetID = e.Item.FindControl("hdnAssetID") as HiddenField;
HiddenField hdnFilename = e.Item.FindControl("hdnFilename") as HiddenField;
HiddenField hdnFileext = e.Item.FindControl("hdnFileext") as HiddenField;
HiddenField hdnFilesize = e.Item.FindControl("hdnFilesize") as HiddenField;
int AssetID = Convert.ToInt32(hdnAssetID.Value);
AdministrationDAC dac = new AdministrationDAC();
AdministrationBFC bfc = new AdministrationBFC();
if (e.CommandName == "DeleteAsset")
{
dac.DeleteAsset(AssetID);
Refresh();
}
else if (e.CommandName == "viewAssetDetail")
{
lblFilesize.Text = hdnFilesize.Value + " KB";
lblTitle.Text = hdnFilename.Value;
lblExtension.Text = hdnFileext.Value;
lblUrl.Text = SystemConstants.CustomerUrl + "ImageHandler.ashx?" + SystemConstants.qs_AssetID + "=" + hdnAssetID.Value;;
ModalPopupExtender1.Show();
}
}
}
public void SetActivityGroup()
{
if (EditMode)
{
AdministrationDAC dac = new AdministrationDAC();
var dr = dac.RetrieveActivityGroup(ActivityID);
var drdet = dac.RetrieveActivity(ActivityID);
chkMale.Checked = dr.forMale;
chkFemale.Checked = dr.forFemale;
chkChild.Checked = dr.forChildren;
if (dr.AgeFrom == 0 && dr.AgeTo == 99)
{
chkAgeAll.Checked = true;
}
else
{
txtOldFrom.Text = dr.AgeFrom.ToString();
txtOldTo.Text = dr.AgeTo.ToString();
}
tabRowAge.Visible = !chkAgeAll.Checked;
if (!string.IsNullOrEmpty(drdet.Keywords))
{
txtKeyword.Text = drdet.Keywords;
}
}
}
private void SetDDL()
{
AdministrationEDSC.CategoryDTDataTable dt = new AdministrationDAC().RetrieveAllCategories();
dropDownParent.Items.Clear();
ListItem li = new ListItem("Root", "0");
dropDownParent.Items.Add(li);
foreach (var dr in dt)
{
string name = "";
if (dr.Level1ParentID != 0 && !dr.IsLevel1ParentNameNull())
{
name += dr.Level1ParentName + " >> ";
}
if (dr.Level2ParentID != 0 && !dr.IsLevel2ParentNameNull())
{
name += dr.Level2ParentName + " >> ";
}
name += dr.Name;
li = new ListItem(name, dr.ID.ToString());
dropDownParent.Items.Add(li);
}
if (CategoryRoot != 0)
{
dropDownParent.SelectedValue = CategoryRoot.ToString();
}
}
private void CheckActivityImage()
{
//checkdatabase for record
//if not exist, create img folder & thumb folder
var dr = new AdministrationDAC().RetrieveActivityImageInformation(ActivityID);
if (dr == null)
{
dr = new AdministrationEDSC.ActivityImageDTDataTable().NewActivityImageDTRow();
//Create new ImageInformationRecord
dr.ActivityID = ActivityID;
dr.FreeStorage = SystemConstants.MaxActivityImageStorage;
dr.StorageUsed = 0;
dr.ImageAmount = 0;
new AdministrationDAC().createActivityImageInformation(dr);
// string Path = SystemConstants.ImageDirectory + "/" + activityID + "/" + activityID + "_" + imageID + "_" + prodImage.Filename;
//Ensure Directory is exist
//Server.MapPath(SystemConstants.ActImageDirectory + "/" + ActivityID + "/");
//Create ImageDir
//System.IO.Directory.CreateDirectory(Server.MapPath(@SystemConstants.ActImageDirectory + "/" + ActivityID + "/"));
//Create ImageThumbDir
//System.IO.Directory.CreateDirectory(Server.MapPath(@SystemConstants.ActImageDirectory + "/" + ActivityID + "/" + @SystemConstants.ImageThumbDirectory));
}
else
{
divUploadSuccessfull.Visible = true;
}
}
protected void rptRewards_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
HiddenField hdntimes = e.Item.FindControl("Timesused") as HiddenField;
HiddenField hdnused = e.Item.FindControl("Usagetimes") as HiddenField;
Label lblStatus = e.Item.FindControl("lblStatus") as Label;
Label lblRwdID = e.Item.FindControl("lblRwdID") as Label;
if (hdntimes.Value == "")
{
hdntimes.Value = "0";
}
if (hdnused.Value == "")
{
hdnused.Value = "0";
}
if (Convert.ToInt32(hdntimes.Value) >= Convert.ToInt32(hdnused.Value))
{
lblStatus.Text = "Inactive";
}
else
{
lblStatus.Text = "Active";
}
Label lblleft = e.Item.FindControl("Coupons_left") as Label;
lblleft.Text = Convert.ToString(Convert.ToInt32(hdnused.Value) - Convert.ToInt32(hdntimes.Value));
HiddenField hdnRwdtype = e.Item.FindControl("hdnRwdtype") as HiddenField;
Label lblRwdtype = e.Item.FindControl("lblRwdtype") as Label;
int rwdtype = Convert.ToInt32(hdnRwdtype.Value);
if (rwdtype == (int)SystemConstants.RewardType.Discount)
{
lblRwdtype.Text = "Discount";
}
else if (rwdtype == (int)SystemConstants.RewardType.Offer)
{
lblRwdtype.Text = "Offer";
}
else if (rwdtype == (int)SystemConstants.RewardType.Other)
{
lblRwdtype.Text = "Other";
}
else if (rwdtype == (int)SystemConstants.RewardType.Gift)
{
lblRwdtype.Text = "Gift";
}
HiddenField hdnProviderID = e.Item.FindControl("hdnProviderID") as HiddenField;
HyperLink hlnkProviderID = e.Item.FindControl("hlnkProviderID") as HyperLink;
HyperLink hlnkSponsorName = e.Item.FindControl("hlnkSponsorName") as HyperLink;
Guid spnId = new Guid(hdnProviderID.Value);
hlnkSponsorName.NavigateUrl = "~/Rewards/SponsorTools.aspx?" + SystemConstants.qs_SponsorsID + "=" + hdnProviderID.Value;
Label lblsponsor = e.Item.FindControl("lblsponsor") as Label;
AdministrationDAC dac = new AdministrationDAC();
lblsponsor.Text = dac.getSponsorName(spnId);
HiddenField hdnRewardsID = e.Item.FindControl("hdnRewardsID") as HiddenField;
HyperLink hlnkRewardsName = e.Item.FindControl("hlnkRewardName") as HyperLink;
hlnkRewardsName.NavigateUrl = "~/Rewards/Modify.aspx?" + SystemConstants.qs_RewardsID + "=" + hdnRewardsID.Value;
}
}
private void SetPageInfo()
{
AdministrationDAC dac = new AdministrationDAC();
var dr = dac.RetrievePage(PageID);
SetData(dr);
Mode = UIMode.View;
}
protected void lnkResenConfirmation_Click(object sender, EventArgs e)
{
var MailConf = new AdministrationDAC().RetrieveWebConfiguration();
var emTemp = new AdministrationDAC().RetrieveMailTemplate((int)SystemConstants.EmailTemplateType.ProviderWelcomeEmail);
new AdministrationBFC().ParseEmail(emTemp, new Guid(hdnUserID.Value), hdnConfirmationToken.Value, (int)SystemConstants.EmailTemplateType.ProviderConfirmationEmail, 0);
EmailSender.SendEmail(MailConf.SMTPAccount, hdnEmail.Value, emTemp.EmailSubject, emTemp.EmailBody, MailConf.SMTPHost, MailConf.SMTPPort, MailConf.SMTPUserName, MailConf.SMTPPassword, MailConf.SMTPSSL, MailConf.SMTPIIS);
lblStatus.Text = "Email Sent - " + DateTime.Now.ToShortDateString() + DateTime.Now.ToShortTimeString();
}
protected void btnNoteCancel_Click(object sender, EventArgs e)
{
noteMode = SystemConstants.FormMode.View;
string message = new AdministrationDAC().RetrieveActivityLogNote(Convert.ToInt32(HdnNoteValue.Value));;
if (!string.IsNullOrEmpty(message))
{
txtNote.Text = message;
}
}
protected void lnkDelete_Click(object sender, EventArgs e)
{
AdministrationDAC dac = new AdministrationDAC();
AdministrationEDSC.SuburbDTDataTable dt = GetSelected();
foreach (AdministrationEDSC.SuburbDTRow dr in dt)
{
dac.DeleteSuburb(dr.ID);
}
Refresh();
}
/*
* public void SetActivityInformation()
* {
* if (EditMode)
* {
* var dr = new AdministrationDAC().RetrieveActivityExplorer(ActivityID);
* ddlCategorylvl2.Visible = true;
* if (dr.CategoryLevel1ParentID != 0)
* {
* ddlCategorylvl1.SelectedValue = dr.CategoryLevel1ParentID.ToString();
* CheckCategorylvl1();
* ddlCategorylvl2.SelectedValue = dr.CategoryID.ToString();
* }
* else
* ddlCategorylvl1.SelectedValue = dr.CategoryID.ToString();
*
* ddlFeesCategory.SelectedValue = dr.ActivityType.ToString();
* SetEligibilityView();
* txtEligibility.Text = dr.eligibilityDescription;
* txtFee.Text = dr.Price;
* if (dr.isMembershipRequired == null)
* dr.isMembershipRequired = false;
* radIsMemberReqYes.Checked = dr.isMembershipRequired;
* radIsMemberReqNo.Checked = !dr.isMembershipRequired;
*
* if (dr.isMembershipRequired == null)
* dr.isMembershipRequired = true;
* radCommenceYes.Checked = dr.isCommenceAnytime;
* radCommenceNo.Checked = !dr.isCommenceAnytime;
* }
* }
*/
private void setActivityDescription()
{
var dr = new AdministrationDAC().RetrieveActivity(ActivityID);
txtFullDesc.Text = dr.FullDescription;
List <ListItem> SelectedCat = new List <ListItem>();
if (dr.CategoryID != 0)
{
var Cat = new AdministrationDAC().RetrieveCategory(dr.CategoryID);
ListItem cat1 = new ListItem(Cat.Name, Cat.ID.ToString());
SelectedCat.Add(cat1);
}
if (dr.SecondaryCategoryID1 != 0)
{
var Cat = new AdministrationDAC().RetrieveCategory(dr.SecondaryCategoryID1);
ListItem cat2 = new ListItem(Cat.Name, Cat.ID.ToString());
SelectedCat.Add(cat2);
}
if (dr.SecondaryCategoryID2 != 0)
{
var Cat = new AdministrationDAC().RetrieveCategory(dr.SecondaryCategoryID2);
ListItem cat3 = new ListItem(Cat.Name, Cat.ID.ToString());
SelectedCat.Add(cat3);
}
if (dr.SecondaryCategoryID3 != 0)
{
var Cat = new AdministrationDAC().RetrieveCategory(dr.SecondaryCategoryID3);
ListItem cat4 = new ListItem(Cat.Name, Cat.ID.ToString());
SelectedCat.Add(cat4);
}
if (dr.SecondaryCategoryID4 != 0)
{
var Cat = new AdministrationDAC().RetrieveCategory(dr.SecondaryCategoryID4);
ListItem cat5 = new ListItem(Cat.Name, Cat.ID.ToString());
SelectedCat.Add(cat5);
}
ActivityRegistrationCategory1.setSelectedCategory(SelectedCat);
//set fees category
ddlFeesCategory.SelectedValue = dr.ActivityType.ToString();
SetEligibilityView();
if (dr.ActivityType == (int)SystemConstants.ActivityFeeCategory.Private_Paid || dr.ActivityType == (int)SystemConstants.ActivityFeeCategory.Public_Paid)
{
txtFee.Text = dr.Price;
}
if (dr.ActivityType == (int)SystemConstants.ActivityFeeCategory.Private_Paid || dr.ActivityType == (int)SystemConstants.ActivityFeeCategory.Private_Free)
{
txtEligibility.Text = dr.eligibilityDescription;
}
}
protected void ddlYears_SelectedIndexChanged(object sender, EventArgs e)
{
string[] x = { "JAN", "FEB", "MAR", "APR", "MAY", "JUN", "JUL", "AUG", "SEP", "OCT", "NOV", "DEC" };
Guid userId = Guid.Empty;
string fName = null;
if (Session[SystemConstants.ses_FName] != null)
{
fName = (String)(Session[SystemConstants.ses_FName]);
}
var dt = new AdministrationDAC().RetrieveallVouchers();
decimal[] y = new decimal[12];
int allyear = 0;
for (int i = 1; i < 13; i++)
{
int redemption = 0;
foreach (DataRow dtr in dt.Rows)
{
DateTime date = (System.DateTime)dtr["IssueDate"];
int yr = date.Year;
if (Convert.ToString(yr).Equals(ddlYears.SelectedValue))
{
if (date.Month.Equals(i))
{
redemption++;
y[i - 1] = redemption;
}
}
}
allyear += redemption;
}
BarChart1.Series.Add(new AjaxControlToolkit.BarChartSeries {
Data = y, Name = "Monthly Total Redemption", BarColor = "#22536e "
});
BarChart1.CategoriesAxis = string.Join(",", x);
BarChart1.ChartTitle = string.Format("Total Number of Redemption in " + ddlYears.SelectedItem.Value + ": " + allyear);
if (x.Length > 3)
{
BarChart1.ChartWidth = (x.Length * 100).ToString();
}
BarChart1.Visible = ddlYears.SelectedItem.Value != "";
BarChart1.ChartWidth = "800";
}
private void InitiateCategory()
{
listViewCatRoot.Items.Clear();
listViewCatLvl1.Items.Clear();
listViewCatLvl2.Items.Clear();
divSecCat.Visible = false;
divL2SecCat.Visible = false;
AdministrationEDSC.CategoryDTDataTable dt = new AdministrationDAC().RetrieveLv0Categories();
SortListItem(dt);
listViewCatRoot.DataSource = dt;
listViewCatRoot.DataBind();
}
private void SetEmailer()
{
var dr = new AdministrationDAC().RetrieveEmailer();
if (dr != null)
{
SetEmailerInformation(dr);
}
else
{
Mode = UIMode.Create;
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (!isError())
{
AdministrationEDSC.UserProfilesDTRow dr = GetRegistrationData();
AdministrationDAC dac = new AdministrationDAC();
dac.UpdateUserProfiles(dr);
//Membership.GetUser().Email = dr.Email;
}
Mode = SystemConstants.FormMode.View;
SetUserInformation();
}
private void InitActivityInformation()
{
var dr = new AdministrationDAC().RetrieveActivity(ActivityID);
ProviderID = dr.ProviderID;
RadYes.Checked = dr.isApproved;
RadNo.Checked = !dr.isApproved;
SetActivityDetail();
SetActivityDescription();
SetActivityTimetable(dr.TimetableType);
SetActivityGrouping();
SetActivityImages();
}
protected void ddlCouncil_SelectedIndexChanged(object sender, EventArgs e)
{
if (ddlCouncil.SelectedValue == "0")
{
lblState.Text = "Select a council";
}
else
{
var councilDr = new AdministrationDAC().RetrieveCouncilState(Convert.ToInt32(ddlCouncil.SelectedValue));
lblState.Text = councilDr.StateDetail;
hdnStateID.Value = councilDr.StateID.ToString();
}
}
