public ActionResult UpdateSPPending(int?id)
{
SoloParent c = db.SoloParents.FirstOrDefault(s => s.SoloParentId == id);
if (c == null)
{
return(HttpNotFound());
}
else
{
c.Status = "Pending";
db.SaveChanges();
#region SMS NOTIF
if (c.Client.MobileNumbers != null)
{
MobileNumber mb = c.Client.MobileNumbers.FirstOrDefault(m => m.IsDisabled == false && m.Token != null);
if (mb != null)
{
try
{
SMS(mb.MobileNo, "Hello " + c.Client.GivenName + ", your Solo Parent Application is now Pending.");
}
catch (Exception e)
{
Trace.TraceInformation(e.Message);
}
}
}
#endregion
return(RedirectToAction("Index", new { }));
}
}
public ActionResult DeleteConfirmed(int id)
{
SoloParent soloParent = db.SoloParents.Find(id);
db.SoloParents.Remove(soloParent);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "SoloParentId,Status,CreatedByUserId,VerifiedByUserId,DateCreated,InterviewDate,ApplicationDate,ApprovalDate,ReleaseDate")] SoloParent soloParent)
{
if (ModelState.IsValid)
{
db.Entry(soloParent).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(soloParent));
}
// GET: SoloParents/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
SoloParent soloParent = db.SoloParents.Find(id);
if (soloParent == null)
{
return(HttpNotFound());
}
return(View(soloParent));
}
public ActionResult UpdateSPReleaseDate()
{
int id = Convert.ToInt16(Request.Form["SoloParentId"]);
string unparsedDate = Request.Form["Date"];
DateTime date = DateTime.Parse(unparsedDate);
SoloParent c = db.SoloParents.FirstOrDefault(s => s.SoloParentId == id);
if (c == null)
{
return(HttpNotFound());
}
else
{
c.ReleaseDate = date;
db.SaveChanges();
#region SMS NOTIF
if (c.Client.MobileNumbers != null)
{
MobileNumber mb = c.Client.MobileNumbers.FirstOrDefault(m => m.IsDisabled == false && m.Token != null);
if (mb != null)
{
try
{
SMS(mb.MobileNo, "Hello " + c.Client.GivenName + ", the release date for Solo Parent ID is on " + date + ".");
}
catch (Exception e)
{
Trace.TraceInformation(e.Message);
}
}
}
#endregion
return(RedirectToAction("Index", new { }));
}
}
public ActionResult ApplySP(ClientEditModel ce)
{
/*
* Client newClient = new Client(ce);
*
* ClaimsIdentity identity = (ClaimsIdentity)User.Identity;
* IEnumerable<Claim> claims = identity.Claims;
*
* newClient.CityId = Convert.ToInt16(claims.FirstOrDefault(c => c.Type == "CityId").Value);
* newClient.DateCreated = DateTime.UtcNow.AddHours(8);
*
* db.Clients.Add(newClient);
*
* SoloParent newSC = new SoloParent();
* newSC.Status = "Pending";
* newSC.Client = newClient;
* newSC.ApplicationDate = newClient.DateCreated;
*
* db.SoloParents.Add(newSC);
*
* if (ce.ClientBeneficiaries != null)
* {
* ce.ClientBeneficiaries.ForEach(c => c.ClientId = newClient.ClientId);
* ce.ClientBeneficiaries.ForEach(c => db.ClientBeneficiary.Add(c));
* }
*
* string email = User.Identity.GetUserName();
* ApplicationUser au = db.Users.FirstOrDefault(u => u.UserName == email);
*
* au.ClientId = newClient.ClientId;
*
* List<Requirement> rl = new List<Requirement>{
* new Requirement { ClientId = newClient.ClientId, IsDone = false, Name = "Solo Parent Baranggay Certificate", Description = "Baranggay Certificate" },
* new Requirement { ClientId = newClient.ClientId, IsDone = false, Name = "Solo Parent Proof of Financial Status", Description = "Payslip, Bank Transactions" },
* new Requirement { ClientId = newClient.ClientId, IsDone = false, Name = "Solo Parent Supporting Document", Description = "Nullity of Marriage, Death Certificate" },
* new Requirement { ClientId = newClient.ClientId, IsDone = false, Name = "Solo Parent Birth Certificate (Children)", Description = "Birth Certificate of your child/children" },
* };
*
* db.Requirements.AddRange(rl);
*
* if (db.SaveChanges() > 1)
* {
* return RedirectToAction("Requirements", "Clients", null);
* }
* else
* {
* return View(ce);
* }
*/
string username = User.Identity.GetUserName();
ApplicationUser au = db.Users.FirstOrDefault(u => u.UserName == username);
SoloParent newSC = new SoloParent();
if (au.Client != null)
{
// if existing client
#region MODIFY CLIENT PROPERTIES
au.Client.BirthDate = ce.BirthDate;
au.Client.BirthPlace = ce.BirthPlace;
au.Client.Citizenship = ce.Citizenship;
au.Client.CityAddress = ce.CityAddress;
au.Client.CivilStatus = ce.CivilStatus;
au.Client.ContactNumber = ce.ContactNumber;
au.Client.DateOfMarriage = ce.DateOfMarriage;
au.Client.Gender = ce.Gender;
au.Client.Occupation = ce.Occupation;
au.Client.PlaceOfMarriage = ce.PlaceOfMarriage;
au.Client.ProvincialAddress = ce.ProvincialAddress;
au.Client.Religion = ce.Religion;
au.Client.SpouseBirthDate = ce.SpouseBirthDate;
au.Client.SpouseBluCardNo = ce.SpouseBluCardNo;
au.Client.SpouseName = ce.SpouseName;
au.Client.StartOfResidency = ce.StartOfResidency;
au.Client.TypeOfResidency = ce.TypeOfResidency;
#endregion
// save modifications
db.SaveChanges();
// add sc
newSC.Status = "Pending";
newSC.Client = au.Client;
newSC.ApplicationDate = au.Client.DateCreated;
db.SoloParents.Add(newSC);
// add beneficiaries
if (ce.ClientBeneficiaries != null)
{
ce.ClientBeneficiaries.ForEach(c => c.ClientId = au.ClientId.Value);
ce.ClientBeneficiaries.ForEach(c => db.ClientBeneficiary.Add(c));
}
// add requirements
List <Requirement> rl = new List <Requirement> {
new Requirement {
ClientId = au.Client.ClientId, IsDone = false, Name = "Solo Parent Baranggay Certificate", Description = "Baranggay Certificate"
},
new Requirement {
ClientId = au.Client.ClientId, IsDone = false, Name = "Solo Parent Proof of Financial Status", Description = "Payslip, Bank Transactions"
},
new Requirement {
ClientId = au.Client.ClientId, IsDone = false, Name = "Solo Parent Supporting Document", Description = "Nullity of Marriage, Death Certificate"
},
new Requirement {
ClientId = au.Client.ClientId, IsDone = false, Name = "Solo Parent Birth Certificate (Children)", Description = "Birth Certificate of your child/children"
},
};
db.Requirements.AddRange(rl);
// save
if (db.SaveChanges() > 1)
{
return(RedirectToAction("Requirements", "Clients", null));
}
else
{
return(View(ce));
}
}
else
{
// add client
Client newClient = new Client(ce);
ClaimsIdentity identity = (ClaimsIdentity)User.Identity;
IEnumerable <Claim> claims = identity.Claims;
newClient.CityId = Convert.ToInt16(claims.FirstOrDefault(c => c.Type == "CityId").Value);
newClient.DateCreated = DateTime.UtcNow.AddHours(8);
db.Clients.Add(newClient);
// add sc
newSC.Status = "Pending";
newSC.Client = newClient;
newSC.ApplicationDate = newClient.DateCreated;
db.SoloParents.Add(newSC);
// add beneficiaries
if (ce.ClientBeneficiaries != null)
{
ce.ClientBeneficiaries.ForEach(c => c.ClientId = newClient.ClientId);
ce.ClientBeneficiaries.ForEach(c => db.ClientBeneficiary.Add(c));
}
au.ClientId = newClient.ClientId;
// add requirements
List <Requirement> rl = new List <Requirement> {
new Requirement {
ClientId = newClient.ClientId, IsDone = false, Name = "Solo Parent Baranggay Certificate", Description = "Baranggay Certificate"
},
new Requirement {
ClientId = newClient.ClientId, IsDone = false, Name = "Solo Parent Proof of Financial Status", Description = "Payslip, Bank Transactions"
},
new Requirement {
ClientId = newClient.ClientId, IsDone = false, Name = "Solo Parent Supporting Document", Description = "Nullity of Marriage, Death Certificate"
},
new Requirement {
ClientId = newClient.ClientId, IsDone = false, Name = "Solo Parent Birth Certificate (Children)", Description = "Birth Certificate of your child/children"
}
};
db.Requirements.AddRange(rl);
// save
if (db.SaveChanges() > 1)
{
return(RedirectToAction("Requirements", "Clients", null));
}
else
{
return(View(ce));
}
}
}
