/// <summary>
/// This method is used to save category contents with associated category
/// </summary>
/// <param name="content"></param>
public void SaveCategoryContent(ContentModel content)
{
using (SDNSettingEntities objCategoryEntities = new SDNSettingEntities())
{
var obj = objCategoryEntities.CategoriesContents.Where(x => x.Cat_Id == content.CategoryID && x.IsDeleted != true && x.Set_Default == true && content.IsSelected == true).FirstOrDefault();
if (obj != null)
{
obj.Set_Default = false;
objCategoryEntities.SaveChanges();
}
try
{
CategoriesContent catContent = new CategoriesContent();
catContent.Cat_Contents = content.ContentName.Trim();
catContent.Content_Limit = content.Limit;
catContent.Cat_Id = content.CategoryID;
catContent.IsDeleted = false;
catContent.Set_Default = content.IsSelected;
catContent.CreatedDate = DateTime.Now;
objCategoryEntities.CategoriesContents.Add(catContent);
objCategoryEntities.SaveChanges();
}
catch (Exception ex)
{
throw ex;
}
}
}
public bool IsContentExists(ContentModel content)
{
bool IsExists = false;
using (SDNSettingEntities objCategoryEntities = new SDNSettingEntities())
{
try
{
var catContent = objCategoryEntities.CategoriesContents.Where(e => e.Cat_Id == content.CategoryID &&
e.Cat_Contents == content.ContentName.Trim() && e.IsDeleted == false && e.ID != content.ContentID).ToList();
if (catContent.Count > 0)
{
IsExists = true;
}
else
{
IsExists = false;
}
}
catch (Exception ex)
{
throw ex;
}
return(IsExists);
}
}
public bool IsCodeAndRateExists(TaxModel taxModel)
{
bool isExists = false;
try
{
using (SDNSettingEntities objEntities = new SDNSettingEntities())
{
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;
}
}
public TaxModel GetDefaultTaxes()
{
try
{
using (SDNSettingEntities objEntities = new SDNSettingEntities())
{
var defaultTax = (from tax in objEntities.TaxCodesAndRates
where tax.IsDeleted == false
select new TaxModel()
{
TaxID = tax.ID,
TaxName = tax.Tax_Name,
TaxDescription = tax.Tax_Description,
TaxCode = tax.Tax_Code,
TaxRate = tax.Tax_Rate,
IsDefault = tax.Tax_Default,
IsInActive = tax.Tax_Inactive,
Predefined = tax.Predefined
}).Where(x => x.IsDefault == true && x.IsInActive != "Y").FirstOrDefault();
return(defaultTax as TaxModel);
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// This method is used to retrieve single tax code and rates
/// </summary>
/// <param name="taxId"></param>
/// <returns></returns>
public List <TaxModel> GetTax(int taxId)
{
try
{
using (SDNSettingEntities objEntities = new SDNSettingEntities())
{
var lstTax = (from tax in objEntities.TaxCodesAndRates
where tax.IsDeleted == false &&
tax.ID == taxId
select new TaxModel
{
TaxID = tax.ID,
TaxName = tax.Tax_Name,
TaxDescription = tax.Tax_Description,
TaxCode = tax.Tax_Code,
TaxRate = tax.Tax_Rate,
IsDefault = tax.Tax_Default,
IsInActive = tax.Tax_Inactive,
Predefined = tax.Predefined
}).ToList();
return(lstTax);
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// This method is used to update category contents with associated category
/// </summary>
/// <param name="content"></param>
public void UpdateCategoryContent(ContentModel content)
{
using (SDNSettingEntities objCategoryEntities = new SDNSettingEntities())
{
try
{
var obj = objCategoryEntities.CategoriesContents.Where(x => x.Cat_Id == content.CategoryID && x.IsDeleted != true && x.Set_Default == true && content.IsSelected == true).FirstOrDefault();
if (obj != null)
{
obj.Set_Default = false;
objCategoryEntities.SaveChanges();
}
CategoriesContent catContent = objCategoryEntities.CategoriesContents.SingleOrDefault(i => i.ID == content.ContentID);
if (catContent != null)
{
catContent.Cat_Contents = content.ContentName;
catContent.Content_Limit = content.Limit;
catContent.Set_Default = content.IsSelected;
catContent.ModifiedDate = DateTime.Now;
objCategoryEntities.SaveChanges();
}
//var categoryContent = objCategoryEntities.CategoriesContents.Where(e => e.Cat_Id == content.CategoryID && e.ID!=content.ContentID).ToList();
//if (categoryContent != null)
//{
// foreach (var c in categoryContent)
// {
// if (content.IsSelected == true)
// {
// if (c.Set_Default == true)
// {
// c.Set_Default = false;
// }
// }
// else
// {
// if(c.Set_Default==true)
// {
// c.Set_Default = true;
// }
// }
// objCategoryEntities.SaveChanges();
// }
//}
}
catch (Exception ex)
{
throw ex;
}
}
}
/// <summary>
/// This is used to get all categories
/// </summary>
public List <UI.Entities.CategoryModel> GetCategoryList()
{
using (SDNSettingEntities objCategoryEntities = new SDNSettingEntities())
{
var result = objCategoryEntities.Categories.ToList();
List <UI.Entities.CategoryModel> catModel = (from r in result
select new UI.Entities.CategoryModel
{
ID = r.ID,
CategoryName = r.Cat_Name
}).ToList <UI.Entities.CategoryModel>();
return(catModel);
}
}
public List <CategoryModel> GetCategory(string CategoryCode)
{
using (SDNSettingEntities objCategoryEntities = new SDNSettingEntities())
{
var result = objCategoryEntities.Categories.Where(e => e.Cat_Code == CategoryCode).ToList();
List <UI.Entities.CategoryModel> catModel = (from r in result
select new UI.Entities.CategoryModel
{
ID = r.ID,
CategoryName = r.Cat_Name,
CategoryCode = r.Cat_Code
}).ToList <UI.Entities.CategoryModel>();
return(catModel);
}
}
public List <ContentModel> GetPSCategoryList()
{
using (SDNSettingEntities objCategoryEntities = new SDNSettingEntities())
{
var result = objCategoryEntities.TermsAndConditions.ToList();
List <ContentModel> catModel = (from r in result
select new ContentModel
{
CategoryID = r.ID,
CategoryName = r.Cat_Name,
CategoryCode = r.Cat_Code,
ContentName = r.Cat_Content
}).ToList <ContentModel>();
return(catModel);
}
}
public string GetPSCategoryContentList(string tcCode)
{
string content = string.Empty;
using (SDNSettingEntities objCategoryEntities = new SDNSettingEntities())
{
var result = (from tandc in objCategoryEntities.TermsAndConditions
where tandc.Cat_Code == tcCode
select tandc.Cat_Content).SingleOrDefault();
if (result != null)
{
content = result;
}
return(content);
}
}
/// <summary>
/// This method is used to delete the tax
/// </summary>
/// <param name="id"></param>
public void DeleteTax(int id)
{
try
{
using (SDNSettingEntities objEntities = new SDNSettingEntities())
{
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 Purchase and sales Category Content
/// </summary>
/// <param name="content"></param>
public void SavePSCategoryContent(ContentModel content)
{
using (SDNSettingEntities objCategoryEntities = new SDNSettingEntities())
{
try
{
var tandc = objCategoryEntities.TermsAndConditions.Where(e => e.Cat_Code == content.CategoryCode).SingleOrDefault();
if (tandc != null)
{
tandc.Cat_Content = content.ContentName;
objCategoryEntities.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 (SDNSettingEntities objEntities = new SDNSettingEntities())
{
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 delete Category Content
/// </summary>
/// <param name="catId"></param>
public void DeleteCategoryContent(int contentID)
{
using (SDNSettingEntities objCategoryEntities = new SDNSettingEntities())
{
try
{
CategoriesContent catContent = objCategoryEntities.CategoriesContents.SingleOrDefault(i => i.ID == contentID);
if (catContent != null)
{
catContent.IsDeleted = true;
objCategoryEntities.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
}
/// <summary>
/// This method is used to get all the taxes with codes and rates
/// </summary>
/// <returns></returns>
public List <TaxModel> GetAllTaxes()
{
try
{
using (SDNSettingEntities objEntities = new SDNSettingEntities())
{
var lstTax = (from tax in objEntities.TaxCodesAndRates
where tax.IsDeleted == false
select new
{
TaxID = tax.ID,
TaxName = tax.Tax_Name,
TaxDescription = tax.Tax_Description,
TaxCode = tax.Tax_Code,
TaxRate = tax.Tax_Rate,
IsDefault = tax.Tax_Default,
IsInActive = tax.Tax_Inactive,
Predefined = tax.Predefined
}).ToList();
return(lstTax.AsEnumerable() // Client-side from here on
.Select((tax, index) => new TaxModel()
{
TaxID = tax.TaxID,
TaxName = tax.TaxName,
TaxDescription = tax.TaxDescription,
TaxCode = tax.TaxCode,
TaxRate = tax.TaxRate,
IsDefault = tax.IsDefault,
IsInActive = tax.IsInActive,
Predefined = tax.Predefined,
StrTaxRate = tax.TaxRate.ToString() + "%",
Rank = tax.Predefined == true?"#": string.Empty
}).ToList());
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// This method is used to save Tax Name
/// </summary>
/// <param name="taxName"></param>
public void SaveTaxName(string taxName)
{
using (SDNSettingEntities objCategoryEntities = new SDNSettingEntities())
{
try
{
var taxes = objCategoryEntities.TaxCodesAndRates.ToList();
if (taxes.Count > 0)
{
foreach (var tax in taxes)
{
tax.Tax_Name = taxName;
objCategoryEntities.SaveChanges();
}
}
}
catch (Exception ex)
{
throw ex;
}
}
}
public string GetNumberFormat()
{
string numberFormat = string.Empty;
using (SDNSettingEntities objCategoryEntities = new SDNSettingEntities())
{
var format = objCategoryEntities.Options.FirstOrDefault();
if (format != null)
{
numberFormat = format.Number_Format;
}
if (numberFormat != string.Empty)
{
return(numberFormat);
}
else
{
return(string.Empty);
}
}
}
/// <summary>
/// This method is used to get category contents of selected category
/// </summary>
/// <param name="catID"></param>
/// <returns></returns>
public List <ContentModel> GetCategoryContentList(int catID)
{
using (SDNSettingEntities objCategoryEntities = new SDNSettingEntities())
{
var result = (from catContent in objCategoryEntities.CategoriesContents
join cat in objCategoryEntities.Categories
on catContent.Cat_Id equals cat.ID
where catContent.Cat_Id == catID && catContent.IsDeleted == false
select new ContentModel
{
ContentID = catContent.ID,
ContentName = catContent.Cat_Contents,
CategoryID = cat.ID,
ContentType = cat.Content_Type,
CategoryName = cat.Cat_Name,
CategoryCode = cat.Cat_Code,
IsSelected = catContent.Set_Default,
Predefined = catContent.Predefined
}).ToList();
return(result);
}
}
/// <summary>
/// This method is used get category details from Category
/// </summary>
/// <param name="ID"></param>
/// <returns></returns>
public List <ContentModel> GetCategoryDetails(int ID)
{
using (SDNSettingEntities objCategoryEntities = new SDNSettingEntities())
{
try
{
var result = (from cat in objCategoryEntities.Categories
where cat.ID == ID
select new ContentModel
{
CategoryID = cat.ID,
CategoryCode = cat.Cat_Code,
CategoryName = cat.Cat_Name,
ContentType = cat.Content_Type,
}).ToList();
return(result);
}
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 (SDNSettingEntities objEntities = new SDNSettingEntities())
{
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;
}
}
