public Register3 GetRegister3ByCompanyId(int companyId, int year)
{
Register3 register;
using (var context = new WebKikDataContext())
{
register = context.Registers3.Where(rg3 => (rg3.OwnerProjectCompanyId == companyId && rg3.Year == (Year)year)).FirstOrDefault();
return(register);
}
}
public Register9 GetRegister9ByCompanyId(int companyId, int year)
{
Register9 register;
using (var context = new WebKikDataContext())
{
register = context.Registers9.Where(rg9 => (rg9.OwnerProjectCompanyId == companyId && rg9.Year == year)).Include(x => x.Register9Data).FirstOrDefault();
return(register);
}
}
//public Register9 CalculateRegisterFields(Register9 register)
//{
// return register;
//}
public Register11 GetRegister11(int id)
{
Register11 register;
using (var context = new WebKikDataContext())
{
register = context.Registers11.Where(rg11 => (rg11.Id == id)).Include(x => x.Register11Data).FirstOrDefault();
return(register);
}
}
public Register9 GetRegister9(int id)
{
Register9 register;
using (var context = new WebKikDataContext())
{
register = context.Registers9.Where(rg8 => (rg8.Id == id)).Include(x => x.Register9Data).FirstOrDefault();
return(register);
}
}
public Register11Data CreateRegisterData(Register11Data data)
{
Register11Data register;
using (var context = new WebKikDataContext())
{
var data11 = context.Registers11Data.Add(data);
context.SaveChanges();
return(data11);
}
}
public Register10Data DeleteRegisterData(int id)
{
Register10Data data10 = null;
using (var context = new WebKikDataContext())
{
data10 = context.Registers10Data.FirstOrDefault(d => d.Id == id);
context.Registers10Data.Remove(data10);
context.SaveChanges();
}
return(data10);
}
public Register11Data DeleteRegisterData(int id)
{
Register11Data data = null;
using (var context = new WebKikDataContext())
{
data = context.Registers11Data.Where(d => d.Id == id).FirstOrDefault();
context.Registers11Data.Remove(data);
context.SaveChanges();
}
return(null);
}
public Register10 Create(Register10 model)
{
Register10 register;
using (var context = new WebKikDataContext())
{
register = context.Registers10.Add(new Register10
{
Year = model.Year,
OwnerProjectCompanyId = model.OwnerProjectCompanyId,
Currency = model.Currency,
Type = RegisterType.Register10
});
context.SaveChanges();
}
return(register);
}
public Register11 Create(Register11 model)
{
Register11 register;
using (var context = new WebKikDataContext())
{
register = context.Registers11.Add(new Register11
{
Year = model.Year,
OwnerProjectCompanyId = model.OwnerProjectCompanyId,
Currency = model.Currency,
Type = RegisterType.Register11,
DecisionOfLiquidationData = model.DecisionOfLiquidationData == DateTime.MinValue ? null: model.DecisionOfLiquidationData,
CompletionOfLiquidationData = model.CompletionOfLiquidationData == DateTime.MinValue ? null : model.DecisionOfLiquidationData
});
context.SaveChanges();
}
return(register);
}
public Register10Data CreateRegisterData(Register10Data data)
{
using (var context = new WebKikDataContext())
{
var data10 = context.Registers10Data.Add(new Register10Data
{
Register10Id = data.Register10Id,
SectionId = data.SectionId,
AssetType = data.AssetType,
CauseDisposal = data.CauseDisposal,
Num1 = data.Num1,
Num2 = data.Num2,
Num3 = data.Num3,
Num4 = data.Num4
});
context.SaveChanges();
return(data10);
}
}
public void Configuration(IAppBuilder app)
{
const string connectionName = "WebKikConnection";
var config = new HttpConfiguration {
IncludeErrorDetailPolicy = IncludeErrorDetailPolicy.Always
};
var container = config.UseUnity(connectionName);
WebApiConfig.Register(config, container);
app.UseWebApi(config);
config.EnableEnumPrefixFree(true);
ConfigureJsonSerializer(config);
InitializationHelper.Initialize(typeof(AutomapperInitializationAttribute).Assembly);
WebKikDataContext.Initialize(connectionName);
app.UseSpaRazor("index.cshtml");
}
public ICollection <SupportingDocument> GetAllSupportingDocumentsByCompanyId(int id, int type)
{
using (var context = new WebKikDataContext())
{
var company = context.ProjectCompanies.Where(cmp => cmp.Id == id).FirstOrDefault();
var checkdate = DateTime.Today;
var q = context.ProjectCompanyShares.Where(x => x.OwnerProjectCompanyId == company.ProjectId && (x.ShareStartDate <= checkdate && (x.ShareFinishDate >= checkdate || x.ShareFinishDate == null)));
var allCompany = q.Include(x => x.OwnerProjectCompany).Include(c => c.DependentProjectCompany).ToList();
var ids = allCompany.Select(c => c.Id).ToList();
if (!ids.Contains(id))
{
ids.Add(id);
}
var documents = context.SupportingDocuments.Where(sup => ids.Contains(sup.ProjectCompanyId) && (type == 0 ? sup.IsUU : (type == 1 ? sup.IsND : sup.IsUKIK)));
return(documents.ToList());
}
}
public Register10Data EditRegisterData(Register10Data data)
{
Register10Data data10 = null;
using (var context = new WebKikDataContext())
{
data10 = context.Registers10Data.FirstOrDefault(d => d.Id == data.Id);
if (data10 != null)
{
data10.SectionId = data.SectionId;
data10.AssetType = data.AssetType;
data10.CauseDisposal = data.CauseDisposal;
data10.Register10Id = data.Register10Id;
data10.Num1 = data.Num1;
data10.Num2 = data.Num2;
data10.Num3 = data.Num3;
data10.Num4 = data.Num4;
}
context.SaveChanges();
}
return(data10);
}
public Register9Data CreateRegisterData(Register9Data data)
{
Register9Data register;
using (var context = new WebKikDataContext())
{
var data9 = context.Registers9Data.Add(new Register9Data
{
Register9Id = data.Register9Id,
StockholderName = data.StockholderName,
CountryCodeId = data.CountryCodeId,
LastYearDividendPaymentYear = data.LastYearDividendPaymentYear,
CurrentYearDividendPaymentData = data.CurrentYearDividendPaymentData.HasValue ? data.CurrentYearDividendPaymentData.Value : new DateTime(0),
CurrentYearDividendSum = data.CurrentYearDividendSum,
CurrentYearTransitionalDividendPaymentData = data.CurrentYearTransitionalDividendPaymentData.HasValue ? data.CurrentYearTransitionalDividendPaymentData.Value : new DateTime(0),
CurrentYearTransitionalDividendSum = data.CurrentYearTransitionalDividendSum,
LastYearDividendPaymentData = data.LastYearDividendPaymentData.HasValue ? data.LastYearDividendPaymentData.Value : new DateTime(0),
LastYearDividendSum = data.LastYearDividendSum
});
context.SaveChanges();
return(data9);
}
}
public Register9Data EditRegisterData(Register9Data data)
{
Register9Data data9 = null;
using (var context = new WebKikDataContext())
{
data9 = context.Registers9Data.Where(d => d.Id == data.Id).FirstOrDefault();
if (data9 != null)
{
data9.StockholderName = data.StockholderName;
data9.CountryCodeId = data.CountryCodeId;
data9.LastYearDividendPaymentYear = data.LastYearDividendPaymentYear;
data9.CurrentYearDividendPaymentData = data.CurrentYearDividendPaymentData;
data9.CurrentYearDividendSum = data.CurrentYearDividendSum;
data9.CurrentYearTransitionalDividendPaymentData = data.CurrentYearTransitionalDividendPaymentData;
data9.CurrentYearTransitionalDividendSum = data.CurrentYearTransitionalDividendSum;
data9.LastYearDividendPaymentData = data.LastYearDividendPaymentData;
data9.LastYearDividendSum = data.LastYearDividendSum;
}
context.SaveChanges();
}
return(data9);
}
public SupportingDocument CreateDocument(int year, int companyType, int companyId, bool isUU, bool isUKIK, bool isND, string uKIKDocType, byte[] fileData, string fileName)
{
SupportingDocument doc = new SupportingDocument
{
Year = year,
CompanyType = companyType,
ProjectCompanyId = companyId,
IsUU = isUU,
IsUKIK = isUKIK,
IsND = isND,
Data = fileData,
FileName = fileName,
UKIKDocType = !string.IsNullOrEmpty(uKIKDocType) ? getUkikDocTypeId(uKIKDocType) : (int?)null
};
using (var context = new WebKikDataContext())
{
var document = context.SupportingDocuments.Add(doc);
context.SaveChanges();
return(document);
}
// return null;
}
public async Task <IEnumerable <RegisterListItem> > GetRegistersByShareIdAndYear(int projectCompanyId, int year)
{
var registersList = new List <RegisterListItem>();
/// todo: Refactor into loop
//register1
var register1 = await register1Repository.Where(x => x.Year == (Year)year && x.OwnerProjectCompanyId == projectCompanyId).FirstOrDefaultAsync();
registersList.Add(new RegisterListItem
{
Id = register1 != null ? register1.Id : 0,
Type = register1 != null ? register1.Type : RegisterType.Register1,
IsFilled = register1 != null
});
//register2
var register2 = await register2Repository.Where(x => x.Year == (Year)year && x.OwnerProjectCompanyId == projectCompanyId).FirstOrDefaultAsync();
registersList.Add(new RegisterListItem
{
Id = register2 != null ? register2.Id : 0,
Type = register2 != null ? register2.Type : RegisterType.Register2,
IsFilled = register2 != null
});
//register3
var register3 = await register3Repository.Where(x => x.Year == (Year)year && x.OwnerProjectCompanyId == projectCompanyId).FirstOrDefaultAsync();
registersList.Add(new RegisterListItem
{
Id = register3 != null ? register3.Id : 0,
Type = register3 != null ? register3.Type : RegisterType.Register3,
IsFilled = register3 != null
});
//register4
var register4 = await register4Repository.Where(x => x.Year == (Year)year && x.OwnerProjectCompanyId == projectCompanyId).FirstOrDefaultAsync();
registersList.Add(new RegisterListItem
{
Id = register4 != null ? register4.Id : 0,
Type = register4 != null ? register4.Type : RegisterType.Register4,
IsFilled = register4 != null
});
//register5
var register5 = await register5Repository.Where(x => x.Year == (Year)year && x.OwnerProjectCompanyId == projectCompanyId).FirstOrDefaultAsync();
registersList.Add(new RegisterListItem
{
Id = register5 != null ? register5.Id : 0,
Type = register5 != null ? register5.Type : RegisterType.Register5,
IsFilled = register5 != null
});
//register6
var register6 = await register6Repository.Where(x => x.Year == (Year)year && x.OwnerProjectCompanyId == projectCompanyId).FirstOrDefaultAsync();
registersList.Add(new RegisterListItem
{
Id = register6 != null ? register6.Id : 0,
Type = register6 != null ? register6.Type : RegisterType.Register6,
IsFilled = register6 != null
});
//register7
var register7 = await register7Repository.Where(x => x.Year == (Year)year && x.OwnerProjectCompanyId == projectCompanyId).FirstOrDefaultAsync();
registersList.Add(new RegisterListItem
{
Id = register7 != null ? register7.Id : 0,
Type = register7 != null ? register7.Type : RegisterType.Register7,
IsFilled = register7 != null
});
Register8 register8 = null;
using (var context = new WebKikDataContext())
{
register8 = context.Registers8.Where(rg8 => (rg8.Year == year && rg8.OwnerProjectCompanyId == projectCompanyId)).FirstOrDefault();
}
registersList.Add(new RegisterListItem
{
Id = register8 != null ? register8.Id : 0,
Type = register8 != null ? register8.Type : RegisterType.Register8,
IsFilled = register8 != null
});
Register9 register9 = null;
using (var context = new WebKikDataContext())
{
register9 = context.Registers9.Where(rg9 => (rg9.Year == year && rg9.OwnerProjectCompanyId == projectCompanyId)).FirstOrDefault();
}
registersList.Add(new RegisterListItem
{
Id = register9 != null ? register9.Id : 0,
Type = register9 != null ? register9.Type : RegisterType.Register9,
IsFilled = register9 != null
});
Register10 register10;
using (var context = new WebKikDataContext())
{
register10 = context.Registers10.FirstOrDefault(x => x.Year == year && x.OwnerProjectCompanyId == projectCompanyId);
}
registersList.Add(new RegisterListItem
{
Id = register10?.Id ?? 0,
Type = register10?.Type ?? RegisterType.Register10,
IsFilled = register10 != null
});
Register11 register11;
using (var context = new WebKikDataContext())
{
register11 = context.Registers11.FirstOrDefault(x => x.Year == year && x.OwnerProjectCompanyId == projectCompanyId);
}
registersList.Add(new RegisterListItem
{
Id = register11 != null ? register11.Id : 0,
Type = register11 != null ? register11.Type : RegisterType.Register11,
IsFilled = register11 != null
});
return(registersList);
}
public Register11Service(WebKikDataContext context)
{
dbContext = context;
}
public Register10Service()
{
context = new WebKikDataContext();
}
