public async Task<ActionResult> Default(RegisterViewModel model)
{
var context = new MyDbContext();
var UserManager = new UserManager<ApplicationUser>(new UserStore<ApplicationUser>(context));
// The default Validators that the UserManager uses are UserValidator and MinimumLengthValidator
// You can tweak some of the settings as follows
// This example sets the Password length to be 3 characters
UserManager.UserValidator = new UserValidator<ApplicationUser>(UserManager)
{
AllowOnlyAlphanumericUserNames = false
};
UserManager.PasswordValidator = new MinimumLengthValidator(3);
if (ModelState.IsValid)
{
var user = new ApplicationUser() { UserName = model.UserName };
user.HomeTown = model.HomeTown;
var result = await UserManager.CreateAsync(user, model.Password);
if (result.Succeeded)
{
var authManager = HttpContext.GetOwinContext().Authentication;
var claimsIdentity = UserManager.CreateIdentity(user, DefaultAuthenticationTypes.ApplicationCookie);
authManager.SignIn(claimsIdentity);
return RedirectToAction("Index", "Home");
}
else
{
foreach (var error in result.Errors)
{
ModelState.AddModelError("", error);
}
}
}
// If we got this far, something failed, redisplay form
return View(model);
}
public static void OnContractToBeCompleted(object source, EventArgs e)
{
MyDbContext db = new MyDbContext();
var contract = (Contract)source;
//Get contract from db to check wheter the saving worked and the status is set
contract = db.Contracts.Find(contract.Id);
if (contract != null && contract.ContractStatus.Id == 1)
{
var tempTask = new ContractTask();
tempTask.Description = "Vertrag vervollstaendigen";
tempTask.TaskType = TaskTypes.VertragVervollstaendigen;
tempTask.Contract = contract;
tempTask.User = contract.Dispatcher;
tempTask.IsDone = false;
tempTask.DateCreated = DateTime.Now;
//for Testing only - for Real App uncomment the Line after
tempTask.Expiring = DateTime.Now.AddMinutes(Constants.LAUFZEIT_DISPATCHERTASK_MINUTEN_TEST);
//tempTask.Expiring = DateTime.Now.AddDays(Constants.LAUFZEIT_DISPATCHERTASK_TAGE);
db.ContractTasks.Add(tempTask);
db.SaveChanges();
//take care that the task gets removed
tempTask.TriggerTaskCreatedEvent();
System.Diagnostics.Debug.WriteLine("<Vertrag vervollstaendigen> Aufgabe erstellt");
}
}
static void Main(string[] args)
{
// Original tutorial: http://blog.devart.com/entity-framework-code-first-support-for-oracle-mysql-postgresql-and-sqlite.html
//--------------------------------------------------------------
// You use the capability for configuring the behavior of the EF-provider:
/*
Devart.Data.Oracle.Entity.Configuration.OracleEntityProviderConfig config =
Devart.Data.Oracle.Entity.Configuration.OracleEntityProviderConfig.Instance;
config.Workarounds.IgnoreSchemaName = true;
* */
//--------------------------------------------------------------
/*--------------------------------------------------------------
You can set up a connection string for DbContext in different ways.
It can be placed into the app.config (web.config) file.
The connection string name must be identical to the DbContext descendant name.
<add name="MyDbContext" connectionString="Data Source=ora1020;
User Id=test;Password=test;" providerName="Devart.Data.Oracle" />
After that, you create a context instance, while a connection string is
enabled automatically:
MyDbContext context = new MyDbContext();
---------------------------------------------------------------*/
/*--------------------------------------------------------------
You can choose one of database initialization
strategies or turn off initialization:
--------------------------------------------------------------*/
System.Data.Entity.Database.SetInitializer<MyDbContext>(new MyDbContextDropCreateDatabaseAlways());
/*System.Data.Entity.Database.SetInitializer
<MyOracleContext>(new MyDbContextCreateDatabaseIfNotExists());
System.Data.Entity.Database.SetInitializer
<MyOracleContext>(new MyDbContextDropCreateDatabaseIfModelChanges());
System.Data.Entity.Database.SetInitializer<MyOracleContext>(null);*/
//--------------------------------------------------------------
/*--------------------------------------------------------------
Let's create MyDbContext and execute a database query.
Depending on selected database initialization strategy,
database tables can be deleted/added, and filled with source data.
---------------------------------------------------------------*/
Console.WriteLine("Available account currencies in database:");
using (MyDbContext context = new MyDbContext())
{
var list = (from d in context.AccountCurrencies
select d).ToList();
foreach (var l in list)
{
Console.WriteLine(l.IsoCode);
}
}
Console.ReadKey();
}
static void Main()
{
try
{
using(var db = new MyDbContext())
{
Console.WriteLine("*** Using EF directly ***");
var data = db.Customers.Take(10).OrderBy(x => x.CustomerId);
foreach(var row in data)
{
Console.WriteLine(row.CompanyName);
}
Console.WriteLine();
Console.WriteLine("*** Using EF via a repository ***");
ICustomersRepository customersRepository = new CustomersRepository(db);
var repoData = customersRepository.GetTop10();
foreach(var row in repoData)
{
Console.WriteLine(row.CompanyName);
}
}
}
catch(Exception e)
{
Console.WriteLine("**************************************************");
Console.WriteLine("********************** Exception *****************");
Console.WriteLine();
Console.WriteLine(e.Message);
Console.WriteLine();
Console.WriteLine(e.InnerException);
}
}
//Gets the Departments of Dispatcher depend on the Client
public static IQueryable<CostCenter> GetCostCentersFromClient(string client, MyDbContext db)
{
var query = from c in db.CostCenters
where c.Client.ClientName.Equals(client)
select c;
return query;
}
public static IQueryable<ContractSubType> GetContractSubTypesFromContractTypes(string type, MyDbContext db)
{
var query = from s in db.ContractSubTypes
where s.ContractType.Description.Equals(type)
select s;
return query;
}
//Gets the Departments of Dispatcher depend on the Client
public static IQueryable<Department> GetDepartmentsFromClient(string client, MyDbContext db)
{
var query = from d in db.Departments
where d.Client.ClientName.Equals(client)
select d;
return query;
}
public void TestMethod1()
{
var validator = new Validator();
var ctx = new MyDbContext();
var results = validator.CheckDbContext(ctx).AlsoCheck(DatabaseObjectType.Trigger, "dbo", "MyTrigger").Validate();
Assert.IsTrue(!results.Any());
}
public void SetUp()
{
Database.SetInitializer(new DataSeedingInitializer());
context = new MyDbContext("DefaultDb");
customerRepository = new CustomerRepository(context);
genericRepository = new GenericRepository(context);
}
public AccountController()
{
db = new MyDbContext();
UserManager = new UserManager<MyUser>(new UserStore<MyUser>(db));
RoleManager = new RoleManager<IdentityRole>(new RoleStore<IdentityRole>(db));
UserManager.UserValidator = new UserValidator<MyUser>(UserManager) { AllowOnlyAlphanumericUserNames = false };
}
//Gets the Client of Department
public static IQueryable<Client> GetClientOfDepartment(string department, MyDbContext db)
{
var subQuery = from dep in db.Departments
where dep.DepartmentName.Equals(department)
select dep;
var query = from c in db.Clients
join dep in subQuery on c.Id equals dep.Client.Id
select c;
return query;
}
//Gets the Departments of UserEmail
public static IQueryable<Department> GetDepartmentsOfUser(string userName, MyDbContext db)
{
var subQuery = from du in db.DepartmentUser_Relations
where du.User.UserName.Equals(userName)
select du;
var query = from dep in db.Departments
join du in subQuery on dep.Id equals du.DepartmentID
select dep;
return query;
}
/// 获取当前数据上下文
/// </summary>
/// <returns></returns>
public static MyDbContext GetCurrentContext()
{
MyDbContext _nContext = CallContext.GetData("MyDbContext") as MyDbContext;
if (_nContext == null)
{
_nContext = new MyDbContext();
CallContext.SetData("MyDbContext", _nContext);
}
return _nContext;
}
/*<!--Oberhauser/-->*/
//Gets the Departments of Dispatcher depend on the Client
public static IQueryable<ContractUser> GetCoordinatorsFromClient(string client, MyDbContext db)
{
var subQuery = from c in db.CoordinatorClient_Relations
where c.Client.ClientName.Equals(client)
select c;
var query = from u in db.Users
from c in subQuery
where (
u.Id.Equals(c.CoordinatorID)
)
select u;
return query;
}
public HomeController(MyDbContext someDb = null)
{
//If we were given a null context, just use the default context
if (someDb == null)
{
Db = new MyDbContext("MyDbContext");
}
else
{
//otherwise, use the supplied context
Db = someDb;
}
}
public DbGeography GetPersonGeography(string firstName)
{
using (var context = new MyDbContext())
{
var q = from p in context.Person_People
where p.FirstName == firstName
select p.Person_BusinessEntity.Person_BusinessEntityAddresses;
var address = q.First().First();
return address.Person_Address.SpatialLocation;
}
}
public IList<string> GetDistinctNames()
{
using (var context = new MyDbContext())
{
var q = from p in context.Person_People select p.FirstName;
var names = q.Distinct()
.OrderBy(x => x)
.ToList();
return names;
}
}
public IList<Person_Person> GetPeopleByFirstName(string firstName)
{
using (var context = new MyDbContext())
{
var q = from p in context.Person_People where p.FirstName == firstName select p;
var names = q.Distinct()
.Include( x=> x.Person_BusinessEntity)
.Include(x => x.Person_BusinessEntity.Person_BusinessEntityAddresses)
.OrderBy(x => x.LastName)
.ToList();
return names;
}
}
public void Execute(IJobExecutionContext context)
{
System.Diagnostics.Debug.WriteLine("Aufgabe wird geloescht ");
JobDataMap dataMap = context.JobDetail.JobDataMap;
int taskKey = dataMap.GetInt("TaskId");
MyDbContext db = new MyDbContext();
ContractTask task = db.ContractTasks.Find(taskKey);
db.ContractTasks.Remove(task);
db.SaveChanges();
System.Diagnostics.Debug.WriteLine("Aufgabe wurde geloescht ");
}
/// <summary>
///
/// Messenger Note on Task Notification
///
/// </summary>
/// <param name="context"></param>
public void Execute(IJobExecutionContext context)
{
JobDataMap dataMap = context.JobDetail.JobDataMap;
int taskKey = dataMap.GetInt("TaskId");
MyDbContext db = new MyDbContext();
var task = db.ContractTasks.Find(taskKey);
if (task != null && task.IsDone == false)
{
Messenger messenger = Messenger.Instance;
messenger.AddToMessenger(DateTime.Now, "Aufgabe " + "<b>" + task.Description + "</b>" + " muss bald erledigt werden");
}
}
public void Test2()
{
using (var context = new MyDbContext())
{
var queryable = context.Products
.AsQueryable()
.GroupBy("new ( ProductName )", "it")
.Select("new ( Key.ProductName AS ProductName, SUM(UnitPrice) as Total )")
.ToListAsync();
foreach (var record in queryable.Result)
{
}
}
}
public static void OnContractCompleted(object source, EventArgs e)
{
//Not implemented yet - Mark Task as Done
MyDbContext db = new MyDbContext();
var contract = (Contract)source;
var task = db.ContractTasks.Where(t => t.Contract.Id == contract.Id && t.TaskType == TaskTypes.VertragVervollstaendigen).SingleOrDefault();
task.IsDone = true;
db.Entry(task).State = EntityState.Modified;
db.SaveChanges();
//take care that the task gets removed
task.TriggerTaskDoneEvent();
System.Diagnostics.Debug.WriteLine("Vertrag vervollstaendigt");
}
// GET: ClaimsIdentityFactory
public async Task<ActionResult> Index(LoginViewModel model, string returnUrl)
{
var context = new MyDbContext();
var userManager = new UserManager<ApplicationUser>(new UserStore<ApplicationUser>(context));
userManager.ClaimsIdentityFactory = new MyClaimsIdentityFactory<ApplicationUser>();
// Create a User to SignIn
var user = await userManager.FindAsync(model.UserName, model.Password);
//SignIn the User by generating a ClaimsIdentity
var claimsIdentity = await userManager.CreateIdentityAsync(user, DefaultAuthenticationTypes.ApplicationCookie);
// This claimsIdentity should have a claim called LastLoginTime
var authManager = HttpContext.GetOwinContext().Authentication;
authManager.SignIn(claimsIdentity);
return RedirectToLocal(returnUrl);
}
public static void OnDispatcherSet(object source, EventArgs e)
{
MyDbContext db = new MyDbContext();
Contract tempContract = (Contract)source;
//The dispatcher has to be loaded here because the nav property is not set at this point yet
ContractUser dispatcher = db.Users.Find(tempContract.DispatcherId);
//Notify Dispatcher
dynamic email = new Email("DispatcherMail");
email.to = dispatcher.Email;
email.from = applicationEmail;
email.contractId = tempContract.Id;
email.Send();
System.Diagnostics.Debug.WriteLine("Email wurde abgeschickt");
}
// http://trentacular.com/2010/08/linq-to-entities-wild-card-like-extension-method/
static void Main(string[] args)
{
using (var context = new MyDbContext())
{
context.Database.Log = (sql) => Debug.WriteLine(sql);
#if BEFORE
var q =
context.Stores.Where(
h => h.Name.StartsWith("E") && h.Name.EndsWith("E"));
#else
var q = context.Stores.WhereStartsAndEndsWith(h => h.Name, "E");
#endif
foreach (var storeName in q.Select(s => s.Name).ToList())
{
Console.WriteLine(storeName);
}
}
Console.ReadLine();
}
/// <summary>
///
/// Checks if the Task stil exists and if its not done yet.
/// Then it sends a notification to the responsible person
///
/// </summary>
/// <param name="context"></param>
public void Execute(IJobExecutionContext context)
{
JobDataMap dataMap = context.JobDetail.JobDataMap;
int taskKey = dataMap.GetInt("TaskId");
MyDbContext db = new MyDbContext();
var task = db.ContractTasks.Find(taskKey);
if (task != null && task.IsDone == false)
{
var contract = db.Contracts.Find(task.Contract.Id);
var contractOwner = contract.Owner;
if (contractOwner == null)
{
return;
}
MailUtility.NotifyOnEscalation(task, contractOwner.Email);
System.Diagnostics.Debug.WriteLine("Benachrichtigung ueber Eskalation abgeschickt");
}
}
public static ContractStatus checkContractStatus(Contract contract, MyDbContext db)
{
if(contract.ContractStatus != null)
{
string currentStatus = contract.ContractStatus.Description;
if(currentStatus == "deleted" || currentStatus == "closed")
{
return contract.ContractStatus;
}
if(currentStatus == "repealed")
{
//Not implemented yet
return contract.ContractStatus;
}
}
if (getAbsoluteContractStatus(contract) > 8)
{
return db.ContractStatuses.Where(b => b.Description == "active").FirstOrDefault();
}
return db.ContractStatuses.Where(b => b.Description == "incomplete").FirstOrDefault();
}
public async Task<ActionResult> Customize(RegisterViewModel model)
{
var context = new MyDbContext();
var UserManager = new UserManager<ApplicationUser>(new UserStore<ApplicationUser>(context));
// The default Validators that the UserManager uses are UserValidator and MinimumLengthValidator
// If you want to have complete control over validation then you can write your own validators.
UserManager.UserValidator = new MyUserValidation();
UserManager.PasswordValidator = new MyPasswordValidation();
UserManager.PasswordHasher = new PasswordHasher();
if (ModelState.IsValid)
{
var user = new ApplicationUser() { UserName = model.UserName };
user.HomeTown = model.HomeTown;
var result = await UserManager.CreateAsync(user, model.Password);
if (result.Succeeded)
{
var authManager = HttpContext.GetOwinContext().Authentication;
var claimsIdentity = UserManager.CreateIdentity(user, DefaultAuthenticationTypes.ApplicationCookie);
authManager.SignIn(claimsIdentity);
return RedirectToAction("Index", "Home");
}
else
{
foreach (var error in result.Errors)
{
ModelState.AddModelError("", error);
}
}
}
// If we got this far, something failed, redisplay form
return View("Index",model);
}
//Gets the Dispatchers depend on the Department
public static IQueryable<ContractUser> GetDispatchersFromDepartment(string department, MyDbContext db)
{
/*
var subQuery = from du in db.DU_Relations
where du.Department.DepartmentName.Equals(selection)
select du;
var query = from u in db.Users
join du in subQuery on u.Id equals du.UserID
select u;
var data = new SelectList(query, "Id", "UserName").ToList();
return Json(data);
*/
var subQuery = from dep in db.Departments
where dep.DepartmentName.Equals(department)
select dep;
var query = from u in db.Users
from dep in subQuery
where (
u.Id.Equals(dep.DispatcherId)
|| u.Id.Equals(dep.ViceDispatcherId)
)
select u;
return query;
}
public InvoiceLineRepository(MyDbContext context) : base(context)
{
}
public TestController(IDemoStudentAppService demoStudentAppService, MyDbContext db)
{
this._demoStudentAppService = demoStudentAppService;
this._db = db;
}
public EfDeleteUserCommand(MyDbContext context) : base(context)
{
}
public OrderF()
{
context = new MyDbContext();
}
public KategoriRepository(MyDbContext _db) : base(_db)
{
}
public LogsRepository(MyDbContext context)
{
_context = context;
}
public BrandsController(MyDbContext myDbContext)
{
_myDbContext = myDbContext;
}
public UsersRepo(MyDbContext db)
{
_db = db;
}
public static List <DataGridGamesView> Update(List <DataGridGamesView> AllGames)
{
using (var cnt = new MyDbContext())
{
List <LibraryDataGDBLink> links = LibraryDataGDBLink.GetLibraryData().ToList();
List <DataGridGamesView> q = new List <DataGridGamesView>();
var games = (from g in cnt.Game
where g.hidden != true
select g).ToList();
foreach (var game in games)
{
DataGridGamesView d = new DataGridGamesView();
d.ID = game.gameId;
d.System = GSystem.GetSystemName(game.systemId);
d.LastPlayed = DbEF.FormatDate(game.gameLastPlayed);
d.Favorite = game.isFavorite;
d.Country = game.Country;
if (game.romNameFromDAT != null)
{
if (game.romNameFromDAT.Contains("(USA)"))
{
d.Country = "US";
}
if (game.romNameFromDAT.Contains("(Europe)"))
{
d.Country = "EU";
}
}
d.Flags = game.OtherFlags;
d.Language = game.Language;
d.Publisher = game.Publisher;
d.Year = game.Year;
if (game.gameNameFromDAT != null && game.gameNameFromDAT != "")
{
d.Game = game.gameNameFromDAT;
}
else
{
d.Game = game.gameName;
}
//d.DatName = game.gameNameFromDAT;
d.DatRom = game.romNameFromDAT;
if (game.gdbId != null && game.gdbId > 0)
{
var link = links.Where(x => x.GDBId == game.gdbId).SingleOrDefault(); // LibraryDataGDBLink.GetLibraryData(game.gdbId.Value);
if (link != null)
{
if (link.Publisher != null && link.Publisher != "")
{
d.Publisher = link.Publisher;
}
d.Developer = link.Developer;
if (link.Year != null && link.Year != "")
{
d.Year = DbEF.ReturnYear(link.Year);
}
d.Players = link.Players;
d.Coop = link.Coop;
d.ESRB = link.ESRB;
}
}
q.Add(d);
}
return(q);
//AllGames = ng;
}
}
public TaiKhoanDAO()
{
db = new MyDbContext();
}
public CityRepository(MyDbContext myContext)
{
_myContext = myContext;
}
public TradeRepository(MyDbContext context) : base(context)
{
}
public PlayableController(MyDbContext context, MyHelperService helper)
{
_context = context;
_helper = helper;
}
public MyHelperService(MyDbContext context)
{
_context = context;
}
private void btneliminar_Click(object sender, EventArgs e)
{
if (txtnombre.Text != "")
{
var idCtl = moduloInicio.ObtenerIdControl(iduser); //listado controles del usuario
int i = 0;
while (moduloInicio.Existe("select * from pyme.controls where IdUsuario=" + iduser + ";") && i < idCtl.Count)
{
if (!moduloInicio.Existe("select * from pyme.trabajadorcontrols where Control_IdControl=" + idCtl[i].IdControl + ";"))
{
if (!moduloInicio.Existe("select * from pyme.cursocontrols where Control_IdControl=" + idCtl[i].IdControl + ";"))
{
if (!moduloInicio.Existe("select * from pyme.epicontrols where Control_IdControl=" + idCtl[i].IdControl + ";"))
{
if (!moduloInicio.Existe("select * from pyme.periodocontrols where Control_IdControl=" + idCtl[i].IdControl + ";"))
{
if (!moduloInicio.Existe("select * from pyme.agenda where IdUsuario=" + iduser + ";"))
{
}
else
{
MessageBox.Show("no se puede eliminar, agenda asociada"); return;
}
}
else
{
MessageBox.Show("no se puede eliminar, controles/periodos asociados"); return;
}
}
else
{
MessageBox.Show("no se puede eliminar, controles/epi asociados"); return;
}
}
else
{
MessageBox.Show("no se puede eliminar, controles/curso asociados"); return;
}
}
else
{
MessageBox.Show("no se puede eliminar, controles/trabajador asociados"); return;
}
i++;
}
// eliminar controles de un usuario
moduloInicio.OperarSql("delete from pyme.controls where IdUsuario=" + iduser + ";");
if (MessageBox.Show("Este proceso borra el usuario " + datagridUsuarios.CurrentRow.Cells[1].Value.ToString().ToUpper() + " de la bd, lo quieres hacer S/N", "CUIDADO", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
using (MyDbContext context = new MyDbContext())
{
Usuario usuario = context.Usuarios.Where(x => x.IdUsuario == iduser).FirstOrDefault();
context.Usuarios.Remove(usuario);
context.SaveChanges();
}
Recarga();
}
btnAlta.Enabled = true;
}
else
{
MessageBox.Show("Usuario no seleccionado");
}
}
//Сохранение/Изменение
private void Save_Click(object sender, RoutedEventArgs e)
{
try
{
using (MyDbContext db = new MyDbContext())
{
User thisUser = db.Users.Find(App.CurrentUser.Id);
MedCard test = db.MedCards.FirstOrDefault(p => p.ID == thisUser.Id);
if (Bday_textbox.SelectedDate <= DateTime.Now.Date && Bday_textbox.SelectedDate > DateTime.Now.AddYears(-150).Date)
{
if (test == null)
{
MedCard card = new MedCard();
card.ID = thisUser.Id;
card.Name = Name_textbox.Text;
card.Surname = Surname_textbox.Text;
card.Patronymic = Patronymic_textbox.Text;
card.Gender = Gender.Text;
card.BDay = DateTime.ParseExact(Bday_textbox.Text, "dd.MM.yyyy",
System.Globalization.CultureInfo.InvariantCulture);
card.City = City_textbox.Text;
card.Street = Street_textbox.Text;
card.House = Convert.ToInt32(House_textbox.Text);
card.Housing = Housing.Text;
card.Flat = Flat_textbox.Text;
card.Image = PathImage;
db.MedCards.AddRange(new List <MedCard> {
card
});
db.SaveChanges();
MaterialMessageBox.Show("Сохранение/Изменение прошло успешна", "Уведомление");
}
else
{
db.MedCards.Find(thisUser.Id).Name = Name_textbox.Text.Trim();
db.MedCards.Find(thisUser.Id).Surname = Surname_textbox.Text.Trim();
db.MedCards.Find(thisUser.Id).Patronymic = Patronymic_textbox.Text.Trim();
db.MedCards.Find(thisUser.Id).Gender = Gender.Text.Trim();
db.MedCards.Find(thisUser.Id).BDay = DateTime.ParseExact(Bday_textbox.Text, "dd.MM.yyyy",
System.Globalization.CultureInfo.InvariantCulture);
db.MedCards.Find(thisUser.Id).City = City_textbox.Text.Trim();
db.MedCards.Find(thisUser.Id).Street = Street_textbox.Text.Trim();
db.MedCards.Find(thisUser.Id).House = Convert.ToInt32(House_textbox.Text);
db.MedCards.Find(thisUser.Id).Housing = Housing.Text.Trim();
db.MedCards.Find(thisUser.Id).Flat = Flat_textbox.Text.Trim();
db.MedCards.Find(thisUser.Id).Image = PathImage;
AdMainImage.Source = new BitmapImage(new Uri(PathImage, UriKind.Absolute));
db.SaveChanges();
MaterialMessageBox.Show("Сохранение/Изменение прошло успешна", "Уведомление");
}
}
else
{
MaterialMessageBox.Show("Некорретная дата, попробуйте ещё раз", "Уведомление");
Bday_textbox.Text = "";
}
}
}
catch (Exception ex) { MaterialMessageBox.Show("Упс.. Что-то пошло не так", "Уведомление"); }
}
public BillsItemService(MyDbContext dbContext)
{
DbContext = dbContext;
}
public SkillRepository(MyDbContext myDbContext) : base(myDbContext)
{
}
public BaseService(MyDbContext dbContext)
{
DbContext = dbContext;
}
public NoteRepository(MyDbContext _context)
{
context = _context;
}
/// <summary>
///
/// </summary>
/// <param name="dbcontext"></param>
/// <returns></returns>
public async Task Connect(MyDbContext dbcontext)
{
_DbContext = dbcontext;
await Run();
}
public ProductController(MyDbContext db, IHostingEnvironment env)
{
this.db = db;
this.env = env;
}
public Handler(MyDbContext context)
{
this._context = context;
}
private void btnReport_Click(object sender, EventArgs e)
{
if (rbDetailedHistory.Checked)
{
if (cbReportFor.selectedIndex == 0 || (cbReportFor.selectedIndex == 1 &&
cbPropertyType.selectedIndex > -1 &&
cbProperty.selectedIndex > -1))
{
var dt = new DataTable();
dt.Columns.Add("Customer");
dt.Columns.Add("Price");
dt.Columns.Add("Method");
dt.Columns.Add("Period");
dt.Columns.Add("Start");
dt.Columns.Add("End");
dt.Columns.Add("Property");
// ReSharper disable ConvertIfStatementToSwitchStatement
if (cbReportFor.selectedIndex == 0)
{
var properties = _db.Properties.ToList();
foreach (var property in properties)
{
var contracts = _db.Contracts.Where(c => c.PropertyId == property.Id).ToList();
foreach (var contract in contracts)
{
var customers = _db.Clients.Where(c => c.Id == contract.ClientId).ToList();
foreach (var customer in customers)
{
dt.Rows.Add(customer.Name, contract.Price, contract.Method,
contract.PayEvery + " " + contract.Period,
contract.Start.ToShortDateString(), contract.End.ToShortDateString(),
property.Name);
}
}
}
var rpt = new rptDetailedHistory();
rpt.SetDataSource(dt);
rpt.PrintToPrinter(1, true, 0, 0);
}
else if (cbReportFor.selectedIndex == 1)
{
if (cbProperty.selectedIndex >= 0 || cbPropertyType.selectedIndex >= 0)
{
var propertyId = int.Parse(cbTempProperty.SelectedValue.ToString());
var property = _db.Properties.Find(propertyId);
if (property == null)
{
return;
}
var contracts = _db.Contracts.Where(c => c.PropertyId == property.Id).ToList();
foreach (var contract in contracts)
{
var customers = _db.Clients.Where(c => c.Id == contract.ClientId).ToList();
foreach (var customer in customers)
{
dt.Rows.Add(customer.Name, contract.Price, contract.Method,
contract.PayEvery + " " + contract.Period,
contract.Start.ToShortDateString(), contract.End.ToShortDateString());
}
}
var rpt = new rptDetailedHistory();
rpt.SetDataSource(dt);
rpt.PrintToPrinter(1, true, 0, 0);
}
else
{
MessageBox.Show(@"Please fill all the fields", "", MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
}
}
else
{
MessageBox.Show(@"Please fill all the fields", "", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else if (rbOccupation.Checked)
{
if (cbReportFor2.selectedIndex == 0 || (cbReportFor2.selectedIndex == 1 &&
cbPropertyType2.selectedIndex > -1 &&
cbProperty2.selectedIndex > -1))
{
var dt = new DataTable();
dt.Columns.Add("Property");
dt.Columns.Add("PropertyType");
dt.Columns.Add("Status");
dt.Columns.Add("Client");
dt.Columns.Add("Start");
dt.Columns.Add("End");
dt.Columns.Add("Rate");
if (cbReportFor2.selectedIndex == 0)
{
var properties = _db.Properties.ToList();
foreach (var property in properties)
{
var contract = _db.Contracts.FirstOrDefault(c => c.PropertyId == property.Id);
if (contract != null)
{
var contracts = _db.Contracts.Where(c => c.PropertyId == property.Id).ToList();
foreach (var c in contracts)
{
var client = _db.Clients.Find(c.ClientId);
// ReSharper disable once PossibleNullReferenceException
dt.Rows.Add(property.Name, property.BuildingType.ToString(),
property.Status.ToString(),
client.Name, c.Start.ToShortDateString(), c.End.ToShortDateString(),
c.Price);
}
}
else
{
dt.Rows.Add(property.Name, property.BuildingType.ToString(), property.Status.ToString(),
"", "", "", "");
}
}
var rpt = new rptAllOccupation();
rpt.SetDataSource(dt);
rpt.PrintToPrinter(1, true, 0, 0);
}
else if (cbReportFor2.selectedIndex == 1)
{
var propertyId = int.Parse(cbTempProperty.SelectedValue.ToString());
var property = _db.Properties.Find(propertyId);
if (property == null)
{
return;
}
var contract = _db.Contracts.Where(c => c.PropertyId == property.Id)
.OrderByDescending(c => c.Id).FirstOrDefault();
if (contract != null)
{
var client = _db.Clients.Find(contract.ClientId);
// ReSharper disable once PossibleNullReferenceException
dt.Rows.Add(property.Name, property.BuildingType.ToString(), property.Status.ToString(),
client.Name, contract.Start.ToShortDateString(), contract.End.ToShortDateString(),
contract.Price);
}
else
{
dt.Rows.Add(property.Name, property.BuildingType.ToString(), property.Status.ToString(),
"", "", "", "");
}
var rpt = new rptAllOccupation();
rpt.SetDataSource(dt);
rpt.PrintToPrinter(1, true, 0, 0);
}
}
else
{
MessageBox.Show(@"Please fill all the fields", "", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else if (rbCashFlow.Checked)
{
// ReSharper disable NotAccessedVariable
double collectedTotal = 0;
double notCollectedTotal = 0;
var start = dtpStart.Value;
var end = dtpEnd.Value;
var dt = new DataTable();
dt.Columns.Add("Client");
dt.Columns.Add("Property");
dt.Columns.Add("PaymentDate");
dt.Columns.Add("Amount");
dt.Columns.Add("Status");
dt.Columns.Add("CollectedTotal");
dt.Columns.Add("NotCollectedTotal");
var payments = _db.Payments.Where(p => p.PaymentDate >= start && p.PaymentDate <= end).ToList();
using (var db = new MyDbContext())
{
foreach (var payment in payments)
{
var contract = db.Contracts.Find(payment.ContractId);
if (contract == null)
{
continue;
}
// ReSharper disable PossibleNullReferenceException
var property = db.Properties.Find(contract.PropertyId);
var client = db.Clients.Find(contract.ClientId);
dt.Rows.Add(client.Name, property.Name,
string.IsNullOrWhiteSpace(payment.PaymentDate.ToShortDateString())
? contract.PayDate.ToShortDateString()
: payment.PaymentDate.ToShortDateString(),
payment.PayedAmount.ToString(CultureInfo.InvariantCulture), "Collected");
collectedTotal += payment.PayedAmount;
}
}
if (chbUncollected.Checked)
{
// ReSharper disable once RedundantAssignment
var contractsPending = new List <Contract>();
using (var db = new MyDbContext())
{
contractsPending = db.Contracts.Where(c =>
c.PayStatus.Equals("Pending") && c.PayDate >= start && c.PayDate <= end).ToList();
}
foreach (var contract in contractsPending)
{
using (var db = new MyDbContext())
{
var property = db.Properties.Find(contract.PropertyId);
var client = db.Clients.Find(contract.ClientId);
dt.Rows.Add(client.Name, property.Name, contract.PayDate.ToShortDateString(),
contract.Price.ToString(CultureInfo.InvariantCulture), "Not Collected");
notCollectedTotal += contract.Price;
}
}
}
var rpt = new rptCashFlow();
var textCollectedTotal = (TextObject)rpt.ReportDefinition.ReportObjects["CollectedTotal"];
var textNotCollectedTotal = (TextObject)rpt.ReportDefinition.ReportObjects["NotCollectedTotal"];
textCollectedTotal.Text = collectedTotal.ToString(CultureInfo.InvariantCulture);
textNotCollectedTotal.Text = notCollectedTotal.ToString(CultureInfo.InvariantCulture);
rpt.SetDataSource(dt);
rpt.PrintToPrinter(1, true, 0, 0);
}
}
public ComandValidator(MyDbContext context)
{
RuleFor(x => x.categoryFormVm).SetValidator(new CategoryValidator(context));
}
public ChiTietHdsController(MyDbContext context)
{
_context = context;
}
public LotRepository(MyDbContext db)
{
this.db = db;
}
public UsersController(MyDbContext context)
{
_context = context;
}
public UserService(IOptions <AppSettings> appSettings, MyDbContext context)
{
_appSettings = appSettings.Value;
_context = context;
}
public MonitorBeurtController()
{
db = new MyDbContext();
UserManager = new UserManager<MyUser>(new UserStore<MyUser>(db));
RoleManager = new RoleManager<IdentityRole>(new RoleStore<IdentityRole>(db));
}
public TarifsController(MyDbContext context)
{
_context = context;
}
