protected void Button4_Click(object sender, EventArgs e)
{
try
{
acceptance ac = new acceptance();
ac.user_id = Convert.ToInt32(TextBox1.ToString());
ac.user_id = Convert.ToInt32(usid.Value.ToString());
ac.work_id = mywork.id;
ac.detail = details.Value.ToString();
ac.dead_time = Convert.ToDateTime(date.Value.ToString());
DataClasses1DataContext db = new DataClasses1DataContext();
var hj = from i in db.acceptances where i.user_id == ac.user_id && i.work_id == ac.work_id select i;
if (hj.Count() > 0)
{
Exception c = new Exception("this user alredy accepted");
throw c;
}
var maxValue = db.acceptances.Max(x => x.id);
ac.id = maxValue + 1;
db.acceptances.InsertOnSubmit(ac);
db.SubmitChanges();
}
catch (Exception ex)
{
HtmlGenericControl er = (HtmlGenericControl)this.Master.FindControl("error");
HtmlGenericControl al = (HtmlGenericControl)this.Master.FindControl("alert");
al.Visible = true;
er.Visible = true;
er.InnerText = ex.Message;
}
}
protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e)
{
try
{
DataClasses1DataContext db = new DataClasses1DataContext();
if (e.CommandName.Equals("acceptreq") == true)
{
int maxValue;
int id = Convert.ToInt32(e.CommandArgument.ToString());
acceptance n = new acceptance();
if (db.acceptances.Count() > 0)
{
maxValue = db.acceptances.Max(x => x.id);
}
else
{
maxValue = 0;
}
n.user_id = id;
n.work_id = mywork.id;
n.id = maxValue + 1;
n.dead_time = DateTime.Now;
n.detail = ":D";
n.cost = 100;
var hj = from i in db.acceptances where i.user_id == n.user_id && i.work_id == n.work_id select i;
if (hj.Count() > 0)
{
Exception c = new Exception("this user alredy accepted");
throw c;
}
db.acceptances.InsertOnSubmit(n);
db.SubmitChanges();
}
else if (e.CommandName.Equals("Delete") == true)
{
int id = Convert.ToInt32(e.CommandArgument.ToString());
var requestdelete = from i in db.applicants
where i.user_id == id
select i;
applicant ap = requestdelete.First();
db.applicants.DeleteOnSubmit(ap);
db.SubmitChanges();
}
}
catch (Exception ex)
{
HtmlGenericControl er = (HtmlGenericControl)this.Master.FindControl("error");
HtmlGenericControl al = (HtmlGenericControl)this.Master.FindControl("alert");
al.Visible = true;
er.Visible = true;
er.InnerText = ex.Message;
}
}
protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e)
{
try
{
DataClasses1DataContext db = new DataClasses1DataContext();
int id = Convert.ToInt32(e.CommandArgument.ToString());
if (e.CommandName.Equals("Delete") == true)
{
var cc = from c in db.acceptances
where c.id == id
select c;
acceptance bn = cc.First();
db.acceptances.DeleteOnSubmit(bn);
db.SubmitChanges();
Response.Redirect("acceptances.aspx?id=" + workid);
}
}
catch (Exception ex)
{
}
}
