public ActionResult Withdrow(CitizenBalance c)
{
var old = db.CitizenBalances.Find(c.CitizenBalance_id);
old.CitizenBalance_balance -= c.CitizenBalance_balance;
db.SaveChanges();
ViewBag.CitizenBalance_citizen_id = new SelectList(db.Citizens.Where(a => a.citizen_isDeleted != true), "citizen_id", "citizen_national_id");
return(RedirectToAction("Index"));
}
public ActionResult DeleteConfirmed(int id)
{
CitizenBalance citizenBalance = db.CitizenBalances.Find(id);
citizenBalance.CitizenBalance_isDeleted = true;
db.SaveChanges();
return(RedirectToAction("Index"));
}
// GET: CitizenBalances/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
CitizenBalance citizenBalance = db.CitizenBalances.Find(id);
if (citizenBalance == null)
{
return(HttpNotFound());
}
return(View(citizenBalance));
}
// GET: CitizenBalances/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
CitizenBalance citizenBalance = db.CitizenBalances.Find(id);
if (citizenBalance == null)
{
return(HttpNotFound());
}
ViewBag.CitizenBalance_citizen_id = new SelectList(db.Citizens.Where(a => a.citizen_isDeleted != true), "citizen_id", "citizen_national_id");
return(View(citizenBalance));
}
public ActionResult Create(CitizenBalance citizenBalance)
{
if (ModelState.IsValid)
{
var data = db.CitizenBalances.Where(a => a.CitizenBalance_citizen_id == citizenBalance.CitizenBalance_citizen_id).SingleOrDefault();
if (data != null)
{
ViewBag.errbalance = Languages.Language.citizen_balance;
ViewBag.CitizenBalance_citizen_id = new SelectList(db.Citizens.Where(a => a.citizen_isDeleted != true), "citizen_id", "citizen_national_id");
return(View(citizenBalance));
}
db.CitizenBalances.Add(citizenBalance);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CitizenBalance_citizen_id = new SelectList(db.Citizens.Where(a => a.citizen_isDeleted != true), "citizen_id", "citizen_national_id");
return(View(citizenBalance));
}
public ActionResult Edit(CitizenBalance citizenBalance)
{
if (ModelState.IsValid)
{
var data = db.CitizenBalances.Where(a => a.CitizenBalance_citizen_id != citizenBalance.CitizenBalance_citizen_id);
foreach (var item in data)
{
if (item.CitizenBalance_citizen_id == citizenBalance.CitizenBalance_citizen_id)
{
ViewBag.errbalance = Languages.Language.citizen_balance;
ViewBag.CitizenBalance_citizen_id = new SelectList(db.Citizens.Where(a => a.citizen_isDeleted != true), "citizen_id", "citizen_national_id");
return(View());
}
}
db.Entry(citizenBalance).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CitizenBalance_citizen_id = new SelectList(db.Citizens, "citizen_id", "citizen_national_id");
return(View(citizenBalance));
}
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();
try
{
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 + "_" + Guid.NewGuid() + Path.GetExtension(f1.file.FileName);
string filePath = Server.MapPath("~/DocumentDataURL/" + filename);
if (!Directory.Exists(filePath))
{
Directory.CreateDirectory(filePath);
}
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);
}
catch (Exception e)
{
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 + "_" + Guid.NewGuid() + Path.GetExtension(f1.file.FileName);
string filePath = "D:\\App\\DocumentDataURL\\" + filename;
if (!Directory.Exists(filePath))
{
Directory.CreateDirectory(filePath);
}
f1.file.SaveAs(filePath);
//==================================================
d.document_citizen_id = s.citizen_id;
//==========================
d.document_data = filePath;
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();
CitizenBalance citizenbalance = new CitizenBalance();
citizenbalance.CitizenBalance_citizen_id = s.citizen_id;
citizenbalance.CitizenBalance_balance = 0;
db.CitizenBalances.Add(citizenbalance);
db.SaveChanges();
Session["success"] = Languages.Language.CitizenAddedSuccessfully;
return(RedirectToAction("Index", "home"));
}
return(View());
}
