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();
}
