public async Task <bool> AddJob(SA_Job News)
{
// News.CreatedDate = DateTime.Now;
_context.SA_Job.Add(News);
int x = await _context.SaveChangesAsync();
return(x == 0 ? false : true);
}
public async Task <bool> AddCMS(SA_CMS CMS)
{
// CMS.CreatedDate = DateTime.Now;
_context.SA_CMS.Add(CMS);
int x = await _context.SaveChangesAsync();
return(x == 0 ? false : true);
}
public async Task <bool> AddAdvisoryConetnt(SA_AdvisoryContent News)
{
News.CreatedTime = DateTime.Now;
_context.SA_AdvisoryContent.Add(News);
int x = await _context.SaveChangesAsync();
return(x == 0 ? false : true);
}
public async Task <bool> AddUser(SA_User User)
{
// User.CreatedDate = DateTime.Now;
_context.SA_User.Add(User);
int x = await _context.SaveChangesAsync();
return(x == 0 ? false : true);
}
public async Task <bool> AddCategory(SA_Category Category)
{
// Category.CreatedDate = DateTime.Now;
_context.SA_Category.Add(Category);
int x = await _context.SaveChangesAsync();
return(x == 0 ? false : true);
}
public async Task <bool> AddProduct(SA_Product Product)
{
// Product.CreatedDate = DateTime.Now;
_context.SA_Product.Add(Product);
int x = await _context.SaveChangesAsync();
return(x == 0 ? false : true);
}
public async Task <bool> AddIndustry(SA_Industry News)
{
News.CreatedTime = News.CreatedTime != null? News.CreatedTime.Value: DateTime.Now;
_context.SA_Industry.Add(News);
int x = await _context.SaveChangesAsync();
return(x == 0 ? false : true);
}
public async Task <bool> AddCommentary(SA_Commentary News)
{
News.IsActive = true;
News.IsDelete = false;
News.CreatedTime = News.CreatedTime != null? News.CreatedTime: DateTime.Now;
_context.SA_Commentary.Add(News);
int x = await _context.SaveChangesAsync();
return(x == 0 ? false : true);
}
public async Task <bool> UpdateDeals(SA_Deals Deals)
{
_context.Entry(Deals).State = EntityState.Modified;
// Deals.ModeifiedDate = DateTime.Now;
int x = await _context.SaveChangesAsync();
return(x == 0 ? false : true);
}
public async Task <bool> AddFreeTrial(Lead_Master lead)
{
int x = 0;
try
{
_context.Lead_Master.Add(lead);
x = await _context.SaveChangesAsync();
}
catch (Exception ex)
{
}
return(x == 0 ? false : true);
}
public async Task <bool> AddSalesPackageTrial(SalesPackageSubscription subs)
{
int x = 0;
try
{
subs.Status = "Active";
_context.SalesPackageSubscription.Add(subs);
x = await _context.SaveChangesAsync();
}
catch (Exception ex)
{
}
return(x == 0 ? false : true);
}
public ActionResult SaveHeaderContent(SA_HomeHeader UserNews)
{
if (UserNews.Id == 0)
{
UserNews.CreatedTime = DateTime.Now;
_context.SA_HomeHeader.Add(UserNews);
_context.SaveChangesAsync();
}
else
{
SA_HomeHeader EditNews = _context.SA_HomeHeader.Where(Cat => Cat.Id == UserNews.Id).FirstOrDefault();
EditNews.EmailAddress = UserNews.EmailAddress;
EditNews.OfficeAddress = UserNews.OfficeAddress;
EditNews.PhoneNumber = UserNews.PhoneNumber;
EditNews.CreatedTime = UserNews.CreatedTime;
_context.Entry(EditNews).State = EntityState.Modified;
int x = _context.SaveChanges();
}
return(RedirectToAction("HeaderContent"));
}
public async Task <bool> AddRole(SA_RoleViewModel RoleViewModel)
{
try
{
int x = 0;
SA_Role Role = new Models.SA_Role();
Role.Role = RoleViewModel.Role;
Role.CreatedTime = DateTime.Now;
Role.RoleDiscription = RoleViewModel.RoleDiscription;
_context.SA_Role.Add(Role);
_context.SaveChanges();
if (RoleViewModel.ChemicalPricing == true)
{
SA_RoleWiseAccess access = new Models.SA_RoleWiseAccess();
access.RoleId = Role.id;
access.Pageid = 1;
access.access = true;
access.PageDiscription = "Chemical Pricing";
access.CreatedTime = DateTime.Now;
_context.SA_RoleWiseAccess.Add(access);
_context.SaveChanges();
}
if (RoleViewModel.MarketAnalysis == true)
{
SA_RoleWiseAccess access = new Models.SA_RoleWiseAccess();
access.RoleId = Role.id;
access.Pageid = 2;
access.access = true;
access.PageDiscription = "Market Analysis";
access.CreatedTime = DateTime.Now;
_context.SA_RoleWiseAccess.Add(access);
_context.SaveChanges();
}
if (RoleViewModel.CompanyProfile == true)
{
SA_RoleWiseAccess access = new Models.SA_RoleWiseAccess();
access.RoleId = Role.id;
access.Pageid = 3;
access.access = true;
access.PageDiscription = "Company Profile";
access.CreatedTime = DateTime.Now;
_context.SA_RoleWiseAccess.Add(access);
_context.SaveChanges();
}
if (RoleViewModel.IndustryReports == true)
{
SA_RoleWiseAccess access = new Models.SA_RoleWiseAccess();
access.RoleId = Role.id;
access.Pageid = 4;
access.access = true;
access.PageDiscription = "Industry Reports";
access.CreatedTime = DateTime.Now;
_context.SA_RoleWiseAccess.Add(access);
_context.SaveChanges();
}
if (RoleViewModel.News == true)
{
SA_RoleWiseAccess access = new Models.SA_RoleWiseAccess();
access.RoleId = Role.id;
access.Pageid = 5;
access.access = true;
access.PageDiscription = "News";
access.CreatedTime = DateTime.Now;
_context.SA_RoleWiseAccess.Add(access);
_context.SaveChanges();
}
if (RoleViewModel.Deals == true)
{
SA_RoleWiseAccess access = new Models.SA_RoleWiseAccess();
access.RoleId = Role.id;
access.Pageid = 6;
access.access = true;
access.PageDiscription = "Deals";
access.CreatedTime = DateTime.Now;
_context.SA_RoleWiseAccess.Add(access);
_context.SaveChanges();
}
if (RoleViewModel.SubscriptionManagement == true)
{
SA_RoleWiseAccess access = new Models.SA_RoleWiseAccess();
access.RoleId = Role.id;
access.Pageid = 7;
access.access = true;
access.PageDiscription = "Subscription Management";
access.CreatedTime = DateTime.Now;
_context.SA_RoleWiseAccess.Add(access);
x = await _context.SaveChangesAsync();
}
return(x == 0 ? false : true);
}
catch (Exception ex)
{
return(false);
}
}
public async Task <bool> AddCustWiseAccess(string id, int Custid)
{
try
{
int x = 0;
string[] items = id.Split(new char[] { ',', ' ' }, StringSplitOptions.RemoveEmptyEntries);
foreach (var i in items)
{
if (Convert.ToInt32(i) == 1)
{
CustWiseAccess access = new Models.CustWiseAccess();
access.CustId = Custid;
access.Pageid = 1;
access.access = true;
access.PageDiscription = "Chemical Pricing";
access.CreatedTime = DateTime.Now;
_context.CustWiseAccess.Add(access);
x = _context.SaveChanges();
}
if (Convert.ToInt32(i) == 2)
{
CustWiseAccess access = new Models.CustWiseAccess();
access.CustId = Custid;
access.Pageid = 2;
access.access = true;
access.PageDiscription = "Market Analysis";
access.CreatedTime = DateTime.Now;
_context.CustWiseAccess.Add(access);
x = _context.SaveChanges();
}
if (Convert.ToInt32(i) == 3)
{
CustWiseAccess access = new Models.CustWiseAccess();
access.CustId = Custid;
access.Pageid = 3;
access.access = true;
access.PageDiscription = "Company Profile";
access.CreatedTime = DateTime.Now;
_context.CustWiseAccess.Add(access);
x = _context.SaveChanges();
}
if (Convert.ToInt32(i) == 4)
{
CustWiseAccess access = new Models.CustWiseAccess();
access.CustId = Custid;
access.Pageid = 4;
access.access = true;
access.PageDiscription = "Industry Reports";
access.CreatedTime = DateTime.Now;
_context.CustWiseAccess.Add(access);
x = _context.SaveChanges();
}
if (Convert.ToInt32(i) == 5)
{
CustWiseAccess access = new Models.CustWiseAccess();
access.CustId = Custid;
access.Pageid = 5;
access.access = true;
access.PageDiscription = "News";
access.CreatedTime = DateTime.Now;
_context.CustWiseAccess.Add(access);
x = _context.SaveChanges();
}
if (Convert.ToInt32(i) == 6)
{
CustWiseAccess access = new Models.CustWiseAccess();
access.CustId = Custid;
access.Pageid = 6;
access.access = true;
access.PageDiscription = "Deals";
access.CreatedTime = DateTime.Now;
_context.CustWiseAccess.Add(access);
x = _context.SaveChanges();
}
if (Convert.ToInt32(i) == 7)
{
CustWiseAccess access = new Models.CustWiseAccess();
access.CustId = Custid;
access.Pageid = 7;
access.access = true;
access.PageDiscription = "Subscription Management";
access.CreatedTime = DateTime.Now;
_context.CustWiseAccess.Add(access);
x = await _context.SaveChangesAsync();
}
}
return(x == 0 ? false : true);
}
catch (Exception ex)
{
return(false);
}
}