public int Save(Models.MPayrollDetails model) { Common.Logger l = new Common.Logger(); string ClassName = "CPayrollDetails"; try { DB.PayrollDetail bs = new DB.PayrollDetail(); bs.id = Convert.ToInt32(model.PayrollId); bs.LastMonthPaid = model.LastMonthPaid; l.Print(ClassName, Common.LogPointer.Info.ToString(), "Model Values id[" + model.id + "] PayrollId[" + model.PayrollId + "] LastMonthPaid[" + model.LastMonthPaid + "] "); obj.PayrollDetails.InsertOnSubmit(bs); obj.SubmitChanges(); l.Print(ClassName, Common.LogPointer.Info.ToString(), "Record Inserted Successfully"); return(1); } catch (Exception ex) { l.Print(ClassName, Common.LogPointer.Error.ToString(), ex.ToString()); return(-1); } }
public int Save(Models.MRoles model) { Common.Logger l = new Common.Logger(); string ClassName = "CRoles"; try { DB.Role bs = new DB.Role(); //bs.id = int.Parse(model.id); bs.RoleName = model.RoleName; l.Print(ClassName, Common.LogPointer.Info.ToString(), "Model Values id[" + model.id + "] RoleName[" + model.RoleName + "] "); obj.Roles.InsertOnSubmit(bs); obj.SubmitChanges(); l.Print(ClassName, Common.LogPointer.Info.ToString(), "Record Inserted Successfully"); return(1); } catch (Exception ex) { l.Print(ClassName, Common.LogPointer.Error.ToString(), ex.ToString()); return(-1); } }
public int Save(Models.MUserRolesContainer model) { Common.Logger l = new Common.Logger(); string ClassName = "CUserRolesContainer"; try { DB.UserRolesContainer bs = new DB.UserRolesContainer(); bs.id = int.Parse(model.id); bs.userId = int.Parse(model.userId); l.Print(ClassName, Common.LogPointer.Info.ToString(), "Model Values id[" + model.id + "] userId[" + model.userId + "] RolesId[" + model.Rolesid + "] "); obj.UserRolesContainers.InsertOnSubmit(bs); obj.SubmitChanges(); l.Print(ClassName, Common.LogPointer.Info.ToString(), "Record Inserted Successfully"); return(1); } catch (Exception ex) { l.Print(ClassName, Common.LogPointer.Error.ToString(), ex.ToString()); return(-1); } }
/// <summary> /// Initializes a new instance of the <see cref="MainWindow"/> class. /// </summary> public MainWindow() { // DO NOT REORDER variable instantiation unless you know what you are doing!!! InitializeComponent(); // Settings should come first Settings.Instance = Settings.Load(Utilities.GetAppDataPath() + "Settings.xml"); if (Settings.Instance == null) { SettingsWindow win = new SettingsWindow(); Settings.Instance = new Settings(); win.ShowDialog(); } // File System must be set after settings FileSystem = new Common.FileSystem.IO(Settings.Instance.StorageLocation); // Logger can be started after FileSystem Logger = new Common.Logger(Utilities.GetAppDataPath()); // CouchDB can be instantiated after both FileSystem and Logger _couchdb = new Common.CouchDB.Database(Settings.Instance.CouchDatabaseName, new Common.CouchDB.Server(Settings.Instance.CouchServerIp, Settings.Instance.CouchServerPort)); Common.ErrorManager.UpdateUI actErrorUpdateUI = ErrorUpdateUI; ErrorManager = new Common.ErrorManager(actErrorUpdateUI); _statusBarItemGuid = Guid.Empty; _workMaster = new Master(ErrorManager, FileSystem, _couchdb); IdTranslation = new Dictionary<Guid, Guid>(); _fsWatcher = new FileSystemWatcher(Settings.Instance.StorageLocation); _fsWatcher.IncludeSubdirectories = true; _fsWatcher.NotifyFilter = NotifyFilters.LastWrite; _fsWatcher.Changed += new FileSystemEventHandler(FS_Changed); _fsWatcher.EnableRaisingEvents = true; _addedFileMappings = new Dictionary<string, Guid>(); this.Loaded += new RoutedEventHandler(MainWindow_Loaded); ResourceTree.OnRelease += new ResourceTreeView.EventDelegate(ResourceTree_OnRelease); ResourceTree.OnCancel += new ResourceTreeView.EventDelegate(ResourceTree_OnCancel); ResourceTree.OnItemSelect += new ResourceTreeView.EventDelegate(ResourceTree_OnItemSelect); ResourceTree.OnReload += new ResourceTreeView.EventDelegate(ResourceTree_OnReload); ResourceTree.OnStatusUpdate += new ResourceTreeView.StatusUpdateDelegate(ResourceTree_OnStatusUpdate); ResourceTree.RegisterStatusBarItem(SBItem); }
public void GetReleaseKeyTest() { var version = DotNetVersionCheck.GetReleaseKey(); Logger.Info("Version: " + version); }
public int Save(Models.MInventory model, Common.Constants.SaleTransactions transaction) { Common.Logger l = new Common.Logger(); string ClassName = "CInventory"; try { string totalUnitsofProducts = string.Empty; DB.Inventory bs = new DB.Inventory(); DB.InventoryBalance iv = new DB.InventoryBalance(); switch (transaction) { #region Addition Indentory case Common.Constants.SaleTransactions.Addition: { #region Updating Inventory var query = (from o in obj.Inventories where Convert.ToInt32(model.WareHouseld) == o.WareHouseId && o.ProductId == Convert.ToInt32(model.ProductId) && o.Cost == model.Cost select o.Quantity).FirstOrDefault(); if (query == null) { totalUnitsofProducts = model.Quantity; //Inventory bs.ProductId = int.Parse(model.ProductId); bs.WareHouseId = int.Parse(model.WareHouseld); bs.Cost = model.Cost; bs.date = model.Date; bs.Quantity = totalUnitsofProducts; bs.FiscalYearId = int.Parse(model.FiscalYearld); l.Print(ClassName, Common.LogPointer.Info.ToString(), "Model Values id[" + model.id + "] ProductId[" + model.ProductId + "] WareHouseId[" + model.WareHouseld + "] Cost[" + model.Cost + "] Quantity[ " + model.Cost + "] FiscalYearId[ " + model.FiscalYearld + " ] "); obj.Inventories.InsertOnSubmit(bs); obj.SubmitChanges(); l.Print(ClassName, Common.LogPointer.Info.ToString(), "Record Inserted Successfully"); } else { totalUnitsofProducts = query; float Quantity = 0; Quantity = Convert.ToSingle(totalUnitsofProducts) + Convert.ToSingle(model.Quantity); var Data = (from o in obj.Inventories where Convert.ToInt32(model.WareHouseld) == o.WareHouseId && o.ProductId == Convert.ToInt32(model.ProductId) && o.Cost == model.Cost select o); foreach (var item in Data) { item.ProductId = Convert.ToInt32(model.ProductId); item.Quantity = Convert.ToString(Quantity); item.Cost = model.Cost; item.WareHouseId = Convert.ToInt32(model.WareHouseld); item.date = model.Date; } obj.SubmitChanges(); } #endregion #region updating Inventory Balance var invenotryBalance = (from o in obj.InventoryBalances where o.ProductsId == Convert.ToInt32(model.ProductId) && o.WarehouseId == Convert.ToInt32(model.WareHouseld) orderby o.id ascending select o); if (!invenotryBalance.Any()) { iv.Date = Convert.ToDateTime(model.Date); iv.ProductsId = Convert.ToInt32(model.ProductId); iv.WarehouseId = Convert.ToInt32(model.WareHouseld); iv.PurchaseUnitsCost = model.Cost; iv.PurchaseUnits = model.Quantity; float PurchaseTotal = Convert.ToSingle(Convert.ToSingle(model.Cost) * Convert.ToSingle(model.Quantity)); iv.PurchaseTotal = PurchaseTotal.ToString(); iv.BalanceUnitsCost = model.Cost; iv.BalanceUnits = model.Quantity; iv.BalanceTotal = PurchaseTotal.ToString(); obj.InventoryBalances.InsertOnSubmit(iv); obj.SubmitChanges(); } else { float oldUnits = 0, oldCost = 0, oldTotal = 0, newTotal = 0, newUnits = 0, newCost = 0; foreach (var item in invenotryBalance) { oldUnits = Convert.ToSingle(item.BalanceUnits); oldCost = Convert.ToSingle(item.BalanceUnitsCost); oldTotal = Convert.ToSingle(item.BalanceTotal); newUnits = oldUnits + Convert.ToSingle(model.Quantity); newCost = Convert.ToSingle(model.Cost); newTotal = Convert.ToSingle(newUnits * newCost); } iv.Date = Convert.ToDateTime(model.Date); iv.ProductsId = Convert.ToInt32(model.ProductId); iv.WarehouseId = Convert.ToInt32(model.WareHouseld); iv.PurchaseUnitsCost = model.Cost; iv.PurchaseUnits = model.Quantity; float PurchaseTotal = Convert.ToSingle(Convert.ToSingle(model.Cost) * Convert.ToSingle(model.Quantity)); iv.PurchaseTotal = PurchaseTotal.ToString(); iv.BalanceUnitsCost = newCost.ToString(); iv.BalanceUnits = newUnits.ToString(); iv.BalanceTotal = newTotal.ToString(); obj.InventoryBalances.InsertOnSubmit(iv); obj.SubmitChanges(); } #endregion break; } #endregion #region Deduction Indentory case Common.Constants.SaleTransactions.Deduction: { #region Updating Inventory var query = (from o in obj.Inventories where Convert.ToInt32(model.WareHouseld) == o.WareHouseId && o.ProductId == Convert.ToInt32(model.ProductId) && o.Cost == model.Cost orderby o.date select o.Quantity).FirstOrDefault(); if (query == null) { return(0); } else { totalUnitsofProducts = query; float Quantity = 0; Quantity = Convert.ToSingle(totalUnitsofProducts) - Convert.ToSingle(model.Quantity); if (Quantity < 0) { //Quantity not found in warehouse/Invenotry return(0); } var Data = (from o in obj.Inventories where Convert.ToInt32(model.WareHouseld) == o.WareHouseId && o.ProductId == Convert.ToInt32(model.ProductId) && model.Cost == model.Cost select o); foreach (var item in Data) { item.ProductId = Convert.ToInt32(model.ProductId); item.Quantity = Convert.ToString(Quantity); item.Cost = model.Cost; item.WareHouseId = Convert.ToInt32(model.WareHouseld); bs.date = model.Date; } obj.SubmitChanges(); } #endregion #region Updating Inventory Balance var invenotryBalance = (from o in obj.InventoryBalances where o.ProductsId == Convert.ToInt32(model.ProductId) && o.WarehouseId == Convert.ToInt32(model.WareHouseld) orderby o.id ascending select o); if (!invenotryBalance.Any()) { iv.Date = Convert.ToDateTime(model.Date); iv.ProductsId = Convert.ToInt32(model.ProductId); iv.WarehouseId = Convert.ToInt32(model.WareHouseld); iv.SaleUnitsCost = model.Cost; iv.SaleUnits = model.Quantity; float PurchaseTotal = Convert.ToSingle(Convert.ToSingle(model.Cost) * Convert.ToSingle(model.Quantity)); iv.SaleTotal = PurchaseTotal.ToString(); iv.BalanceUnitsCost = model.Cost; iv.BalanceUnits = model.Quantity; iv.BalanceTotal = PurchaseTotal.ToString(); obj.InventoryBalances.InsertOnSubmit(iv); obj.SubmitChanges(); } else { float oldUnits = 0, oldCost = 0, oldTotal = 0, newTotal = 0, newUnits = 0, newCost = 0; foreach (var item in invenotryBalance) { oldUnits = Convert.ToSingle(item.BalanceUnits); oldCost = Convert.ToSingle(item.BalanceUnitsCost); oldTotal = Convert.ToSingle(item.BalanceTotal); newUnits = oldUnits - Convert.ToSingle(model.Quantity); newCost = Convert.ToSingle(model.Cost); newTotal = Convert.ToSingle(newUnits * newCost); } iv.Date = Convert.ToDateTime(model.Date); iv.ProductsId = Convert.ToInt32(model.ProductId); iv.WarehouseId = Convert.ToInt32(model.WareHouseld); iv.SaleUnitsCost = model.Cost; iv.SaleUnits = model.Quantity; float PurchaseTotal = Convert.ToSingle(Convert.ToSingle(model.Cost) * Convert.ToSingle(model.Quantity)); iv.SaleTotal = PurchaseTotal.ToString(); iv.BalanceUnitsCost = newCost.ToString(); iv.BalanceUnits = newUnits.ToString(); iv.BalanceTotal = newTotal.ToString(); obj.InventoryBalances.InsertOnSubmit(iv); obj.SubmitChanges(); } #endregion break; } #endregion #region Transfer Inventory case Common.Constants.SaleTransactions.Transfer: { break; } #endregion default: { totalUnitsofProducts = "0"; break; } } return(1); } catch (Exception ex) { l.Print(ClassName, Common.LogPointer.Error.ToString(), ex.ToString()); return(-1); } }
public int Save(Models.MSaleTransactions model) { Common.Logger l = new Common.Logger(); string ClassName = "CSaleTransaction"; try { DB.Transaction1 bs = new DB.Transaction1(); bs.id = Convert.ToInt32(model.id); bs.ProductID = Convert.ToInt32(model.ProductID); bs.CostPrice = model.CostPrice; bs.SalePrice = model.SalePrice; bs.units = model.units; bs.TransactionType = model.transactionType; bs.VendorID = model.VendorID; bs.ClientID = model.clientID; bs.OrderId = Convert.ToInt32(model.OrderId); bs.WareHouseId = Convert.ToInt32(model.WareHouseId); bs.date = model.date; l.Print(ClassName, Common.LogPointer.Info.ToString(), "Model Values id[" + model.id + "] ProductID[" + model.ProductID + "] CostPrice[" + model.CostPrice + "] SalePrice[" + model.SalePrice + "] units [ " + model.units + "] TransactionType [ " + model.transactionType + " ] ClientID [ " + model.clientID + " ] VendorID [ " + model.VendorID + " ] date [ " + model.date + " ]"); obj.Transaction1s.InsertOnSubmit(bs); obj.SubmitChanges(); if (model.transactionType == Common.Constants.SaleTransactions.Addition.ToString()) { Classes.CJournal cj = new CJournal(); DB.Journal j = new DB.Journal(); j.acc_id = Convert.ToInt32(Common.Constants.Accounts.ChartOfAccounts.MerchandiseInventory); j.amount = Convert.ToSingle(Convert.ToSingle(bs.CostPrice) * Convert.ToSingle(bs.units)) - Convert.ToSingle(model.Discount); j.des = "Purchased Inventory [" + bs.units + "] "; j.e_date = Convert.ToDateTime(model.date); j.type = Common.Constants.Accounts.Type.Debit.ToString(); obj.Journals.InsertOnSubmit(j); obj.SubmitChanges(); if (Convert.ToSingle(model.Discount) > 0) { j = new DB.Journal(); j.acc_id = Convert.ToInt32(Common.Constants.Accounts.ChartOfAccounts.PurchaseDiscount); j.amount = Convert.ToSingle(model.Discount); j.des = "Purchased Inventory Discount [" + bs.units + "] "; j.e_date = Convert.ToDateTime(model.date); j.type = Common.Constants.Accounts.Type.Debit.ToString(); obj.Journals.InsertOnSubmit(j); obj.SubmitChanges(); } j = new DB.Journal(); j.acc_id = Convert.ToInt32(Common.Constants.Accounts.ChartOfAccounts.Cash); j.amount = Convert.ToSingle(Convert.ToSingle(bs.CostPrice) * Convert.ToSingle(bs.units)); j.des = "Purchased Inventory [" + bs.units + "] "; j.e_date = Convert.ToDateTime(model.date); j.type = Common.Constants.Accounts.Type.Credit.ToString(); obj.Journals.InsertOnSubmit(j); obj.SubmitChanges(); } else if (model.transactionType == Common.Constants.SaleTransactions.Deduction.ToString()) { Classes.CJournal cj = new CJournal(); DB.Journal j = new DB.Journal(); j.acc_id = Convert.ToInt32(Common.Constants.Accounts.ChartOfAccounts.Cash); j.amount = Convert.ToSingle(Convert.ToSingle(bs.CostPrice) * Convert.ToSingle(bs.units)) - Convert.ToSingle(model.Discount); j.des = "Sold Inventory [" + bs.units + "] "; j.e_date = Convert.ToDateTime(model.date); j.type = Common.Constants.Accounts.Type.Debit.ToString(); obj.Journals.InsertOnSubmit(j); obj.SubmitChanges(); if (Convert.ToSingle(model.Discount) > 0) { j = new DB.Journal(); j.acc_id = Convert.ToInt32(Common.Constants.Accounts.ChartOfAccounts.SalesDiscount); j.amount = Convert.ToSingle(model.Discount); j.des = "Sold Inventory Discount [" + bs.units + "] "; j.e_date = Convert.ToDateTime(model.date); j.type = Common.Constants.Accounts.Type.Debit.ToString(); obj.Journals.InsertOnSubmit(j); obj.SubmitChanges(); } j = new DB.Journal(); j.acc_id = Convert.ToInt32(Common.Constants.Accounts.ChartOfAccounts.Sales); j.amount = Convert.ToSingle(Convert.ToSingle(bs.CostPrice) * Convert.ToSingle(bs.units)); j.des = "Sold Inventory [" + bs.units + "] "; j.e_date = Convert.ToDateTime(model.date); j.type = Common.Constants.Accounts.Type.Credit.ToString(); obj.Journals.InsertOnSubmit(j); obj.SubmitChanges(); cj = new CJournal(); j = new DB.Journal(); j.acc_id = Convert.ToInt32(Common.Constants.Accounts.ChartOfAccounts.CostOfGoodsSold); j.amount = Convert.ToSingle(Convert.ToSingle(bs.CostPrice) * Convert.ToSingle(bs.units)); j.des = "Sold Inventory [" + bs.units + "] "; j.e_date = Convert.ToDateTime(model.date); j.type = Common.Constants.Accounts.Type.Debit.ToString(); obj.Journals.InsertOnSubmit(j); obj.SubmitChanges(); j = new DB.Journal(); j.acc_id = Convert.ToInt32(Common.Constants.Accounts.ChartOfAccounts.MerchandiseInventory); j.amount = Convert.ToSingle(Convert.ToSingle(bs.CostPrice) * Convert.ToSingle(bs.units)); j.des = "Sold Inventory [" + bs.units + "] "; j.e_date = Convert.ToDateTime(model.date); j.type = Common.Constants.Accounts.Type.Credit.ToString(); obj.Journals.InsertOnSubmit(j); obj.SubmitChanges(); } l.Print(ClassName, Common.LogPointer.Info.ToString(), "Record Inserted Successfully"); return(1); } catch (Exception ex) { l.Print(ClassName, Common.LogPointer.Error.ToString(), ex.ToString()); return(-1); } }