private void Page_Loaded(object sender, RoutedEventArgs e)
{
entity.Properties.Settings _setting = new entity.Properties.Settings();
sales_packingViewSource = FindResource("sales_packingViewSource") as CollectionViewSource;
dbContext.sales_packing.Where(a => a.id_company == _setting.company_ID).Include("sales_packing_detail").Load();
sales_packingViewSource.Source = dbContext.sales_packing.Local;
sales_packingsales_packinglist_detailViewSource = FindResource("sales_packingsales_packing_detailViewSource") as CollectionViewSource;
CollectionViewSource app_branchViewSource = FindResource("app_branchViewSource") as CollectionViewSource;
app_branchViewSource.Source = dbContext.app_branch.Where(a => a.is_active == true && a.id_company == _setting.company_ID).OrderBy(a => a.name).ToList();
CollectionViewSource app_terminalViewSource = FindResource("app_terminalViewSource") as CollectionViewSource;
app_terminalViewSource.Source = dbContext.app_terminal.Where(a => a.is_active == true && a.id_company == _setting.company_ID).OrderBy(a => a.name).ToList();
sales_orderViewSource = FindResource("sales_orderViewSource") as CollectionViewSource;
sales_orderViewSource.Source = dbContext.sales_order.Where(a => a.id_company == _setting.company_ID && a.status == Status.Documents_General.Approved).Include(a => a.sales_order_detail).ToList();
Dispatcher.InvokeAsync(new Action(() =>
{
cbxDocument.ItemsSource = entity.Brillo.Logic.Range.List_Range(dbContext, entity.App.Names.PackingList, _setting.branch_ID, _setting.terminal_ID);
cbxPackingType.ItemsSource = Enum.GetValues(typeof(Status.PackingTypes));
}));
}
private void CurrencyBox_Loaded(object sender, RoutedEventArgs e)
{
if (!DesignerProperties.GetIsInDesignMode(this))
{
using (db db = new db())
{
entity.Properties.Settings _setting = new entity.Properties.Settings();
app_currencyList = db.app_currency.Where(x => x.id_company == _setting.company_ID && x.is_active == true).ToList();
cbCurrency.ItemsSource = app_currencyList;
}
}
}
private void auth_Login(string u, string p)
{
Dispatcher.BeginInvoke((Action)(() => { this.Cursor = Cursors.AppStarting; }));
Dispatcher.BeginInvoke((Action)(() => { progBar.IsIndeterminate = true; }));
try
{
entity.Properties.Settings Settings = new entity.Properties.Settings();
if (Settings.company_ID == 0)
{
using (db db = new db())
{
Settings.company_ID = db.app_company.FirstOrDefault().id_company;
Settings.Save();
}
}
Cognitivo.Properties.Settings ViewSettings = new Properties.Settings();
CurrentSession.ConnectionString = ViewSettings.MySQLconnString;
CurrentSession.Start(u, p);
if (CurrentSession.User != null)
{
Dispatcher.BeginInvoke((Action)(() =>
{
if (chbxRemember.IsChecked == true)
{
Settings.user_UserName = tbxUser.Text;
Settings.Save();
}
}));
myWindow.is_LoggedIn = true;
Dispatcher.BeginInvoke((Action)(() => myFrame.Navigate(new mainMenu_Corporate())));
}
else
{
Dispatcher.BeginInvoke((Action)(() => { tbxUser.Focus(); }));
}
}
catch (Exception ex)
{
MessageBox.Show(ex.InnerException.ToString(), "Cognitivo ERP", MessageBoxButton.OK, MessageBoxImage.Error);
}
finally
{
Dispatcher.BeginInvoke((Action)(() => { this.Cursor = Cursors.Arrow; }));
Dispatcher.BeginInvoke((Action)(() => { progBar.IsIndeterminate = false; }));
taskAuth = null;
}
}
private void Page_Loaded(object sender, RoutedEventArgs e)
{
entity.Properties.Settings _settings = new entity.Properties.Settings();
template_designerViewSource = FindResource("template_designerViewSource") as CollectionViewSource;
ProjectTemplateDB.project_event_template.Where(a => a.is_active == true && a.id_company == _settings.company_ID).Load();
template_designerViewSource.Source = ProjectTemplateDB.project_event_template.Local;
template_designerservices_per_eventViewSource = FindResource("template_designerservices_per_eventViewSource") as CollectionViewSource;
template_designerproject_event_template_variableViewSource = FindResource("template_designerproject_event_template_variableViewSource") as CollectionViewSource;
List <item_tag> item_tag = new List <item_tag>();
item_tag = ProjectTemplateDB.item_tag.Where(a => a.id_company == _settings.company_ID && a.is_active == true).ToList();
CollectionViewSource item_tagViewSource = FindResource("item_tagViewSource") as CollectionViewSource;
item_tagViewSource.Source = item_tag;
CollectionViewSource item_tagViewSourceForEvents = FindResource("item_tagViewSourceForEvents") as CollectionViewSource;
item_tagViewSourceForEvents.Source = item_tag;
CollectionViewSource item_tagViewSourceForPerson = FindResource("item_tagViewSourceForPerson") as CollectionViewSource;
item_tagViewSourceForPerson.Source = item_tag;
}
public mainLogIn()
{
InitializeComponent();
try
{
lblVersion.Content = ApplicationDeployment.CurrentDeployment.CurrentVersion.ToString();
}
catch
{
var obj = Assembly.GetExecutingAssembly().GetName().Version;
lblVersion.Content = string.Format("Application Version {0}.{1}.{2}.{3}", obj.Major, obj.Minor, obj.Build, obj.Revision);
}
myFrame = myWindow.mainFrame;
//string imgSource = "http://images2.fanpop.com/image/photos/12900000/Tony-Stark-tony-stark-12952919-387-528.jpg";
//BitmapImage bitmap = new BitmapImage();
//bitmap.BeginInit();
//bitmap.UriSource = new Uri(imgSource, UriKind.Absolute);
//bitmap.EndInit();
//imgAvatar.ImageSource = bitmap;
Task taskdb = Task.Factory.StartNew(() => check_createdb());
entity.Properties.Settings Settings = new entity.Properties.Settings();
if (Settings.user_Name != null && Settings.user_UserName != "")
{
tbxUser.Text = Settings.user_UserName;
tbxPassword.Focus();
chbxRemember.IsChecked = true;
}
else
{
tbxUser.Focus();
}
}
private async void Page_Loaded(object sender, RoutedEventArgs e)
{
entity.Properties.Settings _setting = new entity.Properties.Settings();
employeeViewSource = (CollectionViewSource)FindResource("contactViewSource");
await dbContext.contacts.Where(i => i.is_employee && i.is_active && i.id_company == _setting.company_ID).OrderBy(i => i.name).ToListAsync();
employeeViewSource.Source = dbContext.contacts.Local;
contacthr_contractViewSource = (CollectionViewSource)FindResource("contacthr_contractViewSource");
contacthr_familyViewSource = (CollectionViewSource)FindResource("contacthr_familyViewSource");
contacthr_talent_detailViewSource = (CollectionViewSource)FindResource("contacthr_talent_detailViewSource");
contacthr_educationViewSource = (CollectionViewSource)FindResource("contacthr_educationViewSource");
hr_positionViewSource = (CollectionViewSource)FindResource("hr_positionViewSource");
await dbContext.hr_position.ToListAsync();
hr_positionViewSource.Source = dbContext.hr_position.Local;
app_departmentViewSource = (CollectionViewSource)FindResource("app_departmentViewSource");
await dbContext.app_department.ToListAsync();
app_departmentViewSource.Source = dbContext.app_department.Local;
hr_talentViewSource = (CollectionViewSource)FindResource("hr_talentViewSource");
await dbContext.hr_talent.ToListAsync();
hr_talentViewSource.Source = dbContext.hr_talent.Local;
app_locationViewSource = (CollectionViewSource)FindResource("app_locationViewSource");
await dbContext.app_location.ToListAsync();
app_locationViewSource.Source = dbContext.app_location.Local;
cbxBloodtype.ItemsSource = Enum.GetValues(typeof(contact.BloodTypes));
cbxmaritialstatus.ItemsSource = Enum.GetValues(typeof(contact.CivilStatus));
cbxGender.ItemsSource = Enum.GetValues(typeof(contact.Genders));
cbxRelation.ItemsSource = Enum.GetValues(typeof(hr_family.Relationship));
}
private void check_createdb()
{
using (var db = new db())
{
bool db_exists = db.Database.Exists();
if (!db_exists)
{
Dispatcher.BeginInvoke((Action)(() => { myFrame.Navigate(new StartUp()); }));
}
else
{
string company_Alias = string.Empty;
app_company app_company = db.app_company.Where(x => x.id_company == entity.CurrentSession.Id_Company).FirstOrDefault();
if (app_company != null)
{
if (!string.IsNullOrEmpty(app_company.alias))
{
company_Alias = app_company.alias;
}
else
{
company_Alias = app_company.name;
}
}
entity.Properties.Settings Settings = new entity.Properties.Settings();
Settings.company_Name = company_Alias;
Dispatcher.BeginInvoke((Action)(() =>
{
Settings.Save();
}));
}
}
}
private void item_request_detailMovementDataGrid_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
entity.Properties.Settings setting = new entity.Properties.Settings();
int id_branch = setting.branch_ID;
CollectionViewSource item_requestitem_request_detailViewSource = ((CollectionViewSource)(FindResource("item_requestitem_request_detailViewSource")));
item_request_detail item_request_detail = (item_request_detail)item_requestitem_request_detailViewSource.View.CurrentItem;
if (item_request_detail != null)
{
item _item = dbContext.items.Where(x => x.id_item == item_request_detail.id_item).FirstOrDefault();
var movement =
(from items in dbContext.item_movement
where items.status == Status.Stock.InStock &&
items.item_product.id_item == item_request_detail.id_item &&
items.app_location.id_branch == id_branch
group items by new { items.app_location }
into last
select new
{
id_location = last.Key.app_location.id_location,
location = last.Key.app_location.name,
quntitiy = last.Sum(x => x.credit != null ? x.credit : 0) - last.Sum(x => x.debit != null ? x.debit : 0),
}).ToList();
List <desion> list_desion = new List <desion>();
foreach (dynamic item in movement)
{
// int id_location = (int)item.location;
desion desion = new desion();
desion.id_item = _item.id_item;
desion.id_location = item.id_location;
desion.location = item.location;
desion.name = _item.name;
desion.avlqty = item.quntitiy;
desion.decisionqty = 0;
desion.decisionState = state.added;
list_desion.Add(desion);
}
item_request_decisionmovementDataGrid.ItemsSource = list_desion;
var transfer =
//(from items in dbContext.item_transfer_detail
// where items.item_product.id_item == item_request_detail.id_item
// group items by new { items.item_transfer.app_branch_destination }
// into last
// select new
// {
// id_location = last.Key.app_branch_destination.app_location.Where(x => x.is_default).FirstOrDefault().id_location,
// branch = last.Key.app_branch_destination.name,
// quntitiy = last.Sum(x => x.quantity_destination != null ? x.quantity_destination : 0),
// }).ToList();
(from items in dbContext.item_movement
where items.status == Status.Stock.InStock &&
items.item_product.id_item == item_request_detail.id_item
group items by new { items.app_location.app_branch }
into last
select new
{
id_location = last.Key.app_branch.app_location.Where(x => x.is_default).FirstOrDefault().id_location,
branch = last.Key.app_branch.name,
quntitiy = last.Sum(x => x.credit != null ? x.credit : 0) - last.Sum(x => x.debit != null ? x.debit : 0),
}).ToList();
List <desion> list_desion_transfer = new List <desion>();
foreach (dynamic item in transfer)
{
desion desion = new desion();
desion.branch = item.branch;
desion.id_location = item.id_location;
desion.id_item = _item.id_item;
desion.name = _item.name;
desion.avlqty = item.quntitiy;
desion.decisionqty = 0;
desion.decisionState = state.added;
list_desion_transfer.Add(desion);
}
item_request_decisiontransferDataGrid.ItemsSource = list_desion_transfer;
List <desion> list_desion_purchase = new List <desion>();
desion purchasedesion = new desion();
purchasedesion.decisionState = state.added;
purchasedesion.decisionqty = 0;
list_desion_purchase.Add(purchasedesion);
item_request_decisionpurchaseDataGrid.ItemsSource = list_desion_purchase;
List <desion> list_desion_production = new List <desion>();
desion productiondesion = new desion();
productiondesion.name = item_request_detail.item.name;
productiondesion.RaisePropertyChanged("name");
productiondesion.decisionqty = 0;
productiondesion.decisionState = state.added;
list_desion_production.Add(productiondesion);
item_request_decisionproductionDataGrid.ItemsSource = list_desion_production;
}
}