//[ValidateAntiForgeryToken]
public object create(string email)
{
//check email not null
//check email not exist
//create emptyform + insert email
if (!string.IsNullOrEmpty(email) && !tblFamilyLogic.checkEmailExist(email) && Regex.IsMatch(email, @"\w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*"))
{
using (tblFamilyLogic family = new tblFamilyLogic())
{
tblFamily c = new tblFamily();
c.parent1Email = email;
c.iAgree = false;
c.parent1GetAlertBycell = false;
c.parent1GetAlertByEmail = false;
c.parent1EmailConfirm = false;
c.parent1CellConfirm = false;
c.parent2GetAlertBycell = false;
c.parent2GetAlertByEmail = false;
c.parent2EmailConfirm = false;
c.parent2CellConfirm = false;
c.paymentOk = false;
c.date = DateTime.Today;
return(View(c));
}
}
else
{
return(Redirect("~/account/unAutorise"));//real check is by Js in client side- if we here there is asecurity problem!
}
}
public ActionResult Index(int id, int?year)//id=familyId
{
using (tblFamilyLogic family = new tblFamilyLogic())
{
using (tblStudentLogic students = new tblStudentLogic())
{
ViewBag.Years = tblYearsLogic.GetYears();
tblFamily c = family.GetFamilyById(id);
if (c != null)
{
List <tblStudent> s;
if (!year.HasValue)
{
s = students.GetStudentByFamilyIdAndYear(id);
}
else
{
s = students.GetStudentByFamilyIdAndYear(id, year.Value);
}
familyViewModel vm = new familyViewModel()
{
EditableTblFamily = c,
students = s
};
return(View(vm));
}
return(null);
}
}
}
public string GetFamily(string id)
{
tblFamily res = null;
using (var logic = new tblFamilyLogic())
{
res = logic.GetFamilyByStudentId(id.Trim());
}
return(JsonConvert.SerializeObject(res));
}
public async Task <ActionResult> ConfirmEmail(string Token, string Email)
{
if (Token != null)
{
Task <string> t = new Task <string>(() =>
{
using (LoginLogic login = new LoginLogic())
{
FormsAuthenticationTicket formsTicket = FormsAuthentication.Decrypt(Token);
int familyId = int.Parse(formsTicket.Name);
string emailHolder = formsTicket.UserData;
// string schoolName = tblSystemLogic.getSystemValueByKey("schoolName").value;
if (!formsTicket.Expired && tblFamilyLogic.checkIfFamilyExist(familyId))//take from db
{
using (tblFamilyLogic family = new tblFamilyLogic())
{
tblFamily c = family.GetFamilyById(familyId);
if (emailHolder == "parent1" && c.parent1Email == Email)
{
c.parent1EmailConfirm = true;
}
if (emailHolder == "parent2" && c.parent2Email == Email)
{
c.parent2EmailConfirm = true;
}
tblFamilyLogic.update(c);
}
// return RedirectToAction("OK");
return("OK");
}
else
{
return("Error");
}
//return RedirectToAction("Error");
}
});
t.Start();
string result = await t;
if (result == "OK")
{
return(RedirectToAction("OK"));
}
else
{
return(RedirectToAction("Error"));
}
}
else
{
return(RedirectToAction("Error"));
}
}
public JsonResult SaveFamily(tblFamily data)
{
data.oneParentOnly = (Request.Form["oneParentOnly"] == "on");
data.parent1GetAlertByEmail = (Request.Form["parent1GetAlertByEmail"] == "on");
data.parent1GetAlertBycell = (Request.Form["parent1GetAlertBycell"] == "on");
data.parent2GetAlertByEmail = (Request.Form["parent2GetAlertByEmail"] == "on");
data.parent2GetAlertBycell = (Request.Form["parent2GetAlertBycell"] == "on");
data.subsidy = (Request.Form["subsidy"] == "on");
var id = 0;
if (data.familyId == 0)
{
id = tblFamilyLogic.createFamily(data);
}
else
{
using (var logic = new tblFamilyLogic())
{
var fm = logic.GetFamilyById(data.familyId);
fm.oneParentOnly = data.oneParentOnly;
fm.parent1Type = data.parent1Type;
fm.parent1FirstName = data.parent1FirstName;
fm.parent1LastName = data.parent1LastName;
fm.parent1Email = data.parent1Email;
fm.parent1GetAlertByEmail = data.parent1GetAlertByEmail;
fm.parent1CellPhone = data.parent1CellPhone;
fm.parent1GetAlertBycell = data.parent1GetAlertBycell;
fm.parent2Type = data.parent2Type;
fm.parent2FirstName = data.parent2FirstName;
fm.parent2LastName = data.parent2LastName;
fm.parent2Email = data.parent2Email;
fm.parent2GetAlertByEmail = data.parent2GetAlertByEmail;
fm.parent2CellPhone = data.parent2CellPhone;
fm.parent2GetAlertBycell = data.parent2GetAlertBycell;
fm.subsidy = data.subsidy;
tblFamilyLogic.update(fm);
}
}
return(null);
}
//[Authorize]
//public JsonResult regPay1(string h)
//{
// return Json(JsonRequestBehavior.AllowGet);
//}
//------------------------------------//
// GET: tblStudent
public ActionResult Index()
{
using (var logic = new tblStudentLogic())
{
ViewBag.Classes = logic.Classes();
ViewBag.Shicvas = logic.Shicvas();
ViewBag.DefaultCityId = logic.DefaultCityId;
}
if (ViewBag.DefaultCityId > 0)
{
using (var logic5 = new tblStreetsLogic())
{
ViewBag.DefaultCity = logic5.GetCityById(ViewBag.DefaultCityId);
}
}
using (var logic2 = new LineLogic())
{
ViewBag.Lines = logic2.GetList();
}
using (var logic3 = new StationsLogic())
{
ViewBag.Stations = logic3.GetList();
}
using (var logic4 = new tblFamilyLogic())
{
ViewBag.Families = JsonConvert.SerializeObject(logic4.GetAll().Select(z => new
{
Id = z.familyId,
Name = z.parent1FirstName + " " + z.parent1LastName +
(z.oneParentOnly ? "" : " / " + z.parent2FirstName + " " + z.parent2LastName)
}));
}
using (var logic5 = new tblSchoolLogic())
{
ViewBag.Schools = JsonConvert.SerializeObject(logic5.GetList().Select(z => new
{
Id = z.id,
Name = z.name
}));
}
return(View());
}
public JsonResult ConfirmCellPhonNumberupdate(string kod, string cellNumber)
{
try
{
string SessioncellNumber = null;
string Sessionkod = null;
if (Session["cellNumber"] != null && Session["kod"] != null)
{
SessioncellNumber = Session["cellNumber"].ToString();
Sessionkod = Session["kod"].ToString();
if (kod == Sessionkod && cellNumber == SessioncellNumber)
{
int familyId = int.Parse(Session["familyId"].ToString());
string phoneHolder = Convert.ToString(Session["phoneHolder"]);
using (tblFamilyLogic family = new tblFamilyLogic())
{
tblFamily c = family.GetFamilyById(familyId);
if (phoneHolder == "parent1cell")
{
c.parent1CellConfirm = true;
}
if (phoneHolder == "parent2cell")
{
c.parent1CellConfirm = true;
}
tblFamilyLogic.update(c);
}
return(Json(0));
}
return(Json(JsonRequestBehavior.DenyGet));
}
return(Json(JsonRequestBehavior.DenyGet));
}
catch
{
return(Json(JsonRequestBehavior.DenyGet));
}
}
public JsonResult ConfirmEmail(string emailHolder)
{
string id = Convert.ToString(Session["familyId"]);
string email = "";
if (emailHolder == "parent1")
{
using (tblFamilyLogic family = new tblFamilyLogic())
{
ViewBag.Years = tblYearsLogic.GetYears();
tblFamily c = family.GetFamilyById(int.Parse(id));
email = c.parent1Email;
}
}
Task <string> x = sendConfirmationEmail(email, emailHolder, id);
//if (x.Result == "ok")
return(Json(new { success = true }));
//else
// return Json(JsonRequestBehavior.DenyGet);
}
