void save()
{
if (txtName.Text.Trim() == string.Empty || txtPass.Text.Trim() == string.Empty || txtUser.Text.Trim() == string.Empty)
{
MessageBox.Show("الرجاء عدم ترك حقول فارغة");
return;
}
if (user.id == 0)
{
db = new DAL.dbDataContext();
db.users.InsertOnSubmit(user);
SetData();
db.SubmitChanges();
}
else
{
SetData();
db.SubmitChanges();
}
MessageBox.Show("تم الحفظ بنجاح");
dgvUsers.DataSource = db.users;
New();
}
public override void Save()
{
if (!IsDataValidated())
{
return;
}
var db = new DAL.dbDataContext();
DAL.Account account;
if (cusVendor.ID == 0)
{
db.CustomersAndVendors.InsertOnSubmit(cusVendor);
account = new DAL.Account();
db.Accounts.InsertOnSubmit(account);
}
else
{
db.CustomersAndVendors.Attach(cusVendor);
account = db.Accounts.Single(s => s.ID == cusVendor.AccountID);
}
SetData();
account.Name = cusVendor.Name;
db.SubmitChanges();
cusVendor.AccountID = account.ID;
db.SubmitChanges();
base.Save();
}
public override void Save()
{
if (txt_Name.Text.Trim() == String.Empty)
{
txt_Name.ErrorText = "برجاء ادخال اسم الخزنة";
return;
}
var db = new DAL.dbDataContext();
DAL.Account account;
if (drawer.ID == 0)
{
account = new DAL.Account();
db.Drawers.InsertOnSubmit(drawer);
db.Accounts.InsertOnSubmit(account);
}
else
{
db.Drawers.Attach(drawer);
account = db.Accounts.Single(s => s.ID == drawer.AccountID);
}
SetData();
account.Name = drawer.Name;
db.SubmitChanges();
drawer.AccountID = account.ID;
db.SubmitChanges();
base.Save();
}
void save()
{
if (Cmb_stores.SelectedValue == null)
{
MessageBox.Show("الرجاء اختيار مخزن");
return;
}
var db = new DAL.dbDataContext();
if (movement_header.id == 0)
{
movement_header = new DAL.movements_header();
db.movements_headers.InsertOnSubmit(movement_header);
SetData();
db.SubmitChanges();
}
foreach (DataGridViewRow row in dgvItems.Rows)
{
movement = new DAL.movement();
movement.movements_header = movement_header;
movement.item_id = Convert.ToInt32(row.Cells["item_id"].Value);
movement.unit_id = Convert.ToInt32(row.Cells["unit_id"].Value);
movement.qty = Convert.ToDecimal(row.Cells["qty"].Value);
//movement.qty_unit = Convert.ToDecimal(row.Cells["unit_qty"].Value);
db.movements.InsertOnSubmit(movement);
db.SubmitChanges();
}
MessageBox.Show("تم الحفظ بنجاح");
New();
}
public override void Save()
{
if (textEdit1.Text.Trim() == string.Empty)
{
textEdit1.ErrorText = "برجاء ادخال اسم الفرع";
return;
}
DAL.Account SalesAccount = new DAL.Account();
DAL.Account SalesReturnAccount = new DAL.Account();
DAL.Account InventoryAccount = new DAL.Account();
DAL.Account CostOfSoldGoodsAccont = new DAL.Account();
var db = new DAL.dbDataContext();
if (store.ID == 0)
{
db.Stores.InsertOnSubmit(store);
db.Accounts.InsertOnSubmit(SalesAccount);
db.Accounts.InsertOnSubmit(SalesReturnAccount);
db.Accounts.InsertOnSubmit(InventoryAccount);
db.Accounts.InsertOnSubmit(CostOfSoldGoodsAccont);
store.DiscountAllowedAccountID = Session.Defaults.DiscountAllowedAccount;
store.DiscountReveiedAccountID = Session.Defaults.DiscountReceivedAccount;
}
else
{
db.Stores.Attach(store);
SalesAccount = db.Accounts.Single(x => x.ID == store.SalesAccountID);
SalesReturnAccount = db.Accounts.Single(x => x.ID == store.SalesReturnAccountID);
InventoryAccount = db.Accounts.Single(x => x.ID == store.InventoryAccountID);
CostOfSoldGoodsAccont = db.Accounts.Single(x => x.ID == store.CostOfSoldGoodsAccountID);
}
SetData();
SalesAccount.Name = store.Name + "- مبيعات";
SalesReturnAccount.Name = store.Name + "- مردود مبيعات";
InventoryAccount.Name = store.Name + "- المخزون";
CostOfSoldGoodsAccont.Name = store.Name + "- تكلفه البضاعه المباعه";
db.SubmitChanges();
store.SalesAccountID = SalesAccount.ID;
store.SalesReturnAccountID = SalesReturnAccount.ID;
store.InventoryAccountID = InventoryAccount.ID;
store.CostOfSoldGoodsAccountID = CostOfSoldGoodsAccont.ID;
db.SubmitChanges();
base.Save();
}
private void btnSave_Click(object sender, EventArgs e)
{
if (txtName.Text.Trim() == string.Empty)
{
MessageBox.Show("الرجاء عدم ترك حقل الاسم فارغ");
return;
}
if (Cmb_stores.SelectedValue == null)
{
MessageBox.Show("الرجاء اختيار مخزن");
return;
}
if (Cmb_stores.SelectedValue == null)
{
MessageBox.Show("الرجاء اختيار وحدة رئيسية");
return;
}
if (item.id == 0)
{
db = new DAL.dbDataContext();
db.items.InsertOnSubmit(item);
unit_relation.item = item;
unit_relation.sup_unit = Convert.ToInt32(Cmb_unites.SelectedValue.ToString());
unit_relation.ratio = 1;
db.unites_relations.InsertOnSubmit(unit_relation);
SetData();
db.SubmitChanges();
foreach (DataGridViewRow row in dgv_subUnits.Rows)
{
//unit_relation = new DAL.unites_relation();
//unit_relation.item_id = item.id;
//unit_relation.sup_unit = Convert.ToInt32(row.Cells["unit_id"].Value);
//unit_relation.ratio = Convert.ToInt32(row.Cells["ratioN"].Value);
//db.unites_relations.InsertOnSubmit(unit_relation);
//db.SubmitChanges();
}
}
else
{
unit_relation = db.unites_relations.Where(i => i.item_id == item.id).Where(i => i.ratio == 1).First();
unit_relation.sup_unit = Convert.ToInt32(Cmb_unites.SelectedValue.ToString());
SetData();
db.SubmitChanges();
}
MessageBox.Show("تم إضافة الصنف بنجاح");
refreshItems();
New();
}
public override void New()
{
product = new DAL.Product()
{
Code = GetNewProductCode(),
IsActive = true
};
var db = new DAL.dbDataContext();
var categ = db.ProductCategories.Where(x => db.ProductCategories.Where(w => w.ParentID == x.ID).Count() == 0).FirstOrDefault();
if (categ != null)
{
product.CategoryID = categ.ID;
}
base.New();
this.Text = "اضافه صنف جديد";
var data = gridView1.DataSource as BindingList <DAL.ProductUnit>;
if (db.UnitNames.Count() == 0)
{
db.UnitNames.InsertOnSubmit(new DAL.UnitName()
{
Name = "قطعة"
});
db.SubmitChanges();
RefreshData();
}
data.Add(new DAL.ProductUnit()
{
factor = 1, UnitID = db.UnitNames.First().ID, Barcode = GetNewBarCode()
});
}
public override void Save()
{
gridView1.UpdateCurrentRow();
if (ValdiateData() == false)
{
return;
}
var db = new DAL.dbDataContext();
if (product.ID == 0)
{
db.Products.InsertOnSubmit(product);
}
else
{
db.Products.Attach(product);
}
SetData();
db.SubmitChanges();
var data = gridView1.DataSource as BindingList <DAL.ProductUnit>;
foreach (var item in data)
{
item.ProductID = product.ID;
if (string.IsNullOrEmpty(item.Barcode))
{
item.Barcode = "";
}
}
sdb.SubmitChanges();
base.Save();
this.Text = string.Format("بيانات صنف : {0}", product.Name);
}
private void btnAccept_Click(object sender, EventArgs e)
{
int user_id = Properties.Settings.Default.user_id;
user = db.users.Where(a => a.id == user_id).FirstOrDefault();
if (user.type == "user")
{
if (dgvMovements.Rows.Count > 0)
{
int id = 0;
if (dgvMvtHeader.CurrentRow.Cells[0].Value != null)
{
id = Convert.ToInt32(dgvMvtHeader.CurrentRow.Cells[0].Value.ToString());
movement_header.approved = 1;
movement_header.userApproved = user.id;
db.SubmitChanges();
MessageBox.Show("تم قبول الطلب بنجاح");
btnAccept.Enabled = false;
}
}
}
else
{
MessageBox.Show("عفوا ! لا يمتلك هذا المستخدم صلاحية قبول الطلبات");
}
}
void save()
{
if (txt_name.Text.Trim() == string.Empty)
{
MessageBox.Show("الرجاء عدم ترك حقل الاسم فارغ");
return;
}
if (store.id == 0)
{
db = new DAL.dbDataContext();
db.stores.InsertOnSubmit(store);
SetData();
db.SubmitChanges();
}
else
{
SetData();
db.SubmitChanges();
}
MessageBox.Show("تم الحفظ بنجاح");
DGV_stores.DataSource = db.stores;
New();
}
private void Lkp_Category_ProcessNewValue(object sender, DevExpress.XtraEditors.Controls.ProcessNewValueEventArgs e)
{
if (e.DisplayValue is string st && st.Trim() != string.Empty)
{
var newObject = new DAL.ProductCategory()
{
Name = st, ParentID = 0, Number = "0"
};
using (var db = new DAL.dbDataContext())
{
db.ProductCategories.InsertOnSubmit(newObject);
db.SubmitChanges();
}
((List <DAL.ProductCategory>)lkp_Category.Properties.DataSource).Add(newObject);
e.Handled = true;
}
}
private void RepoUOM_ProcessNewValue(object sender, DevExpress.XtraEditors.Controls.ProcessNewValueEventArgs e)
{
if (e.DisplayValue is string value && value.Trim() != string.Empty)
{
var NewObject = new DAL.UnitName()
{
Name = value.Trim()
};
using (DAL.dbDataContext db = new DAL.dbDataContext())
{
db.UnitNames.InsertOnSubmit(NewObject);
db.SubmitChanges();
}
((List <DAL.UnitName>)repoUOM.DataSource).Add(NewObject);
((List <DAL.UnitName>)((LookUpEdit)sender).Properties.DataSource).Add(NewObject);
e.Handled = true;
}
}
void Save()
{
if (txt_name.Text.Trim() == String.Empty)
{
txt_name.ErrorText = "برجاء ادخال اسم الشركة";
return;
}
DAL.dbDataContext db = new DAL.dbDataContext();
DAL.CompanyInfo info = db.CompanyInfos.FirstOrDefault();
if (info == null)
{
info = new DAL.CompanyInfo();
}
info.CompanyName = txt_name.Text;
info.Mobile = txt_mobile.Text;
info.Phone = txt_phone.Text;
info.Address = txt_address.Text;
db.SubmitChanges();
XtraMessageBox.Show("تم الحفظ بنجاح");
}
public override void Save()
{
if (IsDataValidated() == false)
{
return;
}
var db = new DAL.dbDataContext();
if (category.ID == 0)
{
db.ProductCategories.InsertOnSubmit(category);
}
else
{
db.ProductCategories.Attach(category);
}
SetData();
db.SubmitChanges();
base.Save();
}
public override void Delete()
{
var db = new DAL.dbDataContext();
if (XtraMessageBox.Show(text: "هل تريد حذف المخزن", caption: "تاكيد الحذف",
buttons: MessageBoxButtons.YesNo,
icon: MessageBoxIcon.Question) == DialogResult.Yes)
{
var log = db.StoreLogs.Where(x => x.SourceID == store.ID).Count();
var accountLog = db.Journals.Where(x => x.AccountID == store.CostOfSoldGoodsAccountID ||
x.AccountID == store.SalesAccountID ||
x.AccountID == store.SalesReturnAccountID ||
x.AccountID == store.InventoryAccountID
).Count();
if (log + accountLog > 0)
{
XtraMessageBox.Show(text: "عفوا لا يمكن حذف المخزن حيث ام استخادمه في النظام "
, caption: "", buttons: MessageBoxButtons.OK, icon: MessageBoxIcon.Error);
return;
}
db.Stores.Attach(store);
db.Stores.DeleteOnSubmit(store);
db.Accounts.DeleteAllOnSubmit(db.Accounts.Where(x =>
x.ID == store.CostOfSoldGoodsAccountID ||
x.ID == store.SalesAccountID ||
x.ID == store.SalesReturnAccountID ||
x.ID == store.InventoryAccountID
));
db.SubmitChanges();
XtraMessageBox.Show("تم الحذف بنجاح");
New();
}
}
public override void Save()
{
gridView1.UpdateCurrentRow();
var db = new DAL.dbDataContext();
if (invoice.ID == 0)
{
db.InvoiceHeaders.InsertOnSubmit(invoice);
}
else
{
db.InvoiceHeaders.Attach(invoice);
}
SetData();
var items = (Collection <DAL.InvoiceDetail>)gridView1.DataSource;
if (invoice.Expences > 0)
{
var totalPrice = items.Sum(x => x.TotalPrice);
var totalQTY = items.Sum(x => x.ItemQty);
var ByPriceUnit = invoice.Expences / totalPrice; // السعر لكل جنيه واحد
var ByQtyUnit = invoice.Expences / totalQTY; //السعر لكل قطعه واحده من الوحده المختاره
XtraDialogArgs args = new XtraDialogArgs();
UserControls.CostDistributionOption distributionOption = new UserControls.CostDistributionOption();
args.Caption = "";
args.Content = distributionOption;
((XtraBaseArgs)args).Buttons = new DialogResult[]
{
DialogResult.OK
};
args.Showing += Args_Showing;
XtraDialog.Show(args);
foreach (var row in items)
{
if (distributionOption.SelectedOption == Master.CostDistributionOptions.ByPrice)
{
row.CostValue = (row.TotalPrice / row.ItemQty) + (ByPriceUnit * row.Price); // توزيع بالسعر
}
else
{
row.CostValue = (row.TotalPrice / row.ItemQty) + (ByQtyUnit); // توزيع بالكميه
}
row.TotalCostValue = row.ItemQty * row.CostValue;
}
}
else
{
foreach (var row in items)
{
row.CostValue = row.TotalPrice / row.ItemQty;
row.TotalCostValue = row.TotalPrice;
}
}
var msg = $" {invoice.ID} لعميل {glkp_PartID.Text} فاتوره مبيعات رقم ";
#region Journals
// فاتوره بقيمه بضاعه 1000
// ضريبه 120
// مصروف نقل 100
// خصم 50
// 1170 الصافي
// حساب المخزون - مدين - 1100
// حساب ضريبه مضافه - مدين - 120
// حساب المورد - دائن - 1220
// حساب المورد - مدين - 50
// حساب خصم نقدي مكتسب - دائن - 50
// حساب المورد -مدين - 1000
// حساب الخذنه -دائن - 1000
db.Journals.DeleteAllOnSubmit(db.Journals.Where(x => x.SourceType == (byte)type && x.SourceID == invoice.ID));
db.SubmitChanges();
var partAccountID = db.CustomersAndVendors.Single(x => x.ID == invoice.PartID).AccountID;
var store = db.Stores.Single(x => x.ID == invoice.Branch);
var drawer = db.Drawers.Single(x => x.ID == invoice.Drawer);
db.Journals.InsertOnSubmit(new DAL.Journal() // Part
{
AccountID = partAccountID,
Code = 54545,
Credit = invoice.Total + invoice.TaxValue + invoice.Expences,
Debit = 0,
InsertDate = invoice.Date,
Notes = msg,
SourceID = invoice.ID,
SourceType = (byte)type,
});
db.Journals.InsertOnSubmit(new DAL.Journal() // Store Inventory
{
AccountID = store.InventoryAccountID,
Code = 54545,
Credit = 0,
Debit = invoice.Total + invoice.Expences,
InsertDate = invoice.Date,
Notes = msg,
SourceID = invoice.ID,
SourceType = (byte)type,
});
if (invoice.Tax > 0)
{
db.Journals.InsertOnSubmit(new DAL.Journal() //
{
AccountID = Session.Defaults.PurchaseTax,
Code = 54545,
Credit = 0,
Debit = invoice.TaxValue,
InsertDate = invoice.Date,
Notes = msg + " - ضريبه مضافه ",
SourceID = invoice.ID,
SourceType = (byte)type,
});
}
//if (Invoice.Expences > 0)
// db.Journals.InsertOnSubmit(new DAL.Journal() //
// {
// AccountID = Session.Defualts.PurchaseExpences,
// Code = 54545,
// Credit = 0,
// Debit = Invoice.Expences,
// InsertDate = Invoice.Date,
// Notes = msg + " - مصروفات شراء",
// SourceID = Invoice.ID,
// SourceType = (byte)Type,
// });
if (invoice.DiscountVale > 0)
{
db.Journals.InsertOnSubmit(new DAL.Journal() // Store Tax
{
AccountID = Session.Defaults.DiscountReceivedAccount,
Code = 54545,
Credit = invoice.DiscountVale,
Debit = 0,
InsertDate = invoice.Date,
Notes = msg + " - خصم شراء",
SourceID = invoice.ID,
SourceType = (byte)type,
});
db.Journals.InsertOnSubmit(new DAL.Journal() // Store Tax
{
AccountID = partAccountID,
Code = 54545,
Credit = 0,
Debit = invoice.DiscountVale,
InsertDate = invoice.Date,
Notes = msg + " - خصم شراء",
SourceID = invoice.ID,
SourceType = (byte)type,
});
}
if (invoice.Paid > 0)
{
db.Journals.InsertOnSubmit(new DAL.Journal() //
{
AccountID = drawer.AccountID,
Code = 54545,
Credit = invoice.Paid,
Debit = 0,
InsertDate = invoice.Date,
Notes = msg + " - سداد",
SourceID = invoice.ID,
SourceType = (byte)type,
});
db.Journals.InsertOnSubmit(new DAL.Journal() //
{
AccountID = partAccountID,
Code = 54545,
Credit = 0,
Debit = invoice.Paid,
InsertDate = invoice.Date,
Notes = msg + " - سداد",
SourceID = invoice.ID,
SourceType = (byte)type,
});
}
#endregion
foreach (var row in items)
{
row.InvoiceID = invoice.ID;
}
generalDB.SubmitChanges();
db.StoreLogs.DeleteAllOnSubmit(db.StoreLogs.Where(x => x.SourceType == (byte)type && x.SourceID == invoice.ID));
db.SubmitChanges();
if (invoice.PostedToStore)
{
foreach (var row in items)
{
var unitView = Session.ProductsView.Single(x => x.ID == row.ItemID).Units.Single(x => x.UnitID == row.ItemUnitID);
db.StoreLogs.InsertOnSubmit(new DAL.StoreLog()
{
ProductID = row.ItemID,
InsertTime = invoice.PostDate.Value,
SourceID = invoice.ID,
SourceType = (byte)type,
Notes = msg,
IsInTransaction = true,
StoreID = row.StoreID,
Qty = row.ItemQty * unitView.Factor,
CostValue = row.CostValue / unitView.Factor
});
}
}
db.SubmitChanges();
base.Save();
}