Beispiel #1
0
        /// <summary>
        /// This method is used to delete the tax
        /// </summary>
        /// <param name="param"></param>
        void DeleteTax(object param)
        {
            Mouse.OverrideCursor = Cursors.Wait;
            ITaxOperationRepository     taxRepository = new TaxOperationRepository();
            ITaxCodesAndRatesRepository tax           = new TaxCodesAndRatesRepository();
            var taxModel = SelectedTax as TaxModel;

            if (taxModel != null)
            {
                if (taxModel.Predefined == false || taxModel.Predefined == null)
                {
                    MessageBoxResult result = MessageBox.Show("Do you want to delete tax?\n" + "@ Simple Accounting Software Pte Ltd", "Delete Tax", MessageBoxButton.YesNo);
                    if (result == MessageBoxResult.Yes)

                    {
                        var Check = tax.IsTaxDeleted(taxModel.TaxID);
                        if (Check.Equals("1") && Check != null)
                        {
                            TaxErrors = "# GST Code cannot be deleted because it is used in transaction.";
                        }
                        else
                        {
                            taxRepository.DeleteTax(taxModel.TaxID);
                            SelectedTax = new TaxModel();
                            Tax         = new ObservableCollection <TaxModel>(tax.GetAllTaxes());
                        }
                    }
                }
                else
                {
                    TaxErrors = "# GST Free cannot be deleted.";
                }
            }
            Mouse.OverrideCursor = null;
        }
Beispiel #2
0
        public async Task <IActionResult> Edit([FromRoute] Guid Id, [FromBody] TaxModel obj)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            if (Id != obj.Id)
            {
                return(BadRequest());
            }

            var dataModel = _mapper.Map <Tax>(obj);

            _context.Entry(dataModel).State = EntityState.Modified;

            try
            {
                await _context.SaveChangesAsync();
            }
            catch (DbUpdateConcurrencyException)
            {
                if (!Exists(Id))
                {
                    return(NotFound());
                }
                else
                {
                    throw;
                }
            }

            return(NoContent());
        }
Beispiel #3
0
        /// <summary>
        /// This method is used to delete the tax
        /// </summary>
        /// <param name="param"></param>
        void DeleteTax(object param)
        {
            Mouse.OverrideCursor = Cursors.Wait;
            ITaxOperationRepository     taxRepository = new TaxOperationRepository();
            ITaxCodesAndRatesRepository tax           = new TaxCodesAndRatesRepository();
            var taxModel = SelectedTax as TaxModel;

            if (taxModel != null)
            {
                if (taxModel.Predefined == false || taxModel.Predefined == null)
                {
                    MessageBoxResult result = MessageBox.Show("Do you want to delete tax?", "Delete Tax", MessageBoxButton.YesNo);
                    if (result == MessageBoxResult.Yes)
                    {
                        taxRepository.DeleteTax(taxModel.TaxID);
                        SelectedTax = new TaxModel();
                        Tax         = new ObservableCollection <TaxModel>(tax.GetAllTaxes());
                    }
                }
                else
                {
                    TaxErrors = "# GST Free cannot be deleted.";
                }
            }
            Mouse.OverrideCursor = null;
        }
