private void save_Click(object sender, RoutedEventArgs e)
{
if (lstData.SelectedItems.Count <= 0)
{
MyMessageBox.Show("لم يتم اختيار أي قيمة للتعديل");
return;
}
if (txtUpdatedValue.Text.Trim() == "")
{
MyMessageBox.Show("يجب ادخال القيمة الجديدة");
return;
}
if (MyMessageBox.Show("هل تريد تأكيد تعديل البيانات", MessageBoxButton.YesNo) == MessageBoxResult.Yes)
{
string query = "Update " + (column == "Job" || column == "HealthStatus" ? "Parent" : "House") + " set " + column + " = '" + txtUpdatedValue.Text.Replace("\'", "").Trim() + "' where " + column + " in (";
foreach (string item in lstData.SelectedItems)
{
query += "'" + item.Replace("\'", "") + "',";
}
query = query.Remove(query.Length - 1) + ")";
MyMessageBox.Show("تم تعديل " + BaseDataBase._NonQuery(query) + " قيمة في قاعدة البيانات");
lstData.ItemsSource = column == "" ? null : BaseDataBase.GetAllStrings("Select Distinct " + column + " from " + (column == "Job" || column == "HealthStatus" ? "Parent" : "House") + " order by " + column);
}
}
public static bool UpdateData(FormedBasket x)
{
BaseDataBase._NonQuery("delete from FormedBasket_Item where FormedBasket_Item.FormedBasketID = " + x.Id);
bool b = BaseDataBase._StoredProcedure("sp_Update_FormedBasket"
, new SqlParameter("@Id", x.Id)
, new SqlParameter("@Name", x.Name)
, new SqlParameter("@IsActive", x.IsActive)
, new SqlParameter("@IsUrgent", x.IsUrgent)
, new SqlParameter("@Notes", x.Notes)
, new SqlParameter("@LastUserID", BaseDataBase.CurrentUser.ID));
foreach (var item in x.FormedBasketItems)
{
if (item.FormedBasket == null)
{
item.FormedBasket = x;
}
FormedBasket_Item.InsertData(item);
}
if (x.id.HasValue)
{
FormedBasket_Sector.SaveFormedBasketSectors(x);
}
return(b);
}
internal static bool DeleteFormedBasketSectors(FormedBasket fb)
{
try
{
BaseDataBase._NonQuery("delete from FormedBasket_Sector where FormedBasketID = " + fb.Id.Value);
return(true);
}
catch (Exception ex) { MyMessageBox.Show(ex.Message); return(false); }
}
public class FormedBasket_Sector : ModelViewContext
{
public static bool SaveFormedBasketSectors(FormedBasket fb)
{
try
{
BaseDataBase._NonQuery("delete from FormedBasket_Sector where FormedBasketID = " + fb.Id.Value);
foreach (var sector in fb.RelatedSectors)
{
BaseDataBase._NonQuery($"INSERT INTO [dbo].[FormedBasket_Sector]([FormedBasketID],[SectorID],[LastUserID]) VALUES({fb.Id}, {sector.ID}, {BaseDataBase.CurrentUser.ID})");
}
return(true);
}
catch (Exception ex) { MyMessageBox.Show(ex.Message); return(false); }
}
private void btnSave_Click(object sender, RoutedEventArgs e)
{
if (radGeneral.IsChecked == true)
{
var lst = dg.ItemsSource as List <NextOrderCriteria>;
foreach (var item in lst)
{
if (!item.IsValidate() || !AllValidated(lst))
{
return;
}
}
string query = "delete from NextOrderCriteria;";
foreach (var item in lst)
{
query += $"insert into NextOrderCriteria (FromMember,ToMember,NumberOfDays,LastUserID) Values ({item.FromMember},{item.ToMember},{item.NumberOfDays},{BaseDataBase.CurrentUser.ID});";
}
if (BaseDataBase._NonQuery(query) > 0)
{
MyMessage.CustomMessage("تم الحفظ بنجاح");
}
SystemProperties.UpdateData(SystemProperties.Property.NextOrderSpecialFamily, "");
if (nudDaysSpecialFamily.Value.HasValue)
{
SystemProperties.UpdateData(SystemProperties.Property.NextOrderSpecialFamily, nudDaysSpecialFamily.Value.ToString());
}
SystemProperties.UpdateData(SystemProperties.Property.NextOrderGap, "");
if (nudDaysSpecialFamily.Value.HasValue)
{
SystemProperties.UpdateData(SystemProperties.Property.NextOrderGap, nudNextOrderGap.Value.ToString());
}
DialogResult = true;
}
else
{
if (dgSector.Items.Count > 0)
{
var lst = dgSector.ItemsSource as List <Sector>;
foreach (var item in lst)
{
Sector.UpdateData(item);
}
DialogResult = true;
MyMessage.UpdateMessage();
}
}
}
private void btnSave_Click(object sender, RoutedEventArgs e)
{
string query = "delete from VoucherCriteria; \n";
foreach (var item in VoucherGruopItems)
{
foreach (var i in item.Value)
{
query += string.Format("insert into VoucherCriteria Values ({0},{1},{2}); \n", i.Id, item.Key, BaseDataBase.CurrentUser.ID);
}
}
if (BaseDataBase._NonQuery(query) > 0)
{
MyMessage.InsertMessage();
DialogResult = true;
}
}
private void bw2_DoWork(object sender, DoWorkEventArgs e)
{
var bw = sender as BackgroundWorker;
DataTable dt = e.Argument as DataTable;
Family f = new Family();
f.FamilyType = dt.TableName;
House h = new House();
for (int i = 0; i < dt.Rows.Count; i++)
{
f.FamilyCode = dt.DefaultView[i]["ID"].ToString();
f.FamilyName = dt.DefaultView[i]["Name"].ToString() != "" ? dt.DefaultView[i]["Name"].ToString() : dt.DefaultView[i]["WifeName"].ToString();
f.FamilyFather.FirstName = dt.DefaultView[i]["Name"].ToString();
f.FamilyFather.PID = dt.DefaultView[i]["PID"].ToString();
f.FamilyMother.FirstName = dt.DefaultView[i]["WifeName"].ToString();
f.FamilyMother.PID = dt.DefaultView[i]["WifePID"].ToString();
f.FamilyIdentityID = dt.DefaultView[i]["FamilyBookID"].ToString() + ((dt.DefaultView[i]["FamilyBookChar"].ToString() == "") ? "" : ((" " + dt.DefaultView[i]["FamilyBookChar"].ToString()) + ((dt.DefaultView[i]["FamilyNumber"].ToString() == "") ? "" : " " + dt.DefaultView[i]["FamilyNumber"].ToString())));
if (f.FamilyIdentityID == "")
{
f.FamilyIdentityID = "لايوجد دفتر عائلة";
}
f.FamilyPersonCount = dt.DefaultView[i]["FamilyMemberCount"].ToString();
f.FamilyFather.Phone = dt.DefaultView[i]["Phone"].ToString();
f.FamilyFather.Mobile = dt.DefaultView[i]["Mobile"].ToString();
f.FamilyStatus = dt.DefaultView[i]["FamilyStatus"].ToString();
h.OldAddress = dt.DefaultView[i]["BasePlace"].ToString();
h.Address = dt.DefaultView[i]["CurrentPlace"].ToString();
f.Notes = dt.DefaultView[i]["Notes"].ToString();
f.Evaluation = dt.DefaultView[i]["Evaluation"].ToString();
f.ApplyDate = BaseDataBase.DateNow;
List <FamilyPerson> fps = new List <FamilyPerson>();
int b1 = dt.DefaultView[i]["Baby1"] is DBNull ? 0 : (int)dt.DefaultView[i]["Baby1"];
int b2 = dt.DefaultView[i]["Baby2"] is DBNull ? 0 : (int)dt.DefaultView[i]["Baby2"];
int b3 = dt.DefaultView[i]["Baby3"] is DBNull ? 0 : (int)dt.DefaultView[i]["Baby3"];
int m1 = dt.DefaultView[i]["Male1"] is DBNull ? 0 : (int)dt.DefaultView[i]["Male1"];
int m2 = dt.DefaultView[i]["Male2"] is DBNull ? 0 : (int)dt.DefaultView[i]["Male2"] - 1;
int f1 = dt.DefaultView[i]["Female1"] is DBNull ? 0 : (int)dt.DefaultView[i]["Female1"];
int f2 = dt.DefaultView[i]["Female2"] is DBNull ? 0 : (int)dt.DefaultView[i]["Female2"];
int f3 = dt.DefaultView[i]["Female3"] is DBNull ? 0 : (int)dt.DefaultView[i]["Female3"];
if (f3 > 0)
{
f3--;
f.FamilyMother.DOB = BaseDataBase.DateNow.AddYears(-50);
f.FamilyFather.DOB = BaseDataBase.DateNow.AddYears(-55);
}
else
{
f2--;
f.FamilyMother.DOB = BaseDataBase.DateNow.AddYears(-30);
f.FamilyFather.DOB = BaseDataBase.DateNow.AddYears(-40);
}
int index = 0;
while (b1 > 0)
{
b1--;
FamilyPerson fp = new FamilyPerson();
fp.FirstName = "الابن " + ++index;
fp.DOB = BaseDataBase.DateNow.AddMonths(-2);
if (m1 > 0)
{
m1--; fp.Gender = "ذكر";
}
else
{
f1--; fp.Gender = "أنثى";
}
fps.Add(fp);
}
while (b2 > 0)
{
b2--;
FamilyPerson fp = new FamilyPerson();
fp.FirstName = "الابن " + ++index;
fp.DOB = BaseDataBase.DateNow.AddMonths(-10);
if (m1 > 0)
{
m1--; fp.Gender = "ذكر";
}
else
{
f1--; fp.Gender = "أنثى";
}
fps.Add(fp);
}
while (b3 > 0)
{
b3--;
FamilyPerson fp = new FamilyPerson();
fp.FirstName = "الابن " + ++index;
fp.DOB = BaseDataBase.DateNow.AddMonths(-18);
if (m1 > 0)
{
m1--; fp.Gender = "ذكر";
}
else
{
f1--; fp.Gender = "أنثى";
}
fps.Add(fp);
}
while (m1 > 0)
{
m1--;
FamilyPerson fp = new FamilyPerson();
fp.FirstName = "الابن " + ++index;
fp.DOB = BaseDataBase.DateNow.AddYears(-8);
fp.Gender = "ذكر";
fps.Add(fp);
}
while (m2 > 0)
{
m2--;
FamilyPerson fp = new FamilyPerson();
fp.FirstName = "الابن " + ++index;
fp.DOB = BaseDataBase.DateNow.AddYears(-15);
fp.Gender = "ذكر";
fps.Add(fp);
}
while (f1 > 0)
{
f1--;
FamilyPerson fp = new FamilyPerson();
fp.FirstName = "الابن " + ++index;
fp.DOB = BaseDataBase.DateNow.AddYears(-8);
fp.Gender = "أنثى";
fps.Add(fp);
}
while (f2 > 0)
{
f2--;
FamilyPerson fp = new FamilyPerson();
fp.FirstName = "الابن " + ++index;
fp.DOB = BaseDataBase.DateNow.AddYears(-15);
fp.Gender = "أنثى";
fps.Add(fp);
}
while (f3 > 0)
{
f3--;
FamilyPerson fp = new FamilyPerson();
fp.FirstName = "الابن " + ++index;
fp.DOB = BaseDataBase.DateNow.AddYears(-50);
fp.Gender = "أنثى";
fps.Add(fp);
}
f.FamilyID = BaseDataBase._StoredProcedureReturnable("sp_Add2FamilyHilal"
, new SqlParameter("@FamilyID", SqlDbType.Int)
, new SqlParameter("@FamilyCode", f.FamilyCode)
, new SqlParameter("@FamilyName", f.FamilyName)
, new SqlParameter("@FamilyType", f.FamilyType)
, new SqlParameter("@FamilyIdentityID", f.FamilyIdentityID)
, new SqlParameter("@ApplyDate", f.ApplyDate)
, new SqlParameter("@FamilyPersonCount", f.FamilyPersonCount)
, new SqlParameter("@FamilyStatus", f.FamilyStatus)
, new SqlParameter("@Evaluation", f.Evaluation)
, new SqlParameter("@Notes", f.Notes)
, new SqlParameter("@Phone", f.FamilyFather.Phone)
, new SqlParameter("@Mobile", f.FamilyFather.Mobile)
, new SqlParameter("@FirstNameF", f.FamilyFather.FirstName)
, new SqlParameter("@DOBF", f.FamilyFather.DOB)
, new SqlParameter("@PIDF", f.FamilyFather.PID)
, new SqlParameter("@FirstNameM", f.FamilyMother.FirstName)
, new SqlParameter("@DOBM", f.FamilyMother.DOB)
, new SqlParameter("@PIDM", f.FamilyMother.PID)
, new SqlParameter("@OldAddress", h.OldAddress)
, new SqlParameter("@Address", h.Address));
int ChildID = int.Parse(BaseDataBase._Scalar("select IsNull(Max(FamilyPersonID)+1,1) from FamilyPerson"));
for (int j = 0; j < fps.Count; j++)
{
string s = string.Format("insert into FamilyPerson(FamilyPersonID,FamilyID,FirstName,Gender,DOB) values ({0},{1},'{2}','{3}',",
ChildID + j, f.FamilyID, fps[j].FirstName, fps[j].Gender);
if (fps[j].DOB.HasValue)
{
s += "'" + fps[j].DOB.Value.ToString("MM/dd/yyyy") + "')";
}
else
{
s += "null)";
}
BaseDataBase._NonQuery(s);
}
bw.ReportProgress(i);
}
}
private void btnSaveTable_Click(object sender, RoutedEventArgs e)
{
if (dgExcelFile.ItemsSource != null && dgExcelFile.Items.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
Family f = new Family();
House h = new House();
List <FamilyPerson> fps = new List <FamilyPerson>();
try
{
if (dt.DefaultView[i][1].ToString() == "")
{
continue;
}
f.FamilyCode = dt.DefaultView[i][1].ToString();
f.FamilyType = dt.DefaultView[i][2].ToString();
f.FamilyIdentityID = dt.DefaultView[i][3].ToString();
if (dt.DefaultView[i][4].ToString() != "")
{
f.FamilyIdentityID += " " + dt.DefaultView[i][4].ToString();
if (dt.DefaultView[i][5].ToString() != "")
{
f.FamilyIdentityID += " " + dt.DefaultView[i][5].ToString();
}
}
f.ApplyDate = GetDate(dt.DefaultView[i][6].ToString());
f.FamilyPersonCount = dt.DefaultView[i][7].ToString();
f.FamilyName = dt.DefaultView[i][8].ToString();
f.Notes = dt.DefaultView[i][9].ToString();
f.FamilyFather.FirstName = dt.DefaultView[i][10].ToString();
f.FamilyFather.FatherName = dt.DefaultView[i][11].ToString();
f.FamilyFather.LastName = dt.DefaultView[i][12].ToString();
f.FamilyFather.BirthPlace = dt.DefaultView[i][13].ToString();
f.FamilyFather.DOB = GetDate(dt.DefaultView[i][14].ToString());
f.FamilyFather.PID = dt.DefaultView[i][15].ToString();
f.FamilyMother.FirstName = dt.DefaultView[i][16].ToString();
f.FamilyMother.FatherName = dt.DefaultView[i][17].ToString();
f.FamilyMother.LastName = dt.DefaultView[i][18].ToString();
f.FamilyMother.BirthPlace = dt.DefaultView[i][19].ToString();
f.FamilyMother.DOB = GetDate(dt.DefaultView[i][20].ToString());
f.FamilyMother.PID = dt.DefaultView[i][21].ToString();
h.Address = dt.DefaultView[i][22].ToString() + ((dt.DefaultView[i][23].ToString().Trim() == "") ? "" : (" بناء " + dt.DefaultView[i][23].ToString())) + ((dt.DefaultView[i][24].ToString().Trim() == "") ? "" : " طابق " + dt.DefaultView[i][24].ToString());
h.HouseType = dt.DefaultView[i][25].ToString();
f.FamilyFather.Phone = dt.DefaultView[i][26].ToString();
f.FamilyFather.Mobile = dt.DefaultView[i][27].ToString();
h.OldAddress = dt.DefaultView[i][28].ToString();
int j = 29;
while (dt.DefaultView[i][j].ToString().Trim() != "")
{
FamilyPerson c = new FamilyPerson();
c.FirstName = dt.DefaultView[i][j].ToString();
c.DOB = GetDate(dt.DefaultView[i][j + 1].ToString());
c.Gender = (dt.DefaultView[i][j + 2].ToString() == "ذ") ? "ذكر" : "أنثى";
j += 3;
fps.Add(c);
}
string temp = BaseDataBase._Scalar("select FamilyID from Family where FamilyCode = '" + f.FamilyCode + "'");
if (string.IsNullOrEmpty(temp))
{
f.FamilyID = null;
f.FamilyID = BaseDataBase._StoredProcedureReturnable("sp_Add2Family4Aleppo"
, new SqlParameter("@FamilyID", SqlDbType.Int)
, new SqlParameter("@FamilyCode", f.FamilyCode)
, new SqlParameter("@FamilyName", f.FamilyName)
, new SqlParameter("@FamilyType", f.FamilyType)
, new SqlParameter("@FamilyIdentityID", f.FamilyIdentityID)
, new SqlParameter("@ApplyDate", f.ApplyDate)
, new SqlParameter("@FamilyPersonCount", f.FamilyPersonCount)
, new SqlParameter("@FamilyStatus", f.FamilyStatus)
, new SqlParameter("@Evaluation", f.Evaluation)
, new SqlParameter("@Notes", f.Notes)
, new SqlParameter("@Phone", f.FamilyFather.Phone)
, new SqlParameter("@Mobile", f.FamilyFather.Mobile)
, new SqlParameter("@FirstNameFF", f.FamilyFather.FirstName)
, new SqlParameter("@FirstNameFFa", f.FamilyFather.FatherName)
, new SqlParameter("@FirstNameFL", f.FamilyFather.LastName)
, new SqlParameter("@BirthPlaceF", f.FamilyFather.BirthPlace)
, new SqlParameter("@DOBF", f.FamilyFather.DOB)
, new SqlParameter("@PIDF", f.FamilyFather.PID)
, new SqlParameter("@FirstNameMF", f.FamilyMother.FirstName)
, new SqlParameter("@FirstNameMFa", f.FamilyMother.FatherName)
, new SqlParameter("@FirstNameML", f.FamilyMother.LastName)
, new SqlParameter("@BirthPlaceM", f.FamilyMother.BirthPlace)
, new SqlParameter("@DOBM", f.FamilyMother.DOB)
, new SqlParameter("@PIDM", f.FamilyMother.PID)
, new SqlParameter("@OldAddress", h.OldAddress)
, new SqlParameter("@Address", h.Address));
if (!f.FamilyID.HasValue)
{
MessageBox.Show("خطأ في بيانات العائلة " + f.FamilyName + "\nذات الرقم " + f.FamilyCode);
continue;
}
}
else
{
f.FamilyID = int.Parse(temp);
if (!BaseDataBase._StoredProcedure("sp_Add2Family4Aleppo1"
, new SqlParameter("@FamilyID", f.FamilyID)
, new SqlParameter("@FamilyCode", f.FamilyCode)
, new SqlParameter("@FamilyName", f.FamilyName)
, new SqlParameter("@FamilyType", f.FamilyType)
, new SqlParameter("@FamilyIdentityID", f.FamilyIdentityID)
, new SqlParameter("@ApplyDate", f.ApplyDate)
, new SqlParameter("@FamilyPersonCount", f.FamilyPersonCount)
, new SqlParameter("@FamilyStatus", f.FamilyStatus)
, new SqlParameter("@Evaluation", f.Evaluation)
, new SqlParameter("@Notes", f.Notes)
, new SqlParameter("@Phone", f.FamilyFather.Phone)
, new SqlParameter("@Mobile", f.FamilyFather.Mobile)
, new SqlParameter("@FirstNameFF", f.FamilyFather.FirstName)
, new SqlParameter("@FirstNameFFa", f.FamilyFather.FatherName)
, new SqlParameter("@FirstNameFL", f.FamilyFather.LastName)
, new SqlParameter("@BirthPlaceF", f.FamilyFather.BirthPlace)
, new SqlParameter("@DOBF", f.FamilyFather.DOB)
, new SqlParameter("@PIDF", f.FamilyFather.PID)
, new SqlParameter("@FirstNameMF", f.FamilyMother.FirstName)
, new SqlParameter("@FirstNameMFa", f.FamilyMother.FatherName)
, new SqlParameter("@FirstNameML", f.FamilyMother.LastName)
, new SqlParameter("@BirthPlaceM", f.FamilyMother.BirthPlace)
, new SqlParameter("@DOBM", f.FamilyMother.DOB)
, new SqlParameter("@PIDM", f.FamilyMother.PID)
, new SqlParameter("@OldAddress", h.OldAddress)
, new SqlParameter("@Address", h.Address)))
{
MessageBox.Show("خطأ في بيانات العائلة " + f.FamilyName + "\nذات الرقم " + f.FamilyCode);
continue;
}
}
BaseDataBase._NonQuery("delete from child where FamilyID = " + f.FamilyID);
foreach (var item in fps)
{
item.FamilyID = f.FamilyID;
DBMain.InsertData(item);
}
}
catch { }
}
}
}
