public void searchCustomerData()
{
string sql = "SELECT cusfields.Index,cusfields.Value,cusindex.Name,cusfields.IDKey AS FID FROM crm2.cusfields INNER JOIN crm2.cusindex ON cusfields.CusID=cusindex.IDKey WHERE cusfields.CusID='" + customer + "';";
TaskCallback call = populatePage;
DatabaseFunctions.SendToPhp(false, sql, call);
}
// Functia principala de calcul a Recomandarilor.
public static List<Preparat> Recomandari(int id_user, Comanda comanda_actuala, int k)
{
IstoricComenzi istoric = DatabaseFunctions.getIstoric(id_user);
List<Comanda> istoric_comenzi = istoric.ListaComenzi;
List<Preparat> recomandari=null;
if (istoric_comenzi.Count > 0)
{
recomandari = Gaseste_recomandari_ContentBased(id_user, k/2, istoric_comenzi);
List<Preparat> recomandari_collective = Gaseste_recomandari_Collective(id_user, comanda_actuala, k);
foreach (var preparat in recomandari_collective)
{
if (recomandari.Count == k)
{
break;
}
if (!recomandari.Contains(preparat))
{
recomandari.Add(preparat);
}
}
}
else
{
List<String> lista_specifice = DatabaseFunctions.getSpecificsForUser(id_user);
if (lista_specifice == null)
recomandari = DatabaseFunctions.topKPreparate(k);
else
recomandari = DatabaseFunctions.topKPreparateSpecific(lista_specifice, k);
}
return recomandari;
}
public void onClicked(object sender, RoutedEventArgs e)
{
List <string> batch = new List <string>();
foreach (DataPair dataPair in this.entryDict)
{
if (dataPair.isNew)
{
string s = "INSERT INTO cusfields (cusfields.Value,cusfields.Index,CusID) VALUES('" + FormatFunctions.CleanDateNew(dataPair.Value.Text) + "','" + FormatFunctions.CleanDateNew(dataPair.Index.Text) + "','" + this.customer + "')";
batch.Add(s);
dataPair.isNew = false;
}
else if (!dataPair.Index.Text.Equals(dataPair.Index.GetInit()) || !dataPair.Value.Text.Equals(dataPair.Value.GetInit()))
{
string s = "UPDATE cusfields SET cusfields.Value = '" + FormatFunctions.CleanDateNew(dataPair.Value.Text) + "',cusfields.Index='" + FormatFunctions.CleanDateNew(dataPair.Index.Text) + "' WHERE (IDKey= '" + dataPair.Index.GetInt() + "');";
batch.Add(s);
}
}
string sql = "UPDATE cusfields SET cusfields.value='" + FormatFunctions.CleanDateNew(noteLabel.Text) + "' WHERE cusfields.Index LIKE'%otes%' AND CusID= '" + customer + "'";
batch.Add(sql);
string sql2 = "UPDATE cusindex SET Name='" + FormatFunctions.CleanDateNew(nameLabel.Text) + "' WHERE IDKey= '" + customer + "'";
batch.Add(sql2);
string sql3 = "UPDATE cusfields SET cusfields.value='" + FormatFunctions.CleanDateNew(BookingDate.Text) + "' WHERE cusfields.Index LIKE '%ookin%' AND CusID= '" + customer + "'";
batch.Add(sql3);
string sql4 = "UPDATE cusfields SET cusfields.value='" + FormatFunctions.CleanPhone(phoneLabel.Text) + "' WHERE cusfields.Index LIKE '%hone%' AND CusID= '" + customer + "'";
batch.Add(sql4);
string sql5 = "UPDATE cusfields SET cusfields.value='" + FormatFunctions.CleanDateNew(DateTime.Now.ToString("yyyy/M/d h:mm:ss")) + "' WHERE cusfields.Index LIKE '%odified On%' AND CusID= '" + customer + "'";//'Modified On','" + FormatFunctions.CleanDateNew(DateTime.Now.ToString("yyyy/M/d h:mm:ss")) + "'
batch.Add(sql5);
DatabaseFunctions.SendBatchToPHP(batch);
}
private void BuildAvgScoreTable(Table table, string title, Dictionary <int, decimal> data, Dictionary <int, int> numberOfRoundsPlayed, int titleFont)
{
table.CellSpacing = 5;
TableRow tableTitleRow = new TableRow();
TableCell titleCell = AddCell(tableTitleRow, title);
titleCell.HorizontalAlign = HorizontalAlign.Center;
titleCell.Font.Bold = true;
titleCell.Font.Size = titleFont;
titleCell.ColumnSpan = 3;
tableTitleRow.Cells.Add(titleCell);
table.Rows.Add(tableTitleRow);
table.Rows.Add(CreateAvgScoreColumnTitleRow("Number of Rounds"));
var items = from pair in data
orderby pair.Value ascending
select pair;
foreach (KeyValuePair <int, decimal> pair in items)
{
if (numberOfRoundsPlayed[pair.Key] > 0)
{
table.Rows.Add(CreateRow(new List <string>()
{
DatabaseFunctions.GetGolferName(pair.Key), Decimal.Round(data[pair.Key], 2).ToString(), numberOfRoundsPlayed[pair.Key].ToString()
}));
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
bool isUserCommissioner = false;
leagueID = (int)((SiteMaster)this.Master).LeagueID;
currentSeasonID = DatabaseFunctions.GetCurrentSeasonID(leagueID.ToString());
if (leagueID == 3)
{
RulesHyperlink.Visible = true;
RulesHyperlink.NavigateUrl = "http://www.golfleagueinfo.com/2017ProgCOSLeagueRules.htm";
}
List <Announcement> announcements = DatabaseFunctions.GetAnnouncements(leagueID);
foreach (var announcement in announcements)
{
AddAnnouncementRow(announcement);
}
if (HttpContext.Current.User.Identity.IsAuthenticated)
{
var currentUserID = Membership.GetUser().ProviderUserKey.ToString();
var commisioners = DatabaseFunctions.GetCommissionerIds(leagueID);
isUserCommissioner = commisioners.Contains(currentUserID);
if (isUserCommissioner)
{
this.ButtonAddAnnouncement.Visible = true;
}
}
}
private void BuildAvgScoreTable(Table table, string title, Dictionary <int, Scoring.WeightedAvgHelper> data, int titleFont, string thirdColumnTitle)
{
table.CellSpacing = 5;
TableRow tableTitleRow = new TableRow();
TableCell titleCell = AddCell(tableTitleRow, title);
titleCell.HorizontalAlign = HorizontalAlign.Center;
titleCell.Font.Bold = true;
titleCell.Font.Size = titleFont;
titleCell.ColumnSpan = 3;
tableTitleRow.Cells.Add(titleCell);
table.Rows.Add(tableTitleRow);
table.Rows.Add(CreateAvgScoreColumnTitleRow(thirdColumnTitle));
var items = from pair in data
orderby pair.Value.averageValue ascending
select pair;
foreach (KeyValuePair <int, Scoring.WeightedAvgHelper> pair in items)
{
if (pair.Value.numValues > 0)
{
table.Rows.Add(CreateRow(new List <string>()
{
DatabaseFunctions.GetGolferName(pair.Key), Decimal.Round(pair.Value.averageValue, 2).ToString(), pair.Value.numValues.ToString()
}));
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (((SiteMaster)this.Master).LeagueName != null)
{
this.leagueID = leagueID = (int)((SiteMaster)this.Master).LeagueID;
}
else
{
//error?
Response.Redirect("NoLeague.aspx");
}
currentSeasonID = DatabaseFunctions.GetCurrentSeasonID(leagueID.ToString());
eventsAndGolfers = DatabaseFunctions.GetEventsAndPlayers(leagueID, currentSeasonID);
//Dictionary<int, string> courses = DatabaseFunctions.GetAllCourses();
//Dictionary<int, string> teams = DatabaseFunctions.GetTeamNames(leagueID, currentSeasonID);
if (!Page.IsPostBack)
{
ListItem initialItem = new ListItem("Select Event to Continue", "0");
Dropdown_LeagueEvent.Items.Add(initialItem);
//TODO only add events in current season?
foreach (KeyValuePair <int, EventInfo> eventPair in eventsAndGolfers.events.OrderBy(x => x.Value.EventID))
{
int eventID = eventPair.Key;
ListItem eventItem = new ListItem(eventsAndGolfers.events[eventID].EventName, eventID.ToString());
Dropdown_LeagueEvent.Items.Add(eventItem);
}
Dropdown_LeagueEvent.SelectedIndex = 0;
}
}
private void AddSubsToDropdown(DropDownList dropdown, int selectedEventID)
{
Dictionary <int, string> allGolfers = DatabaseFunctions.GetGolferNamesAndIDs(leagueID.ToString());//get all players
List <int> scheduledGolfers = DatabaseFunctions.GetGolfersByEvent(selectedEventID);
Dictionary <int, int> subs = DatabaseFunctions.GetSubs(selectedEventID);
foreach (int golferID in scheduledGolfers)
{
if (!subs.ContainsKey(golferID))
{
allGolfers.Remove(golferID);
}
}
foreach (int golferID in subs.Values)
{
allGolfers.Remove(golferID);
}
ListItem selectionItem = new ListItem("None", "0");
dropdown.Items.Add(selectionItem);
foreach (int golferID in allGolfers.Keys)
{
ListItem playerItem = new ListItem(allGolfers[golferID], golferID.ToString());
dropdown.Items.Add(playerItem);
}
}
// Token: 0x06000833 RID: 2099 RVA: 0x0003A480 File Offset: 0x00038680
protected virtual void LoadFromReader(IDataReader rd)
{
if (rd == null)
{
throw new ArgumentNullException("rd");
}
this.Id = DatabaseFunctions.GetGuid(rd, "NotificationID");
this.Title = DatabaseFunctions.GetString(rd, "Title");
this.Description = DatabaseFunctions.GetString(rd, "Description");
this.CreatedAt = DatabaseFunctions.GetDateTime(rd, "CreatedAt");
this.Ignored = DatabaseFunctions.GetBoolean(rd, "Ignored");
this.TypeId = DatabaseFunctions.GetGuid(rd, "NotificationTypeID");
this.Url = DatabaseFunctions.GetString(rd, "Url");
DateTime dateTime = DatabaseFunctions.GetDateTime(rd, "AcknowledgedAt");
if (dateTime == DateTime.MinValue)
{
this.AcknowledgedAt = null;
}
else
{
this.AcknowledgedAt = new DateTime?(dateTime);
}
this.AcknowledgedBy = DatabaseFunctions.GetString(rd, "AcknowledgedBy");
}
public DataSet getEwalletNumber_new(string userid, string portal)
{
DatabaseFunctions db = new DatabaseFunctions();
return(db.getEwalletNumber_New(userid, portal));
}
private async void UpdateButton_Clicked(object sender, EventArgs e)
{
DatabaseFunctions dbf = new DatabaseFunctions();
var userList = await dbf.getUsers();
foreach (var item in userList)
{
if (item.Profile == t.Profile)
{
t = item;
}
}
var check = await dbf.deleteUser(t);
if (!CrossConnectivity.Current.IsConnected)
{
await DisplayAlert("Warning", "Please, check your internet settings!", "OK");
}
else if (check)
{
DependencyService.Get <ISaveAndLoad>().SaveText("login.txt", "");
await Navigation.PushAsync(new MainCsPage());
}
else
{
await DisplayAlert("Warning", "Something went wrong, please check back later!", "OK");
}
}
public void populate()
{
string sql2 = "SELECT agents.FName,agents.IDKey FROM agents WHERE Active='1'";
TaskCallback call3 = populateSalesCombo;
DatabaseFunctions.SendToPhp(false, sql2, call3);
}
public void getFavoriteAgents()
{
string statement = "SELECT agents.Fname AS Name,agents.IDKey, '0' AS g FROM agents INNER JOIN chatfavorite ON agents.IDKey=chatfavorite.TargetID WHERE chatfavorite.AgentID='" + ClientData.AgentIDK + "';";
TaskCallback call = new TaskCallback(this.populatePicker);
DatabaseFunctions.SendToPhp(false, statement, call);
}
public void populateTardiGridBypass()
{
TaskCallback call = populateTardiGrid;
string sql = "SELECT * FROM agentrecords WHERE AgentID='" + agents[Agent3.SelectedIndex] + "'";
DatabaseFunctions.SendToPhp(false, sql, call);
}
public void onClickLate(object sender, RoutedEventArgs e)
{
string sql = "INSERT INTO agentrecords (AgentID,Note,Date,RecordType) VALUES ('" + agents[Agent3.SelectedIndex] + "','" + SickNote.Text + "','" + DayPicker3.SelectedDate.Value.ToString("yyyy/M/d") + "','Tardy')";
DatabaseFunctions.SendToPhp(sql);
populateTardiGridBypass();
}
private void BindDataToGridview(int selectedEventID)
{
List <ScoresView> dataToBind = new List <ScoresView>();
Dictionary <int, string> golferNames = DatabaseFunctions.GetGolferNamesAndIDs(leagueID.ToString());
Dictionary <int, int> subs = DatabaseFunctions.GetSubs(selectedEventID);
Dictionary <int, List <byte> > scores = DatabaseFunctions.GetScores(selectedEventID);
List <int> golferIDs = DatabaseFunctions.GetGolfersByEvent(selectedEventID);
foreach (int golferID in golferIDs)
{
try
{
string sub = subs.ContainsKey(golferID) ? golferNames[subs[golferID]] : "";
List <byte> scoresToUse;
if (sub == "")
{
scoresToUse = scores.ContainsKey(golferID) ? scores[golferID] : null;
}
else
{
scoresToUse = scores[subs[golferID]];
}
ScoresView scoresView = new ScoresView(golferNames[golferID], sub, scoresToUse, golferID);
dataToBind.Add(scoresView);
}
catch { }
}
grdScores.DataSource = dataToBind;
grdScores.DataBind();
}
public int InserteWalletDepositForm(string Enumber, string Formtype, string paymentdate, string amountpaid, string trnum, string bankname, string OnlineBankAccountName, string BankTransactionNo, byte[] imagefile,string imageName)
{
int id=-1;
try {
MemoryStream ms = new MemoryStream(imagefile);
FileStream fs = new FileStream(System.Web.Hosting.HostingEnvironment.MapPath
("~/depositSlipScans/") + imageName, FileMode.Create);
ms.WriteTo(fs);
DatabaseFunctions db = new DatabaseFunctions();
Enumber = utilities.Encrypt(Enumber);
Formtype = utilities.Encrypt(Formtype);
amountpaid= utilities.Encrypt(amountpaid);
trnum =utilities.Encrypt(trnum);
bankname = utilities.Encrypt(bankname);
OnlineBankAccountName = utilities.Encrypt(OnlineBankAccountName);
BankTransactionNo = utilities.Encrypt(BankTransactionNo);
imageName = utilities.Encrypt(imageName);
id= db.InserteWalletDepositForm(Enumber,Formtype,paymentdate,amountpaid,trnum,bankname,OnlineBankAccountName,BankTransactionNo,imageName);
ms.Close();
fs.Close();
fs.Dispose();
}
catch (Exception e) {
}
return id;
}
public int InserteWalletDepositForm(string Enumber, string Formtype, string paymentdate, string amountpaid, string trnum, string bankname, string OnlineBankAccountName, string BankTransactionNo, byte[] imagefile, string imageName)
{
int id = -1;
try {
MemoryStream ms = new MemoryStream(imagefile);
FileStream fs = new FileStream(System.Web.Hosting.HostingEnvironment.MapPath
("~/depositSlipScans/") + imageName, FileMode.Create);
ms.WriteTo(fs);
DatabaseFunctions db = new DatabaseFunctions();
Enumber = utilities.Encrypt(Enumber);
Formtype = utilities.Encrypt(Formtype);
amountpaid = utilities.Encrypt(amountpaid);
trnum = utilities.Encrypt(trnum);
bankname = utilities.Encrypt(bankname);
OnlineBankAccountName = utilities.Encrypt(OnlineBankAccountName);
BankTransactionNo = utilities.Encrypt(BankTransactionNo);
imageName = utilities.Encrypt(imageName);
id = db.InserteWalletDepositForm(Enumber, Formtype, paymentdate, amountpaid, trnum, bankname, OnlineBankAccountName, BankTransactionNo, imageName);
ms.Close();
fs.Close();
fs.Dispose();
}
catch (Exception e) {
}
return(id);
}
public async Task <PaginatedList <ChefListItemDto> > Handle(SearchForChefsQuery query, CancellationToken ct)
{
var filter = query.Filter;
var dbQuery = context.Users
.Where(u => u.UserProfiles.Any(p => p.IdProfile == (int)Profile.CHEF) &&
DatabaseFunctions.IsNear(u.Id, filter.Latitude, filter.Longitude, distanceConfig.MinDistance));
dbQuery = ApplyFilters(dbQuery, filter);
return(await dbQuery.Select(u => new ChefListItemDto
{
Id = u.Id,
Picture = u.Picture ?? NoDataFallbacks.NO_DATA_IMAGE,
ChefFullName = u.FirstName + " " + u.LastName,
City = u.UserAddresses
.OrderBy(ua => ua.LastTimeUsed)
.FirstOrDefault()
.Address
.City
.Name,
Categories = DatabaseFunctions.UserCategories(u.Id),
})
.ToPaginatedListAsync(filter.PageIndex, filter.ItemsPerPage, ct));
}
private void AddTableRow(Table SkinsTable, int golferID, List <byte> scores, List <int> skins)
{
TableRow tr = new TableRow();
//CheckBox checkBox = new CheckBox();
//checkBox.ID = "Checkbox_" + golferID.ToString();
//checkBox.Checked = true;
//checkBox.Text = DatabaseFunctions.GetGolferName(golferID);
//skinsCheckboxes.Add(golferID, checkBox);
//TableCell cell = new TableCell();
//cell.Controls.Add(checkBox);
//tr.Cells.Add(cell);
AddCell(tr, DatabaseFunctions.GetGolferName(golferID));
for (int i = 0; i < 9; i++)
{
TableCell c = AddCell(tr, scores[i].ToString());
if (skins[i] == golferID)
{
c.BackColor = Color.LightBlue;
}
}
SkinsTable.Rows.Add(tr);
}
public void assessStage()
{
string sql = "SELECT Stage FROM jobindex WHERE IDKey='" + customer + "'";
TaskCallback call = populateAssessment;
DatabaseFunctions.SendToPhp(false, sql, call);
}
private void DisplayHandicappedSkins()
{
int selectedEventID = int.Parse(Dropdown_LeagueEvent.SelectedValue);
if (selectedEventID != 0)
{
Dictionary <int, List <byte> > scores = DatabaseFunctions.GetScores(selectedEventID);
Dictionary <int, int> handicaps = Scoring.GetPlayerHandicapsForEvent(leagueID, selectedEventID, scores.Keys.ToList());
Table_SkinsResults.Width = 800;
Table_SkinsResults.Rows.Clear();
var courseInfo = DatabaseFunctions.GetCourseInfo(selectedEventID);
AddCourseInfoRowsSkinsTable(Table_SkinsResults, courseInfo);
Scoring.ApplyHandicapsToScoresForHandicappedSkins(scores, handicaps, courseInfo);
List <int> skins = Scoring.calculateSkins(scores);
//reset skins dropdown
DropdownList_SkinsPlayers.Items.Clear();
ListItem initialItem = new ListItem("Select Golfers(s) to Exclude From Skins", "0");
DropdownList_SkinsPlayers.Items.Add(initialItem);
foreach (int GolferID in scores.Keys)
{
ListItem item = new ListItem(DatabaseFunctions.GetGolferName(GolferID), GolferID.ToString());
DropdownList_SkinsPlayers.Items.Add(item);
AddTableRow(Table_SkinsResults, GolferID, scores[GolferID], skins);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
leagueID = (int)((SiteMaster)this.Master).LeagueID;
if (!Page.IsPostBack)
{
int currentSeasonID = DatabaseFunctions.GetCurrentSeasonID(leagueID.ToString());
AddEventsToDropdown(currentSeasonID);
List <Season> seasons = DatabaseFunctions.GetSeasons(leagueID);
int i = 0;
foreach (Season season in seasons)
{
ListItem newItem = new ListItem(season.SeasonName, season.SeasonID.ToString());
Dropdown_Seasons.Items.Add(newItem);
if (season.isCurrentSeason)
{
Dropdown_Seasons.SelectedIndex = i;
}
i++;
}
//populate views dropdown
ListItem initialItem = new ListItem("Select View to Continue", "0");
DropDown_View.Items.Add(initialItem);
DropDown_View.Items.Add(SKINS_VIEW);
DropDown_View.Items.Add(SKINS_VIEW_HANDICAPPED);
DropDown_View.Items.Add(WEEKLY_LEADERBOARD_VIEW);
DropDown_View.Items.Add(WEEKLY_RESULTS_VIEW);
ViewState["PlayersToExcludeFromSkins"] = new List <int>();
ListItem initialItem2 = new ListItem("Select Golfers(s) to Exclude From Skins", "0");
DropdownList_SkinsPlayers.Items.Add(initialItem2);
}
}
public void getFavoriteGroups()
{
string statement = "SELECT IDKey,GroupName AS Name, '2' AS g FROM groupmembers WHERE MemberID='" + ClientData.AgentIDK + "';";
TaskCallback call = new TaskCallback(this.populatePicker);
DatabaseFunctions.SendToPhp(false, statement, call);
}
public async Task <string> DiagnosticDataSpecific(string pcId)
{
await DatabaseFunctions.InitializeStaticStorage(_db).ConfigureAwait(false);
try {
var lastMinutes = _db.LastMinutes;
var listOfLastMinute = await lastMinutes.Where(lm => lm.PcId.Equals(pcId)).ToListAsync <LastMinute>();
if (listOfLastMinute.Count == 0)
{
return("false");
}
listOfLastMinute.Sort((LastMinute lm1, LastMinute lm2) =>
{
if (lm1.TimeChanged == null)
{
return(0);
}
return(lm2.TimeChanged != null ? ((DateTime)lm1.TimeChanged).CompareTo((DateTime)lm2.TimeChanged) : 0);
});
for (var i = 1; i <= 60; i++)
{
listOfLastMinute[i - 1].Second = i;
}
return(JsonSerializer.Serialize(listOfLastMinute));
}
catch (Exception e)
{
return("false");
}
}
public string getEwalletNumber(string userid, string portal)
{
DatabaseFunctions db = new DatabaseFunctions();
return(db.getEwalletNumber(userid, portal));
}
protected void RemoveButtonClick(object sender, CommandEventArgs e)
{
Button b = (Button)sender;
string matchupIDToRemove = b.ID;
int team1ID, team2ID;
MatchupIDtoTeamIDs(matchupIDToRemove, out team1ID, out team2ID);
List <Control> controlsToRemove = new List <Control>();
foreach (Control control in Panel_Matchups.Controls)
{
if (control.ID.Contains(matchupIDToRemove))
{
controlsToRemove.Add(control);
}
}
foreach (Control control in controlsToRemove)
{
Panel_Matchups.Controls.Remove(control);
}
int currentSeasonID = DatabaseFunctions.GetCurrentSeasonID(leagueID.ToString());
Dictionary <int, string> teams = DatabaseFunctions.GetTeamNames(leagueID);
AddTeamToDropdowns(team1ID, teams);
AddTeamToDropdowns(team2ID, teams);
SelectedMatchups.Remove(team1ID);
ViewState["MatchupControls"] = SelectedMatchups;
}
protected void Page_Load(object sender, EventArgs e)
{
string pagename = Path.GetFileName(Request.PhysicalPath);
string UserID = string.Empty;
bool loggedStatus = false;
if(System.Web.HttpContext.Current.User != null)
{
loggedStatus = System.Web.HttpContext.Current.User.Identity.IsAuthenticated;
if(loggedStatus)
{
UserID = Membership.GetUser().ProviderUserKey.ToString();
DatabaseFunctions d = new DatabaseFunctions();
int uid = d.GetCandidateID(UserID);
DBFunctions db = new DBFunctions();
var timetable = db.gettimetable(uid);
foreach (var t in timetable)
{
timetabletbl.Text += "<tr ><td>" + t.Courses_tbl.Course + "</td><td>" + t.Day + "</td><td>" + t.Teacher + "</td><td>" + t.StartTime + "</td><td>" + t.EndTime + "</td></tr>";
}
}
}
else
{
Response.Redirect("Login.aspx?Redirecturl=" + pagename); Response.Redirect("Login.aspx?Redirecturl=" + pagename);
}
}
protected void Page_Load(object sender, EventArgs e)
{
string pagename = Path.GetFileName(Request.PhysicalPath);
string UserID = string.Empty;
bool loggedStatus = false;
if (System.Web.HttpContext.Current.User != null)
{
loggedStatus = System.Web.HttpContext.Current.User.Identity.IsAuthenticated;
if (loggedStatus)
{
UserID = Membership.GetUser().ProviderUserKey.ToString();
DatabaseFunctions d = new DatabaseFunctions();
int uid = d.GetCandidateID(UserID);
DBFunctions db = new DBFunctions();
var timetable = db.gettimetable(uid);
foreach (var t in timetable)
{
timetabletbl.Text += "<tr ><td>" + t.Courses_tbl.Course + "</td><td>" + t.Day + "</td><td>" + t.Teacher + "</td><td>" + t.StartTime + "</td><td>" + t.EndTime + "</td></tr>";
}
}
}
else
{
Response.Redirect("Login.aspx?Redirecturl=" + pagename); Response.Redirect("Login.aspx?Redirecturl=" + pagename);
}
}
public void onClick(object sender, RoutedEventArgs e)
{
DateTime d = (DateTime)DayPicker.SelectedDate;
string sql = "SELECT * FROM punchclock WHERE AgentID='" + agents[Agent.SelectedIndex] + "' AND (" + FormatFunctions.getRelevantDates(d, "TimeStamp") + ")";
if ((bool)AppCheck.IsChecked)
{
sql += " AND Approved='1'";
}
if ((bool)!LocCheck.IsChecked)
{
sql += " AND (State='True' OR State='False')";
}
sql += " ORDER BY IDKey ASC";
TaskCallback call = populateStamps;
DatabaseFunctions.SendToPhp(false, sql, call);
if ((bool)tarCheck.IsChecked)
{
string sql4 = "SELECT * FROM agentrecords WHERE AgentID='" + agents[Agent.SelectedIndex] + "' AND (" + FormatFunctions.getRelevantDates(d, "Date") + ") ORDER BY IDKey DESC";
TaskCallback call3 = populateTardiness;
DatabaseFunctions.SendToPhp(false, sql4, call3);
}
}
private void populateEventDetailsInModal(int EventID)
{
//int currentSeasonID = DatabaseFunctions.GetCurrentSeasonID(leagueID.ToString());
List <EventInfo> events = DatabaseFunctions.GetEvents(leagueID, currentSeasonID);
EventInfo eventInfo = events.Where(x => x.EventID == EventID).ToList().First();
Dictionary <int, int> matchups = DatabaseFunctions.GetMatchups(eventInfo.EventID);
Dictionary <int, Team> teams = DatabaseFunctions.GetTeams(leagueID);
foreach (int team1ID in matchups.Keys)
{
AddMatchup(team1ID, matchups[team1ID], teams[team1ID].TeamName, teams[matchups[team1ID]].TeamName);
teams.Remove(team1ID);
teams.Remove(matchups[team1ID]);
}
if (!eventInfo.HasScores)
{
foreach (Team team in teams.Values)
{
if (!team.hidden)
{
AddToRemainingTeams(team.TeamID, team.TeamName);
}
}
}
TextBox_EventName.Text = eventInfo.EventName;
datepicker.Text = eventInfo.Date;
Dropdown_Course.SelectedValue = eventInfo.CourseID.ToString();
}
internal static void OnC2SAskCreateCharacter(ByteBuffer buffer, Connection connection)
{
var incPacket = new CharacterPackets.C2SAskCreateCharacter(buffer, connection);
var client = ClientManager.GetClient(connection);
if (!DatabaseFunctions.CreateCharacter(
client.UserId, incPacket.CharName,
(byte)incPacket.ClassCode,
(byte)incPacket.HeightCode,
(byte)incPacket.FaceCode,
(byte)incPacket.HairCode,
out var character))
{
return;
}
if (!DatabaseFunctions.AddCharacterToDB(character, out var charID))
{
return;
}
character.Id = charID;
var charInfoForPacket = new PacketStructs.CharacterInfo(character);
var outPacket = new CharacterPackets.S2CAnsCreateCharacter(charInfoForPacket.ToBytes(), connection);
outPacket.Send(connection);
}
protected void Requestbtn_Click(object sender, EventArgs e)
{
DBFunctions db = new DBFunctions();
DatabaseFunctions d = new DatabaseFunctions();
LibraryMember member = new LibraryMember { UserID = stid, Status = 0,JoinDate=DateTime.Now.Date };
db.requestlibrarymembership(member);
}
public string inserteWalletTranscation(string ewalletnumber, string description, string Amount, string tType, string transcationnum
, string Portal)
{
DatabaseFunctions db = new DatabaseFunctions();
db.inserteWalletTranscationrow(ewalletnumber, description, Amount, tType, transcationnum, Portal);
return "Done";
}
protected void submitcommentbtn_Click(object sender, EventArgs e)
{
DBFunctions db = new DBFunctions();
DatabaseFunctions d = new DatabaseFunctions();
Discussions_tbl dis = new Discussions_tbl { userID = d.GetCandidateID(UserID), Discission = commenttxt.InnerText, TopicID = int.Parse(Request.QueryString["topicid"].ToString()), Date = DateTime.Now };
dis= db.adddiscussion(dis);
//discusion.Text += "<div class='comment-name'><img src='images//" + Session["Image"] + "' height='50px' width='50px'> <span class='h4 '>" + Session["Name"] + "</span></div><br>";
//discusion.Text += "<p class='blockquote comment'> " + dis.Discission + "</p><br>";
//discusion.Text += "<p class='caption'>" + dis.Date + "</p><br><hr>";
loaddiscussions(dis.TopicID.Value);
}
public int AddEwallet(string userid,string Enumber, string pin, string Name, string address, string portal)
{
DatabaseFunctions db = new DatabaseFunctions();
Enumber = utilities.Encrypt(Enumber);
pin = utilities.Encrypt(pin);
Name = utilities.Encrypt(Name);
address = utilities.Encrypt(address);
portal = utilities.Encrypt(portal);
int flag = db.createeWalletAccount(userid, Enumber, pin, Name, address, portal);
return flag;
}
protected void btnlogin_Click(object sender, EventArgs e)
{
string returnuurl = "";
if (Request.QueryString["Redirecturl"] != null)
{
returnuurl = Request.QueryString["Redirecturl"];
Message.Visible = true;
Message.Text = "Please Login First";
}
else
{
DBFunctions db = new DBFunctions();
Candidate_tbl candidate = db.LoginChek(username.Text, password.Text);
if (Membership.ValidateUser(username.Text, password.Text))
{
FormsAuthentication.SetAuthCookie(username.Text, true);
string UserID = "";
bool LoggedStatus = (System.Web.HttpContext.Current.User != null) && System.Web.HttpContext.Current.User.Identity.IsAuthenticated;
MembershipUser mu = Membership.GetUser(username.Text);
UserID = mu.ProviderUserKey.ToString();
DatabaseFunctions d = new DatabaseFunctions();
int uid = d.GetCandidateID(UserID);
Session["username"] = username.Text;
Session["userid"] = uid;
Session["Name"] = candidate.Name;
Session["Image"] = candidate.Image;
Session["Role"] = "Student";
Session["email"] = candidate.Email;
Session["candidate"] = candidate;
if (returnuurl == "")
{
Response.Redirect("ProfilePage.aspx");
}
else
{
Response.Redirect(returnuurl);
}
}
else
{
Message.Text = "Wrong Username or Password";
Message.Visible = true;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
bool loggedStatus = false;
if (System.Web.HttpContext.Current.User != null)
{
DatabaseFunctions d = new DatabaseFunctions();
loggedStatus = System.Web.HttpContext.Current.User.Identity.IsAuthenticated;
if (loggedStatus)
{
UserID = Membership.GetUser().ProviderUserKey.ToString();
stid = d.GetCandidateID(UserID);
if (stid != -1)
{
DBFunctions db = new DBFunctions();
backlink.Text = "<a href='#0' class='btn btn-primary' onclick='history.back()'>Back</a>";
var chk = db.getLirarymember(stid);
if (chk == null)
{
var stdent = db.getstdentinfo(stid);
nametxt.Text = stdent.Candidate_tbl.Name;
metricno.Text = stdent.Candidate_tbl.AddmissionList_tbl.FirstOrDefault().MetricNo;
programme.Text = stdent.Program_tbl.ProgramName;
}
else
{
membershipform.Visible = false;
membermsg.Visible = true;
if (chk.Status == 0)
{
membermsg.InnerText = "Your Request For Library Membership is Pending..!!";
}
else if (chk.Status == 1)
{
membermsg.InnerText = "You Already Have The Library Membership!!";
}
}
}
else
{
}
}
}
}
public static string depositFormUpdate(string trnum, string userID, int pageIndex)
{
DatabaseFunctions db = new DatabaseFunctions();
int actualAmount = db.getDepositFormAmount(trnum);
db.Update_eWallet_Status_Balance(trnum, userID, actualAmount);
string query = "[GeteWalletPaymentdeposit_application]";
SqlCommand cmd = new SqlCommand(query);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@PageIndex", pageIndex);
cmd.Parameters.AddWithValue("@PageSize", PageSize);
cmd.Parameters.Add("@RecordCount", SqlDbType.Int, 4).Direction = ParameterDirection.Output;
return GetData(cmd, pageIndex).GetXml();
}
protected void LoginBtn_Click(object sender, EventArgs e)
{
string enumber = utilities.Encrypt(InputEnumber.Text);
string pin = utilities.Encrypt(InputPin.Text);
string name = utilities.Encrypt(InputName.Text);
string address = utilities.Encrypt(InputAddress.Text);
string portal = utilities.Encrypt(InputPortal.Text);
DatabaseFunctions db = new DatabaseFunctions();
//db.createeWalletAccount(,enumber, pin, name, address, portal);
//string encpPin = utilities.Base64Encode(pin);
// Response.Write("<script>alert('"+encpPin+"')</script>");
// Response.Write("<script>alert('" + utilities.Base64Decode(encpPin) + "')</script>");
}
public void getcoursesfee()
{
DatabaseFunctions d = new DatabaseFunctions();
int sid= d.GetCandidateID(UserID);
DBFunctions db = new DBFunctions();
var coursefeelist= db.getstudentcoursefee(sid);
foreach(var cf in coursefeelist)
{
if(cf.Status==0)
coursefeetbl.Text += "<tr><td>"+cf.Courses_tbl.Course+"</td><td>"+cf.Courses_tbl.Marks+"</td><td>"+cf.Courses_tbl.Fee+"</td><td><a href=#0 class='btn btn-danger'>Unpaid</a></td><td><a hred='#0' class='btn btn-primary'>Pay</a></td></tr>";
else if(cf.Status==1)
{
coursefeetbl.Text += "<tr><td>" + cf.Courses_tbl.Course + "</td><td>" + cf.Courses_tbl.Marks + "</td><td>" + cf.Courses_tbl.Fee + "</td><td><a href=#0 class='btn btn-info'>paid</a></td></tr>";
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
string Userid = string.Empty;
bool loggedStatus = false;
if (Session["admin"] == null)
{
if (System.Web.HttpContext.Current.User != null)
{
DatabaseFunctions db = new DatabaseFunctions();
loggedStatus = System.Web.HttpContext.Current.User.Identity.IsAuthenticated;
if (loggedStatus)
{
Userid = Membership.GetUser().ProviderUserKey.ToString();
// loadprogrammes();
if (!IsPostBack)
{
int uid = db.GetCandidateID(Userid);
int status = db.GetAdmissionStatus(uid);
int CheckRegno = -1;
string FormNumber = "";
FormNumber = db.getFormumber();
if (FormNumber != "")
{
CheckRegno = db.CheckAdmission(FormNumber);
if (CheckRegno == -1 || CheckRegno == 0)
{
isSTudent = false;
}
else if (CheckRegno > 0)
{
isSTudent = true;
}
}
}
}
else
{
Response.Redirect("Login.aspx");
}
}
}
}
protected void btnRegister_Click(object sender, EventArgs e)
{
MembershipCreateStatus createStatus;
string message = string.Empty;
Candidate_tbl candidate = new Candidate_tbl { Name = Nametxt.Text, Username = Usernametxt.Text, Email = Emailtxt.Text, Password = Passwordtxt.Text, Phone = Phonetxt.Text, Status = 0, AdmissionYear = DateTime.Now.Year.ToString() };
MembershipUser newUser = System.Web.Security.Membership.CreateUser(Usernametxt.Text, Passwordtxt.Text, Emailtxt.Text, null, null, true, out createStatus);
switch (createStatus)
{
case MembershipCreateStatus.Success: message = "The user account was successfully created!";
FormsAuthentication.SetAuthCookie(Usernametxt.Text, true);
DatabaseFunctions db = new DatabaseFunctions();
DBFunctions d = new DBFunctions();
int i=db.insertUserOtherInfo(Usernametxt.Text, Phonetxt.Text, newUser.ProviderUserKey.ToString(),0);
int CandidateID=d.AddCandidate(candidate);
if(i!=-1)
{
db.InsertMappindIDs(newUser.ProviderUserKey.ToString(),CandidateID);
Response.Redirect("ProfilePage.aspx");
}
break;
case MembershipCreateStatus.DuplicateUserName: message = "There already exists a user with this username.";
break;
case MembershipCreateStatus.DuplicateEmail: message = "There already exists a user with this email address.";
break;
case MembershipCreateStatus.InvalidEmail: message = "There email address you provided in invalid.";
break;
case MembershipCreateStatus.InvalidAnswer: message = "There security answer was invalid.";
break;
case MembershipCreateStatus.InvalidPassword: message = "The password you provided is invalid. It must be atleast 4 characters long.";
break;
default: message = "There was an unknown error; the user account was NOT created.";
break;
}
RegistrationLabel.Visible = true;
RegistrationLabel.Text = message;
}
protected void Page_Load(object sender, EventArgs e)
{
string pagname = Path.GetFileName(Request.PhysicalPath);
if (System.Web.HttpContext.Current.User != null)
{
bool LoggedStatus = false;
LoggedStatus = System.Web.HttpContext.Current.User.Identity.IsAuthenticated;
if (LoggedStatus)
{
UserID = Membership.GetUser().ProviderUserKey.ToString();
DatabaseFunctions db = new DatabaseFunctions();
StudentID = db.GetCandidateID(UserID);
loadmails();
}
}
else
{
Response.Redirect("Login.aspx?Redirecturl=" + pagname);
}
}
public static string getinboxcount()
{
DBFunctions db = new DBFunctions();
if(System.Web.HttpContext.Current.User != null){
DatabaseFunctions d = new DatabaseFunctions();
int check = d.GetCandidateID( Membership.GetUser().ProviderUserKey.ToString());
if (check != -1)
{
return db.getstudentinboxcount(check).ToString();
}
else
{
return "";
}
}
else
{
return "0";
}
}
protected void Page_Load(object sender, EventArgs e)
{
string pagename = Path.GetFileName(Request.PhysicalPath);
bool loggedStatus = false;
if (System.Web.HttpContext.Current.User != null)
{
DatabaseFunctions db = new DatabaseFunctions();
loggedStatus = System.Web.HttpContext.Current.User.Identity.IsAuthenticated;
if (loggedStatus)
{
Userid = Membership.GetUser().ProviderUserKey.ToString();
// loadprogrammes();
}
else
{
Response.Redirect("Login.aspx");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
string pagename = Path.GetFileName(Request.PhysicalPath);
bool loggedStatus = false;
if (System.Web.HttpContext.Current.User != null)
{
if (!IsPostBack)
{
loggedStatus = System.Web.HttpContext.Current.User.Identity.IsAuthenticated;
if (loggedStatus)
{
DBFunctions db = new DBFunctions();
DatabaseFunctions d = new DatabaseFunctions();
Userid = Membership.GetUser().ProviderUserKey.ToString();
uid = d.GetCandidateID(Userid);
// loadprogrammes();
StudentInfo_tbl temp = db.getstdentinfo(uid);
StudentSelectedCredit obj = db.getStudentCredits(uid).FirstOrDefault();
if (obj != null)
{
Credits = Convert.ToInt16(obj.SelectedCourseCount);
}
getcourses();
}
else
{
Response.Redirect("Login.aspx?Redirecturl=" + pagename);
}
}
}
// dropdownCourse.DataSource=
}
protected void FileUploadComplete(object sender, AjaxControlToolkit.AsyncFileUploadEventArgs e)
{
if (AsyncFileUpload1.HasFile)
{
var fileName = AsyncFileUpload1.FileName;
var fileExtension = fileName.Substring(fileName.LastIndexOf('.') + 1);
if (fileExtension.ToLower().Contains("jpg") || fileExtension.ToLower().Contains("png"))
{
if (AsyncFileUpload1.FileContent.Length < 2000000)
{
String savePath = MapPath("profilepics/" + AsyncFileUpload1.FileName);
DatabaseFunctions db = new DatabaseFunctions();
string formnum = db.getFormumber();
string origPath = MapPath("profilepics/" + formnum + ".jpg");
AsyncFileUpload1.SaveAs(origPath);
// File.AppendAllText("C:/lg.txt", "\r\n"+savePath);
AsyncFileUpload1.SaveAs(savePath);
var image = new Bitmap(MapPath("profilepics/" + formnum + ".jpg"));
if (image.Height > 200 || image.Width > 200)
{
Console.Write("IMAGE DIMENSION LARGE PROCESSING IMAGE");
var image2 = ResizeImage(image, 200, 200);
image.Dispose();
image = null;
File.Delete(origPath);
image2.Save(origPath);
image2.Dispose();
image2 = null;
}
else
{
//Console.Write("IMAGE DIMENSION SMALL SKIPPING IMAGE");
image.Dispose();
image = null;
}
// AsyncFileUpload1.SaveAs(MapPath("C:/AdmissionPortal/profilepics/" + AsyncFileUpload1.FileName));
// literealErrorImage.Text = "";
UploadFolderPath = "profilepics/";
ViewState["imageDisplay_str"] = formnum + "." + fileExtension;
}
else
{
ClearContents(sender as Control);
// literealErrorImage.Text = " <span class=\"btn btn-danger\">Image file size should be less than 2 MB </span>";
}
}
}
}
public void getstates()
{
DatabaseFunctions db = new DatabaseFunctions();
DataSet dt = db.getStates();
if (dt.Tables[0].Rows.Count > 0)
{
dropdownSto.DataSource = dt.Tables[0];
dropdownSto.DataBind();
}
}
public void loadbirthDay_Dropdowns()
{
getstates();
for (int i = 1; i < 32; i++)
{
dropdownDay.Items.Insert((i - 1), new ListItem(i.ToString(), i.ToString()));
}
int j = 0;
for (int i = 1900; i < 2015; i++)
{
dropdownyears.Items.Insert(j, new ListItem(i.ToString(), i.ToString()));
j++;
}
int c = DateTime.Now.Year;
int c2 = c - 45;
j = 1;
for (int i = c; i >= c2; i--)
{
dropdownExamYear.Items.Insert(j, new ListItem(i.ToString(), i.ToString()));
dropdownListexamyear2.Items.Insert(j, new ListItem(i.ToString(), i.ToString()));
j++;
}
c2 = c - 35;
j = 1;
for (int i = c; i >= c2; i--)
{
dropdownJambExamYear_Previous.Items.Insert(j, new ListItem(i.ToString(), i.ToString()));
dropdownyearCompleted_Previous.Items.Insert(j, new ListItem(i.ToString(), i.ToString()));
dropdownIndustrialTrainingEndYear.Items.Insert(j, new ListItem(i.ToString(), i.ToString()));
dropdownIndustrialTrainingYearStart2.Items.Insert(j, new ListItem(i.ToString(), i.ToString()));
j++;
}
//j=1;
//for (int x = c; x < c + 20; x++)
//{
// dropdownIndustrialTrainingEndYear.Items.Insert(j, new ListItem(x.ToString(), x.ToString()));
// dropdownIndustrialTrainingYearStart2.Items.Insert(j, new ListItem(x.ToString(), x.ToString()));
// j++;
//}
//dropdownJambExamYear_Previous
DatabaseFunctions db = new DatabaseFunctions();
DataSet ds = new DataSet();
ds = db.getdates_CBT(Convert.ToInt32(ViewState["programID"]));
if (ds.Tables[0].Rows.Count > 0)
{
dropdownScheduleDate.DataSource = ds.Tables[0];
dropdownScheduleDate.DataBind();
}
else
{
dropdownScheduleDate.Items.Clear();
dropdownScheduleDate.Items.Insert(0, new ListItem("Select Date", ""));
dropdownScheduleDate.DataBind();
}
}
protected void FileUploadComplete_Old(object sender, AjaxControlToolkit.AsyncFileUploadEventArgs e)
{
if (AsyncFileUpload1.HasFile)
{
var fileName = AsyncFileUpload1.FileName;
var fileExtension = fileName.Substring(fileName.LastIndexOf('.') + 1);
if (fileExtension.ToLower().Contains("jpg") || fileExtension.ToLower().Contains("png"))
{
if (AsyncFileUpload1.FileContent.Length < 2000000)
{
String savePath = MapPath("profilepics/" + AsyncFileUpload1.FileName);
DatabaseFunctions db = new DatabaseFunctions();
string formnum = db.getFormumber();
AsyncFileUpload1.SaveAs(MapPath("profilepics/" + formnum + ".jpg"));
// File.AppendAllText("C:/lg.txt", "\r\n"+savePath);
AsyncFileUpload1.SaveAs(savePath);
// AsyncFileUpload1.SaveAs(MapPath("C:/AdmissionPortal/profilepics/" + AsyncFileUpload1.FileName));
// literealErrorImage.Text = "";
UploadFolderPath = "profilepics/";
ViewState["imageDisplay_str"] = formnum + "." + fileExtension;
}
else
{
ClearContents(sender as Control);
// literealErrorImage.Text = " <span class=\"btn btn-danger\">Image file size should be less than 2 MB </span>";
}
}
}
}
public void saveFunction_SaveAll()
{
DatabaseFunctions db = new DatabaseFunctions();
string userId = Membership.GetUser().ProviderUserKey.ToString();
try
{
//if (tabName == "HasJambData")
{
string fullName = db.getStudent_CompleteName(userId);
db.InsertJambData(ViewState["formnum"].ToString(), txtJambRegNo.Text, dropdownSubject1.SelectedItem.Value, txtScore1.Text, dropdownSubject2.SelectedItem.Value, txtscore2.Text,
dropdownSubject3.SelectedItem.Value, txtscore3.Text, dropdownSubject4.SelectedItem.Value, txtscore4.Text, dropdownJambchoice.SelectedItem.Value, userId);
}
// else if (tabName == "HasBioDataSection")
{
string dob = dropdownyears.SelectedItem.Value + "-" + dropdownMonth.SelectedItem.Value + "-" + dropdownDay.SelectedItem.Value;
string img = string.Empty;
if (hidden_dpImage.Value != "")
{
img = ViewState["formnum"].ToString() + ".jpg";
}
db.InsertBioData(ViewState["formnum"].ToString(), txtSurname.Text, txtFirstName.Text, txtOtherName.Text, dropdownGender.SelectedItem.Value, txtHomeaddress.Text, txtPhonenumber.Value, txtEmail.Text, dropdownSto.SelectedItem.Value, dropdownLocalGovtarea.SelectedItem.Value, userId, img, dob);
}
// else if (tabName == "HasOlevelResult")
{
db.InsertOlevelInfo_FirstSitting(ViewState["formnum"].ToString(), userId, dropdownExam.SelectedItem.Value, dropdownExamMonth.SelectedItem.Value, txtExamNum.Text, dropdownExamYear.SelectedItem.Value,
dropdownOlevelSub1.SelectedItem.Value, dropdownolevelGrade1.SelectedItem.Value, dropdownOlevelSub2.SelectedItem.Value, dropdownGrade2.SelectedItem.Value,
dropdownolevelSub3.SelectedItem.Value, dropdownGrade3.SelectedItem.Value, dropdownOlvlSub4.SelectedItem.Value, dropdownGrade4.SelectedItem.Value, dropdownOlevelsub5.SelectedItem.Value, dropdownGrade5.SelectedItem.Value,
dropdownOlevelSub6.SelectedItem.Value, dropdownGrade6.SelectedItem.Value, dropdownOlevelSub7.SelectedItem.Value, dropdonGrade7.SelectedItem.Value, dropdownolevelSub8.SelectedItem.Value, dropdownGrade8.SelectedItem.Value,
dropdowOlevelSub9.SelectedItem.Value, dropdownGrade9.SelectedItem.Value);
db.InsertOlevelInfo_SecondSitting(ViewState["formnum"].ToString(), userId, dropdownExamType2.SelectedItem.Value, dropdownExamMonth2.SelectedItem.Value, txtExamNum2.Text, dropdownListexamyear2.SelectedItem.Value,
dropdownOlevelsubject1b.SelectedItem.Value, dropdownListGrade2.SelectedItem.Value, dropdownOlevelSub2b.SelectedItem.Value, dropdownGrade2b.SelectedItem.Value,
dropdownolevelSub3b.SelectedItem.Value, dropdownGrade3b.SelectedItem.Value, dropdownOlvlSub4b.SelectedItem.Value, dropdownGrade4b.SelectedItem.Value, dropdownOlevelsub5b.SelectedItem.Value, dropdownGrade5b.SelectedItem.Value,
dropdownOlevelSub6b.SelectedItem.Value, dropdownGrade6b.SelectedItem.Value, dropdownOlevelSub7b.SelectedItem.Value, dropdonGrade7b.SelectedItem.Value, dropdownolevelSub8b.SelectedItem.Value, dropdownGrade8b.SelectedItem.Value,
dropdowOlevelSub9b.SelectedItem.Value, dropdownGrade9b.SelectedItem.Value);
}
// else if (tabName == "HasPreviousRecord")
{
string indstart = dropdownIndustrialtrainingStart.SelectedItem.Value + "-" + dropdownIndustrialTrainingEndYear.SelectedItem.Value;
string indEnd = dropdownIndustrialStarmonth2.SelectedItem.Value + "-" + dropdownIndustrialTrainingYearStart2.SelectedItem.Value;
db.InsertPreviousRecord(ViewState["formnum"].ToString(), userId, txtjaRegno_previous.Text, dropdownJambExamYear_Previous.SelectedItem.Value, txtJambFullName_previous.Text,
dropdwnJamIns_Previous.SelectedItem.Value, txtJambCourseName_previous.Text, dropdownCourseType_Previous.SelectedItem.Value, dropdownCourseGrade_Prvious.SelectedItem.Value,
dropdownyearCompleted_Previous.SelectedItem.Value, indstart, indEnd, txtNdMetricNum.Text);
}
//else if (tabName == "HasCBTSchedule")
{
DataSet ds = db.getSingleTimes_CBT(dropdownScheduleDate.SelectedItem.Value, Convert.ToInt32(ViewState["programID"]), dropdownTime.SelectedItem.Text.ToString());
if (ds.Tables[0].Rows.Count > 0)
{
//GET INGO ...
int ID = Convert.ToInt32(ds.Tables[0].Rows[0]["ID"].ToString());
int Usedcapacity = Convert.ToInt16(ds.Tables[0].Rows[0]["Used"].ToString());
Usedcapacity = Usedcapacity + 1;
int insertFlag = db.InsertCbtScheduleIngo(ViewState["formnum"].ToString(), userId, dropdownScheduleDate.SelectedItem.Value, dropdownTime.SelectedItem.Text, ViewState["formnum"].ToString(), lblCbtPassword.Text);
if (insertFlag > 0)
{
//UPDATE PROGRAM USED CAPACITY
db.updateCBTSCheduler(ID, Usedcapacity);
}
}
}
// if (tmp == 1)
{
//ScriptManager.RegisterStartupScript(this.Page, GetType(), "ClosePopup", "alert('Form section saved Successfully !');", true);
}
}
catch (Exception ex)
{
}
}
public void loadDates_CBT()
{
DatabaseFunctions db = new DatabaseFunctions();
DataSet ds = new DataSet();
ds = db.getdates_CBT(Convert.ToInt32(ViewState["programID"]));
if (ds.Tables[0].Rows.Count > 0)
{
dropdownScheduleDate.DataSource = ds.Tables[0];
dropdownScheduleDate.DataBind();
}
else
{
dropdownScheduleDate.Items.Clear();
dropdownScheduleDate.Items.Insert(0, new ListItem("Select Date", ""));
dropdownScheduleDate.DataBind();
}
}
public void loadInstitutions()
{
DatabaseFunctions db = new DatabaseFunctions();
DataSet dt = db.getInstitutions();
if (dt.Tables[0].Rows.Count > 0)
{
dropdwnJamIns_Previous.DataSource = dt.Tables[0];
dropdwnJamIns_Previous.DataBind();
}
}
public void loadTabsInfo(string colName)
{
DataSet ds = new DataSet();
DatabaseFunctions db = new DatabaseFunctions();
string userID = Membership.GetUser().ProviderUserKey.ToString();
if (colName == "HasJambData")
{
ds = db.loadJamDataByUserID(userID);
if (ds.Tables[0].Rows.Count > 0)
{
txtJambRegNo.Text = ds.Tables[0].Rows[0]["JambRegNo"].ToString();
dropdownSubject1.SelectedValue = ds.Tables[0].Rows[0]["Subject1"].ToString();
txtScore1.Text = ds.Tables[0].Rows[0]["Score1"].ToString();
dropdownSubject2.SelectedValue = ds.Tables[0].Rows[0]["Subject2"].ToString();
txtscore2.Text = ds.Tables[0].Rows[0]["Score2"].ToString();
dropdownSubject3.SelectedValue = ds.Tables[0].Rows[0]["Subject3"].ToString();
txtscore3.Text = ds.Tables[0].Rows[0]["Score3"].ToString();
dropdownSubject4.SelectedValue = ds.Tables[0].Rows[0]["Subject4"].ToString();
txtscore4.Text = ds.Tables[0].Rows[0]["Score4"].ToString();
dropdownJambchoice.SelectedValue = ds.Tables[0].Rows[0]["ChoiceOfPolytechnic"].ToString();
if (txtScore1.Text != "" && txtscore2.Text != "" && txtscore3.Text != "" && txtscore4.Text != "")
{
int sum = Convert.ToInt16(txtScore1.Text) + Convert.ToInt16(txtscore2.Text) + Convert.ToInt16(txtscore3.Text) + Convert.ToInt16(txtscore4.Text);
txtJambUtmeScore.Value = sum.ToString();
}
}
}
else if (colName == "HasBioDataSection")
{
ds = db.loadBiodataUserID(userID);
if (ds.Tables[0].Rows.Count > 0)
{
string picture = ds.Tables[0].Rows[0]["ProfilePic"].ToString();
if (picture != "")
{
hidden_dpImage.Value = picture;
imgDisplay.Src = "profilepics/" + picture;
imgDisplay.Style.Add("display", "inline");
}
txtSurname.Text = ds.Tables[0].Rows[0]["Surname"].ToString();
txtFirstName.Text = ds.Tables[0].Rows[0]["Firstname"].ToString();
txtOtherName.Text = ds.Tables[0].Rows[0]["Othername"].ToString();
dropdownGender.SelectedValue = ds.Tables[0].Rows[0]["Gender"].ToString();
string dob = ds.Tables[0].Rows[0]["DOB"].ToString();
//SPLIE AND ASSIGN
string[] splitter = dob.Split('-');
if (splitter.Length > 0)
{
dropdownDay.SelectedValue = splitter[2];
dropdownMonth.SelectedValue = splitter[1];
dropdownyears.SelectedValue = splitter[0];
}
txtPhonenumber.Value = ds.Tables[0].Rows[0]["Phonenumber"].ToString();
txtEmail.Text = ds.Tables[0].Rows[0]["Email"].ToString();
txtHomeaddress.Text = ds.Tables[0].Rows[0]["Address"].ToString();
if (dropdownSto.Items.Count == 1)
{
getstates();
}
try
{
dropdownSto.SelectedValue = ds.Tables[0].Rows[0]["state"].ToString();
}
catch (Exception exx)
{ }
DataSet dstate = new DataSet();
dstate = db.getAreas_States(Convert.ToInt16(ds.Tables[0].Rows[0]["state"].ToString()));
if (dstate.Tables[0].Rows.Count > 0)
{
dropdownLocalGovtarea.DataSource = dstate.Tables[0];
dropdownLocalGovtarea.DataTextField = "Area";
dropdownLocalGovtarea.DataValueField = "ID";
dropdownLocalGovtarea.DataBind();
}
dropdownLocalGovtarea.SelectedValue = ds.Tables[0].Rows[0]["LocalGovtArea"].ToString();
}
}
else if (colName == "HasOlevelResult")
{
loadSubjectandGrades();
ds = db.loadOlevelDataUserID_fs1(userID);
if (ds.Tables[0].Rows.Count > 0)
{
dropdownExam.SelectedValue = ds.Tables[0].Rows[0]["Examtype"].ToString();
dropdownExamMonth.SelectedValue = ds.Tables[0].Rows[0]["Exammonth"].ToString();
dropdownExamYear.SelectedValue = ds.Tables[0].Rows[0]["ExamYear"].ToString();
txtExamNum.Text = ds.Tables[0].Rows[0]["Examnumber"].ToString();
dropdownOlevelSub1.SelectedValue = ds.Tables[0].Rows[0]["Subject1"].ToString();
dropdownolevelGrade1.SelectedValue = ds.Tables[0].Rows[0]["Grade1"].ToString();
dropdownOlevelSub2.SelectedValue = ds.Tables[0].Rows[0]["Subject2"].ToString();
dropdownGrade2.SelectedValue = ds.Tables[0].Rows[0]["Grade2"].ToString();
dropdownolevelSub3.SelectedValue = ds.Tables[0].Rows[0]["Subject3"].ToString();
dropdownGrade3.SelectedValue = ds.Tables[0].Rows[0]["Grade3"].ToString();
dropdownOlvlSub4.SelectedValue = ds.Tables[0].Rows[0]["Subject4"].ToString();
dropdownGrade4.SelectedValue = ds.Tables[0].Rows[0]["Grade4"].ToString();
dropdownOlevelsub5.SelectedValue = ds.Tables[0].Rows[0]["Subject5"].ToString();
dropdownGrade5.SelectedValue = ds.Tables[0].Rows[0]["Grade5"].ToString();
dropdownOlevelSub6.SelectedValue = ds.Tables[0].Rows[0]["Subject6"].ToString();
dropdownGrade6.SelectedValue = ds.Tables[0].Rows[0]["Grade6"].ToString();
dropdownOlevelSub7.SelectedValue = ds.Tables[0].Rows[0]["Subject7"].ToString();
dropdonGrade7.SelectedValue = ds.Tables[0].Rows[0]["Grade7"].ToString();
dropdownolevelSub8.SelectedValue = ds.Tables[0].Rows[0]["Subject8"].ToString();
dropdownGrade8.SelectedValue = ds.Tables[0].Rows[0]["Grade8"].ToString();
dropdowOlevelSub9.SelectedValue = ds.Tables[0].Rows[0]["Subject9"].ToString();
dropdownGrade9.SelectedValue = ds.Tables[0].Rows[0]["Grade9"].ToString();
}
ds = new DataSet();
ds = db.loadOlevelDataUserID_fs2(userID);
if (ds.Tables[0].Rows.Count > 0)
{
dropdownExamType2.SelectedValue = ds.Tables[0].Rows[0]["Examtype"].ToString();
dropdownExamMonth2.SelectedValue = ds.Tables[0].Rows[0]["Exammonth"].ToString();
dropdownListexamyear2.SelectedValue = ds.Tables[0].Rows[0]["ExamYear"].ToString();
txtExamNum2.Text = ds.Tables[0].Rows[0]["Examnumber"].ToString();
dropdownOlevelsubject1b.SelectedValue = ds.Tables[0].Rows[0]["Subject1"].ToString();
dropdownListGrade2.SelectedValue = ds.Tables[0].Rows[0]["Grade1"].ToString();
dropdownOlevelSub2b.SelectedValue = ds.Tables[0].Rows[0]["Subject2"].ToString();
dropdownGrade2b.SelectedValue = ds.Tables[0].Rows[0]["Grade2"].ToString();
dropdownolevelSub3b.SelectedValue = ds.Tables[0].Rows[0]["Subject3"].ToString();
dropdownGrade3b.SelectedValue = ds.Tables[0].Rows[0]["Grade3"].ToString();
dropdownOlvlSub4b.SelectedValue = ds.Tables[0].Rows[0]["Subject4"].ToString();
dropdownGrade4b.SelectedValue = ds.Tables[0].Rows[0]["Grade4"].ToString();
dropdownOlevelsub5b.SelectedValue = ds.Tables[0].Rows[0]["Subject5"].ToString();
dropdownGrade5b.SelectedValue = ds.Tables[0].Rows[0]["Grade5"].ToString();
dropdownOlevelSub6b.SelectedValue = ds.Tables[0].Rows[0]["Subject6"].ToString();
dropdownGrade6b.SelectedValue = ds.Tables[0].Rows[0]["Grade6"].ToString();
dropdownOlevelSub7b.SelectedValue = ds.Tables[0].Rows[0]["Subject7"].ToString();
dropdonGrade7b.SelectedValue = ds.Tables[0].Rows[0]["Grade7"].ToString();
dropdownolevelSub8b.SelectedValue = ds.Tables[0].Rows[0]["Subject8"].ToString();
dropdownGrade8b.SelectedValue = ds.Tables[0].Rows[0]["Grade8"].ToString();
dropdowOlevelSub9b.SelectedValue = ds.Tables[0].Rows[0]["Subject9"].ToString();
dropdownGrade9b.SelectedValue = ds.Tables[0].Rows[0]["Grade9"].ToString();
}
}
else if (colName == "HasPreviousRecord")
{
loadInstitutions();
ds = db.loadPreviousAcademicRecordByUserID(userID);
if (ds.Tables[0].Rows.Count > 0)
{
txtNdMetricNum.Text = ds.Tables[0].Rows[0]["ND_Matric_Number"].ToString();
txtjaRegno_previous.Text = ds.Tables[0].Rows[0]["JAMBRegno"].ToString();
dropdownJambExamYear_Previous.SelectedValue = ds.Tables[0].Rows[0]["JambExamyear"].ToString();
txtJambFullName_previous.Text = ds.Tables[0].Rows[0]["JambFullName"].ToString();
dropdwnJamIns_Previous.SelectedValue = ds.Tables[0].Rows[0]["InstitutionAttented"].ToString();
txtJambCourseName_previous.Text = ds.Tables[0].Rows[0]["CourseName"].ToString();
dropdownCourseType_Previous.Text = ds.Tables[0].Rows[0]["CourseType"].ToString();
dropdownCourseGrade_Prvious.Text = ds.Tables[0].Rows[0]["CourseGrade"].ToString();
dropdownyearCompleted_Previous.SelectedValue = ds.Tables[0].Rows[0]["YearCompleted"].ToString();
string insStart = ds.Tables[0].Rows[0]["IndTrainingStart"].ToString();
string[] splitter = insStart.Split('-');
dropdownIndustrialtrainingStart.SelectedValue = splitter[0];
dropdownIndustrialTrainingEndYear.SelectedValue = splitter[1];
string[] splitter2 = ds.Tables[0].Rows[0]["IndTrainingEnd"].ToString().Split('-');
dropdownIndustrialStarmonth2.SelectedValue = splitter2[0];
dropdownIndustrialTrainingYearStart2.SelectedValue = splitter2[1];
}
}
else if (colName == "HasCBTSchedule")
{
loadDates_CBT();
ds = db.loadCbtScheduleUserID(userID);
if (ds.Tables[0].Rows.Count > 0)
{
string dateTxt = ds.Tables[0].Rows[0]["ScheduleDate"].ToString();
dropdownScheduleDate.SelectedItem.Text = dateTxt;
dropdownTime.SelectedItem.Text = ds.Tables[0].Rows[0]["ScheduleTime"].ToString();
//DataSet dm = db.getAllTimes_CBT(dateTxt, Convert.ToInt32(ViewState["programID"]));
//if (dm.Tables[0].Rows.Count > 0)
//{
// dropdownTime.DataSource = dm.Tables[0];
// dropdownTime.DataBind();
//}
string time = ds.Tables[0].Rows[0]["ScheduleTime"].ToString();
//string timeID = ds.Tables[0].Rows[0]["timeID"].ToString();
//dropdownTime.SelectedValue = timeID;
labelScheduleTxt.Text = dateTxt + ", " + time;
labelCbtUser.Text = ds.Tables[0].Rows[0]["CbtUserName"].ToString();
lblCbtPassword.Text = ds.Tables[0].Rows[0]["CbtPassword"].ToString();
dropdownTime.Enabled = false;
RequiredFieldValidator87.Enabled = false;
RequiredFieldValidator76.Enabled = false;
dropdownScheduleDate.Enabled = false;
}
}
}
public void loadSubjectandGrades()
{
DatabaseFunctions db = new DatabaseFunctions();
DataSet ds = new DataSet();
ds = db.getSubjects();
if (ds.Tables[0].Rows.Count > 0)
{
dropdownOlevelSub1.DataSource = ds.Tables[0];
dropdownOlevelSub1.DataBind();
dropdownOlevelSub2.DataSource = ds.Tables[0];
dropdownOlevelSub2.DataBind();
dropdownolevelSub3.DataSource = ds.Tables[0];
dropdownolevelSub3.DataBind();
dropdownOlvlSub4.DataSource = ds.Tables[0];
dropdownOlvlSub4.DataBind();
dropdownOlevelsub5.DataSource = ds.Tables[0];
dropdownOlevelsub5.DataBind();
dropdownOlevelSub6.DataSource = ds.Tables[0];
dropdownOlevelSub6.DataBind();
dropdownOlevelSub7.DataSource = ds.Tables[0];
dropdownOlevelSub7.DataBind();
dropdownolevelSub8.DataSource = ds.Tables[0];
dropdownolevelSub8.DataBind();
dropdowOlevelSub9.DataSource = ds.Tables[0];
dropdowOlevelSub9.DataBind();
dropdownOlevelsubject1b.DataSource = ds.Tables[0];
dropdownOlevelsubject1b.DataBind();
dropdownOlevelSub2b.DataSource = ds.Tables[0];
dropdownOlevelSub2b.DataBind();
dropdownolevelSub3b.DataSource = ds.Tables[0];
dropdownolevelSub3b.DataBind();
dropdownOlvlSub4b.DataSource = ds.Tables[0];
dropdownOlvlSub4b.DataBind();
dropdownOlevelsub5b.DataSource = ds.Tables[0];
dropdownOlevelsub5b.DataBind();
dropdownOlevelSub6b.DataSource = ds.Tables[0];
dropdownOlevelSub6b.DataBind();
dropdownOlevelSub7b.DataSource = ds.Tables[0];
dropdownOlevelSub7b.DataBind();
dropdownolevelSub8b.DataSource = ds.Tables[0];
dropdownolevelSub8b.DataBind();
dropdowOlevelSub9b.DataSource = ds.Tables[0];
dropdowOlevelSub9b.DataBind();
}
}
protected void dropdownTime_SelectedIndexChanged(object sender, EventArgs e)
{
string dateTxt = dropdownScheduleDate.SelectedItem.Text.ToString();
DataSet ds = new DataSet();
DatabaseFunctions db = new DatabaseFunctions();
ds = db.getSingleTimes_CBT(dateTxt, Convert.ToInt32(ViewState["programID"]), dropdownTime.SelectedItem.Text.ToString());
if (ds.Tables[0].Rows.Count > 0)
{
//GET INGO ...
string time = ds.Tables[0].Rows[0]["ScheduleTime"].ToString();
int capacity = Convert.ToInt16(ds.Tables[0].Rows[0]["Capacity"].ToString());
int Usedcapacity = Convert.ToInt16(ds.Tables[0].Rows[0]["Used"].ToString());
int available = 0;
available = capacity - Usedcapacity;
if (available > 0)
{
labelScheduleTxt.Text = dateTxt + ", " + time + " (" + available + " available)";
lblError.Visible = false;
Random generator = new Random();
if (lblCbtPassword.Text == "")
{
int r = generator.Next(1000, 9999);
lblCbtPassword.Text = r.ToString();
}
}
else
{
lblCbtPassword.Text = "";
labelScheduleTxt.Text = "";
lblError.Text = "No more space available , please choose another slot.";
lblError.Visible = true;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
string pageName = Path.GetFileNameWithoutExtension(Page.AppRelativeVirtualPath);
if (System.Web.HttpContext.Current.User != null)
{
loggedStatus = System.Web.HttpContext.Current.User.Identity.IsAuthenticated;
if (loggedStatus)
{
DatabaseFunctions d = new DatabaseFunctions();
string UserID = Membership.GetUser().ProviderUserKey.ToString();
StudentID = d.GetCandidateID(UserID);
Page.Form.Attributes.Add("enctype", "multipart/form-data");
if (!IsPostBack)
{
DatabaseFunctions db = new DatabaseFunctions();
DataSet appStatus = db.getApplication_ID(Request.QueryString["ApplicationID"].ToString());
if (appStatus.Tables[0].Rows.Count > 0)
{
if (appStatus.Tables[0].Rows[0]["formfilled"].ToString() != "Yes")
{
int programID = 0;
DataSet ds = db.getProgramIDbyApplicationID(Convert.ToInt32(Request.QueryString["ApplicationID"].ToString()));
if (ds.Tables[0].Rows.Count > 0)
{
programID = Convert.ToInt16(ds.Tables[0].Rows[0]["programID"].ToString());
ViewState["programID"] = programID;
ViewState["formnum"] = (ds.Tables[0].Rows[0]["FormNumber"].ToString());
loadbirthDay_Dropdowns();
int JambForm = Convert.ToInt16(ds.Tables[0].Rows[0]["HasJambData"].ToString()); //1
int BioForm = Convert.ToInt16(ds.Tables[0].Rows[0]["HasBioDataSection"].ToString());//2
int OlevelForm = Convert.ToInt16(ds.Tables[0].Rows[0]["HasOlevelResult"].ToString());//3
int PreviousRecordForm = Convert.ToInt16(ds.Tables[0].Rows[0]["HasPreviousRecord"].ToString());//4
int CbtScheduleForm = Convert.ToInt16(ds.Tables[0].Rows[0]["HasCBTSchedule"].ToString());//5
int progressBarAlgo = 0;
if (JambForm == 1)
{
progressBarAlgo = progressBarAlgo + 1;
}
if (BioForm == 1)
{
progressBarAlgo = progressBarAlgo + 1;
}
if (OlevelForm == 1)
{
progressBarAlgo = progressBarAlgo + 1;
}
if (PreviousRecordForm == 1)
{
progressBarAlgo = progressBarAlgo + 1;
}
if (CbtScheduleForm == 1)
{
progressBarAlgo = progressBarAlgo + 1;
}
int startingPercentage = 0;
if (progressBarAlgo > 0)
{
startingPercentage = 100 / progressBarAlgo;
}
else { startingPercentage = 100; }
progressBar.InnerHtml = "<div aria-valuemax=\"100\" aria-valuemin=\"0\" role=\"progressbar\" class=\"progress-bar progress-bar-striped active\" style=\"width: " + startingPercentage + "%;height:30px;font-size:30px;padding-top:5px\">" + startingPercentage + "%</div>";
ViewState["stepsIncrement"] = startingPercentage;
ViewState["progressValue"] = startingPercentage;
var dt = ds.Tables[0];
ViewState["panelInfo"] = dt;
ViewState["NextPanel"] = "";
ViewState["PreviousPanel"] = "";
ViewState["CurrentPanel"] = "";
ViewState["previousPanelName"] = "";
ViewState["FirstPanel"] = "";
ViewState["CurrentPanelName"] = "";
string validationGroup = string.Empty;
for (int c = 2; c < ds.Tables[0].Columns.Count; c++)
{
if (ds.Tables[0].Rows[0][c].ToString() == "1")
{
string colName = ds.Tables[0].Columns[c].ColumnName.ToString();
Panel paneltx = this.Master.FindControl("ContentPlaceHolder1").FindControl(colName) as Panel;
if (paneltx != null)
{
if (ViewState["CurrentPanel"] == "")
{
if (colName == "HasJambData")
{
validationGroup = "appForm";
}
else if (colName == "HasBioDataSection")
{
validationGroup = "appForm_biodata";
}
else if (colName == "HasOlevelResult")
{
validationGroup = "appForm_Olevel";
}
else if (colName == "HasPreviousRecord")
{
validationGroup = "appPreviousRecord";
}
else if (colName == "HasCBTSchedule")
{
validationGroup = "appCBT";
}
ViewState["previousPanelName"] = colName;
ViewState["FirstPanel"] = colName;
ViewState["CurrentPanelName"] = colName;
paneltx.Visible = true;
ViewState["CurrentPanel"] = c;
loadTabsInfo(colName);
btnSave.ValidationGroup = validationGroup;
btnSave.Visible = true;
}
else
{
ViewState["NextPanel"] = c;
btnNext.ValidationGroup = validationGroup;
btnNext.Visible = true;
break;
}
}
}
}
lblCbtUsername.Text = ViewState["formnum"].ToString();
if (ViewState["NextPanel"] != "")
{
btnNext.Visible = true;
btnNext.ValidationGroup = validationGroup;
btnPreview.Visible = false;
}
else
{
btnSave.Visible = false;
btnNext.Visible = false;
btnPreview.ValidationGroup = validationGroup;
btnPreview.Visible = true;
}
}
string imgD = hidden_dpImage.Value;
if (imgD != "")
{
imgDisplay.Src = "profilepics/" + imgD.ToString();
imgDisplay.Style.Add("display", "inline");
}
}
else
{
Response.Redirect("Profilepage.aspx");
}
}
}
}
else
{
Response.Redirect("Login.aspx?ReturnUrl=" + pageName + ".aspx");
}
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
string applicationID = Request.QueryString["ApplicationID"].ToString();
// ScriptManager.RegisterStartupScript(this.Page, GetType(), "ClosePopup", "alertNew('Application Submitted Successfully !','0');", true);
DatabaseFunctions db = new DatabaseFunctions();
db.updateApplicationStatus_Submit(Convert.ToInt32(applicationID));
DataSet appData = db.getApplication_ID((applicationID));
if (appData != null)
{
int programID = Convert.ToInt32(appData.Tables[0].Rows[0]["ProgramID"].ToString());
DataSet pDate = db.getProgramByID(programID);
if (pDate.Tables[0].Rows.Count > 0)
{
int instantadmission = Convert.ToInt16(pDate.Tables[0].Rows[0]["InstantAdmission"].ToString());
if (instantadmission == 1)
{
string programName = appData.Tables[0].Rows[0]["programName"].ToString();
string CourseName = appData.Tables[0].Rows[0]["Course1"].ToString();
string campus = appData.Tables[0].Rows[0]["Campus"].ToString();
string regno = appData.Tables[0].Rows[0]["formnumber"].ToString();
db.insertInstantAdmissiondata(regno, programName, CourseName, campus);
//db.AssignAcceptanceFee()
ScriptManager.RegisterStartupScript(this.Page, GetType(), "ClosePopup2", "alertNew('You have been successfully awarded admission !','0');", true);
DatabaseFunctions d = new DatabaseFunctions();
d.AssignAcceptanceFee(StudentID, programID, 0);
///// Generate acceptance fee and send a message.
d.InsertIntoStudentInfoTableNew(programID, "ND1", StudentID, 0, 1, "0", DateTime.Now.Year.ToString());
int BatchID = d.GetBatchID(DateTime.Now.Year.ToString());
string matricno=DateTime.Now.Year+"-"+programName+"-"+StudentID;
d.InsertIntoAddmissionTableNew(programID, StudentID, 0, "Merit", matricno, BatchID);
double AcceptanceFee = d.GetAcceptanceFeeForProgram(programID);
///// Update Admission Status to 1 .
///// Insert Values to StudentInfo_tbl and AddmissionList (New One)
if(AcceptanceFee!=-1)
{
string Message = "Acceptence Fee Of " +AcceptanceFee+ " Has Been Assigned to You <br> Please Submit This Fees with in One Week";
d.SendMessage(StudentID, Message, "Acceptance Fee", 0);
}
}
else
{
ScriptManager.RegisterStartupScript(this.Page, GetType(), "ClosePopup", "alertNew('Application Submitted Successfully !','0');", true);
}
}
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this.Page, GetType(), "ClosePopup", "alertNew('Error Submiting Application!','1');", true);
}
}
public void formPreview()
{
btnSave.Visible = false;
btnNext.Visible = false;
btnPrevious.Visible = false;
btnPreview.Visible = false;
DataSet ds = new DataSet();
DatabaseFunctions db = new DatabaseFunctions();
ds = db.getProgramIDbyApplicationID(Convert.ToInt32(Request.QueryString["ApplicationID"].ToString()));
if (ds.Tables[0].Rows.Count > 0)
{
int JambForm = Convert.ToInt16(ds.Tables[0].Rows[0]["HasJambData"].ToString()); //1
int BioForm = Convert.ToInt16(ds.Tables[0].Rows[0]["HasBioDataSection"].ToString());//2
int OlevelForm = Convert.ToInt16(ds.Tables[0].Rows[0]["HasOlevelResult"].ToString());//3
int PreviousRecordForm = Convert.ToInt16(ds.Tables[0].Rows[0]["HasPreviousRecord"].ToString());//4
int CbtScheduleForm = Convert.ToInt16(ds.Tables[0].Rows[0]["HasCBTSchedule"].ToString());//5
if (OlevelForm == 0)
{
HasOlevelResult.Visible = false;
}
if (PreviousRecordForm == 0)
{
panelpreview_PreviousRecord.Visible = false;
}
if (CbtScheduleForm == 0)
{
HasCBTSchedule.Visible = false;
}
}
string previousColName = ViewState["CurrentPanelName"].ToString();
Panel panelprev = this.Master.FindControl("ContentPlaceHolder1").FindControl(previousColName) as Panel;
if (panelprev != null)
{
panelprev.Visible = false;
}
panelPreview.Visible = true;
ds = new DataSet();
ds = db.getAlluserRelatedInfo((Membership.GetUser().ProviderUserKey.ToString()));
if (ds.Tables[0].Rows.Count > 0)
{
string programName = string.Empty;
string img = ds.Tables[0].Rows[0]["profilepic"].ToString();
string course = string.Empty;
if (img != "")
{
imgDp.Src = "profilepics/" + img.ToString(); ;
imgDp.Visible = true;
}
else
{
imgDp.Visible = false;
}
DataSet pgName = db.getProgramByID(Convert.ToInt32(ViewState["programID"]));
if (pgName.Tables[0].Rows.Count > 0)
{
programName = pgName.Tables[0].Rows[0]["ProgramName"].ToString();
}
lblSuname.Text = ds.Tables[0].Rows[0]["surname"].ToString();
lblFname.Text = ds.Tables[0].Rows[0]["firstname"].ToString();
lblOtherName.Text = ds.Tables[0].Rows[0]["othername"].ToString();
lblGender.Text = ds.Tables[0].Rows[0]["gender"].ToString();
lblPhonenum.Text = ds.Tables[0].Rows[0]["phonenumber"].ToString();
lblProgram.Text = programName;
lblCourse.Text = db.getApplication_Courses(Convert.ToInt32(ViewState["programID"]), Convert.ToInt32(Request.QueryString["ApplicationID"]));
lblstateoforigin.Text = ds.Tables[0].Rows[0]["statenew"].ToString();
lblLocalGotArea.Text = ds.Tables[0].Rows[0]["govtnew"].ToString();
lblJambRegno.Text = ds.Tables[0].Rows[0]["JAMBRegno"].ToString();
lblJambExamyear.Text = ds.Tables[0].Rows[0]["JambExamyear"].ToString();
lblJambFullName.Text = ds.Tables[0].Rows[0]["JambFullName"].ToString();
lblInstitutionAttended.Text = ds.Tables[0].Rows[0]["institutionNew"].ToString();
lblCourseName.Text = ds.Tables[0].Rows[0]["CourseName"].ToString();
courseType.Text = ds.Tables[0].Rows[0]["CourseType"].ToString();
lblCourseGrade.Text = ds.Tables[0].Rows[0]["CourseGrade"].ToString();
yearCompleted.Text = ds.Tables[0].Rows[0]["YearCompleted"].ToString();
lblIndustrialStart.Text = ds.Tables[0].Rows[0]["IndTrainingStart"].ToString();
lblIndustrialEnd.Text = ds.Tables[0].Rows[0]["IndTrainingEnd"].ToString();
lblCbtSchedule.Text = ds.Tables[0].Rows[0]["ScheduleDate"].ToString() + ", " + ds.Tables[0].Rows[0]["ScheduleTime"].ToString();
labelCbtUser.Text = ds.Tables[0].Rows[0]["CbtUserName"].ToString();
lblCbtPass.Text = ds.Tables[0].Rows[0]["CbtPassword"].ToString();
lblRegistrationNum.Text = ViewState["formnum"].ToString(); ;
}
}
