protected void btnapply_Click(object sender, EventArgs e) { SqlCommand cmd1 = new SqlCommand("select * from Appliedjob where Email='" + lblemail.Text + "' and [Phone]='" + lblmble.Text + "'", con); SqlDataAdapter sd = new SqlDataAdapter(cmd1); con.Open(); DataTable dt1 = new DataTable(); sd.Fill(dt1); if (dt1.Rows.Count > 0) { TextBox des = (TextBox)Dt1.FindControl("txtdes"); SqlCommand cmd = new SqlCommand("insert into Appliedjob(Username,Email,Jobtitle,Companyname,Location,Subjobtag,Fromdate,ToDate,Description) values('" + txtname.Text + "','" + lblemail.Text + "','" + lbjobtitle + "','" + lbcompanyname + "','" + lblocation + "','" + lbSkills + "','" + lbfromdate + "','" + lbtodate + "','" + des.Text + "')", con); int i = cmd.ExecuteNonQuery(); if (i > 0) { Send(); Page.ClientScript.RegisterStartupScript(this.GetType(), "Scripts", "<script>alert( 'You have successfully applied for these job.Please check Your Email' )</script>"); } else { Page.ClientScript.RegisterStartupScript(this.GetType(), "Scripts", "<script>alert( 'Please check Your Email' )</script>"); } } else { Page.ClientScript.RegisterStartupScript(this.GetType(), "Scripts", "<script>alert('Email already Exists')</script>"); } con.Close(); }
private void button1_Click(object sender, EventArgs e) { using (sqlConnection1) { sqlConnection1.Open(); String Dt1; String Dt2; Dt1 = Convert.ToString(dateTimePicker1.Value); Dt1 = Dt1.Substring(3, 3) + Dt1.Substring(0, 3) + Dt1.Substring(6, 4); Dt2 = Convert.ToString(dateTimePicker2.Value); Dt2 = Dt2.Substring(3, 3) + Dt2.Substring(0, 3) + Dt2.Substring(6, 4); textBox1.Text = "EXEC spSalesByPeriod " + "'" + Dt1 + "', '" + Dt2 + "'"; StringBuilder results = new StringBuilder(); sqlCommand1.Parameters["@Beginning_Date"].Value = dateTimePicker1.Value; sqlCommand1.Parameters["@Ending_Date"].Value = dateTimePicker2.Value; SqlDataReader reader = sqlCommand1.ExecuteReader(); while (reader.Read()) { for (int i = 0; i < reader.FieldCount; i++) { results.Append(reader[i].ToString() + "\t"); } results.Append(Environment.NewLine); } textBox2.Text = results.ToString(); } sqlConnection1.Close(); }
public IEnumerable <AgeRangeInfo> GetTotalsByFundAgeRange() { var model = new BundleModel(); var ageRangeInfos = model.TotalsByFundAgeRange(0, Dt1.GetValueOrDefault(), Dt2.GetValueOrDefault(), string.Empty, CampusId); RangeTotal = model.RangeTotal; return(ageRangeInfos); }
public IEnumerable <RangeInfo> GetTotalsByFundRange() { var model = new BundleModel(); var rangeInfos = model.TotalsByFundRange(FundId, Dt1.GetValueOrDefault(), Dt2.GetValueOrDefault(), string.IsNullOrWhiteSpace(Pledged) ? "false" : Pledged, CampusId); RangeTotal = model.RangeTotal; return(rangeInfos); }
public IEnumerable <AgeRangeInfo> GetTotalsByFundAgeRange() { var model = new BundleModel(); var fundids = APIContributionSearchModel.GetCustomFundSetList(DbUtil.Db, FundSet).JoinInts(","); var ageRangeInfos = model.TotalsByFundAgeRange(0, Dt1.GetValueOrDefault(), Dt2.GetValueOrDefault(), string.Empty, CampusId, fundids); RangeTotal = model.RangeTotal; return(ageRangeInfos); }
private void Datalistbind() { SqlDataAdapter da = new SqlDataAdapter("select * from PostJob", con); con.Open(); DataTable dt = new DataTable(); da.Fill(dt); Dt1.DataSource = dt; Dt1.DataBind(); con.Close(); }
private string BuildUrl(string baseurl, int?fundid, int?bundletypeid) { connector = "?"; var sb = new StringBuilder(baseurl); if (fundid.HasValue) { Append(sb, "fundid=" + fundid); } if (bundletypeid.HasValue) { Append(sb, "bundletype=" + bundletypeid); } if (Dt1.HasValue) { Append(sb, "dt1=" + Dt1.ToSortableDate()); } if (Dt2.HasValue) { Append(sb, "dt2=" + Dt2.ToSortableDate()); } if (!IncUnclosedBundles) { Append(sb, "includeunclosedbundles=false"); } if (TaxDedNonTax != "TaxDed") { Append(sb, "taxnontax=" + TaxDedNonTax); } if (CampusId > 0) { Append(sb, "campus=" + CampusId); } if (Online < 2) { Append(sb, "online=" + Online); } return(sb.ToString()); }
public IEnumerable <AgeRangeInfo> GetTotalsByFundAgeRange() { var model = new BundleModel(); var customFundIds = APIContributionSearchModel.GetCustomFundSetList(DbUtil.Db, FundSet); var authorizedFundIds = DbUtil.Db.ContributionFunds.ScopedByRoleMembership(DbUtil.Db).Select(f => f.FundId).ToList(); string fundIds = string.Empty; if (customFundIds?.Count > 0) { fundIds = authorizedFundIds.Where(f => customFundIds.Contains(f)).JoinInts(","); } else { fundIds = authorizedFundIds.JoinInts(","); } var ageRangeInfos = model.TotalsByFundAgeRange(0, Dt1.GetValueOrDefault(), Dt2.GetValueOrDefault(), string.Empty, CampusId, fundIds); RangeTotal = model.RangeTotal; return(ageRangeInfos); }
public GroupClasseJournalVM() { Dt1 = DateTime.Now; Dt2 = Dt1.AddDays(7); GroupClassesJournal = dc.GroupClassesJournals.Where(x => x.ClassesTime > Dt1 && x.ClassesTime < Dt2).ToList(); }