public ActionResult DeletePost(FormCollection formCollection) { User user = new User(); user = Session["User"] as IAProject_FreelancerSystem.Models.User; // Users if (Session["User"] != null) { if (user.role == "admin") { return(RedirectToAction("Profile", "Dashboard")); } else if (user.role == "freelancer") { return(RedirectToAction("Index", "Wall")); } } else { return(RedirectToAction("Index", "Wall")); } var jobID = formCollection["jobID"]; new JobDB().Delete(jobID); List <Rate> jobs_rate = new RateDB().SelectAll(); jobs_rate = jobs_rate.FindAll(r => r.jobID == Int32.Parse(jobID)); for (int i = 0; i < jobs_rate.Count(); i++) { new RateDB().Delete(jobs_rate[i].rateID.ToString()); } List <SavedJob> jobs_saved = new SavedJobDB().SelectAll(); jobs_saved = jobs_saved.FindAll(r => r.jobID == Int32.Parse(jobID)); for (int i = 0; i < jobs_saved.Count(); i++) { new SavedJobDB().Delete(jobs_saved[i].savedID.ToString()); } List <Proposal> jobs_proposal = new ProposalsDB().SelectAll(); jobs_proposal = jobs_proposal.FindAll(r => r.jobID == Int32.Parse(jobID)); for (int i = 0; i < jobs_proposal.Count(); i++) { new ProposalsDB().Delete(jobs_proposal[i].propID.ToString()); } return(RedirectToAction("MyPosts")); }
private void initConfig() { iniFile = new IniFile(Environment.CurrentDirectory + "\\" + Application.ProductName + ".ini"); initC = new InitConfig(); //regE = new RegEdit(); //MessageBox.Show("aaa " + Environment.CurrentDirectory + "\\" + Application.ProductName + ".ini", "LottoryControl StatusServer" + initC.StatusServer.ToLower()); GetConfig(); //MessageBox.Show("bbb", "LottoryControl"); cf = new Config1(); //MessageBox.Show("ccc", "LottoryControl"); conn = new ConnectDB(initC); ratedb = new RateDB(conn); saledb = new SaleDB(conn); sfdb = new StaffDB(conn); thodb = new ThooDB(conn); lotdb = new LottoDB(conn); rwdb = new RewardDB(conn); fldb = new FlockDB(conn); srdb = new SaleRateDB(conn); cudb = new CustomerDB(conn); imgdb = new ImageDB(conn); nldb = new NumberLimitDB(conn); //MessageBox.Show("ddd", "LottoryControl"); rate = new Rate(); sale = new Sale(); staff = new Staff(); tho = new Thoo(); lot = new Lotto(); rw = new Reward(); fl = new FLock(); sr = new SaleRate(); cu = new Customer(); img = new Image1(); nl = new NumberLimit(); r2Down = new Rate(); r2Tod = new Rate(); r2Up = new Rate(); r3Up = new Rate(); r3Tod = new Rate(); r3Down = new Rate(); rUp = new Rate(); rDown = new Rate(); //MessageBox.Show("bbb", "LottoryControl"); rUp = ratedb.selectByPk("up"); rDown = ratedb.selectByPk("down"); r3Up = ratedb.selectByPk("3up"); r3Tod = ratedb.selectByPk("3tod"); r3Down = ratedb.selectByPk("3down"); r2Down = ratedb.selectByPk("2down"); r2Up = ratedb.selectByPk("2up"); lTho = thodb.setData(); setThoColor(); lsr = srdb.selectSRAll(); ls = saledb.selectSAll(); lnl = selectByNumberLimit(); //cboThoo = new ComboBox(); cbosf = new ComboBox(); //cboSale = new ComboBox(); //cboThoo = thodb.getCboThoo(cboThoo); cbosf = sfdb.getCboStaff(cbosf); //cboSale = saledb.getCboSale(cboSale); }