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) { } }