public ServiceCategory(string code, string name, string description, ServiceCategory parentCategory)
: base(code)
{
_name = name;
_description = description;
_parentCategory = parentCategory;
}
public async Task<ActionResult> Redigera( ServiceCategory serviceCategory)
{
if (ModelState.IsValid)
{
db.Entry(serviceCategory).State = EntityState.Modified;
await db.SaveChangesAsync();
return RedirectToAction("Index");
}
return View(serviceCategory);
}
public async Task<ActionResult> Skapa(ServiceCategory serviceCategory)
{
if (ModelState.IsValid)
{
serviceCategory.CreatedOn = DateTime.Now;
db.ServiceCategories.Add(serviceCategory);
await db.SaveChangesAsync();
return RedirectToAction("Index");
}
return View(serviceCategory);
}
public ServiceCategory Save()
{
ServiceCategory serviceCategory = null;
var session = NHibernateSessionManager.GetLocalSession();
session.DoTransactional(sess =>
{
serviceCategory = new ServiceCategory(
_form.Code,
_form.CategoryName,
_form.CategoryDescription
);
serviceCategory = _categoryRepository.Insert(serviceCategory);
});
return serviceCategory;
}
public static IList<ServiceSubCategory> GetServiceSubcategories(ServiceCategory serviceCategory, AriClinicContext ctx)
{
return (from c in ctx.ServiceSubCategories
where c.ServiceCategory.ServiceCategoryId == serviceCategory.ServiceCategoryId
select c).ToList<ServiceSubCategory>();
}
public bool Update(ServiceCategory entity)
{
return(serviceCategoryRepository.Update(entity));
}
/// <summary>
/// Traspasa los datos que corresponden a servicios y categorias de servicio
/// </summary>
/// <param name="con">Conector a OFT</param>
/// <param name="ctx">Contexto de AriClinc</param>
public static void ImportCategories(OleDbConnection con, AriClinicContext ctx)
{
int id = 0;
// (0) Borrar los datos previos.
ctx.Delete(ctx.Services);
ctx.Delete(ctx.ServiceCategories);
ctx.SaveChanges();
// (1) Dar de alta las categorias de servicio
string sql = "SELECT * FROM TipServMed";
cmd = new OleDbCommand(sql, con);
da = new OleDbDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds, "ConServicios");
int nreg = ds.Tables["ConServicios"].Rows.Count;
int reg = 0;
ServiceCategory sc = null;
foreach (DataRow dr in ds.Tables["ConServicios"].Rows)
{
DataRow localDr = dr;
reg++;
Console.WriteLine("Categorias {0:#####0} de {1:#####0} {2}", reg, nreg, (string)localDr["NomTipServMed"]);
sc = (from scat in ctx.ServiceCategories
where scat.OftId == (int)localDr["IdTipServMed"]
select scat).FirstOrDefault<ServiceCategory>();
if (sc == null)
{
sc = new ServiceCategory();
ctx.Add(sc);
}
sc.Name = (string)localDr["NomTipServMed"];
sc.OftId = (int)localDr["IdTipservMed"];
ctx.SaveChanges();
}
// (2) Con las categorías dadas de alta damos de alta los
// servicios.
sql = "SELECT * FROM ServMed";
cmd = new OleDbCommand(sql, con);
da = new OleDbDataAdapter(cmd);
ds = new DataSet();
da.Fill(ds, "ConServ2");
nreg = ds.Tables["ConServ2"].Rows.Count;
reg = 0;
Service s = null;
foreach (DataRow dr in ds.Tables["ConServ2"].Rows)
{
reg++;
s = (from sr in ctx.Services
where sr.OftId == (int)dr["IdServMed"]
select sr).FirstOrDefault<Service>();
if (s == null)
{
s = new Service();
ctx.Add(s);
}
s.Name = (string)dr["NomServMed"];
id = (int)dr["IdTipServMed"];
s.ServiceCategory = (from scat in ctx.ServiceCategories
where scat.OftId == id
select scat).FirstOrDefault<ServiceCategory>();
s.OftId = (int)dr["IdServMed"];
}
ctx.SaveChanges();
}
public async Task <IActionResult> CreateUpdateCategory(ServiceCategoryViewModel model)
{
var message = model.Id != null ? Messages.ItemUpdatedSuccessFully : Messages.ItemAddedSuccessFully;
var strategy = _dbContext.Database.CreateExecutionStrategy();
await strategy.ExecuteAsync(async() =>
{
using (var transaction = _dbContext.Database.BeginTransaction())
{
if (model.Id != null)
{
var group = await _dbContext.ServiceCategories.FindAsync(model.Id);
if (group == null)
{
throw new AwroNoreException("Service Category Not Found");
}
group.Name = model.Name;
group.Name_Ar = model.Name_Ar;
group.Name_Ku = model.Name_Ku;
group.CenterType = model.CenterType;
group.UpdatedAt = DateTime.Now;
_dbContext.ServiceCategories.Attach(group);
_dbContext.Entry(group).State = EntityState.Modified;
await _dbContext.SaveChangesAsync();
if (model.ImageUpload != null)
{
var(newName, thumbName, dirPath, baseUrl) = _uploadService.GenerateServiceCategoryLogoName(group.Id, model.ImageUpload);
group.Photo = $"{baseUrl}/{thumbName}";
_dbContext.ServiceCategories.Attach(group);
_dbContext.Entry(group).State = EntityState.Modified;
await _dbContext.SaveChangesAsync();
await _uploadService.UploadServiceCategoryLogoAsync(model.ImageUpload, dirPath, newName, thumbName);
}
}
else
{
var group = new ServiceCategory
{
Name = model.Name,
Name_Ku = model.Name_Ku,
Name_Ar = model.Name_Ar,
CenterType = model.CenterType,
CreatedAt = DateTime.Now,
};
await _dbContext.ServiceCategories.AddAsync(group);
await _dbContext.SaveChangesAsync();
var(newName, thumbName, dirPath, baseUrl) = _uploadService.GenerateServiceCategoryLogoName(group.Id, model.ImageUpload);
group.Photo = $"{baseUrl}/{thumbName}";
_dbContext.ServiceCategories.Attach(group);
_dbContext.Entry(group).State = EntityState.Modified;
await _dbContext.SaveChangesAsync();
await _uploadService.UploadServiceCategoryLogoAsync(model.ImageUpload, dirPath, newName, thumbName);
}
transaction.Commit();
}
});
return(Json(new { success = true, message }));
}
public ApplicationDbContextFixtureServiceRequisitions()
{
var connection = new SqliteConnection("DataSource=:memory:");
connection.Open();
var options = new DbContextOptionsBuilder <ApplicationDbContext>().UseSqlite(connection).Options;
DbContext = new ApplicationDbContext(options);
DbContext.Database.EnsureCreated();
CreateRoles_Users();
//Creates and adds a Category to the context
CleaningCategory = new ServiceCategory()
{
CategoryID = 1,
Name = "Limpeza",
IsSubcategory = false
};
DbContext.Add(CleaningCategory);
DbContext.SaveChanges();
//Creates and adds a Service to the context
CleaningService = new Service()
{
ServiceID = 1,
UserID = Prestador.Id,
ServiceCategoryID = 1,
ServiceName = "Faço limpezas ao domicilio",
Description = "Faço limpezas ao domicilio durante a semana de manha"
};
DbContext.Add(CleaningService);
DbContext.SaveChanges();
//Creates and Adds service requisitions to the context
PendingServiceRequisition = new ServiceRequisition()
{
ServiceRequisitionID = 1,
RequisitionerID = Cliente.Id,
ServiceID = CleaningService.ServiceID,
ServiceRequisitionStatus = ServiceRequisitionStatus.Pending,
AdditionalRequestInfo = "Limpeza de Prédio - 2x por semana",
CreationDate = DateTime.Now,
LastUpdatedTime = DateTime.Now,
LastUpdatedBy = Cliente.UserName,
Service = CleaningService,
Requisitioner = Cliente
};
AcceptedServiceRequisition = new ServiceRequisition()
{
ServiceRequisitionID = 2,
RequisitionerID = Cliente.Id,
ServiceID = CleaningService.ServiceID,
ServiceRequisitionStatus = ServiceRequisitionStatus.Accepted,
AdditionalRequestInfo = "Limpeza de Prédio - 2x por semana",
CreationDate = PendingServiceRequisition.CreationDate,
LastUpdatedTime = DateTime.Now,
LastUpdatedBy = Prestador.UserName,
Service = CleaningService,
Requisitioner = Cliente
};
ConcludedServiceRequisition = new ServiceRequisition()
{
ServiceRequisitionID = 3,
RequisitionerID = Cliente.Id,
ServiceID = CleaningService.ServiceID,
ServiceRequisitionStatus = ServiceRequisitionStatus.Concluded,
AdditionalRequestInfo = "Limpeza de Prédio - 2x por semana",
CreationDate = PendingServiceRequisition.CreationDate,
LastUpdatedTime = DateTime.Now,
LastUpdatedBy = Prestador.UserName,
Service = CleaningService,
Requisitioner = Cliente
};
CancelledServiceRequisition = new ServiceRequisition()
{
ServiceRequisitionID = 4,
RequisitionerID = Cliente.Id,
ServiceID = CleaningService.ServiceID,
ServiceRequisitionStatus = ServiceRequisitionStatus.Cancelled,
AdditionalRequestInfo = "Limpeza de Prédio - 2x por semana",
CreationDate = PendingServiceRequisition.CreationDate,
LastUpdatedTime = DateTime.Now,
LastUpdatedBy = Prestador.UserName,
Service = CleaningService,
Requisitioner = Cliente
};
RejectedServiceRequisition = new ServiceRequisition()
{
ServiceRequisitionID = 5,
RequisitionerID = Cliente.Id,
ServiceID = CleaningService.ServiceID,
ServiceRequisitionStatus = ServiceRequisitionStatus.Rejected,
AdditionalRequestInfo = "Limpeza de Prédio - 2x por semana",
CreationDate = PendingServiceRequisition.CreationDate,
LastUpdatedTime = DateTime.Now,
LastUpdatedBy = Prestador.UserName,
Service = CleaningService,
Requisitioner = Cliente
};
AcceptedServiceRequisition2 = new ServiceRequisition()
{
ServiceRequisitionID = 6,
RequisitionerID = Cliente.Id,
ServiceID = CleaningService.ServiceID,
ServiceRequisitionStatus = ServiceRequisitionStatus.Accepted,
AdditionalRequestInfo = "Limpeza de Prédio - 2x por semana",
CreationDate = PendingServiceRequisition.CreationDate,
LastUpdatedTime = DateTime.Now,
LastUpdatedBy = Prestador.UserName,
ConclusionDate = DateTime.Now,
Service = CleaningService,
Requisitioner = Cliente
};
DbContext.Add(PendingServiceRequisition);
DbContext.Add(AcceptedServiceRequisition);
DbContext.Add(CancelledServiceRequisition);
DbContext.Add(ConcludedServiceRequisition);
DbContext.Add(RejectedServiceRequisition);
DbContext.Add(AcceptedServiceRequisition2);
DbContext.SaveChanges();
}
public override IDeepCopyable CopyTo(IDeepCopyable other)
{
var dest = other as DiagnosticReport;
if (dest != null)
{
base.CopyTo(dest);
if (Name != null)
{
dest.Name = (Hl7.Fhir.Model.CodeableConcept)Name.DeepCopy();
}
if (StatusElement != null)
{
dest.StatusElement = (Code <Hl7.Fhir.Model.DiagnosticReport.DiagnosticReportStatus>)StatusElement.DeepCopy();
}
if (IssuedElement != null)
{
dest.IssuedElement = (Hl7.Fhir.Model.FhirDateTime)IssuedElement.DeepCopy();
}
if (Subject != null)
{
dest.Subject = (Hl7.Fhir.Model.ResourceReference)Subject.DeepCopy();
}
if (Performer != null)
{
dest.Performer = (Hl7.Fhir.Model.ResourceReference)Performer.DeepCopy();
}
if (Identifier != null)
{
dest.Identifier = (Hl7.Fhir.Model.Identifier)Identifier.DeepCopy();
}
if (RequestDetail != null)
{
dest.RequestDetail = new List <Hl7.Fhir.Model.ResourceReference>(RequestDetail.DeepCopy());
}
if (ServiceCategory != null)
{
dest.ServiceCategory = (Hl7.Fhir.Model.CodeableConcept)ServiceCategory.DeepCopy();
}
if (Diagnostic != null)
{
dest.Diagnostic = (Hl7.Fhir.Model.Element)Diagnostic.DeepCopy();
}
if (Specimen != null)
{
dest.Specimen = new List <Hl7.Fhir.Model.ResourceReference>(Specimen.DeepCopy());
}
if (Result != null)
{
dest.Result = new List <Hl7.Fhir.Model.ResourceReference>(Result.DeepCopy());
}
if (ImagingStudy != null)
{
dest.ImagingStudy = new List <Hl7.Fhir.Model.ResourceReference>(ImagingStudy.DeepCopy());
}
if (Image != null)
{
dest.Image = new List <Hl7.Fhir.Model.DiagnosticReport.DiagnosticReportImageComponent>(Image.DeepCopy());
}
if (ConclusionElement != null)
{
dest.ConclusionElement = (Hl7.Fhir.Model.FhirString)ConclusionElement.DeepCopy();
}
if (CodedDiagnosis != null)
{
dest.CodedDiagnosis = new List <Hl7.Fhir.Model.CodeableConcept>(CodedDiagnosis.DeepCopy());
}
if (PresentedForm != null)
{
dest.PresentedForm = new List <Hl7.Fhir.Model.Attachment>(PresentedForm.DeepCopy());
}
return(dest);
}
else
{
throw new ArgumentException("Can only copy to an object of the same type", "other");
}
}
public static ServiceCategoryVm ToViewModel(this ServiceCategory entity) => ViewModelMapper.ConfigMapper.Map <ServiceCategory, ServiceCategoryVm>(entity);
static void Main(string[] args)
{
WriteLine("Welcome to the CyberPatriot scoreboard bot JSON data corrector. This program will aid you in identifying and correcting flaws in your data.");
WriteLine("Corrective actions taken will be marked with an attention prefix, like this message.", error: ErrorState.Attention);
Console.WriteLine();
Console.WriteLine("Enter JSON filepath:");
JObject obj = JObject.Parse(File.ReadAllText(Console.ReadLine()));
var summary = obj["summary"].ToObject <CompleteScoreboardSummary>();
var teamDetails = obj["teams"].ToObject <Dictionary <TeamId, ScoreboardDetails> >();
// preemptive workaround, see #18
WriteLine("Ensuring snapshot timestamps are UTC", error: ErrorState.Attention);
summary.SnapshotTimestamp = summary.SnapshotTimestamp.ToUniversalTime();
foreach (var teamData in teamDetails.Values)
{
teamData.SnapshotTimestamp = teamData.SnapshotTimestamp.ToUniversalTime();
}
var round = (CompetitionRound)obj["round"].Value <int>();
WriteLine($"Parsed {summary.TeamList.Count} team(s) from summary for round {round}");
if (teamDetails.Keys.OrderBy(x => x.TeamNumber).SequenceEqual(summary.TeamList.Select(s => s.TeamId).OrderBy(x => x.TeamNumber)))
{
WriteLine("Details teamlist matches summary teamlist", indentLevel: 1, error: ErrorState.Success);
}
else
{
WriteLine("Details teamlist does not match summary teamlist, printing diff", indentLevel: 1, error: ErrorState.Error);
WriteLine("Teams with details without summary:", indentLevel: 2);
foreach (var teamId in teamDetails.Keys.Except(summary.TeamList.Select(s => s.TeamId)))
{
WriteLine(teamId.ToString(), indentLevel: 2, error: ErrorState.NoPrefix);
}
WriteLine("Teams in summary without details:", indentLevel: 2);
foreach (var teamId in summary.TeamList.Select(s => s.TeamId).Except(teamDetails.Keys))
{
WriteLine(teamId.ToString(), indentLevel: 2, error: ErrorState.NoPrefix);
}
}
var completeTeamSet = teamDetails.Keys.Intersect(summary.TeamList.Select(s => s.TeamId)).ToList();
WriteLine($"There are {completeTeamSet.Count} fully-represented team(s)");
var summaryProperties = typeof(ScoreboardSummaryEntry).GetProperties(BindingFlags.Instance | BindingFlags.Public).Where(p => p.Name != "Category");
var summariesDisagreeExcludingCategory = completeTeamSet
.Select(x => new { TeamId = x, SummarySummary = summary.TeamList.Single(y => y.TeamId == x), DetailsSummary = teamDetails[x].Summary })
.Where(x =>
{
var sumSumCat0 = x.SummarySummary.Category;
var detSumCat0 = x.DetailsSummary.Category;
x.DetailsSummary.Category = null;
x.SummarySummary.Category = null;
bool eqComparison = x.DetailsSummary.Equals(x.SummarySummary);
x.DetailsSummary.Category = detSumCat0;
x.SummarySummary.Category = sumSumCat0;
return(!eqComparison);
}).ToList();
if (summariesDisagreeExcludingCategory.Count > 0)
{
WriteLine($"Excluding purely ServiceCategory disagreements, there are {summariesDisagreeExcludingCategory.Count} teams whose summaries disagree", indentLevel: 1, error: ErrorState.Error);
WriteLine("Here they are:", indentLevel: 2);
foreach (var disagreement in summariesDisagreeExcludingCategory)
{
WriteLine(disagreement.TeamId.ToString(), indentLevel: 2, error: ErrorState.NoPrefix);
foreach (var propToCompare in summaryProperties)
{
var sumVal = propToCompare.GetValue(disagreement.SummarySummary);
var detVal = propToCompare.GetValue(disagreement.DetailsSummary);
if (!Equals(sumVal, detVal))
{
WriteLine($"{propToCompare.Name}: s = '{sumVal}', d = '{detVal}'", indentLevel: 3, error: ErrorState.NoPrefix);
}
}
}
}
else
{
WriteLine($"Notwithstanding ServiceCategory (soon to be inspected), all teams agree within their scoreboard and details on their summaries", indentLevel: 1, error: ErrorState.Success);
}
var categoryDisagreements = completeTeamSet
.Select(x => new { TeamId = x, SummaryCategory = summary.TeamList.Single(y => y.TeamId == x).Category, DetailsCategory = teamDetails[x].Summary.Category })
.Where(x => x.SummaryCategory != x.DetailsCategory).ToList();
WriteLine($"There are {categoryDisagreements.Count} team(s) whose details-summary and scoreboard-summary category markings disagree, of which {categoryDisagreements.Count(x => x.SummaryCategory.HasValue && x.DetailsCategory.HasValue)} are in direct conflict", error: categoryDisagreements.Count == 0 ? ErrorState.Success : ErrorState.Error);
if (categoryDisagreements.Count > 0)
{
WriteLine("Here they are (with warnings indicating inability to take corrective action):", indentLevel: 1);
foreach (var disagreement in categoryDisagreements)
{
bool directConflict = disagreement.SummaryCategory.HasValue && disagreement.DetailsCategory.HasValue;
WriteLine(disagreement.TeamId.ToString(), indentLevel: 2, error: directConflict?ErrorState.Warning: ErrorState.Attention);
if (!directConflict)
{
// since these two disagree, and at least one is null, that means this team has a category
ServiceCategory cat = disagreement.SummaryCategory ?? disagreement.DetailsCategory ?? (ServiceCategory)(-1);
summary.TeamList.Single(y => y.TeamId == disagreement.TeamId).Category = cat;
teamDetails[disagreement.TeamId].Summary.Category = cat;
}
}
}
var asTeams = completeTeamSet.Select(x => summary.TeamList.Single(y => y.TeamId == x)).Where(x => x.Division == Division.AllService).ToList();
if (asTeams.Any(x => x.Category.HasValue))
{
var asTeamsCategoryless = asTeams.Where(x => !x.Category.HasValue).ToList();
WriteLine($"There are {asTeamsCategoryless.Count} service team(s) without category data", error: asTeamsCategoryless.Count == 0 ? ErrorState.Success : ErrorState.Error);
foreach (var team in asTeamsCategoryless)
{
WriteLine(team.TeamId.ToString(), indentLevel: 1, error: ErrorState.NoPrefix);
}
}
else
{
WriteLine("Service teams are consistent in not having category data", error: ErrorState.Success);
}
var nonAsTeams = completeTeamSet.Select(x => summary.TeamList.Single(y => y.TeamId == x)).Where(x => x.Division != Division.AllService).ToList();
if (nonAsTeams.Any(x => x.Category.HasValue))
{
var nonAsTeamsCategoried = nonAsTeams.Where(x => x.Category.HasValue).ToList();
WriteLine($"There are {nonAsTeamsCategoried.Count} non-service team(s) with category data", error: ErrorState.Error);
foreach (var team in nonAsTeamsCategoried)
{
WriteLine(team.TeamId.ToString(), indentLevel: 1, error: ErrorState.NoPrefix);
}
}
else
{
WriteLine("Non-service teams are consistent in not having category data", error: ErrorState.Success);
}
Console.WriteLine();
Console.WriteLine("If you would like to write any C# to adjust this state beyond automated corrections, please type non-blank lines. Otherwise, press return.");
Console.WriteLine("The following globals are available to you:");
foreach (var field in typeof(InterpretedGlobals).GetFields(BindingFlags.Public | BindingFlags.Instance))
{
Console.WriteLine($"{field.Name}\t{field.FieldType}");
}
var cSharpScript = new StringBuilder();
string appendedLine;
do
{
appendedLine = Console.ReadLine();
cSharpScript.AppendLine(appendedLine);
} while (!string.IsNullOrWhiteSpace(appendedLine));
string cSharpCode = cSharpScript.ToString();
if (!string.IsNullOrWhiteSpace(cSharpCode))
{
var globals = new InterpretedGlobals();
globals.Details = teamDetails;
globals.Summary = summary;
globals.Round = round;
try
{
CSharpScript.RunAsync(cSharpCode,
globals: globals,
options: ScriptOptions.Default
.WithReferences(typeof(TeamId).Assembly)
.WithImports("System", "CyberPatriot.Models", "System.Linq", "System.Collections.Generic")).Wait();
round = globals.Round;
Console.WriteLine("Script executed successfully.");
}
catch (Exception e)
{
WriteLine("Error running your script! Oh well, I hope it all worked.", error: ErrorState.Error);
Console.WriteLine(e);
}
}
else
{
Console.WriteLine("No script entered.");
}
Console.WriteLine();
Console.WriteLine("Where would you like to save the modified file?");
string targetPath = Console.ReadLine();
using (JsonWriter jw = new JsonTextWriter(new StreamWriter(File.OpenWrite(targetPath))))
{
// write
jw.WriteStartObject();
jw.WritePropertyName("summary");
var serializer = JsonSerializer.CreateDefault();
// serialize
serializer.Serialize(jw, summary);
jw.WritePropertyName("teams");
serializer.Serialize(jw, teamDetails);
jw.WritePropertyName("round");
jw.WriteValue((int)round);
jw.WriteEndObject();
jw.Flush();
}
Console.WriteLine("Done.");
}
protected void LoadServiceSubCategory2(ServiceCategory scat)
{
// clear previous items
rdcServiceSubCategory.Items.Clear();
foreach (ServiceSubCategory s in scat.ServiceSubCategories)
{
rdcServiceSubCategory.Items.Add(new RadComboBoxItem(s.Name, s.ServiceSubCategoryId.ToString()));
}
}
public static void Initialize(AmsApiDbContext context, UserManager <ApplicationUser> userManager, RoleManager <IdentityRole> roleManager, ILogger <DbInitializer> logger)
{
context.Database.EnsureCreated();
var locations = new Location[] {
new Location {
Active = true, Address = "7696 NW Greensprint St", Address1 = "Suit 123", ContactEmail = "*****@*****.**", ContactName = "Contact PersonNAme", Description = "Este es un salo de belleza", State = "FL", ZipCode = "34987", Country = "US", Phone = "1234567890", City = "Port Saint Lucie"
},
new Location {
Active = true, Address = "123 NW Greensprint St", Address1 = "Suit 434", ContactEmail = "*****@*****.**", ContactName = "PersonNAme", Description = "Este es una barberia", State = "GA", ZipCode = "3093", Country = "US", Phone = "1234567811", City = "Port Saint Lucie"
},
};
if (!context.Locations.Any())
{
//return; // DB has been seeded
context.Locations.AddRange(locations);
context.SaveChanges();
}
var cds = new ClosedDate[] {
new ClosedDate {
Location = locations.FirstOrDefault(), Description = "Holyday 2", From = DateTime.Now.AddDays(55), To = DateTime.Now.AddDays(55)
},
new ClosedDate {
Location = locations.FirstOrDefault(), Description = "Holyday 1", From = DateTime.Now.AddDays(5), To = DateTime.Now.AddDays(5)
},
};
if (!context.ClosedDates.Any())
{
//return; // DB has been seeded
context.ClosedDates.AddRange(cds);
context.SaveChanges();
}
var scs = new ServiceCategory[] {
new ServiceCategory {
Description = "Haircuts and Hairdressing"
},
new ServiceCategory {
Description = "Color"
}
};
if (!context.ServiceCategories.Any())
{
context.ServiceCategories.AddRange(scs);
context.SaveChanges();
}
var ss = new Service[] {
new Service {
ServiceCategory = scs.Single(s => s.Description == "Haircuts and Hairdressing"), ActiveStatus = true, DurationHour = 1, DurationMinute = 30, Price = 50.00m, ServiceDescription = "Modern Hair cuts", ServiceName = "Hair Cuts"
},
new Service {
ServiceCategory = scs.Single(s => s.Description == "Haircuts and Hairdressing"), ActiveStatus = true, DurationHour = 1, DurationMinute = 15, Price = 45.00m, ServiceDescription = "Modern Hair cuts", ServiceName = "Wash"
},
new Service {
ServiceCategory = scs.Single(s => s.Description == "Haircuts and Hairdressing"), ActiveStatus = true, DurationHour = 1, DurationMinute = 30, Price = 50.00m, ServiceDescription = "Hoof cuts", ServiceName = "Manicure and Pedicure"
},
};
if (!context.Services.Any())
{
context.Services.AddRange(ss);
context.SaveChanges();
}
var clients = new Client[] {
new Client {
AcceptsMarketingNotifications = true, Active = true, Email = "*****@*****.**", FirstName = "Client1", LastName = "last 1", Mobile = "1234567890", SendNotificationBy = "phone", Photo = "234234"
},
new Client {
AcceptsMarketingNotifications = true, Active = true, Email = "*****@*****.**", FirstName = "Client 2", LastName = "last 2", Mobile = "1234567890", SendNotificationBy = "email", Photo = "234234"
},
new Client {
AcceptsMarketingNotifications = true, Active = true, Email = "*****@*****.**", FirstName = "Client 3", LastName = "last 3", Mobile = "1234567890", SendNotificationBy = "email", Photo = "234234"
},
};
if (!context.Clients.Any())
{
context.Clients.AddRange(clients);
context.SaveChanges();
}
var uRoles = new IdentityRole {
Name = "admin", ConcurrencyStamp = "adminrole"
};
IdentityResult resultR = roleManager.CreateAsync(uRoles).Result;
uRoles = new IdentityRole {
Name = "staff", ConcurrencyStamp = "staffrole"
};
resultR = roleManager.CreateAsync(uRoles).Result;
uRoles = new IdentityRole {
Name = "customer", ConcurrencyStamp = "customerrole"
};
resultR = roleManager.CreateAsync(uRoles).Result;
var aUser = new ApplicationUser {
UserName = "******", Email = "*****@*****.**", EmailConfirmed = true
};
var result = userManager.CreateAsync(aUser, "Password1$").Result;
var resultRole = userManager.AddToRoleAsync(aUser, "customer").Result;
if (result.Succeeded)
{
logger.LogInformation("User created a new account with password.");
var token = userManager.GenerateEmailConfirmationTokenAsync(aUser).Result;
var results = userManager.ConfirmEmailAsync(aUser, token).Result;
aUser = new ApplicationUser {
UserName = "******", Email = "*****@*****.**", EmailConfirmed = true
};
results = userManager.CreateAsync(aUser, "Password1$").Result;
resultRole = userManager.AddToRoleAsync(aUser, "customer").Result;
token = userManager.GenerateEmailConfirmationTokenAsync(aUser).Result;
results = userManager.ConfirmEmailAsync(aUser, token).Result;
aUser = new ApplicationUser {
UserName = "******", Email = "*****@*****.**", EmailConfirmed = true
};
userManager.CreateAsync(aUser, "Password1$").Wait();
resultRole = userManager.AddToRoleAsync(aUser, "customer").Result;
}
var sts = new Staff[] {
new Staff {
Active = true, BriefCv = "Nice cuts", CanBook = true, Email = "*****@*****.**", FirstName = "Staly 1", LastName = "st", Mobile = "1234567890", Title = "Cutter"
},
new Staff {
Active = true, BriefCv = "Nice cuts same", CanBook = true, Email = "*****@*****.**", FirstName = "St3", LastName = "tr", Mobile = "1234563333", Title = "Very good"
},
new Staff {
Active = true, BriefCv = "D' Penco Nice cuts same", CanBook = true, Email = "*****@*****.**", FirstName = "the", LastName = "penco", Mobile = "1234562233", Title = "The Penco"
},
};
if (!context.Staffs.Any())
{
context.Staffs.AddRange(sts);
context.SaveChanges();
}
aUser = new ApplicationUser {
UserName = "******", Email = "*****@*****.**", EmailConfirmed = true
};
result = userManager.CreateAsync(aUser, "Password1$").Result;
resultRole = userManager.AddToRoleAsync(aUser, "staff").Result;
if (result.Succeeded)
{
var token = userManager.GenerateEmailConfirmationTokenAsync(aUser).Result;
var results = userManager.ConfirmEmailAsync(aUser, token).Result;
aUser = new ApplicationUser {
UserName = "******", Email = "*****@*****.**", EmailConfirmed = true
};
userManager.CreateAsync(aUser, "Password1$").Wait();
resultRole = userManager.AddToRoleAsync(aUser, "admin").Result;
token = userManager.GenerateEmailConfirmationTokenAsync(aUser).Result;
results = userManager.ConfirmEmailAsync(aUser, token).Result;
aUser = new ApplicationUser {
UserName = "******", Email = "*****@*****.**", EmailConfirmed = true
};
userManager.CreateAsync(aUser, "Password1$").Wait();
resultRole = userManager.AddToRoleAsync(aUser, "staff").Result;
}
var whs = new StaffWorkingHour[] {
new StaffWorkingHour {
EndRepeat = EndRepeat.Ongoing, From = DateTime.Now, To = DateTime.Now.AddHours(5), Location = locations.FirstOrDefault(), Staff = sts.FirstOrDefault()
},
new StaffWorkingHour {
EndRepeat = EndRepeat.Ongoing, From = DateTime.Now, To = DateTime.Now.AddHours(3), Location = locations.LastOrDefault(), Staff = sts.LastOrDefault()
},
};
if (!context.StaffWorkingHours.Any())
{
context.StaffWorkingHours.AddRange(whs);
context.SaveChanges();
}
}
public void Add(ServiceCategory serviceCategory)
{
_context.Add(serviceCategory);
_context.SaveChanges();
}
protected void UnloadData(ServiceCategory scat)
{
scat.Name = txtName.Text;
}
protected void LoadData(ServiceCategory scat)
{
txtServiceCategoryId.Text = scat.ServiceCategoryId.ToString();
txtName.Text = scat.Name;
}
public int AddServiceCategory(ServiceCategory serviceCategory)
{
return(ServiceCategoryDAL.CreateServiceCategory(serviceCategory));
}
public CategoryController()
{
myService = new ServiceCategory();
}
public void GetFindByNameItem()
{
mock.Setup(x => x.Categories);
ServiceCategory service = new ServiceCategory(mock.Object);
IEnumerable <string> res = service.GetFindByNameItem(null);
}
public void InitService()
{
_btnSaveService.Click += (sender, args) =>
{
if (string.IsNullOrEmpty(_txtNameService.Text) || string.IsNullOrEmpty(_txtDesscribe.Text))
{
MessageBox.Show("Заполните все поля", "Внимание", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
try
{
using (var context = new DentalContext())
{
var selectService = new ServiceCategory(_txtNameService.Text, _txtDesscribe.Text);
context.ServiceCategories.Add(selectService);
context.SaveChanges();
_objectListViewService.SetObjects(context.ServiceCategories);
ResetServiceControls();
}
}
catch (Exception ex)
{
MessageBox.Show("Ошибка", ex.Message);
}
};
_btnUpdateService.Click += (sender, args) =>
{
try
{
using (var contex = new DentalContext())
{
var updateService = _objectListViewService.SelectedObject as ServiceCategory;
if (updateService == null)
{
MessageBox.Show("Укажите услугу для редактирования", "Внимание", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
updateService.Name = _txtNameService.Text;
updateService.Desscribe = _txtDesscribe.Text;
contex.ServiceCategories.AddOrUpdate(updateService);
contex.SaveChanges();
_objectListViewService.SetObjects(contex.ServiceCategories);
ResetServiceControls();
}
}
catch (Exception ex)
{
MessageBox.Show("Ошибка", ex.Message);
}
};
_btnDeleteService.Click += (sender, args) =>
{
using (var context = new DentalContext())
{
var selectService = _objectListViewService.SelectedObject as ServiceCategory;
var deletedDoctore = context.Patients.First(d => d.Id == selectService.Id);
if (selectService == null)
{
MessageBox.Show("Укажите услугу", "Внимание", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
context.ServiceCategories.Remove(selectService);
context.SaveChanges();
_objectListViewService.SetObjects(context.ServiceCategories);
ResetServiceControls();
}
Close();
};
_objectListViewService.SelectedIndexChanged += (sender, args) =>
{
var selectedService = _objectListViewService.SelectedObject as ServiceCategory;
if (selectedService == null)
{
return;
}
_txtNameService.Text = selectedService.Name;
_txtDesscribe.Text = selectedService.Desscribe;
};
}
public void GetCategoryFind()
{
mock.Setup(x => x.Categories);
ServiceCategory service = new ServiceCategory(mock.Object);
CategoryDTO res = service.GetCategoryFind(null);
}
public ActionResult Post([FromBody] ServiceCategory serviceCategory)
{
return(Ok(
serviceCategoryService.Save(serviceCategory)
));
}
public Frmservicecategory()
{
InitializeComponent();
BindingContext = vm = new ServiceCategory();
//_listView.ItemsSource = vm.WardenServiceData;
}
public ActionResult FillDatabase()
{
var userManager = UserManagerFactory.Get();
var dataProvider = DataProviderFactory.Get();
#region Localities
var minskReg = new Region {
Name = "Минская обл."
}; dataProvider.SaveRegion(minskReg);
var mogilevReg = new Region {
Name = "Могилевская обл."
}; dataProvider.SaveRegion(mogilevReg);
var brestReg = new Region {
Name = "Брестская обл."
}; dataProvider.SaveRegion(brestReg);
var vitebskReg = new Region {
Name = "Витебская обл."
}; dataProvider.SaveRegion(vitebskReg);
var grodnoReg = new Region {
Name = "Гродненская обл."
}; dataProvider.SaveRegion(grodnoReg);
var gomelReg = new Region {
Name = "Гомельская обл."
}; dataProvider.SaveRegion(gomelReg);
var minsk = new City {
Name = "Минск", RegionId = minskReg.Id
}; dataProvider.SaveCity(minsk);
var beresino = new City {
Name = "Березино", RegionId = minskReg.Id
}; dataProvider.SaveCity(beresino);
var borisov = new City {
Name = "Борисов", RegionId = minskReg.Id
}; dataProvider.SaveCity(borisov);
var vileika = new City {
Name = "Вилейка", RegionId = minskReg.Id
}; dataProvider.SaveCity(vileika);
var vologin = new City {
Name = "Воложин", RegionId = minskReg.Id
}; dataProvider.SaveCity(vologin);
var derginsk = new City {
Name = "Держинск", RegionId = minskReg.Id
}; dataProvider.SaveCity(derginsk);
var godino = new City {
Name = "Жодино", RegionId = minskReg.Id
}; dataProvider.SaveCity(godino);
var kleck = new City {
Name = "Клецк", RegionId = minskReg.Id
}; dataProvider.SaveCity(kleck);
var kopil = new City {
Name = "Копыль", RegionId = minskReg.Id
}; dataProvider.SaveCity(kopil);
var krupki = new City {
Name = "Крупки", RegionId = minskReg.Id
}; dataProvider.SaveCity(krupki);
var logoisk = new City {
Name = "Логойск", RegionId = minskReg.Id
}; dataProvider.SaveCity(logoisk);
var luban = new City {
Name = "Любань", RegionId = minskReg.Id
}; dataProvider.SaveCity(luban);
var molodechno = new City {
Name = "Молодечно", RegionId = minskReg.Id
}; dataProvider.SaveCity(molodechno);
var nesvig = new City {
Name = "Несвиж", RegionId = minskReg.Id
}; dataProvider.SaveCity(nesvig);
var mogilev = new City {
Name = "Могилев", RegionId = mogilevReg.Id
}; dataProvider.SaveCity(mogilev);
var belinichy = new City {
Name = "Белыничи", RegionId = mogilevReg.Id
}; dataProvider.SaveCity(belinichy);
var bobruisk = new City {
Name = "Бобоуйск", RegionId = mogilevReg.Id
}; dataProvider.SaveCity(bobruisk);
var bixov = new City {
Name = "Быхов", RegionId = mogilevReg.Id
}; dataProvider.SaveCity(bixov);
var glusk = new City {
Name = "Глуск", RegionId = mogilevReg.Id
}; dataProvider.SaveCity(glusk);
var gorki = new City {
Name = "Горки", RegionId = mogilevReg.Id
}; dataProvider.SaveCity(gorki);
var dribin = new City {
Name = "Дрибин", RegionId = mogilevReg.Id
}; dataProvider.SaveCity(dribin);
var Kirovsk = new City {
Name = "Кировск", RegionId = mogilevReg.Id
}; dataProvider.SaveCity(Kirovsk);
var Klimovichy = new City {
Name = "Климовичи", RegionId = mogilevReg.Id
}; dataProvider.SaveCity(Klimovichy);
var Klichev = new City {
Name = "Кличев", RegionId = mogilevReg.Id
}; dataProvider.SaveCity(Klichev);
var Kostukovichy = new City {
Name = "Костюковичи", RegionId = mogilevReg.Id
}; dataProvider.SaveCity(Kostukovichy);
var Krasnopolie = new City {
Name = "Краснополье", RegionId = mogilevReg.Id
}; dataProvider.SaveCity(Krasnopolie);
var Krichev = new City {
Name = "Кричев", RegionId = mogilevReg.Id
}; dataProvider.SaveCity(Krichev);
var Krugloe = new City {
Name = "Круглое", RegionId = mogilevReg.Id
}; dataProvider.SaveCity(Krugloe);
var Mstislavl = new City {
Name = "Мстиславль", RegionId = mogilevReg.Id
}; dataProvider.SaveCity(Mstislavl);
var Osipovichy = new City {
Name = "Осиповичи", RegionId = mogilevReg.Id
}; dataProvider.SaveCity(Osipovichy);
var Slavgorod = new City {
Name = "Славгород", RegionId = mogilevReg.Id
}; dataProvider.SaveCity(Slavgorod);
var Xotimsk = new City {
Name = "Хотимск", RegionId = mogilevReg.Id
}; dataProvider.SaveCity(Xotimsk);
var Chays = new City {
Name = "Чаусы", RegionId = mogilevReg.Id
}; dataProvider.SaveCity(Chays);
var Cherikov = new City {
Name = "Чериков", RegionId = mogilevReg.Id
}; dataProvider.SaveCity(Cherikov);
var Shklov = new City {
Name = "Шклов", RegionId = mogilevReg.Id
}; dataProvider.SaveCity(Shklov);
var grodno = new City {
Name = "Гродно", RegionId = grodnoReg.Id
}; dataProvider.SaveCity(grodno);
var volcovisk = new City {
Name = "Волковыск", RegionId = grodnoReg.Id
}; dataProvider.SaveCity(volcovisk);
var voronovo = new City {
Name = "Вороново", RegionId = grodnoReg.Id
}; dataProvider.SaveCity(voronovo);
var diatlovo = new City {
Name = "Дятлово", RegionId = grodnoReg.Id
}; dataProvider.SaveCity(diatlovo);
var zelva = new City {
Name = "Зельва", RegionId = grodnoReg.Id
}; dataProvider.SaveCity(zelva);
var ivie = new City {
Name = "Ивье", RegionId = grodnoReg.Id
}; dataProvider.SaveCity(ivie);
var korelichy = new City {
Name = "Кореличи", RegionId = grodnoReg.Id
}; dataProvider.SaveCity(korelichy);
var lida = new City {
Name = "Лида", RegionId = grodnoReg.Id
}; dataProvider.SaveCity(lida);
var mosti = new City {
Name = "Мосты", RegionId = grodnoReg.Id
}; dataProvider.SaveCity(mosti);
var novogrudok = new City {
Name = "Новогрудок", RegionId = grodnoReg.Id
}; dataProvider.SaveCity(novogrudok);
var ostrovec = new City {
Name = "Островец", RegionId = grodnoReg.Id
}; dataProvider.SaveCity(ostrovec);
var oshmiany = new City {
Name = "Ошмяны", RegionId = grodnoReg.Id
}; dataProvider.SaveCity(oshmiany);
var svisloch = new City {
Name = "Свислочь", RegionId = grodnoReg.Id
}; dataProvider.SaveCity(svisloch);
var slonim = new City {
Name = "Слоним", RegionId = grodnoReg.Id
}; dataProvider.SaveCity(slonim);
var smorgon = new City {
Name = "Сморгонь", RegionId = grodnoReg.Id
}; dataProvider.SaveCity(smorgon);
var schychin = new City {
Name = "Щучин", RegionId = grodnoReg.Id
}; dataProvider.SaveCity(schychin);
var gomel = new City {
Name = "Гомель", RegionId = gomelReg.Id
}; dataProvider.SaveCity(gomel);
var Bragin = new City {
Name = "Брагин", RegionId = gomelReg.Id
}; dataProvider.SaveCity(Bragin);
var Vetka = new City {
Name = "Ветка", RegionId = gomelReg.Id
}; dataProvider.SaveCity(Vetka);
var Dabrush = new City {
Name = "Добрушь", RegionId = gomelReg.Id
}; dataProvider.SaveCity(Dabrush);
var Elsk = new City {
Name = "Ельск", RegionId = gomelReg.Id
}; dataProvider.SaveCity(Elsk);
var Gitkovachy = new City {
Name = "Житковичи", RegionId = gomelReg.Id
}; dataProvider.SaveCity(Gitkovachy);
var Globin = new City {
Name = "Жлобин", RegionId = gomelReg.Id
}; dataProvider.SaveCity(Globin);
var Kalinkovachy = new City {
Name = "Калинковичи", RegionId = gomelReg.Id
}; dataProvider.SaveCity(Kalinkovachy);
var Korma = new City {
Name = "Корма", RegionId = gomelReg.Id
}; dataProvider.SaveCity(Korma);
var Lelchici = new City {
Name = "Лельчици", RegionId = gomelReg.Id
}; dataProvider.SaveCity(Lelchici);
var Loev = new City {
Name = "Лоев", RegionId = gomelReg.Id
}; dataProvider.SaveCity(Loev);
var Mozir = new City {
Name = "Мозырь", RegionId = gomelReg.Id
}; dataProvider.SaveCity(Mozir);
var NArovlia = new City {
Name = "Наровля", RegionId = gomelReg.Id
}; dataProvider.SaveCity(NArovlia);
var Petrikov = new City {
Name = "Петриков", RegionId = gomelReg.Id
}; dataProvider.SaveCity(Petrikov);
var Rogachev = new City {
Name = "Рогачев", RegionId = gomelReg.Id
}; dataProvider.SaveCity(Rogachev);
var Svetlogorsk = new City {
Name = "Светлогорск", RegionId = gomelReg.Id
}; dataProvider.SaveCity(Svetlogorsk);
var Chexhersk = new City {
Name = "Чечерск", RegionId = gomelReg.Id
}; dataProvider.SaveCity(Chexhersk);
var vitebsk = new City {
Name = "Витебск", RegionId = vitebskReg.Id
}; dataProvider.SaveCity(vitebsk);
var Braslav = new City {
Name = "Браслав", RegionId = vitebskReg.Id
}; dataProvider.SaveCity(Braslav);
var Verxnedvinsk = new City {
Name = "Верхнедвинск", RegionId = vitebskReg.Id
}; dataProvider.SaveCity(Verxnedvinsk);
var Glubokoe = new City {
Name = "Глубокое", RegionId = vitebskReg.Id
}; dataProvider.SaveCity(Glubokoe);
var Gorodok = new City {
Name = "Городок", RegionId = vitebskReg.Id
}; dataProvider.SaveCity(Gorodok);
var Dokshici = new City {
Name = "Докшицы", RegionId = vitebskReg.Id
}; dataProvider.SaveCity(Dokshici);
var dybrovno = new City {
Name = "Дубровно", RegionId = vitebskReg.Id
}; dataProvider.SaveCity(dybrovno);
var Lepel = new City {
Name = "Лепель", RegionId = vitebskReg.Id
}; dataProvider.SaveCity(Lepel);
var Liozno = new City {
Name = "Лиозно", RegionId = vitebskReg.Id
}; dataProvider.SaveCity(Liozno);
var Miori = new City {
Name = "Миоры", RegionId = vitebskReg.Id
}; dataProvider.SaveCity(Miori);
var Novopolock = new City {
Name = "Новополоцк", RegionId = vitebskReg.Id
}; dataProvider.SaveCity(Novopolock);
var Orsha = new City {
Name = "Орша", RegionId = vitebskReg.Id
}; dataProvider.SaveCity(Orsha);
var Polock = new City {
Name = "Полоцк", RegionId = vitebskReg.Id
}; dataProvider.SaveCity(Polock);
var postavi = new City {
Name = "Поставы", RegionId = vitebskReg.Id
}; dataProvider.SaveCity(postavi);
var Senno = new City {
Name = "Сенно", RegionId = vitebskReg.Id
}; dataProvider.SaveCity(Senno);
var tolochin = new City {
Name = "Толочин", RegionId = vitebskReg.Id
}; dataProvider.SaveCity(tolochin);
var yshachy = new City {
Name = "Ушачи", RegionId = vitebskReg.Id
}; dataProvider.SaveCity(yshachy);
var Chashniki = new City {
Name = "Чашники", RegionId = vitebskReg.Id
}; dataProvider.SaveCity(Chashniki);
var brest = new City {
Name = "Брест", RegionId = brestReg.Id
}; dataProvider.SaveCity(brest);
var Baranovichy = new City {
Name = "Барановичи", RegionId = brestReg.Id
}; dataProvider.SaveCity(Baranovichy);
var Gorodische = new City {
Name = "Городище", RegionId = brestReg.Id
}; dataProvider.SaveCity(Gorodische);
var Bereza = new City {
Name = "Береза", RegionId = brestReg.Id
}; dataProvider.SaveCity(Bereza);
var Beloozerst = new City {
Name = "Белоозеоск", RegionId = brestReg.Id
}; dataProvider.SaveCity(Beloozerst);
var Domachevo = new City {
Name = "Домачево", RegionId = brestReg.Id
}; dataProvider.SaveCity(Domachevo);
var Gancevichy = new City {
Name = "Ганцевичи", RegionId = brestReg.Id
}; dataProvider.SaveCity(Gancevichy);
var Drogichin = new City {
Name = "Дрогичин", RegionId = brestReg.Id
}; dataProvider.SaveCity(Drogichin);
var Antipol = new City {
Name = "Антополь", RegionId = brestReg.Id
}; dataProvider.SaveCity(Antipol);
var Gabinka = new City {
Name = "Жабинка", RegionId = brestReg.Id
}; dataProvider.SaveCity(Gabinka);
var Ivanovo = new City {
Name = "Ивано", RegionId = brestReg.Id
}; dataProvider.SaveCity(Ivanovo);
var Ivacevichy = new City {
Name = "Ивацевичи", RegionId = brestReg.Id
}; dataProvider.SaveCity(Ivacevichy);
var kossovo = new City {
Name = "Коссово", RegionId = brestReg.Id
}; dataProvider.SaveCity(kossovo);
var kamenec = new City {
Name = "Каменец", RegionId = brestReg.Id
}; dataProvider.SaveCity(kamenec);
var Visokoe = new City {
Name = "Высокое", RegionId = brestReg.Id
}; dataProvider.SaveCity(Visokoe);
var kobrin = new City {
Name = "Кобрин", RegionId = brestReg.Id
}; dataProvider.SaveCity(kobrin);
var luninec = new City {
Name = "Луниннец", RegionId = brestReg.Id
}; dataProvider.SaveCity(luninec);
var liaxovochy = new City {
Name = "Ляховичи", RegionId = brestReg.Id
}; dataProvider.SaveCity(liaxovochy);
var pinsk = new City {
Name = "Пинск", RegionId = brestReg.Id
}; dataProvider.SaveCity(pinsk);
var Prugan = new City {
Name = "Пружаны", RegionId = brestReg.Id
}; dataProvider.SaveCity(Prugan);
var stopin = new City {
Name = "Стопин", RegionId = brestReg.Id
}; dataProvider.SaveCity(stopin);
#endregion
var visaElectron = new CardType {
Name = "Visa Electron", IconName = "/Content/Images/Cards/Visa Electron.JPG"
}; dataProvider.SaveCardType(visaElectron);
var visaClassic = new CardType {
Name = "Visa Classic", IconName = "/Content/Images/Cards/Visa Classic.png"
}; dataProvider.SaveCardType(visaClassic);
var visaGold = new CardType {
Name = "Visa Gold", IconName = "/Content/Images/Cards/Visa Gold.png"
}; dataProvider.SaveCardType(visaGold);
var visaPlatinum = new CardType {
Name = "Visa Platinum", IconName = "/Content/Images/Cards/Visa Platinum.png"
}; dataProvider.SaveCardType(visaPlatinum);
var maestro = new CardType {
Name = "Maestro", IconName = "/Content/Images/Cards/Maestro.png"
}; dataProvider.SaveCardType(maestro);
var masterCardStandard = new CardType {
Name = "MasterCard Standard", IconName = "/Content/Images/Cards/MasterCard Standard.png"
}; dataProvider.SaveCardType(masterCardStandard);
var masterCardGold = new CardType {
Name = "MasterCard Gold", IconName = "/Content/Images/Cards/MasterCard Gold.png"
}; dataProvider.SaveCardType(masterCardGold);
var белКарт = new CardType {
Name = "БелКарт", IconName = "/Content/Images/Cards/БелКарт.png"
}; dataProvider.SaveCardType(белКарт);
var forChildren = new CardType {
Name = "Для детей и подростков", IconName = "/Content/Images/Cards/For Children.png"
}; dataProvider.SaveCardType(forChildren);
SaveUser("458_prudnikova_y_n", "Jn999999", true, true, mogilev.Id, "Прудникова Юлия Николаевна", "8975646M009BP5");
var clientUser6 = SaveUser("Karnitsky_N_D", "Tt111111", true, false, Kirovsk.Id, "Карнитский Николай Дмитриевич", "7898675M009BP3");
var clientUser = SaveUser("Ivan.Petrov", "Ip199111", true, false, kobrin.Id, "Петров Иван Сергеевич", "77578654M007BP1");
var clientUser1 = SaveUser("V_A_Aldanova", "Kq121312", true, false, pinsk.Id, "Алданова Валена Александровна", "0098675M009BP3");
var clientUser2 = SaveUser("Eliseenko", "Hy576756", true, false, Kirovsk.Id, "Елисеенко Алла Григорьевна", "0098775M089BP1");
var clientUser3 = SaveUser("K_S_Minchyk", "Hj769000", true, false, nesvig.Id, "Минчук Константиг Станислававия", "0009675M009BP3");
var clientUser4 = SaveUser("Kulman_a_a", "er000111", true, false, lida.Id, "Кульман Анна Аркадьевна", "0096665M089BP7");
var clientUser5 = SaveUser("A_M_Kovalenko", "Am786754", true, false, minsk.Id, "Коваленко Александр Михайлович", "0099800M009BP3");
dataProvider.SaveSessionPassword(new SessionPassword {
UserId = clientUser6.Id, Password = "******"
});
dataProvider.SaveSessionPassword(new SessionPassword {
UserId = clientUser6.Id, Password = "******"
});
dataProvider.SaveSessionPassword(new SessionPassword {
UserId = clientUser6.Id, Password = "******"
});
dataProvider.SaveSessionPassword(new SessionPassword {
UserId = clientUser6.Id, Password = "******"
});
dataProvider.SaveSessionPassword(new SessionPassword {
UserId = clientUser6.Id, Password = "******"
});
dataProvider.SaveSessionPassword(new SessionPassword {
UserId = clientUser.Id, Password = "******"
});
dataProvider.SaveSessionPassword(new SessionPassword {
UserId = clientUser.Id, Password = "******"
});
dataProvider.SaveSessionPassword(new SessionPassword {
UserId = clientUser.Id, Password = "******"
});
dataProvider.SaveSessionPassword(new SessionPassword {
UserId = clientUser.Id, Password = "******"
});
dataProvider.SaveSessionPassword(new SessionPassword {
UserId = clientUser.Id, Password = "******"
});
dataProvider.SaveSessionPassword(new SessionPassword {
UserId = clientUser1.Id, Password = "******"
});
dataProvider.SaveSessionPassword(new SessionPassword {
UserId = clientUser1.Id, Password = "******"
});
dataProvider.SaveSessionPassword(new SessionPassword {
UserId = clientUser1.Id, Password = "******"
});
dataProvider.SaveSessionPassword(new SessionPassword {
UserId = clientUser1.Id, Password = "******"
});
dataProvider.SaveSessionPassword(new SessionPassword {
UserId = clientUser1.Id, Password = "******"
});
dataProvider.SaveSessionPassword(new SessionPassword {
UserId = clientUser2.Id, Password = "******"
});
dataProvider.SaveSessionPassword(new SessionPassword {
UserId = clientUser2.Id, Password = "******"
});
dataProvider.SaveSessionPassword(new SessionPassword {
UserId = clientUser2.Id, Password = "******"
});
dataProvider.SaveSessionPassword(new SessionPassword {
UserId = clientUser2.Id, Password = "******"
});
dataProvider.SaveSessionPassword(new SessionPassword {
UserId = clientUser2.Id, Password = "******"
});
dataProvider.SaveSessionPassword(new SessionPassword {
UserId = clientUser3.Id, Password = "******"
});
dataProvider.SaveSessionPassword(new SessionPassword {
UserId = clientUser3.Id, Password = "******"
});
dataProvider.SaveSessionPassword(new SessionPassword {
UserId = clientUser3.Id, Password = "******"
});
dataProvider.SaveSessionPassword(new SessionPassword {
UserId = clientUser3.Id, Password = "******"
});
dataProvider.SaveSessionPassword(new SessionPassword {
UserId = clientUser3.Id, Password = "******"
});
dataProvider.SaveSessionPassword(new SessionPassword {
UserId = clientUser4.Id, Password = "******"
});
dataProvider.SaveSessionPassword(new SessionPassword {
UserId = clientUser4.Id, Password = "******"
});
dataProvider.SaveSessionPassword(new SessionPassword {
UserId = clientUser4.Id, Password = "******"
});
dataProvider.SaveSessionPassword(new SessionPassword {
UserId = clientUser4.Id, Password = "******"
});
dataProvider.SaveSessionPassword(new SessionPassword {
UserId = clientUser4.Id, Password = "******"
});
dataProvider.SaveSessionPassword(new SessionPassword {
UserId = clientUser5.Id, Password = "******"
});
dataProvider.SaveSessionPassword(new SessionPassword {
UserId = clientUser5.Id, Password = "******"
});
dataProvider.SaveSessionPassword(new SessionPassword {
UserId = clientUser5.Id, Password = "******"
});
dataProvider.SaveSessionPassword(new SessionPassword {
UserId = clientUser5.Id, Password = "******"
});
dataProvider.SaveSessionPassword(new SessionPassword {
UserId = clientUser5.Id, Password = "******"
});
var account = new Account {
UserId = clientUser.Id, Number = "2234 6745 2342 8967", OpenDate = DateTime.Now.AddMonths(-2), CloseDate = DateTime.Now.AddYears(1), Balance = 4657000, MinBalance = 0, Currency = (int)Currencies.BYR, IsOpened = true
}; dataProvider.SaveAccount(account);
dataProvider.SaveCard(new Card {
AccountId = account.Id, CardTypeId = visaElectron.Id, Number = "2234 6745 2342 8967", CreateDate = DateTime.Now.AddMonths(-2), ExpireDate = DateTime.Now.AddYears(1), IsAttached = true
});
var account1 = new Account {
UserId = clientUser1.Id, Number = "2234 8745 7645 8967", OpenDate = DateTime.Now.AddMonths(-2), CloseDate = DateTime.Now.AddYears(1), Balance = 8700000, MinBalance = 2000000, Currency = (int)Currencies.BYR, IsOpened = true
}; dataProvider.SaveAccount(account1);
dataProvider.SaveCard(new Card {
AccountId = account1.Id, CardTypeId = visaElectron.Id, Number = "2234 8745 7645 8967", CreateDate = DateTime.Now.AddMonths(-2), ExpireDate = DateTime.Now.AddYears(1), IsAttached = true
});
var account2 = new Account {
UserId = clientUser2.Id, Number = "3542 6745 8754 9878", OpenDate = DateTime.Now.AddMonths(-2), CloseDate = DateTime.Now.AddYears(1), Balance = 6786000, MinBalance = 0, Currency = (int)Currencies.BYR, IsOpened = true
}; dataProvider.SaveAccount(account2);
dataProvider.SaveCard(new Card {
AccountId = account2.Id, CardTypeId = visaClassic.Id, Number = "3542 6745 8754 9878", CreateDate = DateTime.Now.AddMonths(-2), ExpireDate = DateTime.Now.AddYears(1), IsAttached = true
});
var account2_1 = new Account {
UserId = clientUser2.Id, Number = "3542 6745 8754 8967", OpenDate = DateTime.Now.AddMonths(-2), CloseDate = DateTime.Now.AddYears(1), Balance = 67543220, MinBalance = 0, Currency = (int)Currencies.BYR, IsOpened = true
}; dataProvider.SaveAccount(account2_1);
dataProvider.SaveCard(new Card {
AccountId = account2_1.Id, CardTypeId = visaElectron.Id, Number = "3542 6745 8754 8967", CreateDate = DateTime.Now.AddMonths(-2), ExpireDate = DateTime.Now.AddYears(1), IsAttached = true
});
var account3 = new Account {
UserId = clientUser3.Id, Number = "3892 3424 8754 1765", OpenDate = DateTime.Now.AddMonths(-2), CloseDate = DateTime.Now.AddYears(1), Balance = 675000, MinBalance = 0, Currency = (int)Currencies.BYR, IsOpened = true
}; dataProvider.SaveAccount(account3);
dataProvider.SaveCard(new Card {
AccountId = account3.Id, CardTypeId = visaClassic.Id, Number = "3544 3424 8754 1765", CreateDate = DateTime.Now.AddMonths(-2), ExpireDate = DateTime.Now.AddYears(1), IsAttached = true
});
var account4 = new Account {
UserId = clientUser4.Id, Number = "4545 7865 8754 1765", OpenDate = DateTime.Now.AddMonths(-2), CloseDate = DateTime.Now.AddYears(1), Balance = 6432100, MinBalance = 0, Currency = (int)Currencies.BYR, IsOpened = true
}; dataProvider.SaveAccount(account4);
dataProvider.SaveCard(new Card {
AccountId = account4.Id, CardTypeId = visaElectron.Id, Number = "4545 7865 8754 1765", CreateDate = DateTime.Now.AddMonths(-2), ExpireDate = DateTime.Now.AddYears(1), IsAttached = true
});
var account5 = new Account {
UserId = clientUser5.Id, Number = "8978 1232 8754 6745", OpenDate = DateTime.Now.AddMonths(-2), CloseDate = DateTime.Now.AddYears(1), Balance = 7896540, MinBalance = 0, Currency = (int)Currencies.BYR, IsOpened = true
}; dataProvider.SaveAccount(account5);
dataProvider.SaveCard(new Card {
AccountId = account5.Id, CardTypeId = белКарт.Id, Number = "8978 1232 8754 6745", CreateDate = DateTime.Now.AddMonths(-2), ExpireDate = DateTime.Now.AddYears(1), IsAttached = true
});
var account6 = new Account {
UserId = clientUser6.Id, Number = "9088 1232 9876 9087", OpenDate = DateTime.Now.AddMonths(-2), CloseDate = DateTime.Now.AddYears(1), Balance = 7896540, MinBalance = 0, Currency = (int)Currencies.BYR, IsOpened = true
}; dataProvider.SaveAccount(account6);
dataProvider.SaveCard(new Card {
AccountId = account6.Id, CardTypeId = белКарт.Id, Number = "9088 1232 9876 9087", CreateDate = DateTime.Now.AddMonths(-2), ExpireDate = DateTime.Now.AddYears(1), IsAttached = true
});
var erip = new ServiceCategory {
Name = "Система \"Расчет\" (ЕРИП)", ServiceCategoryId = null
}; dataProvider.SaveServiceCategory(erip);
var beltel = new ServiceCategory {
Name = "БЕЛТЕЛЕКОМ", ServiceCategoryId = erip.Id
}; dataProvider.SaveServiceCategory(beltel);
SaveBeltel(dataProvider, beltel, mogilevReg.Id, "Могилев и Могилевская область", new [] {
new CityTelephone(mogilev.Id, "222", "999999"),
new CityTelephone(belinichy.Id, "2232", "99999"),
new CityTelephone(bobruisk.Id, "2251", "99999"),
new CityTelephone(bixov.Id, "2231", "99999"),
new CityTelephone(glusk.Id, "2230", "99999"),
new CityTelephone(gorki.Id, "2233", "99999"),
new CityTelephone(dribin.Id, "2248", "99999"),
new CityTelephone(Kirovsk.Id, "2237", "99999"),
new CityTelephone(Klimovichy.Id, "2244", "99999"),
new CityTelephone(Klichev.Id, "2241", "99999"),
new CityTelephone(Kostukovichy.Id, "2245", "99999"),
new CityTelephone(Krasnopolie.Id, "2238", "99999"),
new CityTelephone(Krichev.Id, "2241", "99999"),
new CityTelephone(Mstislavl.Id, "2240", "99999"),
new CityTelephone(Osipovichy.Id, "2235", "99999"),
new CityTelephone(Slavgorod.Id, "2246", "99999"),
new CityTelephone(Xotimsk.Id, "2247", "99999"),
new CityTelephone(Chays.Id, "2242", "99999"),
new CityTelephone(Cherikov.Id, "2243", "99999"),
new CityTelephone(Shklov.Id, "2239", "99999")
});
SaveBeltel(dataProvider, beltel, minskReg.Id, "Минск и Минская область", "17", "9999999");
SaveBeltel(dataProvider, beltel, brestReg.Id, "Брест и Брестская область", "162", "999999");
SaveBeltel(dataProvider, beltel, vitebskReg.Id, "Витебск и Витебск область", "212", "999999");
SaveBeltel(dataProvider, beltel, gomelReg.Id, "Гомель и Гомельская область", "232", "999999");
SaveBeltel(dataProvider, beltel, grodnoReg.Id, "Гродно и Голдненская область", "152", "999999");
//var minskObl = new ServiceCategory { Name = "Могилев и Могилевская область", ServiceCategoryId = beltel.Id }; dataProvider.SaveServiceCategory(mogilevObl);
// var internet = new Service { Name = "Интернет (BYFLY, ZALA, Максифон)", ServiceCategoryId = mogilevObl.Id, ScriptName = "BeltelecomInternetViewModel", TemplateName = "BeltelecomInternetTemplate" }; dataProvider.SaveService(internet);
// var telephone = new Service { Name = "Телефон", ServiceCategoryId = mogilevObl.Id, ScriptName = "TelephoneViewModel", TemplateName = "TelephoneTemplate" }; dataProvider.SaveService(telephone);
//var mogilevObl = new ServiceCategory { Name = "Могилев и Могилевская область", ServiceCategoryId = beltel.Id }; dataProvider.SaveServiceCategory(mogilevObl);
var mobileTel = new ServiceCategory {
Name = "Мобильный телефон", ServiceCategoryId = null
}; dataProvider.SaveServiceCategory(mobileTel);
var mts = new Service {
Name = "МТС", ServiceCategoryId = mobileTel.Id, ScriptName = "TelephoneViewModel", TemplateName = "TelephoneTemplate"
}; dataProvider.SaveService(mts);
var life = new Service {
Name = "life:)", ServiceCategoryId = mobileTel.Id, ScriptName = "TelephoneViewModel", TemplateName = "TelephoneTemplate"
}; dataProvider.SaveService(life);
var velcom = new Service {
Name = "VELCOM", ServiceCategoryId = mobileTel.Id, ScriptName = "TelephoneViewModel", TemplateName = "TelephoneTemplate"
}; dataProvider.SaveService(velcom);
var communal = new ServiceCategory {
Name = "Коммунальные", ServiceCategoryId = null
}; dataProvider.SaveServiceCategory(communal);
var common = new Service {
Name = "Общие", ServiceCategoryId = communal.Id, ScriptName = "CommunalPaymentsViewModel", TemplateName = "CommunalPaymentsTemplate"
}; dataProvider.SaveService(common);
var water = new Service {
Name = "Водоснабжение", ServiceCategoryId = communal.Id, ScriptName = "WaterServiceViewModel", TemplateName = "WaterElectricServiceTemplate"
}; dataProvider.SaveService(water);
var electric = new Service {
Name = "Электричество", ServiceCategoryId = communal.Id, ScriptName = "ElectricServiceViewModel", TemplateName = "WaterElectricServiceTemplate"
}; dataProvider.SaveService(electric);
var capRemont = new Service {
Name = "Капитальный ремонт", ServiceCategoryId = communal.Id, ScriptName = "CommunalPaymentsViewModel", TemplateName = "CommunalPaymentsTemplate"
}; dataProvider.SaveService(capRemont);
var gas = new Service {
Name = "Газ", ServiceCategoryId = communal.Id, ScriptName = "CommunalPaymentsViewModel", TemplateName = "CommunalPaymentsTemplate"
}; dataProvider.SaveService(gas);
dataProvider.SaveServiceParameter(new ServiceParameter {
ServiceId = mts.Id, Name = "29", ValueType = (int)ServiceParameterValueTypes.String, DefaultValue = "[2578]999999"
});
dataProvider.SaveServiceParameter(new ServiceParameter {
ServiceId = mts.Id, Name = "33", ValueType = (int)ServiceParameterValueTypes.String, DefaultValue = "9999999"
});
dataProvider.SaveServiceParameter(new ServiceParameter {
ServiceId = life.Id, Name = "25", ValueType = (int)ServiceParameterValueTypes.String, DefaultValue = "9999999"
});
dataProvider.SaveServiceParameter(new ServiceParameter {
ServiceId = velcom.Id, Name = "29", ValueType = (int)ServiceParameterValueTypes.String, DefaultValue = "[1369]999999"
});
dataProvider.SaveServiceParameter(new ServiceParameter {
ServiceId = velcom.Id, Name = "44", ValueType = (int)ServiceParameterValueTypes.String, DefaultValue = "9999999"
});
dataProvider.SaveServiceParameter(new ServiceParameter {
ServiceId = common.Id, Name = "Mask", ValueType = (int)ServiceParameterValueTypes.String, DefaultValue = "999999999"
});
dataProvider.SaveServiceParameter(new ServiceParameter {
ServiceId = water.Id, Name = "Mask", ValueType = (int)ServiceParameterValueTypes.String, DefaultValue = "999999999"
});
dataProvider.SaveServiceParameter(new ServiceParameter {
ServiceId = water.Id, Name = "Tariff", ValueType = (int)ServiceParameterValueTypes.Int, DefaultValue = "15000"
});
dataProvider.SaveServiceParameter(new ServiceParameter {
ServiceId = electric.Id, Name = "Mask", ValueType = (int)ServiceParameterValueTypes.String, DefaultValue = "999999999"
});
dataProvider.SaveServiceParameter(new ServiceParameter {
ServiceId = electric.Id, Name = "150", ValueType = (int)ServiceParameterValueTypes.Int, DefaultValue = "955"
});
dataProvider.SaveServiceParameter(new ServiceParameter {
ServiceId = electric.Id, Name = "300", ValueType = (int)ServiceParameterValueTypes.Int, DefaultValue = "1240"
});
dataProvider.SaveServiceParameter(new ServiceParameter {
ServiceId = electric.Id, Name = "999999", ValueType = (int)ServiceParameterValueTypes.Int, DefaultValue = "1470"
});
dataProvider.SaveServiceParameter(new ServiceParameter {
ServiceId = capRemont.Id, Name = "Mask", ValueType = (int)ServiceParameterValueTypes.String, DefaultValue = "999999999"
});
dataProvider.SaveServiceParameter(new ServiceParameter {
ServiceId = gas.Id, Name = "Mask", ValueType = (int)ServiceParameterValueTypes.String, DefaultValue = "999999999"
});
return(RedirectToAction("Index", "Home"));
}
protected override async Task OnInitializedAsync()
{
await base.OnInitializedAsync();
CategoriesList = await ServiceCategory.ListAllAsync();
}
public IActionResult CreateView()
{
ServiceCategory serviceCategory = new ServiceCategory();
return(PartialView("_Create", serviceCategory));
}
public async Task <IActionResult> addservicecategory([FromBody] ServiceCategory servicecategory)
{
ServiceCategory _servicecategory = null;
List <ServiceCategory> servicecategories = null;
ServiceCategoryError e = new ServiceCategoryError();
Redis redis = new Redis(settings, cache);
CancellationTokenSource cts;
cts = new CancellationTokenSource();
cts.CancelAfter(settings.Value.redisCancellationToken);
servicecategory.created_on = DateTime.Now;
//validate request
if (!ModelState.IsValid)
{
var modelErrors = new List <ServiceCategoryError>();
var eD = new List <string>();
foreach (var modelState in ModelState.Values)
{
foreach (var modelError in modelState.Errors)
{
eD.Add(modelError.ErrorMessage);
}
}
e.error = ((int)HttpStatusCode.BadRequest).ToString();
e.errorDetails = eD;
return(BadRequest(e));
}
//Add to mongo
try
{
//_billercategory = await billercategoryMongoRepo.AddBillerCategory(billercategory);
}
catch (Exception ex)
{
Console.Write(ex.Message);
}
//Add to sql server
try
{
if (servicecategory.id == 0)
{
_servicecategory = await billercategorySqlRepo.AddServiceCategory(servicecategory);
}
else if (servicecategory.id > 0)
{
_servicecategory = await billercategorySqlRepo.UpdateServiceCategory(servicecategory);
}
}
catch (Exception ex)
{
Console.Write(ex.Message);
}
//Write to Redis
try
{
string key = "all_service_category:" + _servicecategory.id;
if (_servicecategory != null)
{
await redis.setservicecategory(key, _servicecategory, cts.Token);
}
}
catch (Exception ex)
{
Console.Write(ex.Message);
}
return(CreatedAtAction("addservicecategory", _servicecategory));
}
public static ServiceCategoryResponse ToRequestModel(this ServiceCategory entity) => ViewModelMapper.ConfigMapper.Map <ServiceCategory, ServiceCategoryResponse>(entity);
public bool Save(ServiceCategory entity)
{
return(serviceCategoryRepository.Save(entity));
}
public bool post([FromBody] ServiceCategory s)
{
return(ad.PostServiceCategory(s));
}
public string put(int id, [FromBody] ServiceCategory s)
{
return(ad.putServiceCategory(id, s));
}
protected void LoadServiceCategory(ServiceCategory scat)
{
// clear previous items
rdcbServiceCategory.Items.Clear();
foreach (ServiceCategory s in ctx.ServiceCategories)
{
rdcbServiceCategory.Items.Add(new RadComboBoxItem(s.Name, s.ServiceCategoryId.ToString()));
}
if (scat != null)
{
rdcbServiceCategory.SelectedValue = scat.ServiceCategoryId.ToString();
}
else
{
rdcbServiceCategory.Items.Add(new RadComboBoxItem(" ", ""));
rdcbServiceCategory.SelectedValue = "";
}
}
public override ErrorList Validate()
{
var result = new ErrorList();
result.AddRange(base.Validate());
if (StatusElement != null)
{
result.AddRange(StatusElement.Validate());
}
if (IssuedElement != null)
{
result.AddRange(IssuedElement.Validate());
}
if (Subject != null)
{
result.AddRange(Subject.Validate());
}
if (Performer != null)
{
result.AddRange(Performer.Validate());
}
if (ReportId != null)
{
result.AddRange(ReportId.Validate());
}
if (RequestDetail != null)
{
RequestDetail.ForEach(elem => result.AddRange(elem.Validate()));
}
if (ServiceCategory != null)
{
result.AddRange(ServiceCategory.Validate());
}
if (DiagnosticTimeElement != null)
{
result.AddRange(DiagnosticTimeElement.Validate());
}
if (Results != null)
{
result.AddRange(Results.Validate());
}
if (Image != null)
{
Image.ForEach(elem => result.AddRange(elem.Validate()));
}
if (ConclusionElement != null)
{
result.AddRange(ConclusionElement.Validate());
}
if (CodedDiagnosis != null)
{
CodedDiagnosis.ForEach(elem => result.AddRange(elem.Validate()));
}
if (Representation != null)
{
Representation.ForEach(elem => result.AddRange(elem.Validate()));
}
return(result);
}
