public Transition_Expenses(FundType ft)
{
InitializeComponent();
var i = new Invoice();
var t = i.AddTransition();
t.LeftAccount = new Account {
Id = 1
}; //1 is general fund account id
t.RightAccount = new Account {
Id = 5
}; //5 is expenses account id
if (ft == FundType.GeneralHidden)
{
t.IsHidden = true;
txtMsg1.Visibility = Visibility.Visible;
txtMsg2.Visibility = Visibility.Collapsed;
var r = BaseDataBase._Scalar($@"select dbo.fn_GetHiddenBalance()");
txtBalance.Text = r;
}
else
{
var r = BaseDataBase._Scalar($@"(select
(select isnull(sum(Value),0) from Transition where IsHidden = 0 and RightAccount = 1 -
(select isnull(sum(Value),0) from Transition where IsHidden = 0 and LeftAccount = 1))" );
txtBalance.Text = r;
}
this.DataContext = i;
}
private void btnDelLister_Click(object sender, RoutedEventArgs e)
{
if (dgListers.SelectedIndex != -1)
{
if (!BaseDataBase.CurrentUser.CanDelete)
{
MyMessageBox.Show("ليس لديك صلاحيات للحذف");
}
else
{
Lister l = Lister.GetListerByID((int)(dgListers.Items[dgListers.SelectedIndex] as DataRowView)[0]);
if (int.Parse(BaseDataBase._Scalar("select dbo.GetGroupCountByListerID(" + l.ListerID + ")")) > 0)
{
MyMessageBox.Show("لا يمكن حذف المقيّم \nبسبب وجود بيانات تقييم سابقة له ضمن فرق التقييم");
}
else if (int.Parse(BaseDataBase._Scalar("select COUNT(ID) from Trained where TrainedType = 2 and TrainedID = " + l.ListerID)) > 0)
{
MyMessageBox.Show("لا يمكن حذف المقيّم \nبسبب وجود بيانات تدريب سابقة له");
}
else if (DBMain.DeleteData(l))
{
dgListers.ItemsSource = Lister.GetAllListersTable;
MyMessage.DeleteMessage();
}
}
}
}
private void cmboReciever_Changed(object sender, SelectionChangedEventArgs e)
{
if (IsLoaded)
{
var i = this.DataContext as Invoice;
if ((sender as ComboBox).SelectedIndex == 3)
{
txtReceiver.IsReadOnly = false;
txtReceiverPID.IsReadOnly = false;
i.Receiver = "";
i.ReceiverPID = "";
}
else
{
txtReceiver.IsReadOnly = true;
txtReceiverPID.IsReadOnly = true;
if ((sender as ComboBox).SelectedIndex == 0)
{
i.Receiver = BaseDataBase._Scalar($"select FirstName + ' ' + Isnull(LastName,'') from Parent where FamilyID = {f.FamilyID} and Gender = 'أنثى'");
i.ReceiverPID = BaseDataBase._Scalar($"select IsNull(PID,'') from Parent where FamilyID = {f.FamilyID} and Gender = 'أنثى'");
}
else if ((sender as ComboBox).SelectedIndex == 1)
{
i.Receiver = BaseDataBase._Scalar($"select FirstName + ' ' + Isnull(LastName,'') from Guardian where FamilyID = {f.FamilyID} and Gender = 'أنثى'");
i.ReceiverPID = BaseDataBase._Scalar($"select IsNull(PID,'') from Guardian where FamilyID = {f.FamilyID} and Gender = 'أنثى'");
}
else
{
i.Receiver = BaseDataBase._Scalar($"select FirstName + ' ' + Isnull(LastName,'') from Guardian where FamilyID = {f.FamilyID} and Gender = N'ذكر'");
i.ReceiverPID = BaseDataBase._Scalar($"select IsNull(PID,'') from Guardian where FamilyID = {f.FamilyID} and Gender = N'ذكر'");
}
}
}
}
public Transition_OrphanFamilyWindow(Family f)
{
InitializeComponent();
this.f = f;
txtFamily.Text = f.FamilyCode;
var i = new Invoice();
foreach (var o in f.FamilyOrphans.Where(x => x.Type != "طالب علم" && x.CurrentSponsorship != null))
{
var t = i.AddTransition();
t.RightAccount = o.Account;
t.Value = o.CurrentSponsorship.AvailableSponsorship.SponsorshipValue;
t.Value = o.CurrentSponsorship.IsDouble ? t.Value * 2 : t.Value;
t.Details = "دفعة من صندوق الايتام";
t.LeftAccount = new Account()
{
Id = (o.Type == "يتيم" ? 2 : 3)
}; //the id of ophan fund (2) account or ophan student fund (3) account
t.RelatedSponsorship = o.CurrentSponsorship;
t.RelatedSponsorship.OrphanName = o.FirstName + " " + o.LastName;
t.SponsorshipID = o.CurrentSponsorship.ID;
t.AccountType = (o.Type == "يتيم" ? Account.AccountType.Orphan : Account.AccountType.OrphanStudent); //the ophan type (2) or ophan student type (3)
}
i.Serial = "A";
i.Receiver = BaseDataBase._Scalar($"select FirstName + ' ' + Isnull(LastName,'') from Parent where FamilyID = {f.FamilyID} and Gender = 'أنثى'");
i.ReceiverPID = BaseDataBase._Scalar($"select IsNull(PID,'') from Parent where FamilyID = {f.FamilyID} and Gender = 'أنثى'");
this.DataContext = i;
}
private void btnDelLister_Click(object sender, RoutedEventArgs e)
{
if (dgSupervisor.SelectedIndex != -1)
{
if (!BaseDataBase.CurrentUser.CanDelete)
{
MyMessageBox.Show("ليس لديك صلاحيات للحذف");
}
else
{
Supervisor s = Supervisor.GetSupervisorByID((int)(dgSupervisor.Items[dgSupervisor.SelectedIndex] as DataRowView)[0]);
if (int.Parse(BaseDataBase._Scalar("select dbo.fn_SupervisorOrphansCount(" + s.SupervisorID + ")")) > 0)
{
MyMessageBox.Show("لا يمكن حذف المشرف \nبسبب وجود بيانات إشراف سابقة له");
}
else if (int.Parse(BaseDataBase._Scalar("select COUNT(ID) from Trained where TrainedType = 3 and TrainedID = " + s.SupervisorID)) > 0)
{
MyMessageBox.Show("لا يمكن حذف المشرف \nبسبب وجود بيانات تدريب سابقة له");
}
else
{
if (s.DeleteSupervisorData())
{
dgSupervisor.ItemsSource = Supervisor.GetAllSupervisorTable;
MyMessage.DeleteMessage();
}
}
}
}
}
public FamilyOrderControl(Order order)
{
InitializeComponent();
if (order.FamilyID.HasValue)
{
int.TryParse(BaseDataBase._Scalar($"select Max(Id) from [order] where FamilyID = " + order.FamilyID), out CurrentMaxOrderID);
}
else
{
int.TryParse(BaseDataBase._Scalar($"select Max(Id) from [order] where SpecialFamilyID = " + order.SpecialFamilyID), out CurrentMaxOrderID);
}
this.DataContext = order;
dgOrderItems.ItemsSource = order.OIs;
cmboInventory.ItemsSource = Inventory.GetAllInventory().Where(x => x.IsActive);
if (!order.Id.HasValue)
{
order.Date = BaseDataBase.DateNow;
if (order.Type == 3)
{
// if the order is urgent no need to select NextOrderDate
if (!order.IsUrgentOrder)
{
order.NextOrderDate = order.Date.Value.AddDays(int.Parse(BaseDataBase._Scalar($"select dbo.GetNextOrderDaysByFamilyID({order.FamilyID})")));
//if the NextOrderDate is Friday or Thursday .. change it to Satruday
order.NextOrderDate = order.NextOrderDate.Value.DayOfWeek == DayOfWeek.Thursday || order.NextOrderDate.Value.DayOfWeek == DayOfWeek.Friday ? order.NextOrderDate.Value.AddDays(2) : order.NextOrderDate.Value;
}
btnSelectItems_Click(null, null);
}
}
//if(!order.Id.HasValue)
// i.FamilyNeeds = FamilyNeed_ListerGroup.GetFamilyNeed_ListerGroupBySupportGroupID(-1, i.FamilyID.Value);
// else i.FamilyNeeds = FamilyNeed_ListerGroup.GetFamilyNeed_ListerGroupBySupportGroupID(i.SupportGroupID, i.FamilyID.Value);
}
private void ChekStudySide()
{
int i;
string s = BaseDataBase._Scalar("Select Count(IsLocal) from MergedStudySide where IsLocal = 1");
if (string.IsNullOrEmpty(s))
{
MyMessageBox.Show("حدثت مشكلة في قاعدة البيانات يرجى مراجعة فريق الدعم");
Environment.Exit(Environment.ExitCode);
}
else
{
i = int.Parse(s);
if (i == 0)
{
StudySideInsertControl w = new StudySideInsertControl();
if (!w.ShowDialog() == true)
{
Environment.Exit(Environment.ExitCode);
}
}
else if (i > 1)
{
MyMessageBox.Show("حدثت مشكلة في قاعدة البيانات يرجى مراجعة فريق الدعم");
Environment.Exit(Environment.ExitCode);
}
}
}
internal bool CanRemove()
{
var r = BaseDataBase._Scalar("select count(*) from SpecialCardSource where SpecialCardID = " + ID);
if (!string.IsNullOrEmpty(r) && int.Parse(r) > 0)
{
return(false);
}
return(true);
}
bool CanPresent()
{
var s = BaseDataBase._Scalar($"select isnull(IsPresentable,0) from Sector where id = (select SectorID from Family where FamilyID = {FamilyID})");
if (!string.IsNullOrEmpty(s))
{
return(bool.Parse(s));
}
return(true);
}
private void btnSave_Click(object sender, RoutedEventArgs e)
{
var order = this.DataContext as Order;
if (order.IsValidateMainOrderData() && order.IsValidateOrderItemsData())
{
try
{
// foreach (var item in x.FamilyNeeds)
// if (!item.IsEnsured)
// if (MyMessageBox.Show("لم يتم تأمين كامل احتياجات العائلة .. هل تريد المتابعة", MessageBoxButton.YesNo) != MessageBoxResult.Yes)
// return;
// break;
if (!order.Id.HasValue)
{
//check if there is any other order from other device
int CurrentMaxOrderID_temp = 0;
if (order.FamilyID.HasValue)
{
int.TryParse(BaseDataBase._Scalar("select Max(Id) from [order] where FamilyID=" + order.FamilyID), out CurrentMaxOrderID_temp);
}
else
{
int.TryParse(BaseDataBase._Scalar("select Max(Id) from [order] where SpecialFamilyID=" + order.SpecialFamilyID), out CurrentMaxOrderID_temp);
}
if (CurrentMaxOrderID_temp != 0 && CurrentMaxOrderID_temp != CurrentMaxOrderID)
{
MyMessageBox.Show("لقد تمت اضافة اعانة جديدة من جهاز اخر\nبجب اغلاق النافذة وتحديث البيانات للتحقق\nلايمكن الاضافة");
return;
}
if (Properties.Settings.Default.ActiveFingerPrint && o == null && MyMessageBox.Show("لم يتم اضافة البصمة الالكترونية هل تريد المتابعة", MessageBoxButton.YesNo) != MessageBoxResult.Yes)
{
return;
}
if (Order.InsertData(order))
{
SendFingerPrint(order);
}
}
else if (Order.UpdateData(order))
{
MyMessage.UpdateMessage();
}
Task.Run(() => InsertOrderItems(order));
//PrintOrder(order);
DialogResult = true;
}
catch (Exception ex) { MyMessageBox.Show(ex.Message); }
}
}
private void btnNext_Click(object sender, RoutedEventArgs e)
{
var o = DataContext as Order;
var Id = BaseDataBase._Scalar("select Min(Id) from [order] o where Type in (1,2,5) and Id > " + o.Id);
if (!string.IsNullOrEmpty(Id))
{
SetDataContext(Order.GetOrderByID(int.Parse(Id)));
}
else
{
MyMessageBox.Show("تم الوصول لاخر امر");
}
}
private void btnDelItem_Click(object sender, RoutedEventArgs e)
{
if (dgSelectedItems.SelectedIndex != -1)
{
txtSearch.Text = string.Empty;
Order_Item s = dgSelectedItems.SelectedItem as Order_Item;
var i = s.Item;
if (s.Order != null)
{
double currentQuantity = 0;
double previousQuantity = 0;
if (s.Order.Id.HasValue)
{
double.TryParse(BaseDataBase._Scalar($"select IsNUll(sum(Quantity),0) from Order_Item where ItemId={s.Item.Id} and OrderID = {s.Order.Id}"), out previousQuantity);
}
else
{
previousQuantity = 0;
}
double.TryParse(BaseDataBase._Scalar($"select Quantity from Batch_Item where InventoryID = {s.Order.InventoryID} and ItemID = {s.Item.Id}"), out currentQuantity);
if (s.Order.Type == 1)
{
if (currentQuantity - previousQuantity < (s.Item.MinimumQuantity.HasValue ? s.Item.MinimumQuantity : 0))
{
MyMessageBox.Show($"القيمة الحالية للمادة \"{s.Item.Name}\" هو {currentQuantity}\nبينما الحد الادنى الذي يجب ان يحويه المستودع هو {(s.Item.MinimumQuantity.HasValue ? s.Item.MinimumQuantity : 0)}\nلا يمكن حذف المادة");
return;
}
}
else
{
if (s.Item.MaximumQuantity.HasValue && currentQuantity + previousQuantity > s.Item.MaximumQuantity)
{
MyMessageBox.Show($"القيمة الحالية للمادة \"{s.Item.Name}\" هو {currentQuantity}\nبينما الحد الاعلى الذي يجب ان يحويه المستودع هو {s.Item.MaximumQuantity}\nلا يمكن حذف المادة");
return;
}
}
}
(lbMainItems.ItemsSource as List <Item>).Add(i);
(dgSelectedItems.ItemsSource as List <Order_Item>).Remove(s);
RefreshPanel();
if (s != null)
{
DeletedItems.Add(s);
}
}
}
public static bool InsertData(TempFamily t)
{
t.Creator = BaseDataBase.CurrentUser.Name;
t.ID = BaseDataBase._StoredProcedureReturnable("sp_Add2TempFamily"
, new SqlParameter("@ID", System.Data.SqlDbType.Int)
, new SqlParameter("@FamilyName", t.FamilyName)
, new SqlParameter("@FamilyCode", t.FamilyCode)
, new SqlParameter("@ApplyDate", t.ApplyDate)
, new SqlParameter("@Notes", t.Notes)
, new SqlParameter("@FamilyType", t.FamilyType)
, new SqlParameter("@FamilyIdentityID", t.FamilyIdentityID)
, new SqlParameter("@FatherFirstName", t.FatherFirstName)
, new SqlParameter("@FatherFatherName", t.FatherFatherName)
, new SqlParameter("@FatherLastName", t.FatherLastName)
, new SqlParameter("@FatherBornPlace", t.FatherBornPlace)
, new SqlParameter("@FatherPID", t.FatherPID)
, new SqlParameter("@FatherDOB", t.FatherDOB)
, new SqlParameter("@MotherFirstName", t.MotherFirstName)
, new SqlParameter("@MotherFatherName", t.MotherFatherName)
, new SqlParameter("@MotherLastName", t.MotherLastName)
, new SqlParameter("@MotherBornPlace", t.MotherBornPlace)
, new SqlParameter("@MotherPID", t.MotherPID)
, new SqlParameter("@MotherDOB", t.MotherDOB)
, new SqlParameter("@Phone", t.Phone)
, new SqlParameter("@Mobile1", t.Mobile1)
, new SqlParameter("@Mobile2", t.Mobile2)
, new SqlParameter("@IsPrinted", t.IsPrinted)
, new SqlParameter("@Printer", t.Printer)
, new SqlParameter("@HouseSection", t.HouseSection)
, new SqlParameter("@HouseStreet", t.HouseStreet)
, new SqlParameter("@HouseBuildingNumber", t.HouseBuildingNumber)
, new SqlParameter("@HouseFloor", t.HouseFloor)
, new SqlParameter("@HouseAddress", t.HouseAddress)
, new SqlParameter("@HouseOldAddress", t.HouseOldAddress)
, new SqlParameter("@Creator", t.Creator)
, new SqlParameter("@IsCancelled", t.IsCancelled)
, new SqlParameter("@FamilyPersonCount", t.FamilyPersonCount)
, new SqlParameter("@CancelReason", t.CancelReason)
, new SqlParameter("@FamilyID", t.FamilyID)
);
t.FamilyCode = BaseDataBase._Scalar("select FamilyCode from TempFamily where Id = " + t.ID);
foreach (var tc in t.TempChilds)
{
tc.TempFamilyID = t.ID;
TempChild.InsertData(tc);
}
return(t.ID.HasValue);
}
private void AddSupport_Click(object sender, RoutedEventArgs e)
{
var sf = this.DataContext as SpecialFamily;
if (!sf.Id.HasValue)
{
MyMessageBox.Show("يجب حفظ بيانات العائلة اولاً");
return;
}
if (!BaseDataBase.CurrentUser.CanPresent)
{
MyMessageBox.Show("ليس لديك صلاحية لاضافة اعانة");
}
else
{
int NumberOfDays = 0;
try { NumberOfDays = int.Parse(BaseDataBase._Scalar("select NumberOfDays from NextOrderSpecialFamily")); }
catch { }
if (NumberOfDays != 0)
{
DateTime?MaxOrderDate;
try { MaxOrderDate = (from x in (lvOrders.ItemsSource as List <Order>) where x.Date.HasValue select x.Date).Max(); }
catch { MaxOrderDate = null; }
if (MaxOrderDate.HasValue && (BaseDataBase.DateNow - MaxOrderDate.Value).Days < NumberOfDays)
{
//if (MyMessageBox.Show("متبقي " + (MaxOrderDate.Value - BaseDataBase.DateNow).Days + " ايام للاستلام القادم\nهل تريد المتابعة", MessageBoxButton.YesNo) != MessageBoxResult.Yes)
MyMessageBox.Show("متبقي " + (MaxOrderDate.Value - BaseDataBase.DateNow).Days + " ايام للاستلام القادم");
return;
}
}
Order o = new Order();
o.Type = 4;
o.SpecialFamilyID = sf.Id;
FamilyOrderControl w = new FamilyOrderControl(o);
w.cmboInventory.IsEnabled = true;
if (w.ShowDialog() == true)
{
sf.Orders.Add(w.DataContext as Order);
this.DataContext = null;
this.DataContext = sf;
}
}
}
public static bool InsertData(Order x, bool InsertOrderItems = false)
{
x.LastUserID = BaseDataBase.CurrentUser.ID.Value;
x.Id = BaseDataBase._StoredProcedureReturnable("sp_Add_Order"
, new SqlParameter("@Id", System.Data.SqlDbType.Int)
, new SqlParameter("@InventoryID", x.InventoryID)
, new SqlParameter("@FamilyID", x.FamilyID)
, new SqlParameter("@OrphanID", x.OrphanID)
, new SqlParameter("@SpecialFamilyID", x.SpecialFamilyID)
, new SqlParameter("@Type", x.Type)
, new SqlParameter("@Date", x.Date)
, new SqlParameter("@NextOrderDate", x.NextOrderDate)
, new SqlParameter("@Description", x.Description)
, new SqlParameter("@Source", x.Source)
, new SqlParameter("@InvoiceSerial", x.InvoiceSerial)
, new SqlParameter("@Notes", x.Notes)
, new SqlParameter("@LastUserID", x.LastUserID));
if (InsertOrderItems)
{
foreach (var item in x.OIs)
{
item.Order = x;
Order_Item.InsertData(item);
}
}
x.OrderCode = int.Parse(BaseDataBase._Scalar($"select OrderCode from [Order] where Id = {x.Id}"));
x.BarCode = BaseDataBase._Scalar($"select BarCode from [Order] where Id = {x.Id}");
//if (x.Id.HasValue)
//{
// foreach (var item in x.FamilyNeeds)
// {
// if (item.IsEnsured)
// item.OrderID = x.Id;
// else item.OrderID = null;
// FamilyNeed_ListerGroup.UpdateData(item);
// }
//}
return(x.Id.HasValue);
}
bool CanRemoveOrder(Order o)
{
if (o != null)
{
foreach (var item in o.OIs)
{
double currentQuantity = 0;
double previousQuantity = 0;
if (item.Order.Id.HasValue)
{
double.TryParse(BaseDataBase._Scalar($"select IsNUll(sum(Quantity),0) from Order_Item where ItemId={item.Item.Id} and OrderID = {item.Order.Id}"), out previousQuantity);
}
else
{
previousQuantity = 0;
}
double.TryParse(BaseDataBase._Scalar($"select Quantity from Batch_Item where InventoryID = {item.Order.InventoryID} and ItemID = {item.Item.Id}"), out currentQuantity);
if (o.Type == 1)
{
if (currentQuantity - previousQuantity < (item.Item.MinimumQuantity.HasValue ? item.Item.MinimumQuantity : 0))
{
MyMessageBox.Show($"القيمة الحالية للمادة \"{item.Item.Name}\" هو {currentQuantity}\nبينما الحد الادنى الذي يجب ان يحويه المستودع هو {(item.Item.MinimumQuantity.HasValue ? item.Item.MinimumQuantity : 0)}\nلا يمكن حذف المادة");
return(false);
}
}
else
{
if (item.Item.MaximumQuantity.HasValue && currentQuantity + previousQuantity > item.Item.MaximumQuantity)
{
MyMessageBox.Show($"القيمة الحالية للمادة \"{item.Item.Name}\" هو {currentQuantity}\nبينما الحد الاعلى الذي يجب ان يحويه المستودع هو {item.Item.MaximumQuantity}\nلا يمكن حذف المادة");
return(false);
}
}
}
}
return(true);
}
public Transition_StudentWindow(Orphan o)
{
InitializeComponent();
this.o = o;
txtStudent.Text = o.FirstName + " " + o.LastName;
var i = new Invoice();
var t = i.AddTransition();
t.RightAccount = o.Account;
t.LeftAccount = new Account()
{
Id = 4
}; //4 is the id of student fund account
t.Value = o.CurrentSponsorship.AvailableSponsorship.SponsorshipValue;
t.Value = o.CurrentSponsorship.IsDouble ? t.Value * 2 : t.Value;
t.SponsorshipID = o.CurrentSponsorship.ID;
t.AccountType = Account.AccountType.Student; // 4 is the student type id
txtSponsor.Text = o.CurrentSponsorship.AvailableSponsorship.RelatedSponsor.Name;
i.Serial = "B";
i.Receiver = BaseDataBase._Scalar($"select FirstName + ' ' + Isnull(LastName,'') from Parent where FamilyID = {o.OrphanFamily.FamilyID} and Gender = 'أنثى'");
i.ReceiverPID = BaseDataBase._Scalar($"select IsNull(PID,'') from Parent where FamilyID = {o.OrphanFamily.FamilyID} and Gender = 'أنثى'");
this.DataContext = i;
}
public static string GetUserNameByID(int id)
{
return(BaseDataBase._Scalar("select Name from Users where id =" + id));
}
private void Window_Loaded_1(object sender, RoutedEventArgs e)
{
txtCharity.Text = BaseDataBase._Scalar("select top 1 Name from MergedStudySide where IsLocal = 1");
txtVersion.Text = Assembly.GetExecutingAssembly().GetName().Version.ToString();
}
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 { }
}
}
}
void GetCurrentBalance(int MainId, int CrossID)
{
var r = BaseDataBase._Scalar($@"select dbo.fn_GetCrossAccountBalance({MainId},{CrossID})");
txtCurrentBalance.Text = r;
}
internal static int GetInventoryByFamilyID(int?familyID)
{
try
{
return(int.Parse(BaseDataBase._Scalar($"select InventoryID from Sector where Id = (select SectorID from Family where FamilyID = {familyID})")));
}
catch { return(-1); }
}
internal bool CanRemove()
{
try
{
string sql = $"select(select count(*) from FormedBasket_Sector where SectorID = {ID}) + (select count(*) from Family where SectorID = {ID})";
var result = BaseDataBase._Scalar(sql);
int n;
if (int.TryParse(result, out n) && n > 0)
{
return(false);
}
return(true);
}
catch (Exception ex) { MyMessageBox.Show(ex.Message); return(false); }
}
private bool ValidateAllItems()
{
var o = this.DataContext as Order;
var lst = dgSelectedItems.ItemsSource as List <Order_Item>;
if (o.Type >= 3)//FamilyOrder
{
foreach (var item in lst)
{
if (item.Item.MaxQuantityPerOrder.HasValue && item.Quantity > item.Item.MaxQuantityPerOrder)
{
MyMessageBox.Show($"أعلى كمية ممكن أن تستلمها العائلة من المادة\" {item.Item.Name}\" في اليوم هي " + item.Item.MaxQuantityPerOrder);
return(false);
}
if (item.Item.MaxQuantityPerFamily.HasValue)
{
double sum = 0;
double.TryParse(BaseDataBase._Scalar($"select sum(Quantity) from Order_item where OrderID in (select id from [Order] where IsNull(FamilyID,-1) = {o.FamilyID} and id <> {o.Id ?? -1}) and ItemID = {item.Item.Id}"), out sum);
if (sum + item.Quantity > item.Item.MaxQuantityPerFamily)
{
MyMessageBox.Show($"تم استلام {sum} من المادة \"{item.Item.Name}\" لهذه العائلة سابقاً\nأعلى كمية ممكن ان تستلمها العائلة بشكل اجمالي هو {item.Item.MaxQuantityPerFamily}");
return(false);
}
}
if (item.Item.MaxQuantityPerDay.HasValue)
{
double sum = 0;
double.TryParse(BaseDataBase._Scalar($"select sum(Quantity) from Order_item where OrderID in (select id from [Order] where Type >= 3 and id <> {o.Id ?? -1} and InventoryID = {o.InventoryID} and CONVERT(date, [Date]) = CONVERT(date, GETDATE())) and ItemID = {item.Item.Id}"), out sum);
if (sum + item.Quantity > item.Item.MaxQuantityPerDay)
{
MyMessageBox.Show($"تم تسليم {sum} من المادة \"{item.Item.Name}\" اليوم\nأعلى كمية ممكن تلسيها من هذه المادة في اليوم هو {item.Item.MaxQuantityPerDay }");
return(false);
}
}
}
}
double currentQuantity = 0;
double previousQuantity = 0;
foreach (var item in lst)
{
if (o.Id.HasValue)
{
double.TryParse(BaseDataBase._Scalar($"select IsNUll(sum(Quantity),0) from Order_Item where ItemId={item.Item.Id} and OrderID = {o.Id}"), out previousQuantity);
}
else
{
previousQuantity = 0;
}
double.TryParse(BaseDataBase._Scalar($"select Quantity from Batch_Item where InventoryID = {o.InventoryID} and ItemID = {item.Item.Id}"), out currentQuantity);
if (o.Type == 1)
{
if (item.Item.MaximumQuantity.HasValue && item.Item.MaximumQuantity < currentQuantity - previousQuantity + item.Quantity)
{
MyMessageBox.Show($"القيمة الحالية للمادة \"{item.Item.Name}\" هو {currentQuantity}\nبينما الحد الاعلى الممكن ادخاله الى المستودع هو {item.Item.MaximumQuantity}\nلا يمكن الاضافة");
return(false);
}
}
else
{
if (currentQuantity + previousQuantity == 0 || item.Quantity > currentQuantity + previousQuantity)
{
MyMessageBox.Show($"القيمة الحالية للمادة \"{item.Item.Name}\" هو {currentQuantity}\nلا يمكن الاضافة");
return(false);
}
if (item.Item.MinimumQuantity.HasValue && item.Item.MinimumQuantity > currentQuantity + previousQuantity - item.Quantity)
{
MyMessageBox.Show($"القيمة الحالية للمادة \"{item.Item.Name}\" هو {currentQuantity}\nبينما الحد الادنى الذي يجب ان يحويه المستودع هو {item.Item.MinimumQuantity}\nلا يمكن الاضافة");
return(false);
}
else if (item.Item.WarningQuantity.HasValue && item.Item.WarningQuantity > currentQuantity + previousQuantity - item.Quantity)
{
if (!BaseDataBase.CurrentUser.IsAdmin)
{
MyMessageBox.Show($"القيمة الحالية للمادة \"{item.Item.Name}\" هو {currentQuantity}\nبينما حد التنبيه للمادة هو {item.Item.WarningQuantity}\nلا يمكن الاضافة");
return(false);
}
else
{
if (MyMessageBox.Show($"القيمة الحالية للمادة \"{item.Item.Name}\" هو {currentQuantity}\nبينما حد التنبيه للمادة هو {item.Item.WarningQuantity}\nهل تريد الاضافة بجميع الاحوال؟", MessageBoxButton.YesNo) != MessageBoxResult.Yes)
{
return(false);
}
}
}
}
}
return(true);
}
