private bool Update(SubscriptionCompanies item)
{
try
{
using (SqlConnection db = new SqlConnection())
{
var record = db.SubscriptionCompanies.FirstOrDefault(t => t.Id == item.Id);
record.Id = item.Id;
record.CompanyId = item.CompanyId;
record.UserId = item.UserId;
record.Created = item.Created;
db.SaveChanges();
}
Logger.SaveLog(LogTypes.Info, "SubscriptionCompaniesRepo.Update", "Company was successfully updated");
return(true);
}
catch (Exception e)
{
Logger.SaveLog(LogTypes.Error, $"{e.Source}: {e.TargetSite}", e.Message, e.StackTrace);
return(false);
}
}
private int Insert(SubscriptionCompanies item)
{
try
{
using (SqlConnection db = new SqlConnection())
{
db.SubscriptionCompanies.Add(item);
db.SaveChanges();
}
Logger.SaveLog(LogTypes.Info, "SubscriptionCompaniesRepo.Insert", "Company was successfully inserted");
return(item.Id);
}
catch (Exception e)
{
Logger.SaveLog(LogTypes.Error, $"{e.Source}: {e.TargetSite}", e.Message, e.StackTrace);
return(0);
}
}
private SubscriptionCompanies SelectItem(int id)
{
try
{
SubscriptionCompanies item = null;
using (SqlConnection db = new SqlConnection())
{
item = db.SubscriptionCompanies.FirstOrDefault(t => t.Id == id);
}
Logger.SaveLog(LogTypes.Info, "SubscriptionCompaniesRepo.SelectItem", "Company was successfully selected");
return(item);
}
catch (Exception e)
{
Logger.SaveLog(LogTypes.Error, $"{e.Source}: {e.TargetSite}", e.Message, e.StackTrace);
return(null);
}
}
public string Subscribe(string companyId)
{
try
{
var userSets = HttpContext.Current.Request.Cookies["user_login"];
var user = _user.SelectItemByEmail(userSets.Value);
var userCompany = _subCompany.SelectItemsByUserId(user.Id);
var company = _subCompany.SelectItemByCompanyId(companyId);
if (companyId != null)
{
if (userSets.Value != null)
{
if (userCompany.Count() != 0 || company.Count() != 0)
{
foreach (var t in userCompany)
{
foreach (var k in company)
{
if (t.UserId != k.UserId && companyId != null)
{
var subCompany = new SubscriptionCompanies()
{
CompanyId = companyId,
UserId = user.Id,
Created = DateTime.Now
};
_subCompany.Add(subCompany);
Logger.SaveLog(LogTypes.Info, "SubscriptionFlightsHandler.Subscribe", "Successfully subscribing");
return("OK");
}
if (k == company.Last())
{
return("Exist");
}
}
}
}
var result = new SubscriptionCompanies()
{
CompanyId = companyId,
UserId = user.Id,
Created = DateTime.Now
};
_subCompany.Add(result);
Logger.SaveLog(LogTypes.Info, "SubscriptionFlightsHandler.Subscribe", "Successfully subscribing");
return("OK");
}
return("NoAuth");
}
return("Error");
}
catch (Exception e)
{
Logger.SaveLog(LogTypes.Error, $"{e.Source}: {e.TargetSite}", e.Message, e.StackTrace);
return("NoAuth");
}
}
public bool Set(SubscriptionCompanies item)
{
return(Update(item));
}
public int Add(SubscriptionCompanies item)
{
return(Insert(item));
}
