public static int Delete(MyJob j) { DBAccess db = new DBAccess(); db.AddParameter("@iMyJobID", j.MyJobID); return(db.ExecuteNonQuery("JobsDb_MyJobs_Delete")); }
protected void ImageButton2_Click(object sender, ImageClickEventArgs e) { MyJob j = new MyJob(); j.PostingID = int.Parse(Request.QueryString["id"]); j.UserName = Profile.UserName; MyJob.Insert(j); }
public static int Insert(MyJob j) { DBAccess db = new DBAccess(); db.AddParameter("@iPostingID", j.PostingID); db.AddParameter("@sUserName", j.UserName); SqlParameter p = new SqlParameter("@iMyJobID", SqlDbType.Int); p.Direction = ParameterDirection.Output; db.AddParameter(p); int retval = db.ExecuteNonQuery("JobsDb_MyJobs_Insert"); if (retval == 1) { return int.Parse(p.Value.ToString()); } else { return -1; } }
public static int Insert(MyJob j) { DBAccess db = new DBAccess(); db.AddParameter("@iPostingID", j.PostingID); db.AddParameter("@sUserName", j.UserName); SqlParameter p = new SqlParameter("@iMyJobID", SqlDbType.Int); p.Direction = ParameterDirection.Output; db.AddParameter(p); int retval = db.ExecuteNonQuery("JobsDb_MyJobs_Insert"); if (retval == 1) { return(int.Parse(p.Value.ToString())); } else { return(-1); } }
public static int Delete(MyJob j) { DBAccess db = new DBAccess(); db.AddParameter("@iMyJobID",j.MyJobID); return db.ExecuteNonQuery("JobsDb_MyJobs_Delete"); }