Beispiel #4
0
        private void dgTax_DoubleClick(object sender, EventArgs e)
        {
            try
            {
                int gridCount = dgTax.Rows.Count;
                if (gridCount > 1)
                {
                    clearForm();
                    taxCode = dgTax.Rows[dgTax.Row][1].ToString();
                    doc     = dgTax.Rows[dgTax.Row][2].ToString();
                    taxName = dgTax.Rows[dgTax.Row][3].ToString();
                    if (taxCode != "Tax Code")
                    {
                        TaxModel           taxdata       = new TaxModel();
                        TaxSiteDocMapModel taxsitedocmap = new TaxSiteDocMapModel();
                        taxdata       = this.taxManager.GetTaxByID(taxCode);
                        taxsitedocmap = this.taxManager.GetTaxByDoc(taxCode, doc);
                        if (taxdata != null)
                        {
                            txtTaxName.Text               = taxdata.TaxName;
                            txtTaxValue.Value             = taxdata.Value;
                            cmbDocumentType.SelectedValue = taxsitedocmap.DocumentType;
                            cmbAppliedon.SelectedValue    = taxsitedocmap.Appliedon;
                            if (taxdata.Type == "Per")
                            {
                                rdoTVTPercent.Checked = true;
                            }
                            else
                            {
                                rdoTVTValue.Checked = true;
                            }

                            if (taxdata.Inclusive == true)
                            {
                                rdoTaxInclusive.Checked = true;
                            }
                            else
                            {
                                rdoTaxExclusive.Checked = true;
                            }

                            if (taxdata.InterStateTax == true)
                            {
                                chkInterStateTax.Checked = true;
                            }
                            else
                            {
                                chkInterStateTax.Checked = false;
                            }
                            flag = true;
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                CommonFunc.ShowMessage(ex.Message, MessageType.Information);
                Logger.Log(ex.Message, Logger.LogingLevel.Error);
            }
        }
        public int InsertTax(TaxModel tax)
        {
            _provider.DisconnectFromDb();

            if (!_provider.Connected)
            {
                throw new AccessToNotConnectedDatabaseException();
            }
            var db = _provider.DatabaseContext;

            using (var transaction = db.GetTransaction())
            {
                if (db.FirstOrDefault <TaxModel>(
                        "WHERE TaxRate = @0 AND MinValue = @1 AND MaxValue = @2 AND CategoryId = @3 AND StateId = @4",
                        tax.TaxRate, tax.MinValue, tax.MaxValue, tax.CategoryId, tax.StateId) != null)
                {
                    throw new ItemAlreadyExistsException();
                }
                db.Insert(tax);

                transaction.Complete();
            }

            _provider.DisconnectFromDb();

            return(tax.Id);
        }
        public void DeleteTax(TaxModel taxToDelete)
        {
            _provider.ConnectToDb();

            if (!_provider.Connected)
            {
                throw new AccessToNotConnectedDatabaseException();
            }
            var db = _provider.DatabaseContext;

            using (var transaction = db.GetTransaction())
            {
                if (db.FirstOrDefault <TaxModel>(
                        "WHERE TaxRate = @0 AND MinValue = @1 AND MaxValue = @2 AND CategoryId = @3 AND StateId = @4",
                        taxToDelete.TaxRate, taxToDelete.MinValue, taxToDelete.MaxValue, taxToDelete.CategoryId,
                        taxToDelete.StateId) == null)
                {
                    throw new ItemNotFoundException();
                }

                db.Delete(taxToDelete);

                transaction.Complete();
            }

            _provider.DisconnectFromDb();
        }
Beispiel #7
0
        public void Add(TaxModel item)
        {
            try
            {
                if (item == null)
                {
                    throw new ArgumentNullException("item");
                }

                var tax = new Tax
                {
                    Id         = item.Id,
                    Name       = item.Name,
                    Code       = item.Code,
                    Rate       = item.Rate,
                    CompanyId  = item.CompanyId,
                    IsActive   = item.IsActive,
                    IsCompound = item.IsCompound
                };
                this._taxRepository.Add(tax);
            }
            catch (Exception ex)
            {
                throw;
            }
        }
Beispiel #8
0
        private async void updateDefaultTax(TaxModel obj)
        {
            if (await Singleton.getDialogueBox().showAsync("Do you confirm the update of the default tax?"))
            {
                Singleton.getDialogueBox().showSearch(ConfigurationManager.AppSettings["update_message"]);
                var savedTaxes = await Bl.BlOrder.UpdateTaxAsync(new List <Tax> {
                    obj.Tax
                });

                if (savedTaxes.Count > 0)
                {
                    await Singleton.getDialogueBox().showAsync("The default Tax has been successfully updated!");
                }
            }
            else
            {
                Tax taxFound = Bl.BlOrder.searchTax(new Tax {
                    Tax_current = 1
                }, ESearchOption.AND).SingleOrDefault();
                if (taxFound != null)
                {
                    var taxModel = TaxList.Where(x => x.Tax.ID == taxFound.ID).SingleOrDefault();
                    if (taxModel != null)
                    {
                        taxModel.IsDefault = true;
                    }
                }
            }
            clearNewTax(null);
            Singleton.getDialogueBox().IsDialogOpen = false;
        }
Beispiel #9
0
        public int InsertTax(TaxModel taxModel)
        {
            int result = 0;

            using (SqlConnection con = new SqlConnection(_ConnectionString.Value.ConnectionString))
            {
                CommonRepository commonRepository = new CommonRepository(_ConnectionString);
                result = commonRepository.GetValidateUnique("Tax", "TaxName", taxModel.TaxName, taxModel.Id.ToString());
                if (result > 0)
                {
                    return(-1);
                }

                int MaxId = commonRepository.GetMaxId("Tax");

                con.Open();
                SqlTransaction sqltrans = con.BeginTransaction();
                var            query    = "INSERT INTO Tax (Id,TaxName,TaxPercentage,TaxType," +
                                          "UserIdInserted,DateInserted,IsDeleted)" +
                                          "VALUES (" + MaxId + ",@TaxName,@TaxPercentage,@TaxType," +
                                          +LoginInfo.Userid + ",GetUtcDate(),0); SELECT CAST(SCOPE_IDENTITY() as INT);";
                result = con.Execute(query, taxModel, sqltrans, 0, System.Data.CommandType.Text);

                if (result > 0)
                {
                    sqltrans.Commit();
                    string output = commonRepository.SyncTableStatus("Tax");
                }
                else
                {
                    sqltrans.Rollback();
                }
                return(result);
            }
        }
            public void Setup()
            {
                _stateRepository    = Substitute.For <IStateDatabaseAccess>();
                _productRepository  = Substitute.For <IProductDatabaseAccess>();
                _categoryRepository = Substitute.For <ICategoryDatabaseAccess>();
                _expectedCategory   = new CategoryModel
                {
                    Id   = CategoryId,
                    Name = CategoryName
                };

                _expectedProduct = Product().OfCategory(_expectedCategory).WithCategoryId(CategoryId)
                                   .OfName(ProductName).WithId(ProductId).WithPurchasePrice(PurchasePrice).Build();

                _expectedTax = Tax().OfTaxRate(TaxRate).OfMinValue(MinMoney).OfMaxValue(MaxMoney)
                               .OfCategoryId(CategoryId).OfStateId(StateId).OfId(TaxId).Build();

                _expectedState = State().OfName(StateName).OfId(StateId)
                                 .OfBaseSalesTax(TaxRate).AppendTax(_expectedTax).Build();

                _preparedStates = new List <StateOfAmericaModel> {
                    _expectedState
                };
                _preparedCategories = new List <CategoryModel> {
                    _expectedCategory
                };
                _preparedProducts = new List <ProductModel> {
                    _expectedProduct
                };
            }
Beispiel #11
0
        void GetOptionsandTaxValues()
        {
            OptionsEntity oData = new OptionsEntity();
            ICustomerPaymentDueDaysRepository paymentRepository = new CustomerPaymentDueDaysRepository();

            oData = paymentRepository.GetOptionSettings();
            if (oData != null)
            {
                this.CurrencyName   = oData.CurrencyCode;   //there is no currency name field in database
                this.CurrencyCode   = oData.CurrencyCode;
                this.CurrencyFormat = oData.NumberFormat;
                this.DecimalPlaces  = oData.DecimalPlaces;
            }
            else
            {
                this.CurrencyName   = "USD";
                this.CurrencyCode   = "USD";
                this.CurrencyFormat = "en-US";
            }
            TaxModel objDefaultTax = new TaxModel();

            objDefaultTax = paymentRepository.GetDefaultTaxes().FirstOrDefault();
            if (objDefaultTax != null)
            {
                this.TaxName = objDefaultTax.TaxName;
            }
            else
            {
                this.TaxName = "GST";
            }
        }
        public bool IsCodeAndRateExists(TaxModel taxModel)
        {
            bool isExists = false;

            try
            {
                using (SASEntitiesEDM objEntities = new SASEntitiesEDM())
                {
                    var tax = objEntities.TaxCodesAndRates.Where(e => e.Tax_Code.Trim() == taxModel.TaxCode
                                                                 //&& e.Tax_Rate == taxModel.TaxRate ------removes after client MOM on 11 may 2017
                                                                 && e.IsDeleted == false && e.ID != taxModel.TaxID).ToList();
                    if (tax.Count > 0)
                    {
                        isExists = true;
                    }
                    else
                    {
                        isExists = false;
                    }
                }
                return(isExists);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Beispiel #13
0
        public ActionResult Tax(TaxModel taxModel)
        {
            if (!ModelState.IsValid)
            {
                string errorString = this.ValidationTax(taxModel);
                if (!string.IsNullOrEmpty(errorString))
                {
                    ViewBag.Validate = errorString;
                    return(View(taxModel));
                }
            }

            if (taxModel.Id > 0)
            {
                var result = _iTaxService.UpdateTax(taxModel);
                if (result == -1)
                {
                    ModelState.AddModelError("TaxName", "Tax name already exists");
                    return(View(taxModel));
                }
                ViewBag.Result = _locService.GetLocalizedHtmlString("EditSuccss");
            }
            else
            {
                var result = _iTaxService.InsertTax(taxModel);
                if (result == -1)
                {
                    ModelState.AddModelError("TaxName", "Tax name already exists");
                    return(View(taxModel));
                }
                ViewBag.Result = _locService.GetLocalizedHtmlString("SaveSuccess");
            }

            return(RedirectToAction("Index", "Tax"));
        }
Beispiel #14
0
 public void SaveUpdateTax(TaxModel model)
 {
     try
     {
         Tax tax = new Tax();
         if (model.TaxCode > 0)
         {
             tax             = _taxRepository.GetTax().FirstOrDefault(x => x.Id == model.TaxCode);
             tax.CreatedDate = CommonFunctions.ParseDateToFinclaveString(DateTime.Now.ToShortDateString());
         }
         else
         {
             tax.CreatedDate  = model.CreatedDate;
             tax.ModifiedBy   = model.ModifiedBy;
             tax.ModifiedDate = model.ModifiedDate;
         }
         tax.TaxDetail = model.TaxDetail;
         tax.Rate      = model.Rate;
         _taxRepository.SaveUpdateTax(tax);
     }
     catch (Exception ex)
     {
         fault.Result       = false;
         fault.ErrorMessage = "Error During Save Or Update Tax";
         fault.ErrorDetails = ex.ToString();
         throw new FaultException <FaultData>(fault);
     }
 }
Beispiel #15
0
        public ActionResult Index(TaxModel model, string cmd)
        {
            TaxService objService = new TaxService();
            int        uid        = 0;

            if (Session["UID"] != null)
            {
                uid = Convert.ToInt32(Session["UID"].ToString());
                if (cmd == "Save Tax")
                {
                    model.Status      = true;
                    model.CreatedBy   = uid;
                    model.CreatedDate = System.DateTime.Now;
                    objService.InsertTax(model);
                    TempData["AMsg"] = "Main Tax Saved Successfully!";
                }
                else
                {
                    model.Name        = model.SName;
                    model.Percentage  = model.SPercentage;
                    model.Description = model.SDescription;

                    model.Status      = true;
                    model.CreatedBy   = uid;
                    model.CreatedDate = System.DateTime.Now;
                    objService.InsertSTax(model);
                    TempData["AMsg"] = "Sub Tax Saved Successfully!";
                }
            }
            return(RedirectToAction("Index"));
        }
Beispiel #16
0
        private void GetListData()
        {
            IPurchaseOrderListRepository purchaseRepository = new PurchaseOrderListRepository();

            var cashBankAcnts = rmRepository.GetAccountDetails().Where(t => t.AccountType == Convert.ToByte(Account_Type.Cash) ||
                                                                       t.AccountType == Convert.ToByte(Account_Type.Bank) || t.AccountType == Convert.ToByte(Account_Type.CreditCard)).ToList();

            if (cashBankAcnts != null)
            {
                TransferFromCashAndBankAccountsLst = cashBankAcnts.ToList();
                TransferTocashAndBankAccountsLst   = cashBankAcnts.ToList();
            }

            var taxes = purchaseRepository.GetDefaultTaxes().ToList();

            if (taxes != null)
            {
                LstTaxes = taxes.ToList();
            }
            TaxModel objDefaultTax = new TaxModel();

            objDefaultTax = purchaseRepository.GetDefaultTaxes().FirstOrDefault();
            if (objDefaultTax != null)
            {
                TaxName = objDefaultTax.TaxName;
            }
        }
Beispiel #17
0
        public IActionResult Edit(int id)
        {
            ViewData["TaxList"] = null;

            DataTable _dtResp = GetTaxList();

            if (this._objHelper.checkDBNullResponse(_dtResp))
            {
                ViewData["TaxList"] = _dtResp;
            }
            else
            {
                ViewData["ListErrorMessage"] = "Unable to fetch data. Try again later.";
            }

            List <KeyValuePair <string, string> > parameters = new List <KeyValuePair <string, string> >();

            parameters.Add(new KeyValuePair <string, string>("selectBy", "tax_by_id"));
            parameters.Add(new KeyValuePair <string, string>("param1", id.ToString()));
            parameters.Add(new KeyValuePair <string, string>("param2", ""));

            DataTable _dtResp1 = _objDataHelper.ExecuteProcedure("entity_master_select", parameters);

            TaxModel tax = new TaxModel();

            tax.applicability = Convert.ToString(_dtResp1.Rows[0]["applicability"]);
            tax.header        = Convert.ToString(_dtResp1.Rows[0]["label"]);
            tax.type          = Convert.ToString(_dtResp1.Rows[0]["type"]);
            tax.value         = Convert.ToInt32(_dtResp1.Rows[0]["value"]);

            return(View("~/Views/Panel/Tax/Edit.cshtml", tax));
        }
Beispiel #18
0
        public ActionResult GetTaxDTableForm()
        {
            TaxModel model = new TaxModel();

            List <TaxList> getTaxList = new List <TaxList>();

            var SQLQuery = "SELECT [TaxID], [Description], [Percentage], [BaseTax], Tbl_FMCOA_GeneralAccount.GATitle,[isUsed], [ShortDepscription] from [Tbl_FMTax], [Tbl_FMCOA_GeneralAccount] where[Tbl_FMCOA_GeneralAccount].GAID = [Tbl_FMTax].GAID";

            using (SqlConnection Connection = new SqlConnection(GlobalFunction.ReturnConnectionString()))
            {
                Connection.Open();
                using (SqlCommand command = new SqlCommand("[dbo].[SP_Tax]", Connection))
                {
                    command.CommandType = CommandType.StoredProcedure;
                    command.Parameters.Add(new SqlParameter("@SQLStatement", SQLQuery));
                    SqlDataReader dr = command.ExecuteReader();
                    while (dr.Read())
                    {
                        getTaxList.Add(new TaxList()
                        {
                            TaxID           = GlobalFunction.ReturnEmptyInt(dr[0]),
                            Description     = GlobalFunction.ReturnEmptyString(dr[1]),
                            Percentage      = GlobalFunction.ReturnEmptyString(dr[2]),
                            BaseTax         = GlobalFunction.ReturnEmptyString(dr[3]),
                            GATitle         = GlobalFunction.ReturnEmptyString(dr[4]),
                            isUsed          = GlobalFunction.ReturnEmptyBool(dr[5]),
                            ShortDescrption = GlobalFunction.ReturnEmptyString(dr[6])
                        });
                    }
                }
                Connection.Close();
            }
            model.getTaxList = getTaxList.ToList();
            return(PartialView("_TableTax", model.getTaxList));
        }
Beispiel #19
0
        public int UpdateTax(TaxModel taxModel)
        {
            int result = 0;

            using (SqlConnection con = new SqlConnection(_ConnectionString.Value.ConnectionString))
            {
                CommonRepository commonRepository = new CommonRepository(_ConnectionString);
                result = commonRepository.GetValidateUnique("Tax", "TaxName", taxModel.TaxName, taxModel.Id.ToString());
                if (result > 0)
                {
                    return(-1);
                }

                con.Open();
                SqlTransaction sqltrans = con.BeginTransaction();
                var            query    = "UPDATE Tax SET TaxName =@TaxName," +
                                          "TaxPercentage = @TaxPercentage, " +
                                          "TaxType = @TaxType, " +
                                          "UserIdUpdated =  " + LoginInfo.Userid +
                                          ",DateUpdated = GetUtcDate() " +
                                          "WHERE Id = @Id;";
                result = con.Execute(query, taxModel, sqltrans, 0, System.Data.CommandType.Text);

                if (result > 0)
                {
                    sqltrans.Commit();
                    string output = commonRepository.SyncTableStatus("Tax");
                }
                else
                {
                    sqltrans.Rollback();
                }
            }
            return(result);
        }
        private void GetTax(dynamic row)
        {
            ResponseVm responseTax = taxController.GetTax();

            if (responseTax.FaultData == null)
            {
                TaxModel objTaxModel = new TaxModel(0, "Select");
                _taxdetails = responseTax.Response.Cast <TaxModel>().ToList();
                _taxdetails.Insert(0, objTaxModel);
                this.cmbTax.ItemsSource       = _taxdetails;
                this.cmbTax.DisplayMemberPath = "TaxDetail";
                this.cmbTax.SelectedValuePath = "TaxCode";
            }
            _taxValue = Convert.ToString(row.TaxPercentage);
            if (row.TaxPercentage != null && Convert.ToDecimal(row.TaxPercentage) != Convert.ToDecimal(0) && _taxdetails.Any(item => Convert.ToDouble(item.Rate) == Convert.ToDouble(_taxValue)))
            {
                _taxValue   = Convert.ToString(row.TaxPercentage);
                cmbTax.Text = Convert.ToString(_taxdetails.FirstOrDefault(item => item.Rate == Convert.ToInt32(row.TaxPercentage)).TaxDetail);
            }
            else
            {
                _taxValue            = Convert.ToString(row.TaxPercentage);
                cmbTax.SelectedIndex = 0;
            }
        }
Beispiel #21
0
        private static Tax getEntityByModel(TaxModel model)
        {
            if (model == null)
            {
                return(null);
            }
            Tax entity = new Tax();

            if (model.Id == 0)
            {
                entity.CreateBy   = AuthenticationHelper.UserId;
                entity.CreateDate = DateTime.Now;
                entity.CompanyId  = AuthenticationHelper.CompanyId.Value;
            }
            else
            {
                entity.CreateBy   = model.CreateBy;
                entity.CreateDate = model.CreateDate;
                entity.CompanyId  = model.CompanyId;
            }

            entity.EndDate    = model.EndDate;
            entity.Id         = model.Id;
            entity.SOBId      = model.SOBId;
            entity.StartDate  = model.StartDate;
            entity.TaxName    = model.TaxName;
            entity.UpdateBy   = AuthenticationHelper.UserId;
            entity.UpdateDate = DateTime.Now;

            return(entity);
        }
Beispiel #22
0
        public static void DeleteTaxDetail(TaxDetailModel model)
        {
            TaxModel       tax       = SessionHelper.Tax;
            TaxDetailModel taxDetail = tax.TaxDetails.FirstOrDefault(x => x.Id == model.Id);

            tax.TaxDetails.Remove(taxDetail);
        }
        void GetOptionsandTaxValues()
        {
            OptionsEntity oData = new OptionsEntity();
            IPurchaseInvoiceListRepository purchaseRepository = new PurchaseInvoiceListRepository();

            oData = purchaseRepository.GetOptionSettings();
            if (oData != null)
            {
                this.CurrencyName = oData.CurrencyCode;     //there is no currency name field in database
            }
            else
            {
                this.CurrencyName = "USD";
                this.DateFormat   = "dd/MM/yyyy";
            }

            TaxModel objDefaultTax = new TaxModel();

            objDefaultTax = purchaseRepository.GetDefaultTaxes().FirstOrDefault();
            if (objDefaultTax != null)
            {
                this.TaxName = objDefaultTax.TaxName;
                //this.TaxName = objDefaultTax.TaxRate;
            }
            else
            {
                this.TaxName = "GST";
                //this.TaxRate = 0;
            }
        }
Beispiel #24
0
        public string ValidateTaxCodesAndRates(TaxModel taxModel)
        {
            StringBuilder msg = new StringBuilder();

            if (string.IsNullOrWhiteSpace(taxModel.TaxDescription) || taxModel.TaxDescription == "")
            {
                msg.Append("Tax Description is Required.\n");
            }

            if (string.IsNullOrWhiteSpace(taxModel.TaxCode) || taxModel.TaxCode == "")
            {
                msg.Append("Tax Code is Required.\n");
            }

            if (Convert.ToString(taxModel.TaxRate) == string.Empty)
            {
                msg.Append("Tax Rate is Required.\n");
            }

            if (!System.Text.RegularExpressions.Regex.IsMatch(taxModel.TaxRate.ToString(), @"^\d+([.]\d{1,2})?%?$"))
            {
                msg.Append("Enter valid Tax Rate.\n");
            }

            if (!(Convert.ToDecimal(taxModel.TaxRate) >= 0 && Convert.ToDecimal(taxModel.TaxRate) <= 100))
            {
                msg.Append("Tax Rate should be between 0 to 100.\n");
            }

            return(msg.ToString());
        }
Beispiel #25
0
        public TaxModel ReadFromFile()
        {
            TaxModel tax = new TaxModel();

            try
            {
                List <string> readText = new List <string>();
                string        line;
                StreamReader  file = new StreamReader(@"c:\Tax.txt");
                while ((line = file.ReadLine()) != null)
                {
                    readText.Add(line);
                }

                file.Close();

                tax.MunicipalityName = readText[0];
                tax.TaxValue         = Decimal.Parse(readText[1]);         //format!!!
                tax.StartDate        = DateTime.Parse(readText[2]);
                if (readText[3] != "-")
                {
                    tax.EndDate = DateTime.Parse(readText[3]);
                }
                tax.TaxType = int.Parse(readText[4]);
            }
            catch (Exception)
            {
                return(null);
            }

            return(tax);
        }
Beispiel #26
0
        //
        // GET: /Tax/

        public ActionResult Index()
        {
            TaxModel objModel = new TaxModel();

            TaxService objService = new TaxService();

            List <TaxModel> objList = new List <TaxModel>();

            objList          = objService.getTax();
            objModel.ListTax = new List <TaxModel>();
            objModel.ListTax.AddRange(objList);

            List <TaxModel> objListSTax = new List <TaxModel>();

            objListSTax       = objService.getSTax();
            objModel.ListSTax = new List <TaxModel>();
            objModel.ListSTax.AddRange(objListSTax);

            List <TaxModel> objListATax = new List <TaxModel>();

            objListATax            = objService.getActiveTax();
            objModel.ListActiveTax = new List <TaxModel>();
            objModel.ListActiveTax.AddRange(objListATax);
            return(View(objModel));
        }
        public string UpdateFromFile(string arg)
        {
            if (arg != "update")
            {
                return(errorMessage);
            }

            TaxModel tax = fileControl.ReadFromFile();

            if (tax == null)
            {
                return("ERROR: check file - something wrong!");
            }

            bool updatePassed = dbControl.AddTax(tax);

            if (!updatePassed)
            {
                return("ERROR: inner DB error :( ");
            }

            string endDate = "-";

            if (tax.EndDate != null)
            {
                endDate = DateTime.Parse(tax.EndDate.ToString()).ToString("yyyy-MM-dd");
            }

            return("Taxes from file: " +
                   "municipality " + tax.MunicipalityName +
                   "; tax " + tax.TaxValue.ToString() +
                   "; start date " + tax.StartDate.ToString("yyyy-MM-dd") +
                   "; end date " + endDate +
                   "; tax type " + Enum.GetName(typeof(TaxTypes), tax.TaxType));
        }
Beispiel #28
0
        public AddPurchase()
        {
            InitializeComponent();
            ChangeHeightWidth();
            ClearData();

            myResourceDictionary        = new ResourceDictionary();
            myResourceDictionary.Source =
                new Uri("/ResourceFiles/En.xaml",
                        UriKind.RelativeOrAbsolute);
            new ObservableCollection <PurchaseStockModel>().Clear();
            // purchase_deliveryDate.se =DateTime.Now;
            ResponseVm responseTax = taxController.GetTax();

            if (responseTax.FaultData == null)
            {
                TaxModel objTaxModel = new TaxModel(0, "Select", 0, "", "", "", "");
                _taxdetails = responseTax.Response.Cast <TaxModel>().ToList();
                _taxdetails.Insert(0, objTaxModel);
                this.cmbTax.ItemsSource       = _taxdetails;
                this.cmbTax.DisplayMemberPath = "TaxDetail";
                this.cmbTax.SelectedValuePath = "TaxCode";
                this.cmbTax.SelectedIndex     = 0;
            }
            ResponseVm responce = productController.GetProductsByCompanyAndBranch();

            if (responce.FaultData == null)
            {
                _products = responce.Response.Cast <ProductModel>().ToList();
                if (_products != null && _products.Count > 0)
                {
                    _products?.ToList().ForEach(x =>
                    {
                        int currentStock = OpeningStockController.GetCurrentStockByProductCode(Convert.ToInt64(x.Id));
                        //ProductModel product = new ProductModel(x.Id, x.ItemCode, x.ItemName, x.RetailPrice.Value, x.TradePrice.Value, x.CategoryCode.Value, x.ItemType, x.BarCode, x.TaxPercentage.Value, x.CategoryName);
                        x.CurrentStock = currentStock;
                    });

                    dgPurchases.ItemsSource = _products;
                    dgPurchases.Visibility  = Visibility.Visible;
                }
                else
                {
                    dgPurchases.Visibility = Visibility.Collapsed;
                    brd_exp.Visibility     = Visibility.Visible;
                }
            }
            if (purchaseStocks == null)
            {
                additems();
            }

            btn_AddRow.IsEnabled    = true;
            btn_Save.IsEnabled      = true;
            btn_remove.IsEnabled    = false;
            btn_remove.Background   = Brushes.Gray;
            _supliers               = controller.GetSuppliersByCompanyAndBrach(UserModelVm.CompanyId, UserModelVm.BranchId).ToList();
            lstPurchase.ItemsSource = purchaseStocks;
        }
Beispiel #29
0
        /// <summary>
        /// This is to cancel the operation
        /// </summary>
        /// <param name="param"></param>
        void DoCancel(object param)
        {
            ITaxCodesAndRatesRepository tax = new TaxCodesAndRatesRepository();

            SelectedTax = new TaxModel();
            Tax         = new ObservableCollection <TaxModel>(tax.GetAllTaxes());
            TaxErrors   = string.Empty;
        }
Beispiel #30
0
        public int UpdateSTax(TaxModel model)
        {
            Mapper.CreateMap <TaxModel, TaxTran>();
            TaxTran objUser = Dbcontext.TaxTrans.SingleOrDefault(m => m.TTID == model.TTID);

            objUser = Mapper.Map(model, objUser);
            return(Dbcontext.SaveChanges());
        }