public ActionResult Create(DivisionModel m)
{
var d = new Division { Name = "New Division" };
d.ProgId = m.TagProgramId;
d.ProgDivs.Add(new ProgDiv { ProgId = m.TagProgramId.Value });
DbUtil.Db.Divisions.InsertOnSubmit(d);
DbUtil.Db.SubmitChanges();
DbUtil.Db.Refresh(RefreshMode.OverwriteCurrentValues, d);
var di = m.DivisionItem(d.Id).Single();
return View("Row", di);
}
public static Organization CreateOrganization(CMSDataContext Db, Division division, string organization)
{
var o = new Organization
{
OrganizationName = organization,
SecurityTypeId = 0,
CreatedDate = Util.Now,
CreatedBy = Util.UserId1,
OrganizationStatusId = 30,
};
division.Organizations.Add(o);
Db.DivOrgs.InsertOnSubmit(new DivOrg { Division = division, Organization = o });
Db.SubmitChanges();
return o;
}
public void SetTagString(CMSDataContext db, string value)
{
if (!value.HasValue())
{
db.DivOrgs.DeleteAllOnSubmit(DivOrgs);
return;
}
var a = value.Split(',');
var qdelete = from d in DivOrgs
where !a.Contains(d.Division.Name)
select d;
db.DivOrgs.DeleteAllOnSubmit(qdelete);
var q = from s in a
join d2 in DivOrgs on s equals d2.Division.Name into g
from d in g.DefaultIfEmpty()
where d == null
select s;
foreach (var s in q)
{
var div = db.Divisions.FirstOrDefault(d => d.Name == s);
if (div == null)
{
div = new Division { Name = s };
string misctags = db.Setting("MiscTagsString", "Misc Tags");
var prog = db.Programs.SingleOrDefault(p => p.Name == misctags);
if (prog == null)
{
prog = new Program { Name = misctags };
db.Programs.InsertOnSubmit(prog);
}
div.Program = prog;
}
DivOrgs.Add(new DivOrg { Division = div });
}
tagString = value;
}
public ActionResult MakeNewDiv(int id, string name)
{
var d = new Division { Name = name, ProgId = id };
d.ProgDivs.Add(new ProgDiv { ProgId = id });
DbUtil.Db.Divisions.InsertOnSubmit(d);
DbUtil.Db.SubmitChanges();
var m = new OrgSearchModel { ProgramId = id, TagDiv = d.Id };
return View("DivisionIds", m);
}
public static Organization FetchOrCreateOrganization(CMSDataContext Db, Division division, string organization, string description)
{
var o = Db.Organizations.SingleOrDefault(oo => oo.Description == description);
if (o == null)
{
o = CreateOrganization(Db, division, organization);
o.Description = description;
}
return o;
}
public static Organization FetchOrCreateOrganization(CMSDataContext Db, Division division, string organization)
{
var o = Db.LoadOrganizationByName(organization);
if (o == null)
return CreateOrganization(Db, division, organization);
return o;
}
public static Division FetchOrCreateDivision(CMSDataContext Db, Program program, string division)
{
var d = Db.Divisions.SingleOrDefault(pp => pp.Name == division && pp.ProgDivs.Any(pd => pd.ProgId == program.Id));
if (d == null)
{
d = new Division { Name = division, Program = program };
var progdiv = new ProgDiv { Division = d, Program = program };
Db.ProgDivs.InsertOnSubmit(progdiv);
Db.SubmitChanges();
}
else
{
var pd = Db.ProgDivs.SingleOrDefault(dd => dd.ProgId == program.Id && dd.DivId == d.Id);
if (pd == null)
program.Divisions.Add(d);
Db.SubmitChanges();
}
return d;
}
public static Organization FetchOrCreateOrganization(CMSDataContext db, Division division, string organization)
{
var o = db.LoadOrganizationByName(organization);
if(o == null || o.DivisionId != division.Id)
return CreateOrganization(db, division, organization);
return o;
}
private void detach_Divisions(Division entity)
{
this.SendPropertyChanging();
entity.Program = null;
}
private void attach_Divisions(Division entity)
{
this.SendPropertyChanging();
entity.Program = this;
}
