public ActionResult AddNewAddressCreate(Address address, int?asas)
{
ViewBag.State = new SelectList(db.States.Where(a => a.state_isDeleted != true), "state_id", "state_name");
if (Session["lang"] != null)
{
if (Session["lang"].ToString().Equals("ar-EG"))
{
ViewBag.State = new SelectList(db.States.Where(a => a.state_isDeleted != true), "state_id", "state_arabic_name");
}
}
var data = (
from ad in db.AddressCitizens
from cit in db.Citizens
from addd in db.Addresses.Where(a => a.address_id == ad.CA_AddressId &&
asas == ad.CA_CitizenId && a.address_isCurrent == true && asas == cit.citizen_id
)
select new
{
addd.address_isCurrent,
addd.address_district_id,
addd.address_street,
addd.address_id
}
).SingleOrDefault();
if (data != null)
{
if (data.address_district_id == address.address_district_id && data.address_street == address.address_street)
{
ViewBag.asas = new SelectList(db.Citizens.Where(a => a.citizen_isDeleted != true), "citizen_id", "citizen_national_id");
ViewBag.addressmsg = Languages.Language.Citizen_already_has_this_address;
ViewBag.address_district_id = new SelectList(db.Districts, "district_id", "district_name");
return(View());
}
var old = db.Addresses.Find(data.address_id);
old.address_isCurrent = false;
address.address_isCurrent = true;
db.Addresses.Add(address);
db.SaveChanges();
AddressCitizen aa = new AddressCitizen();
aa.CA_AddressId = address.address_id;
aa.CA_CitizenId = (int)asas;
db.AddressCitizens.Add(aa);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.asas = new SelectList(db.Citizens.Where(a => a.citizen_isDeleted != true), "citizen_id", "citizen_national_id");
ViewBag.addressmsg = Languages.Language.Citizen_already_has_this_address;
ViewBag.address_district_id = new SelectList(db.Districts, "district_id", "district_name");
return(View());
}
public ActionResult ConfirmIndex(Citizen s, Address address, string inlineDefaultRadiosExample, int?State, Upload f1)
{
var fatherName = db.Citizens.Find(s.citizen_father_id);
s.citizen_second_name = fatherName.citizen_first_name;
s.citizen_third_name = fatherName.citizen_second_name;
s.citizen_fourth_name = fatherName.citizen_third_name;
s.citizen_second_name_arabic = fatherName.citizen_first_name_arabic;
s.citizen_third_name_arabic = fatherName.citizen_second_name_arabic;
s.citizen_fourth_name_arabic = fatherName.citizen_third_name_arabic;
s.TransactionDate = DateTime.Now;
db.Citizens.Add(s);
db.SaveChanges();
if (ModelState.IsValid)
{
if (inlineDefaultRadiosExample == "WithF")
{
var data = (
from ad in db.AddressCitizens
from cit in db.Citizens
from addd in db.Addresses.Where(a => a.address_id == ad.CA_AddressId &&
s.citizen_father_id == ad.CA_CitizenId && a.address_isCurrent == true && s.citizen_father_id == cit.citizen_id
)
select new
{
addd.address_district_id,
addd.address_id,
addd.address_isBirthPlace,
addd.address_isCurrent,
addd.address_isDelete,
addd.address_street,
addd.address_street_arabic
}
).SingleOrDefault();
address.address_district_id = data.address_district_id;
address.address_isBirthPlace = data.address_isBirthPlace;
address.address_isCurrent = data.address_isCurrent;
address.address_street = data.address_street;
address.address_street_arabic = data.address_street_arabic;
}
if (inlineDefaultRadiosExample == "WithM")
{
var data = (
from ad in db.AddressCitizens
from cit in db.Citizens
from addd in db.Addresses.Where(a => a.address_id == ad.CA_AddressId &&
s.citizen_mother_id == ad.CA_CitizenId && a.address_isCurrent == true && s.citizen_mother_id == cit.citizen_id
)
select new
{
addd.address_district_id,
addd.address_id,
addd.address_isBirthPlace,
addd.address_isCurrent,
addd.address_isDelete,
addd.address_street,
addd.address_street_arabic
}
).SingleOrDefault();
address.address_district_id = data.address_district_id;
address.address_isBirthPlace = data.address_isBirthPlace;
address.address_isCurrent = data.address_isCurrent;
address.address_street = data.address_street;
address.address_street_arabic = data.address_street_arabic;
}
db.Addresses.Add(address);
db.SaveChanges();
AddressCitizen c = new AddressCitizen();
c.CA_AddressId = address.address_id;
c.CA_CitizenId = s.citizen_id;
db.AddressCitizens.Add(c);
db.SaveChanges();
Document d = new Document();
var fff = db.Document_Type.Find(f1.document_documentType_id);
d.document_documentType_id = f1.document_documentType_id;
string filename = s.citizen_national_id + "_" + fff.document_type_name + "_" + f1.file.FileName + Path.GetExtension(f1.file.FileName);
string filePath = Server.MapPath("~/DocumentDataURL/" + filename);
string filePathName = Path.Combine(filename, filePath);
f1.file.SaveAs(filePathName);
//==================================================
d.document_citizen_id = s.citizen_id;
//==========================
d.document_data = filePathName;
d.document_name = filename;
d.document_date_upload = DateTime.Now.ToString();
//===============================
// int l = filename.Length;
// string length = filename.Substring(l - 3, 3);
d.document_extensions = Path.GetExtension(f1.file.FileName);
//=========================================
// d.document_id = 0;
db.Documents.Add(d);
db.SaveChanges();
LoginCitizen log = new LoginCitizen();
log.Login_CitizenId = s.citizen_id;
log.Login_CitizenNId = s.citizen_national_id;
var pp = Encrypt.enc(s.citizen_national_id);
log.Login_Password = pp;
log.Login_QRcode = pp;
db.LoginCitizens.Add(log);
db.SaveChanges();
return(RedirectToAction("Index", "home"));
}
return(View());
}
public ActionResult Create(Address address, string inlineDefaultRadiosExample, int NId, int?State)
{
var stat = db.States.Find(State);
var ddd = db.Citizens.Find(NId);
int?father = ddd.citizen_father_id;
int?mother = ddd.citizen_mother_id;
ViewBag.address_district_id = new SelectList(db.Districts, "district_id", "district_name", address.address_district_id);
if (inlineDefaultRadiosExample == "WithF")
{
var data = (
from ad in db.AddressCitizens
from cit in db.Citizens
from addd in db.Addresses.Where(a => a.address_id == ad.CA_AddressId &&
father == ad.CA_CitizenId && a.address_isCurrent == true && father == cit.citizen_id
)
select new
{
addd.address_district_id,
addd.address_id,
addd.address_isBirthPlace,
addd.address_isCurrent,
addd.address_isDelete,
addd.address_street,
}
).SingleOrDefault();
address.address_district_id = data.address_district_id;
address.address_isBirthPlace = data.address_isBirthPlace;
address.address_isCurrent = data.address_isCurrent;
address.address_street = data.address_street;
}
if (inlineDefaultRadiosExample == "WithM")
{
var data = (
from ad in db.AddressCitizens
from cit in db.Citizens
from addd in db.Addresses.Where(a => a.address_id == ad.CA_AddressId &&
mother == ad.CA_CitizenId && a.address_isCurrent == true && mother == cit.citizen_id
)
select new
{
addd.address_district_id,
addd.address_id,
addd.address_isBirthPlace,
addd.address_isCurrent,
addd.address_isDelete,
addd.address_street,
}
).SingleOrDefault();
address.address_district_id = data.address_district_id;
address.address_isBirthPlace = data.address_isBirthPlace;
address.address_isCurrent = data.address_isCurrent;
address.address_street = data.address_street;
}
if (inlineDefaultRadiosExample == "other")
{
address.address_isCurrent = true;
}
//======================================
var iscurrent = (
from citi in db.Citizens
from ad in db.AddressCitizens
from add in db.Addresses.Where(a => a.address_id == ad.CA_AddressId &&
ad.CA_CitizenId == NId && citi.citizen_id == NId
)
select new
{
add.address_id,
add.address_isCurrent
}
).ToList();
Address isCur = new Address();
IEnumerable <Address> m_oEnum = new Address[] { };
IEnumerable <bool> i = new bool[] { };
bool aa = false;
int id = 0;
foreach (var item in iscurrent)
{
if (item.address_isCurrent == true)
{
aa = item.address_isCurrent;
id = item.address_id;
}
}
var d1 = db.Addresses.Where(a => a.address_id == id && a.address_isCurrent == aa).Select(a => a.address_id).SingleOrDefault();
var old = db.Addresses.Find(id);
if (old != null)
{
old.address_isCurrent = false;
}
db.Addresses.Add(address);
db.SaveChanges();
AddressCitizen c = new AddressCitizen();
c.CA_AddressId = address.address_id;
c.CA_CitizenId = NId;
db.AddressCitizens.Add(c);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Create(Address address, string inlineDefaultRadiosExample, int?State)
{
string sssss = inlineDefaultRadiosExample;
Session["asas"] = sssss;
var stat = db.States.Find(State);
string nationalId = "";
if (stat == null)
{
var fatherid1 = db.Citizens.Find(Convert.ToInt32(Session["FId"]));
string a = fatherid1.citizen_national_id.Substring(0, 2);
DateTime birthdate1 = Convert.ToDateTime(Session["BirthDate"]);
nationalId = GenerateNationalId(a, birthdate1);
}
else
{
DateTime birthdate = Convert.ToDateTime(Session["BirthDate"]);
nationalId = GenerateNationalId(stat.state_code, birthdate);
}
//--------------------------
Citizen s = new Citizen();
s.citizen_national_id = nationalId;
if (Session["FId"] != null)
{
s.citizen_father_id = Convert.ToInt32(Session["FId"]);
}
if (Session["MId"] != null)
{
s.citizen_mother_id = Convert.ToInt32(Session["MId"]);
}
//----------------------------------------------------------
var fatherid = db.Citizens.Find(s.citizen_father_id);
if (fatherid != null)
{
s.citizen_second_name = fatherid.citizen_first_name; //|
s.citizen_third_name = fatherid.citizen_second_name; //|
s.citizen_fourth_name = fatherid.citizen_third_name;
s.citizen_second_name_arabic = fatherid.citizen_first_name_arabic; //|
s.citizen_third_name_arabic = fatherid.citizen_second_name_arabic; //|
s.citizen_fourth_name_arabic = fatherid.citizen_third_name_arabic;
Session["second"] = fatherid.citizen_first_name;
Session["third"] = fatherid.citizen_second_name;
Session["fourth"] = fatherid.citizen_third_name;
Session["secondArabic"] = fatherid.citizen_first_name_arabic;
Session["thirdArabic"] = fatherid.citizen_second_name_arabic;
Session["fourthArabic"] = fatherid.citizen_third_name_arabic;
}
//|
//----------------------------------------------------------
s.citizen_birthDate = Convert.ToDateTime(Session["BirthDate"]);
s.citizen_first_name = Session["FirstName"].ToString();
s.citizen_relegion = Session["relegion"].ToString();
s.citizen_gender = Session["gender"].ToString();
s.citizen_birthPlace = Session["BirthPlace"].ToString();
s.citizen_id = 0;
db.Citizens.Add(s);
Session["kjkj"] = s;
// db.SaveChanges();
ViewBag.address_district_id = new SelectList(db.Districts, "district_id", "district_name", address.address_district_id);
if (inlineDefaultRadiosExample == "WithF")
{
var data = (
from ad in db.AddressCitizens
from cit in db.Citizens
from addd in db.Addresses.Where(a => a.address_id == ad.CA_AddressId &&
s.citizen_father_id == ad.CA_CitizenId && a.address_isCurrent == true && s.citizen_father_id == cit.citizen_id
)
select new
{
addd.address_district_id,
addd.address_id,
addd.address_isBirthPlace,
addd.address_isCurrent,
addd.address_isDelete,
addd.address_street,
addd.address_street_arabic
}
).SingleOrDefault();
Session["fatherAddress"] = data;
address.address_district_id = data.address_district_id;
Session["FatherDistrictId"] = data.address_district_id;
address.address_isBirthPlace = data.address_isBirthPlace;
address.address_isCurrent = data.address_isCurrent;
address.address_street = data.address_street;
address.address_street_arabic = data.address_street_arabic;
// db.Addresses.Add(address);
//db.SaveChanges();
Session["AddressDistrictIdFF"] = address.address_district_id;
Session["AddressIsBirthPlaceFF"] = address.address_isBirthPlace;
Session["AddressIsCurrentFF"] = address.address_isCurrent;
Session["AddresStreetFF"] = address.address_street;
Session["AddresStreetFFArabic"] = address.address_street_arabic;
}
if (inlineDefaultRadiosExample == "WithM")
{
var data = (
from ad in db.AddressCitizens
from cit in db.Citizens
from addd in db.Addresses.Where(a => a.address_id == ad.CA_AddressId &&
s.citizen_mother_id == ad.CA_CitizenId && a.address_isCurrent == true && s.citizen_mother_id == cit.citizen_id
)
select new
{
addd.address_district_id,
addd.address_id,
addd.address_isBirthPlace,
addd.address_isCurrent,
addd.address_isDelete,
addd.address_street,
addd.address_street_arabic
}
).SingleOrDefault();
address.address_district_id = data.address_district_id;
Session["motherdistrictid"] = data.address_district_id;
address.address_isBirthPlace = data.address_isBirthPlace;
address.address_isCurrent = data.address_isCurrent;
address.address_street = data.address_street;
address.address_street_arabic = data.address_street_arabic;
//db.Addresses.Add(address);
// db.SaveChanges();
Session["AddressDistrictIdMM"] = address.address_district_id;
Session["AddressIsBirthPlaceMM"] = address.address_isBirthPlace;
Session["AddressIsCurrentMM"] = address.address_isCurrent;
Session["AddresStreetMM"] = address.address_street;
Session["AddresStreetMMArabic"] = address.address_street_arabic;
}
if (inlineDefaultRadiosExample == "other")
{
address.address_isCurrent = true;
Session["AddresStreetOO"] = address.address_street;
Session["AddresStreetOOArabic"] = address.address_street_arabic;
Session["IsCurrenOO"] = address.address_isCurrent;
Session["disId"] = address.address_district_id;
// db.Addresses.Add(address);
// db.SaveChanges();
}
AddressCitizen c = new AddressCitizen();
c.CA_AddressId = address.address_id;
Session["address"] = address.address_id;
c.CA_CitizenId = s.citizen_id;
db.AddressCitizens.Add(c);
//db.SaveChanges();
Session["CID"] = s.citizen_id;
Session["Nai"] = nationalId;
return(RedirectToAction("Create", "Document"));
}
public ActionResult ConfirmIndex()
{
string www = Session["Nai"].ToString();
var validate = db.Citizens.Where(a => a.citizen_national_id == www).SingleOrDefault();
if (validate != null)
{
Session["success"] = Languages.Language.CitizenAlreadExist;
return(RedirectToAction("Index", "home"));
}
Citizen c = new Citizen();
//-----------------citizen infooo----------------------------
if (Session["second"] != null)
{
c.citizen_second_name = Session["second"].ToString();
}
//third
if (Session["third"] != null)
{
c.citizen_third_name = Session["third"].ToString();
}
//fourth
if (Session["fourth"] != null)
{
c.citizen_fourth_name = Session["fourth"].ToString();
}
if (Session["secondArabic"] != null)
{
c.citizen_second_name_arabic = Session["secondArabic"].ToString();
}
if (Session["thirdArabic"] != null)
{
c.citizen_third_name_arabic = Session["thirdArabic"].ToString();
}
if (Session["fourthArabic"] != null)
{
c.citizen_fourth_name_arabic = Session["fourthArabic"].ToString();
}
if (Session["FirstName"] != null)
{
c.citizen_first_name = Session["FirstName"].ToString();
}
if (Session["FirstNameArabic"] != null)
{
c.citizen_first_name_arabic = Session["FirstNameArabic"].ToString();
}
if (Session["FId"] != null)
{
c.citizen_father_id = Convert.ToInt32(Session["FId"]);
}
if (Session["MId"] != null)
{
c.citizen_mother_id = Convert.ToInt32(Session["MId"]);
}
c.citizen_birthDate = Convert.ToDateTime(Session["BirthDate"]);
c.citizen_relegion = Session["relegion"].ToString();
if (Session["gender"] != null)
{
if (Session["gender"].ToString().Equals("Male") || Session["gender"].ToString().Equals("ذكر"))
{
Session["gender"] = "Male";
}
else if (Session["gender"].ToString().Equals("Female") || Session["gender"].ToString().Equals("انثى"))
{
Session["gender"] = "Female";
}
}
if (Session["relegion"] != null)
{
if (Session["relegion"].ToString() == "Muslim" || Session["relegion"].ToString() == "مسلم")
{
Session["relegion"] = "Muslim";
}
else if (Session["relegion"].ToString() == "Cristian" || Session["relegion"].ToString() == "مسيحي")
{
Session["relegion"] = "Cristian";
}
else if (Session["relegion"].ToString() == "Jewish" || Session["relegion"].ToString() == "يهودي")
{
Session["relegion"] = "Jewish";
}
}
c.citizen_relegion = Session["relegion"].ToString();
c.citizen_gender = Session["gender"].ToString();
c.citizen_birthPlace = Session["BirthPlace"].ToString();
c.citizen_birthPlace_arabic = Session["BirthPlaceArabic"].ToString();
c.citizen_national_id = Session["Nai"].ToString();
db.Citizens.Add(c);
db.SaveChanges();
//----------------------Addresses------------------------------
string aa = Session["asas"].ToString();
Address ad = new Address();
if (aa == "WithF")
{
ad.address_district_id = Convert.ToInt32(Session["AddressDistrictIdFF"]);
ad.address_isBirthPlace = Convert.ToBoolean(Session["AddressIsBirthPlaceFF"]);
ad.address_isCurrent = Convert.ToBoolean(Session["AddressIsCurrentFF"]);
ad.address_street = Session["AddresStreetFF"].ToString();
ad.address_street_arabic = Session["AddresStreetFFArabic"].ToString();
db.Addresses.Add(ad);
db.SaveChanges();
}
if (aa == "WithM")
{
ad.address_district_id = Convert.ToInt32(Session["AddressDistrictIdMM"]);
ad.address_isBirthPlace = Convert.ToBoolean(Session["AddressIsBirthPlaceMM"]);
ad.address_isCurrent = Convert.ToBoolean(Session["AddressIsCurrentMM"]);
ad.address_street_arabic = Session["AddresStreetMMArabic"].ToString();
db.Addresses.Add(ad);
db.SaveChanges();
}
if (aa == "other")
{
ad.address_street = Session["AddresStreetOO"].ToString();
ad.address_street_arabic = Session["AddresStreetOOArabic"].ToString();
ad.address_isCurrent = Convert.ToBoolean(Session["IsCurrenOO"]);
ad.address_district_id = Convert.ToInt32(Session["disId"]);
db.Addresses.Add(ad);
db.SaveChanges();
}
//-------------------Address citizen m To m ----------------------
AddressCitizen cc = new AddressCitizen();
cc.CA_AddressId = ad.address_id;
cc.CA_CitizenId = c.citizen_id;
db.AddressCitizens.Add(cc);
db.SaveChanges();
//----------------------------Documents--------------------------
Document doc = new Document();
doc.document_name = Session["filename"].ToString();
doc.document_extensions = Session["extension"].ToString();
doc.document_documentType_id = Convert.ToInt32(Session["documentTypeName"]);
doc.document_data = Session["docData"].ToString();
doc.document_citizen_id = c.citizen_id;
doc.document_date_upload = Session["uploadDate"].ToString();
db.Documents.Add(doc);
db.SaveChanges();
//---------------------- Login Citizen table ---------------------
LoginCitizen log = new LoginCitizen();
// qr code consist of datetime now , datetime seconds , datetime milliseconds , first name and national id
log.Login_CitizenNId = c.citizen_national_id;
string pass = Encrypt.enc(c.citizen_national_id);
log.Login_Password = pass;
log.Login_PinNumber = "1234";
log.Login_CitizenId = c.citizen_id;
string qr = Encrypt.enc(DateTime.Now.ToString() + "_" + DateTime.Now.Second + "_" + DateTime.Now.Millisecond + "_" + c.citizen_first_name + "_" + c.citizen_national_id);
log.Login_QRcode = qr;
db.LoginCitizens.Add(log);
db.SaveChanges();
//--------------------------------------- Live Status -------------------------
Live_Status live = new Live_Status();
live.live_satus_type_id = 1;
live.citizen_citizen_id = c.citizen_id;
db.Live_Status.Add(live);
db.SaveChanges();
Session["success"] = Languages.Language.CitizenAddedSuccessfully;
return(RedirectToAction("Index", "home"));
}
