/// <summary>
/// Create a new tblCitizen object.
/// </summary>
/// <param name="firstName">Initial value of the FirstName property.</param>
/// <param name="lastName">Initial value of the LastName property.</param>
/// <param name="nationalNumber">Initial value of the NationalNumber property.</param>
/// <param name="birthday">Initial value of the Birthday property.</param>
/// <param name="birthPlace">Initial value of the BirthPlace property.</param>
/// <param name="amana">Initial value of the Amana property.</param>
/// <param name="kiedPlace">Initial value of the KiedPlace property.</param>
/// <param name="kiedNumber">Initial value of the KiedNumber property.</param>
/// <param name="gender">Initial value of the Gender property.</param>
/// <param name="socialStatus">Initial value of the SocialStatus property.</param>
/// <param name="religion">Initial value of the Religion property.</param>
public static tblCitizen CreatetblCitizen(global::System.String firstName, global::System.String lastName, global::System.String nationalNumber, global::System.String birthday, global::System.String birthPlace, global::System.String amana, global::System.String kiedPlace, global::System.String kiedNumber, global::System.String gender, global::System.String socialStatus, global::System.String religion)
{
tblCitizen tblCitizen = new tblCitizen();
tblCitizen.FirstName = firstName;
tblCitizen.LastName = lastName;
tblCitizen.NationalNumber = nationalNumber;
tblCitizen.Birthday = birthday;
tblCitizen.BirthPlace = birthPlace;
tblCitizen.Amana = amana;
tblCitizen.KiedPlace = kiedPlace;
tblCitizen.KiedNumber = kiedNumber;
tblCitizen.Gender = gender;
tblCitizen.SocialStatus = socialStatus;
tblCitizen.Religion = religion;
return(tblCitizen);
}
/// <summary>
/// Deprecated Method for adding a new object to the tblCitizen EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddTotblCitizen(tblCitizen tblCitizen)
{
base.AddObject("tblCitizen", tblCitizen);
}
private void btnGenerate_Click(object sender, EventArgs e)
{
using (EGovernmentEntities db = new EGovernmentEntities())
{
if (chkClear.Checked)
{
foreach (tblCitizen item in db.tblCitizen)
{
db.tblCitizen.DeleteObject(item);
}
}
Random r = new Random();
List <string> lstNationalNumbers = new List <string>();
for (int i = 0; i < numRows.Value; i++)
{
tblCitizen newCitizen = new tblCitizen();
newCitizen.Gender = (i % 2 == 0) ? "1" : "0";
if (newCitizen.Gender == "1")
{
newCitizen.FirstName = lstMaleNames[r.Next(0, lstMaleNames.Count)];
}
else
{
newCitizen.FirstName = lstFemaleNames[r.Next(0, lstFemaleNames.Count)];
}
newCitizen.LastName = lstMaleNames[r.Next(0, lstMaleNames.Count)];
//newCitizen.FatherName = lstMaleNames[r.Next(0, lstMaleNames.Count)];
//newCitizen.MotherName = lstFemaleNames[r.Next(0, lstFemaleNames.Count)];
newCitizen.NationalNumber = GetNationalNumber(db, lstNationalNumbers);
lstNationalNumbers.Add(newCitizen.NationalNumber);
newCitizen.Birthday = GetRandomDateTime();
newCitizen.BirthPlace = lstGovernorate[r.Next(0, lstGovernorate.Count)];
newCitizen.Amana = "الأمانة المركزية";
newCitizen.KiedPlace = newCitizen.BirthPlace;
newCitizen.KiedNumber = r.Next(1, 60).ToString();
newCitizen.SocialStatus = r.Next(1, 5).ToString();
newCitizen.Religion = lstReligion[r.Next(0, 3)];
db.tblCitizen.AddObject(newCitizen);
}
db.SaveChanges();
foreach (var item in db.tblCitizen)
{
tblCitizen newCitizen;
#region Father
newCitizen = new tblCitizen();
newCitizen.Gender = "1";
newCitizen.SocialStatus = "2";
newCitizen.Religion = lstReligion[r.Next(0, 3)];
newCitizen.KiedPlace = item.KiedPlace;
newCitizen.KiedNumber = item.KiedNumber;
newCitizen.Amana = "الأمانة المركزية";
newCitizen.BirthPlace = newCitizen.KiedPlace;
newCitizen.Birthday = DateTime.Parse(item.Birthday).AddYears(-15).AddMonths(-5).AddDays(-3).ToShortDateString();
newCitizen.LastName = item.LastName;
newCitizen.FirstName = lstMaleNames[r.Next(0, lstMaleNames.Count)];
newCitizen.NationalNumber = GetNationalNumber(db, lstNationalNumbers);
item.FatherNationalNumber = newCitizen.NationalNumber;
lstNationalNumbers.Add(newCitizen.NationalNumber);
db.tblCitizen.AddObject(newCitizen);
#endregion
#region Mother
newCitizen = new tblCitizen();
newCitizen.Gender = "0";
newCitizen.SocialStatus = "2";
newCitizen.Religion = lstReligion[r.Next(0, 3)];
newCitizen.KiedPlace = item.KiedPlace;
newCitizen.KiedNumber = r.Next(1, 60).ToString();
newCitizen.Amana = "الأمانة المركزية";
newCitizen.BirthPlace = newCitizen.KiedPlace;
newCitizen.Birthday = DateTime.Parse(item.Birthday).AddYears(-10).AddMonths(-3).AddDays(-1).ToShortDateString();
newCitizen.LastName = lstMaleNames[r.Next(0, lstMaleNames.Count)];
newCitizen.FirstName = lstFemaleNames[r.Next(0, lstFemaleNames.Count)];
newCitizen.NationalNumber = GetNationalNumber(db, lstNationalNumbers);
item.MotherNationalNumber = newCitizen.NationalNumber;
lstNationalNumbers.Add(newCitizen.NationalNumber);
db.tblCitizen.AddObject(newCitizen);
#endregion
db.tblCitizen.AddObject(newCitizen);
}
db.SaveChanges();
MessageBox.Show("تم الحفظ بنجاح");
}
}