public ActionResult Approve() { String UID = Request.Params["UID"].ToString(); String PID = Request.Params["PID"].ToString(); Models.Database db = new Models.Database(); ApproveData apd = new ApproveData(); String[] x = apd.getData(UID, PID); db.DatabaseCon("EAloAllInfo"); db.setData("Insert into InfoTable (Dates,DTB,Cat,City,Region,FixedDetails,UserDetails,Price,UID,PID,Phone,img1,img2,img3,img4,img5) values(" + "'" + "Dates" + "'," + "'" + x[0] + "'," + "'" + x[1] + "'," + "'" + x[2] + "'," + "'" + x[3] + "'," + "'" + x[4] + "'," + "'" + x[5] + "'," + "'" + x[6] + "'," + "'" + x[7] + "'," + "'" + x[8] + "'," + "'" + x[9] + "'," + "'" + x[10] + "'," + "'" + x[11] + "'," + "'" + x[12] + "'," + "'" + x[13] + "'," + "'" + x[14] + "'" + ")"); //db.DatabaseCon("EAloAllInfo").Close(); db.DatabaseCon("EAloCity"); db.setData("Insert into " + Space(x[2]) + " (Dates,DTB,Cat,City,Region,FixedDetails,UserDetails,Price,UID,PID,Phone,img1,img2,img3,img4,img5) values(" + "'" + "Dates" + "'," + "'" + x[0] + "'," + "'" + x[1] + "'," + "'" + x[2] + "'," + "'" + x[3] + "'," + "'" + x[4] + "'," + "'" + x[5] + "'," + "'" + x[6] + "'," + "'" + x[7] + "'," + "'" + x[8] + "'," + "'" + x[9] + "'," + "'" + x[10] + "'," + "'" + x[11] + "'," + "'" + x[12] + "'," + "'" + x[13] + "'," + "'" + x[14] + "'" + ")"); /// db.DatabaseCon("EAloCity").Close(); db.DatabaseCon("EAlo" + Space(x[0])); db.setData("Insert into " + "Cetagory" + " (Dates,DTB,Cat,City,Region,FixedDetails,UserDetails,Price,UID,PID,Phone,img1,img2,img3,img4,img5) values(" + "'" + "Dates" + "'," + "'" + x[0] + "'," + "'" + x[1] + "'," + "'" + x[2] + "'," + "'" + x[3] + "'," + "'" + x[4] + "'," + "'" + x[5] + "'," + "'" + x[6] + "'," + "'" + x[7] + "'," + "'" + x[8] + "'," + "'" + x[9] + "'," + "'" + x[10] + "'," + "'" + x[11] + "'," + "'" + x[12] + "'," + "'" + x[13] + "'," + "'" + x[14] + "'" + ")"); // db.DatabaseCon("EAlo" + Space(x[0])).Close(); db.DatabaseCon("EAlo"); db.setData("Delete from ApproveTable where UID=" + "'" + UID + "' and PID=" + "'" + PID + "'"); // db.DatabaseCon("EAlo").Close(); return(Redirect("~/Admin/Admin?Password=EAlo&Admin=EAlo")); }
public ActionResult changeStatus(ApproveData approveData) { try { // TODO: Add insert logic here int uId = Convert.ToInt32(Session["UserId"].ToString()); var query = db.ConcreteMixingDesigns.Where(c => c.Id == approveData.id).FirstOrDefault(); query.Status = approveData.Status; query.UpdatedBy = uId; query.UpdatedDate = DateTime.Now; db.SaveChanges(); return(RedirectToAction("ApproveOrDeclineMixingDesign", "MixingDesign", new { id = 1 })); } catch { return(View("ApproveDetails")); } }