//type
#endregion
#region Methods
public void DocumentNumbering()
{
var order = _uow.AccDocumentHeaders.OrderBy(x => x.DocumentDate).ThenBy(x => x.DailyNumber).ToList();
var getDocumentNumbering = _uow.Set <DocumentNumbering>().AsNoTracking().FirstOrDefault(x => x.AccountDocumentId == 1);
var startNumber = getDocumentNumbering.StartNumber;
for (long i = 1; i < order.Count(); i++)
{
int ii = Convert.ToInt32(i);
order[ii].DocumentNumber = startNumber;
startNumber++;
}
_uow.SaveChanges();
var manager = new RadDesktopAlertManager(AlertScreenPosition.TopCenter);
var alert = new RadDesktopAlert
{
FlowDirection = FlowDirection.RightToLeft,
Header = "اطلاعات",
Content = ".شماره گذاری با موفقیت انجام شد",
ShowDuration = 2000,
};
manager.ShowAlert(alert);
}
private async void SaveButton_Click(object sender, RoutedEventArgs e)
{
////await _uow.SaveChangesAsync();
//_virtualQueryableCollectionView.AddNew(new AccDocumentHeader() {TypeDocumentId=1 });
//_virtualQueryableCollectionView.VirtualItemCount++;
//AccDocumentHeaderRadGridView.Rebind();
////_virtualQueryableCollectionView.MoveCurrentToNext();
//_uow.AccDocumentHeaders.Add(new AccDocumentHeader { TypeDocumentId = 1 });
var r = _uow.SaveChanges();
}
public int DeleteGL(GL gL)
{
if (HasTL(gL.GLId) == false)
{
_uow.GLs.Attach(gL);
_uow.GLs.Remove(gL);
return(_uow.SaveChanges());
}
else
{
return(0);
}
}
public int DeleteSL(SL sL)
{
if (HasItem(sL.SLId) == false)
{
_uow.SLs.Attach(sL);
_uow.SLs.Remove(sL);
return(_uow.SaveChanges());
}
else
{
return(0);
}
}
public int DeleteDL(DL dL)
{
if (HasItem(dL.DLId) == false)
{
_uow.DLs.Attach(dL);
_uow.DLs.Remove(dL);
return(_uow.SaveChanges());
}
else
{
return(0);
}
}
public void Save()
{
if (BankAccount != null)
{
//stop Entity Framework from trying to save/insert child objects?
var items = BankAccounts.ToList();
for (int i = 0; i < items.Count; i++)
{
if (items[i].Bank != null)
{
_uow.Entry(items[i].Bank).State = EntityState.Detached;
}
if (items[i].AccountType != null)
{
_uow.Entry(items[i].AccountType).State = EntityState.Detached;
}
if (items[i].CurrencyType != null)
{
_uow.Entry(items[i].CurrencyType).State = EntityState.Detached;
}
}
}
var x = _uow.SaveChanges();
}
public void Save()
{
var SelectedStocks = Stocks.Where(x => x.IsSelected == true);
Product.Stocks.Clear();
foreach (var stock in SelectedStocks)
{
//if (!Product.Stocks.Any(x => x.StockId == stock.StockId))
Product.Stocks.Add(stock);
//else
// Product.Stocks.Add(stock);
}
var ss = _uow.Entry <Product>(Product).State;
_uow.SaveChanges();
}
public void Save()
{
var stcDocumentHeader = StcDocumentHeaders.CurrentItem as StcDocumentHeader;
if (stcDocumentHeader != null)
{
//stop Entity Framework from trying to save/insert child objects?
//var items = stcDocumentHeader.StcDocumentItems.ToList();
//for (int i = 0; i < items.Count; i++)
//{
// if (items[i].DL1 != null)
// _uow.Entry(items[i].DL1).State = EntityState.Detached;
// if (items[i].DL2 != null)
// _uow.Entry(items[i].DL2).State = EntityState.Detached;
// if (items[i].Currency != null)
// _uow.Entry(items[i].Currency).State = EntityState.Detached;
//}
}
_uow.SaveChanges();
}
public void SaveChanges(EditableAccDocumentHeader selectedHeader)
{
var existingParent = _uow.AccDocumentHeaders
.Where(p => p.AccDocumentHeaderId == selectedHeader.AccDocumentHeaderId)
.Include(p => p.AccDocumentItems)
.SingleOrDefault();
if (existingParent != null)
{
// Update parent
_uow.Entry(existingParent).CurrentValues.SetValues(selectedHeader);
// Delete AccDocumentItems
//foreach (var existingChild in existingParent.AccDocumentItems.ToList())
//{
// if (!selectedHeader.AccDocumentItems.Any(c => c.AccDocumentItemId == existingChild.AccDocumentItemId))
// _uow.AccDocumentItems.Remove(existingChild);
//}
//// Update and Insert AccDocumentItems
//foreach (var childModel in selectedHeader.AccDocumentItems)
//{
// var existingChild = existingParent.AccDocumentItems
// .SingleOrDefault(c => c.AccDocumentItemId == childModel.AccDocumentItemId);
// if (existingChild != null)
// // Update child
// _uow.Entry(existingChild).CurrentValues.SetValues(childModel);
// else
// {
// // Insert child
// var newChild = new AccDocumentItem
// {
// SLId = childModel.SLId,
// DL1Id = childModel.DL1Id,
// DL2Id = childModel.DL2Id
// ,
// Debit = childModel.Debit,
// Credit = childModel.Credit,
// Description1 = childModel.Description1,
// Description2 = childModel.Description2
// };// AutoMapper.Mapper.Map<EditableAccDocumentItem, AccDocumentItem>(childModel);// new AccDocumentItem
// //{
// // //Data = childModel.Data,
// // ////...
// //};
// existingParent.AccDocumentItems.Add(newChild);
// }
//}
_uow.SaveChanges();
}
}
//public int GetLastRow()
//{
// if (_uow.AccDocumentItems.Any())
// return _uow.AccDocumentItems.Select(x => x.AccRow).Max();
// return 1;
//}
public void AddAccDocumentItemsAsync(IEnumerable <AccDocumentItem> accDocumentItem)
{
// _uow.AccDocumentItems.AddRange(accDocumentItem);
foreach (var item in accDocumentItem)
{
//var st = _uow.Entry(item).State;
//_uow.AccDocumentItems.Attach(item);
_uow.Set <AccDocumentItem>().AddOrUpdate(x => x.AccDocumentItemId, item);
}
// await _uow.SaveChangesAsync().ConfigureAwait(false);
_uow.SaveChanges();
}
public void ApplyPermission(List <int> actionIds, bool hasAccess, bool isMenu = true)
{
using (var uow = new SainaDbContext())
{
uow.Accesses.Where(x => actionIds.Contains(x.OperationId ?? 0)).ToList().ForEach(x => x.HasAccess = hasAccess);
if (isMenu)
{
items.SelectMany(x => x.Views).SelectMany(x => x.Operations).Where(x => actionIds.Contains(x.OperationId)).ToList().ForEach(x => x.HasAccess = hasAccess);
}
uow.SaveChanges();
}
}
public void Loaded()
{
_uow = new SainaDbContext();
var ids = new List <int> {
1, 3, 4, 5, 6
};
TypeDocuments = _uow.TypeDocuments.Where(x => !ids.Contains(x.TypeDocumentId)).ToList();
SLs = _uow.SLs.Where(x => x.Status == true).ToList();
DLs = _uow.DLs.ToList();
SLStandardDescriptions = _uow.SLStandardDescriptions.ToList();
Currencies = _uow.Currencies.ToList();
AccDocumentHeaders = new QueryableCollectionView(_uow.AccDocumentHeaders.Include(x => x.AccDocumentItems.Select(s => s.SL)).Where(x => _uow.ShamsiToMiladi(x.DocumentDate, "Saal") == _appContextService.CurrentFinancialYear.ToString() &&
(HeaderId == 0 || x.AccDocumentHeaderId == HeaderId) &&
(TypeEnum == 0 || x.TypeDocumentId == TypeEnum)).OrderBy(x => x.DocumentNumber).ToList());
_appContextService.PropertyChanged += (sender, eventArgs) =>
{
try
{
if (eventArgs.PropertyName == "CurrentFinancialYear")
{
var dateDocument = _appContextService.CurrentFinancialYear;
ids = new List <int> {
1, 3, 4, 5, 6
};
TypeDocuments = _uow.TypeDocuments.Where(x => !ids.Contains(x.TypeDocumentId)).ToList();
SLs = _uow.SLs.Where(x => x.Status == true).ToList();
DLs = _uow.DLs.ToList();
SLStandardDescriptions = _uow.SLStandardDescriptions.ToList();
Currencies = _uow.Currencies.ToList();
// AccDocumentHeaders = new QueryableCollectionView(_uow.AccDocumentHeaders.Include(x => x.AccDocumentItems).Where(x => _uow.ShamsiToMiladi(x.DocumentDate, "Saal") == _appContextService.CurrentFinancialYear.ToString()).ToList());
AccDocumentHeaders = new QueryableCollectionView(_uow.AccDocumentHeaders.Include(x => x.AccDocumentItems.Select(s => s.SL)).Where(x => _uow.ShamsiToMiladi(x.DocumentDate, "Saal") == _appContextService.CurrentFinancialYear.ToString() &&
(HeaderId == 0 || x.AccDocumentHeaderId == HeaderId) &&
(TypeEnum == 0 || x.TypeDocumentId == TypeEnum)).OrderBy(x => x.DocumentNumber).ToList());
}
}
catch (Exception)
{ }
};
AccDocumentHeaders.CollectionChanged += AccDocumentHeaders_CollectionChanged;
_uow.SaveChanges();
}
public void LoadRefresh()
{
_uow = new SainaDbContext();
var ids = new List <int> {
1, 3, 4, 5, 6
};
TypeDocuments = _uow.TypeDocuments.Where(x => !ids.Contains(x.TypeDocumentId)).ToList();
SLs = _uow.SLs.Where(x => x.Status == true).ToList();
DLs = _uow.DLs.ToList();
SLStandardDescriptions = _uow.SLStandardDescriptions.ToList();
Currencies = _uow.Currencies.ToList();
AccDocumentHeaders = new QueryableCollectionView(_uow.AccDocumentHeaders.Include(x => x.AccDocumentItems.Select(s => s.SL)).Where(x => _uow.ShamsiToMiladi(x.DocumentDate, "Saal") == _appContextService.CurrentFinancialYear.ToString()
).ToList());
AccDocumentHeaders.CollectionChanged += AccDocumentHeaders_CollectionChanged;
_uow.SaveChanges();
}
private async void OnDraft()
{
//_uow.AccDocumentHeaders.
AccDocumentHeader.Status = StatusEnum.Draft;
//_accDocumentItemListViewModel.SaveCommand.Execute(null);
var test0 = _uow.Entry(testAccDocumentHeader).State;
testAccDocumentHeader = Mapper.Map <EditableAccDocumentHeader, AccDocumentHeader>(_accDocumentHeader, testAccDocumentHeader);
var test = _uow.Entry(testAccDocumentHeader).State;
var test2v = _uow.Entry(testAccDocumentHeader.AccDocumentItems.First()).State;
testAccDocumentHeader.AccDocumentItems = Mapper.Map(AccDocumentItemListViewModel.AccDocumentItems.ToList(), testAccDocumentHeader.AccDocumentItems);
////IEnumerable<AccDocumentItem> itemsToBeDeleted = new List<AccDocumentItem>();
////Mapper.Map(AccDocumentItemListViewModel.ItemsToBeDeleted, itemsToBeDeleted);
var test2 = _uow.Entry(testAccDocumentHeader.AccDocumentItems.First()).State;
_uow.SaveChanges();
//await _accDocumentHeadersService.SaveHeaderAndItemsAsync(testAccDocumentHeader, testAccDocumentHeader.AccDocumentItems, itemsToBeDeleted);
}
public bool SaveSystemSettingSaleModel(SystemSettingSaleModel systemSettingSaleModel)
{
var dict = systemSettingSaleModel.GetType().GetProperties(BindingFlags.Instance | BindingFlags.Public | BindingFlags.DeclaredOnly)
.ToDictionary(prop => prop.Name, prop => prop?.GetValue(systemSettingSaleModel, null)?.ToString() ?? "");
var keyValues = _keyValues.Where(x => dict.Keys.Contains(x.Key)).ToList();
if (keyValues.Any())
{
keyValues.ForEach(x => x.Value = dict[x.Key]);
}
else
{
foreach (var item in dict)
{
_keyValues.Add(new KeyValue {
Key = item.Key, Value = item.Value
});
}
//_uow.SaveChanges();
}
return(_uow.SaveChanges() != 0);
}
internal void AddBankAccount(BankAccount bankAccount)
{
_uow.BankAccounts.Add(bankAccount);
_uow.SaveChanges();
}
private void ContextMenuClick(object sender, RoutedEventArgs e)
{
if (this.ClickedTreeViewItem == null)
{
return;
}
ProductRack item = this.ClickedTreeViewItem.DataContext as ProductRack;
if (item == null)
{
return;
}
string header = (e.OriginalSource as RadMenuItem).Header as string;
switch (header)
{
case "New Child":
ChildListWindow childListWindow = SmObjectFactory.Container.GetInstance <ChildListWindow>();
var tree = childListWindow.DataContext as ChildListWindowViewModel;
childListWindow.ShowDialog();
ProductRack newChild = new ProductRack();
newChild.ProductRackTitle = childListWindow.titleTextbox.Text;
using (var uow = new SainaDbContext())
{
// uow.ProductRacks.Include(Parent).Add(Parent(newChild));
item.Items.Add(newChild);
uow.ProductRacks.Add(item);
uow.SaveChanges();
item.IsExpanded = true; // Ensure that the new child is visible
}
// item.Items.Add(newChild)
break;
case "New Sibling":
childListWindow = SmObjectFactory.Container.GetInstance <ChildListWindow>();
ProductRack newSibling = new ProductRack();
newSibling.ProductRackTitle = childListWindow.titleTextbox.Text;
item.Parent.Items.Add(newSibling);
break;
case "Delete":
using (var uow = new SainaDbContext())
{
item.Parent.Items.Remove(item);
// uow.ProductRacks.Remove(item);
uow.SaveChanges();
}
break;
case "Edit":
using (var uow = new SainaDbContext())
{
this.ClickedTreeViewItem.IsInEditMode = true;
uow.SaveChanges();
}
break;
case "Select":
this.ClickedTreeViewItem.IsSelected = true;
break;
}
}
public void Save()
{
var r = _uow.SaveChanges();
}
private void ContextMenuClick(object sender, RoutedEventArgs e)
{
//GL gl = ClickedTreeViewItem.DataContext as GL;
//TL tl = ClickedTreeViewItem.DataContext as TL;
var SystemAccountingSettingModel = _systemAccountingSettingsService.GetSystemAccountingSettingModel();
int.TryParse(SystemAccountingSettingModel.GLLength, out int SystemAccountingSettingModelGLLength);
// var SystemAccountingSettingModelGLLength = int.Parse(SystemAccountingSettingModel.GLLength);
long lastGLCode = _gLsService.GetLastGLCode() + 1;
var lastGLLenght = (lastGLCode.ToString()).Length;
string tag = (e.OriginalSource as RadMenuItem).Tag as string;
if (ClickedTreeViewItem == null)
{
if (lastGLLenght == SystemAccountingSettingModelGLLength)
{
AddGLTreeItemWindow addGLTreeItemWindow0 = SmObjectFactory.Container.GetInstance <AddGLTreeItemWindow>();
var treeGL = addGLTreeItemWindow0.DataContext as AddGLTreeItemWindowViewModel;
// treeGL.GL = gl;
treeGL.SaveClicked += (g) =>
{
//addTLTreeItemWindow0.DataItem.GL = gl;
g.ImageUrl = "../../Resources/cian.png";
_vm.AddGL(g);
g.GLId = _vm.GetGLId(g.GLCode);
_vm.Items.Add(g);
//_vm.Save();
addGLTreeItemWindow0.Close();
// gl.TLs.Add(addTLTreeItemWindow0.DataItem);
// gl.IsExpanded = true; // Ensure that the new child is visible
//using (var uow = new SainaDbContext())
//{
// uow.GLs.Add(g);
// uow.SaveChanges();
// addGLTreeItemWindow0.Close();
//}
};
addGLTreeItemWindow0.Width = 1000;
addGLTreeItemWindow0.Height = 500;
addGLTreeItemWindow0.CanClose = true;
addGLTreeItemWindow0.Owner = Window.GetWindow(this);
addGLTreeItemWindow0.Show();
}
else
{
DialogParameters parameters = new DialogParameters();
parameters.OkButtonContent = "بستن";
parameters.Header = "اخطار";
parameters.Content = " شماره گذاری این حساب به پایان رسیده است";
RadWindow.Alert(parameters);
}
}
else if (ClickedTreeViewItem.DataContext is GL gl)
{
if (tag == "newGL")
{
if (_accessUtility.HasAccess(70))
{
if (lastGLLenght == SystemAccountingSettingModelGLLength)
{
AddGLTreeItemWindow addGLTreeItemWindow0 = SmObjectFactory.Container.GetInstance <AddGLTreeItemWindow>();
var treeGL = addGLTreeItemWindow0.DataContext as AddGLTreeItemWindowViewModel;
// treeGL.GL = gl;
treeGL.SaveClicked += (g) =>
{
//addTLTreeItemWindow0.DataItem.GL = gl;
g.ImageUrl = "../../Resources/cian.png";
_vm.AddGL(g);
g.GLId = _vm.GetGLId(g.GLCode);
_vm.Items.Add(g);
//_vm.Save();
addGLTreeItemWindow0.Close();
// gl.TLs.Add(addTLTreeItemWindow0.DataItem);
gl.IsExpanded = true; // Ensure that the new child is visible
//using (var uow = new SainaDbContext())
//{
// uow.GLs.Add(g);
// uow.SaveChanges();
// addGLTreeItemWindow0.Close();
//}
};
addGLTreeItemWindow0.Width = 1000;
addGLTreeItemWindow0.Height = 500;
addGLTreeItemWindow0.CanClose = true;
addGLTreeItemWindow0.Owner = Window.GetWindow(this);
addGLTreeItemWindow0.Show();
}
else
{
DialogParameters parameters = new DialogParameters();
parameters.OkButtonContent = "بستن";
parameters.Header = "اخطار";
parameters.Content = " شماره گذاری این حساب به پایان رسیده است";
RadWindow.Alert(parameters);
}
}
// break;
}
else if (tag == "newTL")
{
if (_accessUtility.HasAccess(70))
{
AddTLTreeItemWindow addTLTreeItemWindow0 = SmObjectFactory.Container.GetInstance <AddTLTreeItemWindow>();
var treeTL = addTLTreeItemWindow0.DataContext as AddTLTreeItemWindowViewModel;
treeTL.TL = new TL();
treeTL.TL.GLId = gl.GLId;
treeTL.TL.GL = gl;
treeTL.SaveClicked += (t) =>
{
//addTLTreeItemWindow0.DataItem.GL = gl;
//t.GLId = gl.GLId;
t.ImageUrl = "../../Resources/cian.png";
_vm.AddTL(t);
t.GLId = _vm.GetTLId(t.TLCode);
gl.TLs.Add(t);
//_vm.Save();
addTLTreeItemWindow0.Close();
gl.IsExpanded = true; // Ensure that the new child is visible
//using (var uow = new SainaDbContext())
//{
// uow.TLs.Add(t);
// //uow.Entry(gl).State = EntityState.Modified;
// var vv = uow.SaveChanges();
// addTLTreeItemWindow0.Close();
//}
};
addTLTreeItemWindow0.Width = 1000;
addTLTreeItemWindow0.Height = 500;
addTLTreeItemWindow0.CanClose = true;
addTLTreeItemWindow0.Owner = Window.GetWindow(this);
addTLTreeItemWindow0.Show();
}
}
else if (tag == "edit")
{
if (_accessUtility.HasAccess(71))
{
AddGLTreeItemWindow addGLTreeItemWindow0 = SmObjectFactory.Container.GetInstance <AddGLTreeItemWindow>();
var treeGL = addGLTreeItemWindow0.DataContext as AddGLTreeItemWindowViewModel;
treeGL.GL = gl;
using (var uow = new SainaDbContext())
{
var hasGL = uow.GLs.FirstOrDefault(x => x.GLId == gl.GLId)?.TLs?.Any() == true;
if (hasGL == true)
{
addGLTreeItemWindow0.gLCodeTextbox.IsEnabled = false;
}
treeGL.SaveClicked += (g) =>
{
//addTLTreeItemWindow0.DataItem.GL = gl;
g.GLId = gl.GLId;
g.ImageUrl = "../../Resources/cian.png";
// gl.TLs.Add(addTLTreeItemWindow0.DataItem);
gl.IsExpanded = true; // Ensure that the new child is visible
// _vm.Save();
uow.GLs.Attach(g);
uow.Entry <GL>(g).State = EntityState.Modified;
// uow.GLs(g);
var x = uow.SaveChanges();
addGLTreeItemWindow0.Close();
};
}
addGLTreeItemWindow0.Width = 1000;
addGLTreeItemWindow0.Height = 500;
addGLTreeItemWindow0.CanClose = true;
addGLTreeItemWindow0.Owner = Window.GetWindow(this);
addGLTreeItemWindow0.Show();
}
// break;
}
else if (tag == "delete")
{
if (_accessUtility.HasAccess(72))
{
using (var uow = new SainaDbContext())
{
var hasGL = uow.GLs.FirstOrDefault(x => x.GLId == gl.GLId)?.TLs?.Any() == true;
if (hasGL == false)
{
DialogParameters parameters = new DialogParameters();
parameters.OkButtonContent = "بله، مطمئنم";
parameters.CancelButtonContent = "خیر";
parameters.Header = "اخطار";
parameters.Content = "آیا برای حذف مطمئن هستید؟";
parameters.Closed = OnClosed;
RadWindow.Confirm(parameters);
_dialogResult = _dialogResult == true;
// _dialogResult == true;
}
else
{
DialogParameters parameters = new DialogParameters();
parameters.OkButtonContent = "بستن";
parameters.Header = "اخطار";
parameters.Content = ".امکان حذف وجود ندارد";
// parameters.Closed = OnClosed;
RadWindow.Alert(parameters);
_dialogResult = false;
}
if (_dialogResult == true)
{
// uow.GLs.Attach(gl);
var test = uow.GLs.ToList().Select(x => x.GLId);
_vm.Items.Remove(gl);
uow.Database.ExecuteSqlCommand($"Delete Info.GLs where GLId={gl.GLId} ");
// uow.RejectChanges();
// uow.GLs.Attach(new GL { GLId = gl.GLId });
//uow.Entry<GL>(gl).State = EntityState.Deleted;
//// uow.GLs.Remove(new GL { GLId=gl.GLId});
uow.SaveChanges();
var manager = new RadDesktopAlertManager(AlertScreenPosition.TopCenter, new Point(0, 0), 100);
var alert = new RadDesktopAlert
{
FlowDirection = FlowDirection.RightToLeft,
Header = "اطلاعات",
Content = ".حذف با موفقیت انجام شد",
ShowDuration = 5000,
};
manager.ShowAlert(alert);
}
}
}
}
}
else if (ClickedTreeViewItem.DataContext is TL tl)
{
if (tag == "newTL")
{
if (_accessUtility.HasAccess(70))
{
AddTLTreeItemWindow addTLTreeItemWindow0 = SmObjectFactory.Container.GetInstance <AddTLTreeItemWindow>();
gl = tl.GL;
var treeTL = addTLTreeItemWindow0.DataContext as AddTLTreeItemWindowViewModel;
treeTL.TL = new TL();
treeTL.TL.GLId = gl.GLId;
treeTL.TL.GL = gl;
//treeTL.SelectedGL = gl;
//treeTL.TL = new TL { GL = gl, GLId = gl.GLId };
treeTL.SaveClicked += (t) =>
{
// t.GLId = gl.GLId;
t.ImageUrl = "../../Resources/cian.png";
_vm.AddTL(t);
t.GLId = _vm.GetTLId(t.TLCode);
gl.TLs.Add(t);
addTLTreeItemWindow0.Close();
gl.IsExpanded = true; // Ensure that the new child is visible
//using (var uow = new SainaDbContext())
//{
// uow.TLs.Add(t);
// // uow.Entry(gl).State = EntityState.Modified;
// uow.SaveChanges();
// addTLTreeItemWindow0.Close();
//}
};
addTLTreeItemWindow0.Width = 1000;
addTLTreeItemWindow0.Height = 500;
addTLTreeItemWindow0.CanClose = true;
addTLTreeItemWindow0.Owner = Window.GetWindow(this);
addTLTreeItemWindow0.Show();
}
}
else if (tag == "newSL")
{
if (_accessUtility.HasAccess(70))
{
AddSLTreeItemWindow addSLTreeItemWindow0 = SmObjectFactory.Container.GetInstance <AddSLTreeItemWindow>();
var treeSL = addSLTreeItemWindow0.DataContext as AddSLTreeItemWindowViewModel;
treeSL.SL = new SL();
treeSL.SL.TLId = tl.TLId;
treeSL.SL.TL = tl;
//treeSL.SelectedTL = tl;
//treeSL.SL = new SL { TL = tl, TLId = tl.TLId };
treeSL.SaveClicked += (s) =>
{
//addTLTreeItemWindow0.DataItem.GL = gl;
// s.TLId = tl.TLId;
s.ImageUrl = "../../Resources/cian.png";
_vm.AddSL(s);
s.TLId = _vm.GetSLId(s.SLCode);
tl.SLs.Add(s);
// _vm.Save();
addSLTreeItemWindow0.Close();
tl.IsExpanded = true; // Ensure that the new child is visible
//using (var uow = new SainaDbContext())
//{
// uow.SLs.Add(s);
// uow.Entry(tl).State = EntityState.Modified;
// uow.SaveChanges();
// addSLTreeItemWindow0.Close();
//}
};
addSLTreeItemWindow0.Width = 1000;
addSLTreeItemWindow0.Height = 500;
addSLTreeItemWindow0.CanClose = true;
addSLTreeItemWindow0.Owner = Window.GetWindow(this);
addSLTreeItemWindow0.Show();
}
}
else if (tag == "edit")
{
if (_accessUtility.HasAccess(71))
{
AddTLTreeItemWindow addTLTreeItemWindow0 = SmObjectFactory.Container.GetInstance <AddTLTreeItemWindow>();
var treeTL = addTLTreeItemWindow0.DataContext as AddTLTreeItemWindowViewModel;
treeTL.TL = tl;
using (var uow = new SainaDbContext())
{
var hasTL = uow.TLs.FirstOrDefault(x => x.TLId == tl.TLId)?.SLs?.Any() == true;
if (hasTL == true)
{
addTLTreeItemWindow0.tLCodeTextbox.IsEnabled = false;
}
treeTL.SaveClicked += (t) =>
{
//addTLTreeItemWindow0.DataItem.GL = gl;
t.TLId = tl.TLId;
t.ImageUrl = "../../Resources/cian.png";
// gl.TLs.Add(addTLTreeItemWindow0.DataItem);
tl.IsExpanded = true; // Ensure that the new child is visible
uow.TLs.Attach(t);
uow.Entry <TL>(t).State = EntityState.Modified;
// uow.GLs(g);
// uow.GLs(g);
uow.SaveChanges();
addTLTreeItemWindow0.Close();
};
}
addTLTreeItemWindow0.Width = 1000;
addTLTreeItemWindow0.Height = 500;
addTLTreeItemWindow0.CanClose = true;
addTLTreeItemWindow0.Owner = Window.GetWindow(this);
addTLTreeItemWindow0.Show();
}
}
else if (tag == "delete")
{
if (_accessUtility.HasAccess(72))
{
using (var uow = new SainaDbContext())
{
var hasTL = uow.TLs.FirstOrDefault(x => x.TLId == tl.TLId)?.SLs?.Any() == true;
if (hasTL == false)
{
DialogParameters parameters = new DialogParameters();
parameters.OkButtonContent = "بله، مطمئنم";
parameters.CancelButtonContent = "خیر";
parameters.Header = "اخطار";
parameters.Content = "آیا برای حذف مطمئن هستید؟";
parameters.Closed = OnClosed;
RadWindow.Confirm(parameters);
_dialogResult = _dialogResult == true;
// _dialogResult == true;
}
else
{
DialogParameters parameters = new DialogParameters();
parameters.OkButtonContent = "بستن";
parameters.Header = "اخطار";
parameters.Content = ".امکان حذف وجود ندارد";
// parameters.Closed = OnClosed;
RadWindow.Alert(parameters);
_dialogResult = false;
}
if (_dialogResult == true)
{
// uow.GLs.Attach(gl);
// var test = uow.TLs.ToList().Select(x => x.TLId);
foreach (var item in _vm.Items)
{
item.TLs.Remove(tl);
}
uow.Database.ExecuteSqlCommand($"Delete Info.TLs where TLId={tl.TLId} ");
// uow.RejectChanges();
// uow.GLs.Attach(new GL { GLId = gl.GLId });
//uow.Entry<GL>(gl).State = EntityState.Deleted;
//// uow.GLs.Remove(new GL { GLId=gl.GLId});
uow.SaveChanges();
var manager = new RadDesktopAlertManager(AlertScreenPosition.TopCenter, new Point(0, 0), 100);
var alert = new RadDesktopAlert
{
FlowDirection = FlowDirection.RightToLeft,
Header = "اطلاعات",
Content = ".حذف با موفقیت انجام شد",
ShowDuration = 5000,
};
manager.ShowAlert(alert);
}
}
}
}
}
else if (ClickedTreeViewItem.DataContext is SL)
{
SL sl = ClickedTreeViewItem.DataContext as SL;
if (tag == "newSL")
{
if (_accessUtility.HasAccess(70))
{
AddSLTreeItemWindow addSLTreeItemWindow0 = SmObjectFactory.Container.GetInstance <AddSLTreeItemWindow>();
tl = sl.TL;
var treeSL = addSLTreeItemWindow0.DataContext as AddSLTreeItemWindowViewModel;
treeSL.SL = new SL();
treeSL.SL.TLId = tl.TLId;
treeSL.SL.TL = tl;
treeSL.SaveClicked += (s) =>
{
s.TLId = tl.TLId;
s.ImageUrl = "../../Resources/cian.png";
tl.SLs.Add(s);
_vm.AddSL(s);
// _vm.Save();
addSLTreeItemWindow0.Close();
tl.IsExpanded = true; // Ensure that the new child is visible
//using (var uow = new SainaDbContext())
//{
// uow.SLs.Add(s);
//// uow.Entry(tl).State = EntityState.Modified;
// uow.SaveChanges();
// addSLTreeItemWindow0.Close();
//}
};
addSLTreeItemWindow0.Width = 1000;
addSLTreeItemWindow0.Height = 500;
addSLTreeItemWindow0.CanClose = true;
addSLTreeItemWindow0.Owner = Window.GetWindow(this);
addSLTreeItemWindow0.Show();
}
}
else if (tag == "edit")
{
if (_accessUtility.HasAccess(71))
{
AddSLTreeItemWindow addSLTreeItemWindow0 = SmObjectFactory.Container.GetInstance <AddSLTreeItemWindow>();
var treeSL = addSLTreeItemWindow0.DataContext as AddSLTreeItemWindowViewModel;
treeSL.SL = sl;
using (var uow = new SainaDbContext())
{
var hasItem = uow.AccDocumentItems.Any(x => x.SLId == sl.SLId);
if (hasItem == true)
{
addSLTreeItemWindow0.sLCodeTextbox.IsEnabled = false;
addSLTreeItemWindow0.DL1.IsEnabled = false;
addSLTreeItemWindow0.DL2.IsEnabled = false;
}
treeSL.SaveClicked += (s) =>
{
//addTLTreeItemWindow0.DataItem.GL = gl;
s.SLId = sl.SLId;
s.ImageUrl = "../../Resources/cian.png";
// gl.TLs.Add(addTLTreeItemWindow0.DataItem);
sl.IsExpanded = true; // Ensure that the new child is visible
uow.SLs.Attach(s);
uow.Entry <SL>(s).State = EntityState.Modified;
// uow.GLs(g);
uow.SaveChanges();
addSLTreeItemWindow0.Close();
};
}
addSLTreeItemWindow0.Width = 1000;
addSLTreeItemWindow0.Height = 500;
addSLTreeItemWindow0.CanClose = true;
addSLTreeItemWindow0.Owner = Window.GetWindow(this);
addSLTreeItemWindow0.Show();
}
}
else if (tag == "delete")
{
if (_accessUtility.HasAccess(72))
{
using (var uow = new SainaDbContext())
{
var hasItem = uow.AccDocumentItems.Any(x => x.SLId == sl.SLId);
if (hasItem == false)
{
DialogParameters parameters = new DialogParameters();
parameters.OkButtonContent = "بله، مطمئنم";
parameters.CancelButtonContent = "خیر";
parameters.Header = "اخطار";
parameters.Content = "آیا برای حذف مطمئن هستید؟";
parameters.Closed = OnClosed;
RadWindow.Confirm(parameters);
_dialogResult = _dialogResult == true;
// _dialogResult == true;
}
else
{
DialogParameters parameters = new DialogParameters();
parameters.OkButtonContent = "بستن";
parameters.Header = "اخطار";
parameters.Content = ".امکان حذف وجود ندارد";
// parameters.Closed = OnClosed;
RadWindow.Alert(parameters);
_dialogResult = false;
}
if (_dialogResult == true)
{
// uow.GLs.Attach(gl);
// var test = uow.TLs.ToList().Select(x => x.TLId);
foreach (var item in _vm.Items)
{
foreach (var x in item.TLs)
{
if (x.SLs.Remove(sl))
{
break;
}
}
}
uow.Database.ExecuteSqlCommand($"Delete Info.SLs where SLId={sl.SLId} ");
// uow.RejectChanges();
// uow.GLs.Attach(new GL { GLId = gl.GLId });
//uow.Entry<GL>(gl).State = EntityState.Deleted;
//// uow.GLs.Remove(new GL { GLId=gl.GLId});
uow.SaveChanges();
var manager = new RadDesktopAlertManager(AlertScreenPosition.TopCenter, new Point(0, 0), 100);
var alert = new RadDesktopAlert
{
FlowDirection = FlowDirection.RightToLeft,
Header = "اطلاعات",
Content = ".حذف با موفقیت انجام شد",
ShowDuration = 5000,
};
manager.ShowAlert(alert);
}
}
}
}
}
}
public void Save()
{
_uow.SaveChanges();
}
public int SaveChanges()
{
return(_uow.SaveChanges());
}