/// <summary>
/// This method is used to delete the tax
/// </summary>
/// <param name="id"></param>
public void DeleteTax(int id)
{
try
{
using (SASEntitiesEDM objEntities = new SASEntitiesEDM())
{
TaxCodesAndRate tax = objEntities.TaxCodesAndRates.SingleOrDefault(t => t.ID == id);
tax.IsDeleted = true;
tax.ModifiedDate = DateTime.Now;
objEntities.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// This method is used to save new tax
/// </summary>
/// <param name="taxModel"></param>
public void SaveTax(TaxModel taxModel)
{
try
{
using (SASEntitiesEDM objEntities = new SASEntitiesEDM())
{
TaxCodesAndRate tax = new TaxCodesAndRate();
tax.Tax_Name = taxModel.TaxName;
tax.Tax_Description = taxModel.TaxDescription.Trim();
tax.Tax_Code = taxModel.TaxCode.Trim();
tax.Tax_Rate = taxModel.TaxRate;
if (taxModel.IsInActive == null)
{
tax.Tax_Inactive = "N";
}
else
{
tax.Tax_Inactive = taxModel.IsInActive;
}
tax.Tax_Default = false;
tax.CreatedDate = DateTime.Now;
tax.IsDeleted = false;
objEntities.TaxCodesAndRates.Add(tax);
objEntities.SaveChanges();
var taxes = objEntities.TaxCodesAndRates.ToList();
if (taxes != null)
{
foreach (var taxItem in taxes)
{
taxItem.Tax_Name = taxModel.TaxName;
objEntities.SaveChanges();
}
}
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// This method is used to update the tax
/// </summary>
/// <param name="taxModel"></param>
public void UpdateTax(TaxModel taxModel)
{
try
{
using (SASEntitiesEDM objEntities = new SASEntitiesEDM())
{
TaxCodesAndRate tax = objEntities.TaxCodesAndRates.SingleOrDefault(t => t.ID == taxModel.TaxID);
tax.Tax_Name = taxModel.TaxName;
tax.Tax_Description = taxModel.TaxDescription;
tax.Tax_Code = taxModel.TaxCode;
tax.Tax_Rate = Convert.ToDecimal(taxModel.TaxRate);
if (taxModel.IsInActive == null)
{
tax.Tax_Inactive = "N";
}
else
{
tax.Tax_Inactive = taxModel.IsInActive;
}
tax.Tax_Default = taxModel.IsDefault;
tax.ModifiedDate = DateTime.Now;
objEntities.SaveChanges();
var lstTax = objEntities.TaxCodesAndRates.Where(e => e.ID != taxModel.TaxID).ToList();
if (tax != null)
{
foreach (var c in lstTax)
{
if (taxModel.IsDefault == true)
{
if (c.Tax_Default == true)
{
c.Tax_Default = false;
}
}
else
{
if (c.Tax_Default == true)
{
c.Tax_Default = true;
}
}
objEntities.SaveChanges();
}
}
var taxes = objEntities.TaxCodesAndRates.ToList();
if (taxes != null)
{
foreach (var taxItem in taxes)
{
taxItem.Tax_Name = taxModel.TaxName;
objEntities.SaveChanges();
}
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public void getTaxCodesandRatesList(List <Tax_Codes_and_Rates> taxcodesandrates, bool RUBool)
{
List <Tax_Codes_and_Rates> duplicate = new List <Tax_Codes_and_Rates>();
List <Tax_Codes_and_Rates> unique = new List <Tax_Codes_and_Rates>();
List <Tax_Codes_and_Rates> TaxCodesandRates = entities.TaxCodesAndRates.Where(x => x.IsDeleted != true).Select(x => new Tax_Codes_and_Rates
{
Tax_Name = x.Tax_Name,
Tax_Description = x.Tax_Description,
Tax_Code = x.Tax_Code,
Tax_Rate = x.Tax_Rate.ToString(),
Isinactive = x.Tax_Inactive,
}).OrderBy(e => e.Tax_Code).ToList();
var namearray = (from tcandRates in TaxCodesandRates
select tcandRates.Tax_Code).ToArray();
duplicate = (from tCodelist in taxcodesandrates
where namearray.Contains(tCodelist.Tax_Code)
select tCodelist).ToList();
unique = taxcodesandrates.Except(duplicate).ToList();
var ThirdList = taxcodesandrates.Except(TaxCodesandRates).ToList();
if (RUBool == true)
{
try
{
foreach (var item in unique)
{
TaxCodesAndRate taxCodesAndRate = new TaxCodesAndRate()
{
Tax_Name = item.Tax_Name,
Tax_Inactive = item.Isinactive,
Tax_Description = item.Tax_Description,
Tax_Code = item.Tax_Code,
Tax_Rate = item.Tax_Rate == string.Empty ? 0: Convert.ToDecimal(item.Tax_Rate),
};
entities.TaxCodesAndRates.Add(taxCodesAndRate);
entities.SaveChanges();
}
}
catch (Exception e)
{
throw e;
}
}
else
{
try
{
foreach (var item in ThirdList)
{
var taxandrates = entities.TaxCodesAndRates.FirstOrDefault(x => x.Tax_Code == item.Tax_Code);
taxandrates.Tax_Name = item.Tax_Name;
taxandrates.Tax_Inactive = item.Isinactive;
taxandrates.Tax_Description = item.Tax_Description;
taxandrates.Tax_Rate = item.Tax_Rate == string.Empty ? 0 : Convert.ToDecimal(item.Tax_Rate);
taxandrates.Tax_Code = item.Tax_Code;
entities.SaveChanges();
}
}
catch (Exception e)
{
throw e;
}
}
}
