public async Task <ActionResult> Create([Bind(Include = "idmanagelist,name,flag")] managelist managelist)
{
if (ModelState.IsValid)
{
db.managelists.Add(managelist);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(managelist));
}
public async Task <ActionResult> Create([Bind(Include = "idservice,idcase_FK,name,is_activity,description,idrole_FK")] service service)
{
if (ModelState.IsValid)
{
db.services.Add(service);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
ViewBag.idrole_FK = new SelectList(db.AspNetRoles, "Id", "NameAR", service.idrole_FK);
ViewBag.idcase_FK = new SelectList(db.cases, "idcase", "name", service.idcase_FK);
ViewBag.enableOptions = enable;
return(View(service));
}
public async Task <ActionResult> Create([Bind(Include = "idcenter,name,location,idpartner_FK,flag,min_family_id,max_family_id,min_person_id,max_person_id")] center center)
{
if (ModelState.IsValid)
{
partner p = db.partners.SingleOrDefault(pa => pa.idpartner == center.idpartner_FK);
center.idcenter = p.idpartner + center.flag;
db.centers.Add(center);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
ViewBag.idpartner_FK = new SelectList(db.partners, "idpartner", "name", center.idpartner_FK);
return(View(center));
}
public async Task <ActionResult> Create([Bind(Include = "idreferalfamily,idfamily_FK,idcase_FK,idservice_FK,submittingdate,referalstate,referaldate,servicestate,servicestartdate,serviceenddate,referalsender_FK,senderevalution,recieverevalution,idcenter_FK,outreachnote")] referalfamily referalfamily)
{
if (ModelState.IsValid)
{
db.referalfamilies.Add(referalfamily);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
ViewBag.referalsender_FK = new SelectList(db.AspNetUsers, "Id", "Email", referalfamily.referalsender_FK);
ViewBag.idcase_FK = new SelectList(db.cases, "idcase", "name", referalfamily.idcase_FK);
ViewBag.idcenter_FK = new SelectList(db.centers, "idcenter", "name", referalfamily.idcenter_FK);
ViewBag.idservice_FK = new SelectList(db.services, "idservice", "name", referalfamily.idservice_FK);
ViewBag.idfamily_FK = new SelectList(db.families, "idfamily", "familynature", referalfamily.idfamily_FK);
return(View(referalfamily));
}
public async Task <ActionResult> enableService([Bind(Include = "idcenter_FK,idservice_FK,enabled,location,start_date,end_date,Id")] centerservice centerservice, bool enabled)
{
if (ModelState.IsValid)
{
if (enabled == false)
{
centerservice.end_date = DateTime.Today;
}
db.Entry(centerservice).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
ViewBag.idcenter_FK = new SelectList(db.centers, "idcenter", "name", centerservice.idcenter_FK);
ViewBag.idservice_FK = new SelectList(db.services, "idservice", "name", centerservice.idservice_FK);
ViewBag.enableOptions = enable;
return(await Index());
}
public async Task <ActionResult> Create([Bind(Include = "idperson,fname,lname,fathername,mothername,birthday,birthplace,gender,nationality,martial,relationtype,onoffflag,education,educationstate,phone1,phone2,currentaddress,tempregistrationdate,idcenter_FK,formnumber,note,referalreicver_FK,senderevalution,outreachnote")] temporal temporal)
{
var user = db.AspNetUsers.Find(User.Identity.GetUserId());
if (ModelState.IsValid)
{
DateTime now = DateTime.Now;
temporal.tempregistrationdate = now;
temporal.iduser_FK = User.Identity.GetUserId();
temporal.idcenter_FK = db.AspNetUsers.SingleOrDefault(u => u.Id == temporal.iduser_FK).idcenter_FK;
int?maxcenterform = db.temporals.Where(p => p.idcenter_FK == temporal.idcenter_FK).Max(p => p.formnumber) + 1;
if (maxcenterform != null)
{
temporal.formnumber = maxcenterform;
}
else
{
temporal.formnumber = 1;
}
temporal.idperson = temporal.idcenter_FK.ToString() + temporal.formnumber.ToString();
temporal.submittingdate = DateTime.Now;
temporal.referalstate = "Pending";
temporal.servicestate = "Pending";
temporal.iduser_FK = User.Identity.GetUserId();
db.temporals.Add(temporal);
await db.SaveChangesAsync();
// send notification for outreach
string username = db.AspNetUsers.SingleOrDefault(u => u.Id == temporal.referalreicver_FK).UserName;
NotificationHub.sendnotify(username, "added outreach");
return(RedirectToAction("Index"));
}
ViewBag.idcenter_FK = new SelectList(db.centers, "idcenter", "name", temporal.idcenter_FK);
return(View(temporal));
}
public async Task <ActionResult> Edit([Bind(Include = "Id,UserName,ShowName,Email,PasswordHash,PhoneNumber,idcenter_FK,enabled")] AspNetUser aspNetUser, string[] currentSelectedRolesID)//PasswordHash,
{
if (ModelState.IsValid)
{
AspNetUser s = (from sr in db.AspNetUsers.Include("AspNetRoles")
where sr.Id == aspNetUser.Id
select sr).FirstOrDefault <AspNetUser>();
List <AspNetRole> ros = s.AspNetRoles.ToList();
foreach (var r in ros)
{
s.AspNetRoles.Remove(r);
// await db.SaveChangesAsync();
db.SaveChanges();
}
if (db.Entry(s).State != EntityState.Detached)
{
db.Entry(s).State = EntityState.Detached;
}
db.Entry(aspNetUser).State = EntityState.Modified;
foreach (var r in db.AspNetRoles)
{
if (currentSelectedRolesID != null)
{
foreach (string roleId in currentSelectedRolesID)
{
AspNetRole rls = db.AspNetRoles.Find(roleId);
aspNetUser.AspNetRoles.Add(rls);
}
}
}
//(aspNetUser, aspNetUser.PasswordHash);
ApplicationUserManager usrMngr = HttpContext.GetOwinContext().GetUserManager <ApplicationUserManager>();
// IPasswordHasher hash = usrMngr.PasswordHasher;//(aspNetUser, aspNetUser.PasswordHash);
// aspNetUser.PasswordHash = hash.HashPassword(aspNetUser.PasswordHash);
// IdentityResult i = await usrMngr.UpdateSecurityStampAsync(aspNetUser.Id);
aspNetUser.SecurityStamp = Guid.NewGuid().ToString();//usrMngr.GetSecurityStamp(aspNetUser.Id);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
ViewBag.idcenter_FK = new SelectList(db.centers, "idcenter", "name", aspNetUser.idcenter_FK);
var userRoles = aspNetUser.AspNetRoles;
// var userRoles2 = service.AspNetRoles;
// var allRoles = db.AspNetRoles.Where(a => !userRoles.Contains(a));
// var allTempRoles = db.AspNetRoles;
ICollection <AspNetRole> notSelectedRoles = new List <AspNetRole>();
foreach (var role in db.AspNetRoles)
{
if (!userRoles.Contains(role))
{
notSelectedRoles.Add(role);
}
}
var allRoles = notSelectedRoles;
//ViewBag.RolesID = //new MultiSelectList(db.AspNetRoles, "Id", "Name",service.AspNetRoles.AsEnumerable());
ViewBag.SelectedRolesId = userRoles;
ViewBag.NotSelectedRolesId = allRoles;//db.AspNetRoles;
ViewBag.enableOptions = aspNetUser.enabled;
return(View(aspNetUser));
}
public async Task <ActionResult> Create([Bind(Include = "idperson,fname,lname,nationalnumber,fathername,mothername,birthday,birthplace,gender,nationality,martial,relationtype,onoffflag,education,educationstate,phone1,phone2,currentaddress,registrationdate,idfamily_FK,idcenter_FK,note,iduser,evaluation,applicant,family_order_id")] person person, int currentWorkID, int previousWorkID, int[] weaknesses, int[] documents)
{
if (ModelState.IsValid)
{
DateTime now = DateTime.Now;
person.registrationdate = now;
person.iduser = User.Identity.GetUserId();
person.idcenter_FK = db.AspNetUsers.SingleOrDefault(u => u.Id == person.iduser).idcenter_FK;
int?maxPersonId = db.people.Where(f => f.idcenter_FK == person.idcenter_FK).Max(f => (int?)f.idperson);
if (maxPersonId != null)
{
person.idperson = maxPersonId.GetValueOrDefault() + 1;
}
else
{
person.idperson = db.centers.SingleOrDefault(c => c.idcenter == person.idcenter_FK).min_person_id;
}
int?maxcenterform = db.people.Where(p => p.idcenter_FK == person.idcenter_FK).Max(p => p.formnumber) + 1;
if (maxcenterform != null)
{
person.formnumber = maxcenterform;
}
else
{
person.formnumber = 1;
}
db.people.Add(person);
personmanage currentWork = new personmanage()
{
idperson_FK = person.idperson,
idmanagelist_FK = currentWorkID,
eval = "Current",
person = person,
managelist = db.managelists.SingleOrDefault(ml => ml.idmanagelist == currentWorkID)
};
db.personmanages.Add(currentWork);
personmanage previousWork = new personmanage()
{
idperson_FK = person.idperson,
idmanagelist_FK = previousWorkID,
eval = "Previous",
person = person,
managelist = db.managelists.SingleOrDefault(ml => ml.idmanagelist == previousWorkID)
};
db.personmanages.Add(previousWork);
if (weaknesses != null)
{
foreach (var i in weaknesses)
{
personmanage weakness = new personmanage()
{
idperson_FK = person.idperson,
idmanagelist_FK = i,
person = person,
eval = "",
managelist = db.managelists.SingleOrDefault(ml => ml.idmanagelist == i)
};
db.personmanages.Add(weakness);
}
}
if (documents != null)
{
foreach (int i in documents)
{
personmanage document = new personmanage()
{
idperson_FK = person.idperson,
idmanagelist_FK = i,
person = person,
eval = "",
managelist = db.managelists.SingleOrDefault(ml => ml.idmanagelist == i)
};
db.personmanages.Add(document);
}
}
person.family = db.families.SingleOrDefault(f => f.idfamily == person.idfamily_FK);
await db.SaveChangesAsync();
//return RedirectToAction("Create");
//if (person.family.people.Count >= person.family.personcount)
//{
// return RedirectToAction("Index");
//}
return(new JsonResult
{
Data = new
{
idperson = person.idperson,
family_order_id = person.family_order_id,
//fname = person.fname,
//lname = person.lname,
fullname = person.full_name,
//fathername = person.fathername,
mothername = person.mothername,
age = person.age,
gender = person.gender,
idfamily = person.idfamily_FK,
family_book_number = person.family.family_book_number
},
JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
return(new JsonResult {
Data = "Failed"
});
}
public async Task <ActionResult> Create([Bind(Include = "familynature,personcount,lastaddress_details,currentaddress_details,displacementdate,phone1,phone2,note,iduser,lastname,phone1owner,phone2owner,evaluation,family_book_number,family_head")] family family, int currentAddressID, int previousAddressID, int addressTypeID, int idKnowledgeCenter)
{
if (ModelState.IsValid)
{
family.iduser = User.Identity.GetUserId();
family.idcenter_FK = db.AspNetUsers.SingleOrDefault(u => u.Id == family.iduser).idcenter_FK;
int?maxFamilyId = db.families.Where(f => f.idcenter_FK == family.idcenter_FK).Max(f => (int?)f.idfamily);
if (maxFamilyId != null)
{
family.idfamily = maxFamilyId.GetValueOrDefault() + 1;
}
else
{
family.idfamily = db.centers.SingleOrDefault(c => c.idcenter == family.idcenter_FK).min_family_id;
// family.idfamily = db.centers;
}
int?maxcenterform = db.families.Where(p => p.idcenter_FK == family.idcenter_FK).Max(p => p.formnumber) + 1;
if (maxcenterform != null)
{
family.formnumber = maxcenterform;
}
else
{
family.formnumber = 1;
}
family.is_visited = false;
db.families.Add(family);
familymanage currentAddress = new familymanage()
{
idfamily_FK = family.idfamily,
idmanagelist_FK = currentAddressID,
eval = "Current",
family = family,
managelist = db.managelists.SingleOrDefault(ml => ml.idmanagelist == currentAddressID)
};
db.familymanages.Add(currentAddress);
familymanage previousAddress = new familymanage()
{
idfamily_FK = family.idfamily,
idmanagelist_FK = previousAddressID,
eval = "Previous",
family = family,
managelist = db.managelists.SingleOrDefault(ml => ml.idmanagelist == previousAddressID)
};
db.familymanages.Add(previousAddress);
familymanage addressType = new familymanage()
{
idfamily_FK = family.idfamily,
idmanagelist_FK = addressTypeID,
eval = "",
family = family,
managelist = db.managelists.SingleOrDefault(ml => ml.idmanagelist == addressTypeID)
};
db.familymanages.Add(addressType);
familymanage knowledgecenter = new familymanage()
{
idfamily_FK = family.idfamily,
idmanagelist_FK = idKnowledgeCenter,
family = family,
eval = "",
managelist = db.managelists.SingleOrDefault(ml => ml.idmanagelist == idKnowledgeCenter)
};
db.familymanages.Add(knowledgecenter);
// managelist managel = db.managelists.SingleOrDefault(ml => ml.idmanagelist == idmangelist);
// managel.families.Add(family);
await db.SaveChangesAsync();
return(RedirectToAction("Create", "people", new { id = family.idfamily }));
}
ViewBag.evaluationValues = evaluationValues;
ViewBag.familynatureValues = familynatureValues;
//ViewBag.iduser = new SelectList(db.AspNetUsers, "Id", "Email", family.iduser);
return(View(family));
}
public async Task <ActionResult> Create([Bind(Include = "fname,lname,nationalnumber,fathername,mothername,birthday,birthplace,gender,nationality,martial,relationtype,onoffflag,education,educationstate,phone1,phone2,currentaddress,registrationdate,idfamily_FK,idcenter_FK,formnumber,note,iduser,is_secret,evaluation")] person person, int currentWorkID, int previousWorkID, int idKnowledgeCenter, int[] weaknesses, int[] documents
//, DateTime? servicestartdate, string senderevalution,string outreachnote
)
{
DateTime now = DateTime.Now;
person.registrationdate = now;
person.iduser = User.Identity.GetUserId();
person.idcenter_FK = db.AspNetUsers.SingleOrDefault(u => u.Id == person.iduser).idcenter_FK;
int?maxPersonId = db.people.Where(f => f.idcenter_FK == person.idcenter_FK).Max(f => (int?)f.idperson);
if (maxPersonId != null)
{
person.idperson = maxPersonId.GetValueOrDefault() + 1;
}
else
{
person.idperson = db.centers.SingleOrDefault(c => c.idcenter == person.idcenter_FK).min_person_id;
}
int?maxcenterform = db.people.Where(p => p.idcenter_FK == person.idcenter_FK).Max(p => p.formnumber) + 1;
if (maxcenterform != null)
{
person.formnumber = maxcenterform;
}
else
{
person.formnumber = 1;
}
// person.idperson = person.idcenter_FK.ToString() + person.formnumber.ToString();
person.is_secret = true;
if (ModelState.IsValid)
{
db.people.Add(person);
personmanage currentWork = new personmanage()
{
idperson_FK = person.idperson,
idmanagelist_FK = currentWorkID,
eval = "Current",
person = person,
managelist = db.managelists.SingleOrDefault(ml => ml.idmanagelist == currentWorkID)
};
db.personmanages.Add(currentWork);
personmanage previousWork = new personmanage()
{
idperson_FK = person.idperson,
idmanagelist_FK = previousWorkID,
eval = "Previous",
person = person,
managelist = db.managelists.SingleOrDefault(ml => ml.idmanagelist == previousWorkID)
};
db.personmanages.Add(previousWork);
personmanage knowledgecenter = new personmanage()
{
idperson_FK = person.idperson,
idmanagelist_FK = idKnowledgeCenter,
person = person,
eval = "",
managelist = db.managelists.SingleOrDefault(ml => ml.idmanagelist == idKnowledgeCenter)
};
db.personmanages.Add(knowledgecenter);
if (weaknesses != null)
{
foreach (var i in weaknesses)
{
personmanage weakness = new personmanage()
{
idperson_FK = person.idperson,
idmanagelist_FK = i,
person = person,
eval = "",
managelist = db.managelists.SingleOrDefault(ml => ml.idmanagelist == i)
};
db.personmanages.Add(weakness);
}
}
if (documents != null)
{
foreach (int i in documents)
{
personmanage document = new personmanage()
{
idperson_FK = person.idperson,
idmanagelist_FK = i,
person = person,
eval = "",
managelist = db.managelists.SingleOrDefault(ml => ml.idmanagelist == i)
};
db.personmanages.Add(document);
}
}
//referal data
referalperson rp = new referalperson();
//rp.servicestartdate = servicestartdate;
//rp.senderevalution = person.evaluation.ToString();
// rp.outreachnote = person.note;
rp.idperson_FK = person.idperson;
rp.idcenter_FK = person.idcenter_FK;
rp.referaldate = now;
rp.submittingdate = now;
rp.servicestartdate = now;
string idrole = db.AspNetRoles.Where(a => a.Name == "cmSGBV").First().Id;
int idcase = (int)db.AspNetRoles.Where(a => a.Name == "cmSGBV").First().idcase;
int idservice = db.services.Where(a => a.idcase_FK == idcase).First().idservice;
rp.idcase_FK = idcase;
rp.idservice_FK = idservice;
rp.referalstate = "Approved";
rp.servicestate = "In prgress";
person.referalpersons.Add(rp);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
//ViewBag.iduser = new SelectList(db.AspNetUsers, "Id", "Email", person.iduser);
//ViewBag.idcenter_FK = new SelectList(db.centers, "idcenter", "name", person.idcenter_FK);
//ViewBag.idfamily_FK = new SelectList(db.families, "idfamily", "familynature", person.idfamily_FK);
managelists = db.managelists;
works = new SelectList(managelists.Where(ma => ma.flag == "W"), "idmanagelist", "name");
List <IQueryable> weaknesses1 = new List <IQueryable>();
ViewBag.currentWorkID = works;
ViewBag.previousWorkID = works;
ViewBag.idKnowledgeCenter = new SelectList(managelists.Where(ma => ma.flag == "KC"), "idmanagelist", "name");
weaknesses1.Add(managelists.Where(ma => ma.flag == "WM"));
weaknesses1.Add(managelists.Where(ma => ma.flag == "WD"));
weaknesses1.Add(managelists.Where(ma => ma.flag == "WE"));
weaknesses1.Add(managelists.Where(ma => ma.flag == "WC"));
weaknesses1.Add(managelists.Where(ma => ma.flag == "WWD"));
weaknesses1.Add(managelists.Where(ma => ma.flag == "WWF"));
weaknesses1.Add(managelists.Where(ma => ma.flag == "WWS"));
weaknesses1.Add(managelists.Where(ma => ma.flag == "WP"));
weaknesses1.Add(managelists.Where(ma => ma.flag == "WF"));
weaknesses1.Add(managelists.Where(ma => ma.flag == "WL"));
ViewBag.weaknesses = weaknesses1;
ViewBag.genderOptions = gender;
ViewBag.nationalityOptions = nationality;
ViewBag.martialOptions = martial;
ViewBag.educationstate = educationstate;
ViewBag.relationtype = relationtype;
ViewBag.education = education;
ViewBag.documentsOptions = managelists.Where(ml => ml.flag == "D");
return(View(person));
}
