public ActionResult ManageWorkPackages(Models.SoftwareReqtsModel S, string id)
{
Models.DataBaseTableClassesDataContext db=new Models.DataBaseTableClassesDataContext();
S.SelectedId = id;
var query = from ws in db.WpsForSrs
where ws.Sr_ID == Int32.Parse(S.SelectedId)
select ws.WorkPackageDescription;
foreach (var m in query)
{
SelectListItem li = new SelectListItem();
li.Text = m.Wp_Title;
li.Value = m.Wp_Id.ToString();
S.Wp_used.Add(li);
}
foreach (Models.WorkPackageDescription wp in db.WorkPackageDescriptions)
{
int k;
SelectListItem li = new SelectListItem();
li.Text = wp.Wp_Title;
li.Value = wp.Wp_Id.ToString();
for ( k = 0; k < S.Wp_used.Count; k++)
{
if (S.Wp_used[k].Value == li.Value)
break;
}
if (k < S.Wp_used.Count)
continue;
S.Wp_unused.Add(li);
}
return View(S);
}
public ActionResult DetailedView(Models.SoftwareReqtsModel S,string id)
{
Models.DataBaseTableClassesDataContext db = new Models.DataBaseTableClassesDataContext();
S.SelectedId = id;
var query = from ws in db.WpsForSrs
where ws.Sr_ID == Int32.Parse(S.SelectedId)
select ws.WorkPackageDescription;
foreach (var q in query)
{
SelectListItem li = new SelectListItem();
li.Text = q.Wp_Title;
li.Value = q.Wp_Id.ToString();
S.Wp_used.Add(li);
}
return View(S);
}
public ActionResult WpSubmit(Models.SoftwareReqtsModel S, FormCollection coll)
{
S.SelectedId = Session["srid"].ToString();
try
{
Models.DataBaseTableClassesDataContext db = new Models.DataBaseTableClassesDataContext();
var query = from ws in db.WpsForSrs
where ws.Sr_ID == Int32.Parse(S.SelectedId)
select ws.WorkPackageDescription;
foreach (var m in query)
{
SelectListItem li = new SelectListItem();
li.Text = m.Wp_Title;
li.Value = m.Wp_Id.ToString();
S.Wp_used.Add(li);
}
string[] selected = coll.GetValues("SelectedPackages");
if (selected != null)
{
foreach (string s in selected)
{
int i;
for (i = 0; i < S.Wp_used.Count; i++)
{
if (s == S.Wp_used[i].Value)
break;
}
if (i == S.Wp_used.Count)
{
var que = from srs in db.WpsForSrs
where srs.Wp_Id.ToString() == s && S.SelectedId == srs.Sr_ID.ToString()
select srs;
db.WpsForSrs.DeleteAllOnSubmit(que);
}
}
db.SubmitChanges();
}
else
{
foreach (SelectListItem s in S.Wp_used)
{
var que = from srp in db.WpsForSrs
where srp.Wp_Id == Int32.Parse(s.Value) && srp.Sr_ID == Int32.Parse(S.SelectedId)
select srp;
db.WpsForSrs.DeleteAllOnSubmit(que);
}
db.SubmitChanges();
}
selected = coll.GetValues("UnselectedPackages");
if (selected != null)
{
foreach (string s in selected)
{
Models.WpsForSr ws=new Models.WpsForSr();
ws.Sr_ID=Int32.Parse(S.SelectedId);
ws.Wp_Id=Int32.Parse(s);
db.WpsForSrs.InsertOnSubmit(ws);
}
db.SubmitChanges();
}
}
catch
{
Session["ErrorMessage"] = "Failed To Submit Changes";
return RedirectToAction("ErrorPage", "Home");
}
return RedirectToAction("DetailedView/" + S.SelectedId);
}