protected void Page_Load(object sender, EventArgs e) { UserRole = (Role)Convert.ToInt32(Session["RoleID"]); lblMsg.Text = ""; chkAllCamps.Enabled = true; //btnReport123.Enabled = true; MakeKeyStatusBold(); if (!IsPostBack) { using (CIPMSEntities1 ctx = new CIPMSEntities1()) { ddlCampYear.DataSource = ctx.tblCampYears.Select(x => new { id = x.ID, text = x.CampYear }); ddlCampYear.SelectedValue = Application["CampYearID"].ToString(); ddlCampYear.DataBind(); } if (UserRole == Role.CampDirector) { ddlFed.Visible = false; ddlFed.DataSourceID = null; chklistCamp.DataSourceID = null; chklistCamp.DataSource = CampsDA.GetCampByJWestCampDirector(Int32.Parse(ddlCampYear.SelectedValue), Int32.Parse(Session["UserID"].ToString())); chklistCamp.DataBind(); chkAllCamps.Visible = false; } } }
protected void btnGenerate_Click(object sender, EventArgs e) { int campYearID = Int32.Parse(ddlCampYear.SelectedValue); using (var ctx = new CIPMSEntities1()) { var list = from row in ctx.tblFederationCampsContactDetails.Include("tblCamp") where row.CampYearID == campYearID - 1 orderby row.FederationID, row.tblCamp.ID select row; foreach (var row in list) { // create new detail rows. EF will insert entities automatically because referecing to the existing camps var p = new tblFederationCampsContactDetail { CampYearID = campYearID, tblCamp = ctx.tblCamps.Where(x => x.ID == row.tblCamp.ID + 1000).First(), FederationID = row.FederationID, Contact = row.Contact, Phone = row.Phone, Email = row.Email, NavigationURL = row.NavigationURL, ParentInfoPreviousClickURL = row.ParentInfoPreviousClickURL }; } ctx.SaveChanges(); } lblMsg.Text = "Data generated successfully."; }
protected void btnGenerate_Click(object sender, EventArgs e) { int campYearID = Int32.Parse(ddlCampYear.SelectedValue); using (CIPMSEntities1 ctx = new CIPMSEntities1()) { var list = from row in ctx.tblUserCamps where row.CampYearid == campYearID - 1 orderby row.UserId, row.CampId select row; foreach (var row in list) { // create new detail rows. EF will insert entities automatically because referecing to the existing camps ctx.AddTotblUserCamps(new tblUserCamp { CampYearid = campYearID, UserId = row.UserId, CampId = row.CampId + 1000 }); } ctx.SaveChanges(); } lblMsg.Text = "Data generated successfully."; }
protected void btnGenerate_Click(object sender, EventArgs e) { int campYearID = Int32.Parse(ddlCampYear.SelectedValue); using (var ctx = new CIPMSEntities1()) { var list = from grantrow in ctx.tblFedCampGrants where grantrow.CampYearID == campYearID - 1 orderby grantrow.FederationID, grantrow.CampID select grantrow; foreach (var row in list) { // create new FedCampGrant ctx.AddTotblFedCampGrants(new tblFedCampGrant { CampYearID = campYearID, CampID = row.CampID == 0 ? 0 : row.CampID + 1000, FederationID = row.FederationID, TimeInCamp = row.TimeInCamp, DaysAtLeast = row.DaysAtLeast, GrantAmount = row.GrantAmount }); } ctx.SaveChanges(); } lblMsg.Text = "Data generated successfully."; }
protected void btnGenerate_Click(object sender, EventArgs e) { int campYearID = Int32.Parse(ddlCampYear.SelectedValue); using (var ctx = new CIPMSEntities1()) { var list = from camp in ctx.tblCamps where camp.CampYearID == campYearID - 1 select camp; foreach (var newCamp in list) { ctx.AddTotblCamps(new tblCamp { CampYearID = campYearID, ID = newCamp.ID + 1000, Inactive = false, Name = newCamp.Name, IsManual = false, State = newCamp.State, JDataID = newCamp.JDataID, IsWestCamp = newCamp.IsWestCamp, IsAdamahCamp = newCamp.IsAdamahCamp, IsURJCamp = newCamp.IsURJCamp }); } ctx.SaveChanges(); } lblMsg.Text = "Data generated successfully."; }
protected void Page_Load(object sender, EventArgs e) { UserRole = (Role)Convert.ToInt32(Session["RoleID"]); lblMsg.Text = ""; MakeKeyStatusBold(); if (!IsPostBack) { using (CIPMSEntities1 ctx = new CIPMSEntities1()) { ddlCampYear.DataSource = ctx.tblCampYears.Select(x => new { id = x.ID, text = x.CampYear }); ddlCampYear.SelectedValue = Application["CampYearID"].ToString(); ddlCampYear.DataBind(); } } // Delete old work files string workFileDir = Server.MapPath(@"~/Docs"); // need to check and see if any old files are left behind DirectoryInfo myDir = new DirectoryInfo(workFileDir); foreach (FileSystemInfo myFile in myDir.GetFileSystemInfos("*.xls")) { // Delete any files that are 1 min old //if ((DateTime.Now - myFile.CreationTime).Minutes > 1) myFile.Delete(); } }
protected void btnGenerate_Click(object sender, EventArgs e) { int campYearID = Int32.Parse(ddlCampYear.SelectedValue); using (CIPMSEntities1 ctx = new CIPMSEntities1()) { var list = from row in ctx.tblNationalCamps where row.CampYearID == campYearID - 1 orderby row.FederationID, row.CampID select row; foreach (var row in list) { // create new FedCampGrant ctx.AddTotblNationalCamps(new tblNationalCamp { CampYearID = campYearID, CampID = row.CampID + 1000, FederationID = row.FederationID }); } ctx.SaveChanges(); } lblMsg.Text = "Data generated successfully."; }
protected void btnGenerate_Click(object sender, EventArgs e) { int campYearID = Int32.Parse(ddlCampYear.SelectedValue); using (var ctx = new CIPMSEntities1()) { var list = from row in ctx.tblFederationCamps.Include("tblCamp") where row.CampYearID == campYearID - 1 orderby row.FederationID, row.tblCamp.ID select row; foreach (var row in list) { if (row.tblCamp != null) { var camp = ctx.tblCamps.Where(x => x.ID == row.tblCamp.ID + 1000).FirstOrDefault(); if (camp != null) { var p = new tblFederationCamp { ID = row.ID + 1000, CampYearID = campYearID, tblCamp = camp, FederationID = row.FederationID, isJDS = row.isJDS, Inactive = false }; } } } ctx.SaveChanges(); } lblMsg.Text = "Data generated successfully."; }
protected void btnGenerate_Click(object sender, EventArgs e) { int campYearID = Int32.Parse(ddlCampYear.SelectedValue); using (CIPMSEntities1 ctx = new CIPMSEntities1()) { var list = from row in ctx.tblFederationGrades where row.CampYearID == campYearID - 1 orderby row.FederationID, row.EligibleGrade select row; foreach (var row in list) { // create new detail rows. EF will insert entities automatically because referecing to the existing camps if (row.FederationID != 89) { ctx.AddTotblFederationGrades(new tblFederationGrade { CampYearID = campYearID, FederationID = row.FederationID, EligibleGrade = row.EligibleGrade, TimeInCamp = row.TimeInCamp }); } } ctx.SaveChanges(); } lblMsg.Text = "Data generated successfully."; }
protected void btnDelete_Click(object sender, EventArgs e) { int campYearID = Int32.Parse(ddlCampYear.SelectedValue); using (CIPMSEntities1 ctx = new CIPMSEntities1()) { ctx.uspFedCampGrantDelete(campYearID); } lblMsg.Text = "Data deleted successfully."; }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { using (CIPMSEntities1 ctx = new CIPMSEntities1()) { ddlCampYear.DataSource = ctx.tblCampYears.Select(x => new { id = x.ID, text = x.CampYear }); ddlCampYear.SelectedValue = Application["CampYearID"].ToString(); ddlCampYear.DataBind(); } } }
protected void Page_Load(object sender, EventArgs e) { lblMsg.Text = ""; if (!IsPostBack) { using (CIPMSEntities1 ctx = new CIPMSEntities1()) { ddlCampYear.DataSource = ctx.tblCampYears.Where(x => x.CurrentYear == true).Select(x => new { id = x.ID, text = x.CampYear }); ddlCampYear.DataValueField = "id"; ddlCampYear.DataTextField = "text"; ddlCampYear.DataBind(); } } }
protected void Page_Load(object sender, EventArgs e) { UserRole = (Role)Convert.ToInt32(Session["RoleID"]); lblMsg.Text = ""; MakeKeyStatusBold(); if (!IsPostBack) { using (CIPMSEntities1 ctx = new CIPMSEntities1()) { ddlCampYear.DataSource = ctx.tblCampYears.Select(x => new { id = x.ID, text = x.CampYear }); ddlCampYear.SelectedValue = Application["CampYearID"].ToString(); ddlCampYear.DataBind(); } } }
protected void Page_Load(object sender, EventArgs e) { lblMsg.Text = ""; lblMsg2.Text = ""; if (!IsPostBack) { ResetWarning(false); using (var ctx = new CIPMSEntities1()) { ddlCampYear.DataSource = ctx.tblCampYears.Select(x => new { id = x.ID, text = x.CampYear }); ddlCampYear.SelectedValue = Application["CampYearID"].ToString(); ddlCampYear.DataBind(); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { UserRole = (Role)Convert.ToInt32(Session["RoleID"]); using (CIPMSEntities1 ctx = new CIPMSEntities1()) { ddlCampYear.DataSource = ctx.tblCampYears.Select(x => new { id = x.ID, text = x.CampYear }); ddlCampYear.SelectedValue = Application["CampYearID"].ToString(); ddlCampYear.DataBind(); } if (UserRole == Role.CampDirector) { ddlFed.Visible = false; ddlFed.DataSourceID = null; } } }
protected void Page_Load(object sender, EventArgs e) { UserRole = (Role)Convert.ToInt32(Session["RoleID"]); lblMsg.Text = ""; chkAllCamps.Visible = true; MakeKeyStatusBold(); // We have to determine if its Fed Admin if (!IsPostBack) { if (UserRole == Role.CampDirector || UserRole == Role.FederationAdmin) { chkAllFeds.Visible = false; chkByProgram.Visible = false; } using (CIPMSEntities1 ctx = new CIPMSEntities1()) { ddlCampYear.DataSource = ctx.tblCampYears.Select(x => new { id = x.ID, text = x.CampYear }); ddlCampYear.SelectedValue = Application["CampYearID"].ToString(); ddlCampYear.DataBind(); } for (int i = 0; i < 2; i++) { if (i == 0) { chklistCountryPopular.Items[i].Attributes.Add("title", "Russia, Belarus, Estonia, Kazakhstan, Lithuania, Ukraine, Armenia, Azerbaijan, Georgia, Latvia, Moldova, Uzbekistan, Kyrgyzstan, Turkmenistan, Tajikistan"); chklistCountryPopular.Items[i].Attributes.Add("id", "pretty"); } else { chklistCountryPopular.Items[i].Attributes.Add("title", "Mexico, Belize, Costa Rica, El Salvador, Guatemala, Honduras, Panama, Argentina, Bolivia, Brazil, Chile, Colombia, Ecuador, French Guiana, Guyana, Paraguay, Peru, Suriname, Uruguay, Venezuela, Falkland Islands"); chklistCountryPopular.Items[i].Attributes.Add("id", "pretty2"); } } } }
protected void Page_Load(object sender, EventArgs e) { UserRole = (Role)Convert.ToInt32(Session["RoleID"]); lblMsg.Text = ""; chkAllCamps.Visible = true; if (UserRole == Role.CampDirector || UserRole == Role.FederationAdmin) { chkAllFeds.Visible = false; } MakeKeyStatusBold(); if (!IsPostBack) { using (CIPMSEntities1 ctx = new CIPMSEntities1()) { ddlCampYear.DataSource = ctx.tblCampYears.Select(x => new { id = x.ID, text = x.CampYear }); ddlCampYear.SelectedValue = Application["CampYearID"].ToString(); ddlCampYear.DataBind(); } } }