public void JoinedSubClass_WithAnyProperty()
{
ActiveRecordStarter.Initialize(GetConfigSource(),
typeof(Entity), typeof(CompanyEntity), typeof(PersonEntity), typeof(ManagerEntity));
Recreate();
Entity.DeleteAll();
CompanyEntity.DeleteAll();
PersonEntity.DeleteAll();
ManagerEntity.DeleteAll();
ManagerEntity manager = new ManagerEntity();
manager.Name = "pointy haired";
manager.Save();
PersonEntity person = new PersonEntity();
person.Name = "dilbert";
person.Manager = manager;
person.Save();
PersonEntity[] people = PersonEntity.FindAll();
Assert.AreEqual(1, people.Length);
Assert.IsNotNull(people[0].Manager);
}
public async Task <ActionResult> Post([FromBody] ManagerEntity manager)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
try
{
var result = await _service.Post(manager);
if (result != null)
{
return(Created(new Uri(Url.Link("GetManagerWithId", new { id = result.Id })), result));
}
else
{
return(BadRequest());
}
}
catch (ArgumentException e)
{
return(StatusCode((int)HttpStatusCode.InternalServerError, e.Message));
}
}
public async Task <ManagerEntity> Put(ManagerEntity manager)
{
#region CRM IMPLEMENTATION
var repository2up = await _repository2.UpdateAsync(manager);
if (manager.Crm_START == true)
{
//-----------------------------------------------------------
//New LAUNCH TO CRM MODULE
//Odoo Configuration (Logfile & Conf)
NewconfigurationCRM newconfigurationCRM = new NewconfigurationCRM(manager.Email.ToString(), manager.TAG);
//Image: apeninos / asasaas_odoo:version11.0
//Compose Configuration
NewcomposeCRM newcomposeCRM = new NewcomposeCRM(manager.Email.ToString(),
manager.PORT.ToString(),
"apeninos/asasaas_odoo:version11.0",
manager.TAG);
//New Launch
NewlaunchCRM newlaunchCRM = new NewlaunchCRM(manager.Email.ToString(), manager.TAG);
}
#endregion
return(repository2up);
}
private void AutoManagerAppId()
{
ManagerRepository emp = new ManagerRepository();
ManagerEntity en = new ManagerEntity();
var s = emp.AutoLoadManagerId();
en.ManagerIdGenerate = s;
txtAddId.Text = en.ManagerIdGenerate;
}
public MatchEntity(string id, string name, List <PlayerEntity> houseTeamPlayers, List <PlayerEntity> awayTeamPlayers, ManagerEntity houseTeamManager, ManagerEntity awayTeamManager, RefereeEntity referee, DateTime date)
{
Id = id;
Name = name;
HouseTeamPlayers = houseTeamPlayers;
AwayTeamPlayers = awayTeamPlayers;
HouseTeamManager = houseTeamManager;
AwayTeamManager = awayTeamManager;
Referee = referee;
Date = date;
}
public void Initialize()
{
managerEntity = new ManagerEntity()
{
Id = new Guid("97F201CD-9567-4361-8239-61EA74BBD2CD"),
FirstName = "Dumitru",
LastName = "Mafia",
StartDate = new DateTime(2008, 3, 15),
EndDate = new DateTime(2019, 3, 15),
Salary = 2250
};
}
private void CreateManagers()
{
// Connect to storage.
var account = CloudStorageAccount.Parse(this.ConnectionString);
var tableClient = account.CreateCloudTableClient();
// Create tables.
var table = tableClient.GetTableReference("Manager");
table.Create();
// Create managers.
var managers = new List <Manager>()
{
new Manager()
{
Id = Guid.Parse("d4d97104-217e-4220-b6a7-969fd074ce71"),
Name = "Fred Flintstone",
Email = "*****@*****.**",
Password = PasswordHelper.HashPassword("t2hMtAr37q7e487JPKyqJ2e7yNcJWVDk"),
RegisteredOn = DateTime.UtcNow,
Roles = { "Manager", "Administrator" },
//Teams = { },
VerificationStatus = VerificationStatus.Verified,
VerificationCode = Guid.NewGuid(),
VerificationCodeExpiresOn = DateTime.UtcNow.AddHours(1)
},
new Manager()
{
Id = Guid.Parse("9b2d3334-723a-413d-96c1-06d00be9ce0a"),
Name = "Wilma Flintstone",
Email = "*****@*****.**",
Password = PasswordHelper.HashPassword("5yjdAZ2scFKupyUKFCeE575g7DZ89mvt"),
RegisteredOn = DateTime.UtcNow,
Roles = { },
//Teams = { },
VerificationStatus = VerificationStatus.Pending,
VerificationCode = Guid.NewGuid(),
VerificationCodeExpiresOn = DateTime.UtcNow.AddHours(1)
}
};
// Note that inserts cannot be batched due to varying partition keys.
foreach (var manager in managers)
{
// Create manager.
var entity = new ManagerEntity(manager);
var operation = TableOperation.Insert(entity);
var result = table.Execute(operation);
}
}
public async Task PostManagerEmployeeData(EmployeeEntity employee, ManagerEntity manager)
{
using (var adapter = new DataAccessAdapter()){
//var em=manager.Employees.AddNew();
await adapter.SaveEntityAsync(manager, true);
employee.ManagerId = manager.Id;
Console.WriteLine(manager.Id + " manager.Id");
await adapter.SaveEntityAsync(employee, true);
Console.WriteLine(employee.Id + " employee.Id");
}
}
public bool Save(ManagerEntity er)
{
try
{
string query = "select * from Manager where appid = '" + er.ManagerId + "'";
var dt = DataAccess.GetDataTable(query);
if (dt == null || dt.Rows.Count == 0)
{
query = "Insert into Manager values ('" + er.ManagerId + "','" + er.ManagerName + "','" + er.ManagerAddress + "','" + er.ManagerEmail + "','" + er.ManagerPhone + "','" + er.ManagerGender + "','" + er.ManagerDateOfBirth + "','" + er.ManagerJoiningDate + "','" + er.ManagerMaritalStatus + "','" + er.ManagerBloodGroup + "','" + er.ManagerSalary + "');";
}
else
{
//query = "Update Manager set Name = '" + er.ManagerName + "','" + er.ManagerAddress + "','" + er.ManagerEmail + "','" + er.ManagerPhone + "','" + er.ManagerGender + "','" + er.ManagerDateOfBirth + "','" + er.ManagerJoiningDate + "','" + er.ManagerMaritalStatus + "','" + er.ManagerBloodGroup + "','" + er.ManagerSalary + "' where appid = '" + er.ManagerId + "'";
query = @"update Manager
set Name = '" + er.ManagerName + @"',
Address = " + er.ManagerAddress + @",
Email = " + er.ManagerEmail + @",
Phone = '" + er.ManagerPhone + @"',
Gender = '" + er.ManagerGender + @"'
Date_Of_Birth = '" + er.ManagerDateOfBirth + @"',
Joining_Date = '" + er.ManagerJoiningDate + @"'
Marital_Status = '" + er.ManagerMaritalStatus + @"',
Blood_Group = '" + er.ManagerBloodGroup + @"'
Salary = '" + er.ManagerSalary + @"',
where AppId = '" + er.ManagerId + "';";
}
int count = DataAccess.ExecuteQuery(query);
if (count >= 1)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
return(false);
}
}
public async Task <IActionResult> Create(AddUserViewModel model)
{
if (ModelState.IsValid)
{
var user = new UserEntity
{
FirstName = model.FirstName,
LastName = model.LastName,
Address = model.Address,
Email = model.Username,
UserName = model.Username,
PhoneNumber = model.PhoneNumber
};
var response = await _userHelper.AddUserAsync(user, model.Password);
if (response.Succeeded)
{
var userinDB = await _userHelper.GetUserByEmailAsync(model.Username);
await _userHelper.AddUserToRoleAsync(userinDB, "Admin");
var admin = new ManagerEntity
{
UserEntity = userinDB
};
_context.Managers.Add(admin);
try
{
await _context.SaveChangesAsync();
}
catch (Exception ex)
{
ModelState.AddModelError(string.Empty, ex.Message);
return(RedirectToAction(nameof(Index)));
}
return(RedirectToAction(nameof(Index)));
}
}
return(View(model));
}
public async Task UpdateManagersAndEmployees(ManagerEntity manager, EmployeeEntity employee)
{
using (var adapter = new DataAccessAdapter()){
adapter.StartTransaction(IsolationLevel.ReadCommitted, "FirstTransaction");
try{
manager.IsNew = false;
employee.IsNew = false;
await adapter.SaveEntityAsync(manager);
await adapter.SaveEntityAsync(employee);
adapter.Commit();
}
catch (Exception e) {
adapter.Rollback();
throw new Exception("Transaction rollbacked {0}", e);
}
}
}
public async Task <Manager> CreateManagerAsync(Manager manager)
{
var client = this.StorageAccount.CreateCloudTableClient();
var table = client.GetTableReference("Manager");
// TODO: Provision tables during startup to avoid the runtime overhead of this call.
// TODO: Review service lifetime in dependency injection before settling on approach.
var isCreated = await table.CreateIfNotExistsAsync()
.ConfigureAwait(false);
var entity = new ManagerEntity(manager);
var operation = TableOperation.Insert(entity);
var result = await table.ExecuteAsync(operation)
.ConfigureAwait(false);
var entityCreated = result.Result as ManagerEntity;
var managerCreated = entityCreated.ToManager();
return(managerCreated);
}
public ManagerEntity ConvertToEntity(DataRow row)
{
if (row == null)
{
return(null);
}
var m = new ManagerEntity();
m.ManagerId = row["AppId"].ToString();
m.ManagerName = row["Name"].ToString();
m.ManagerAddress = row["Address"].ToString();
m.ManagerBloodGroup = row["Blood_Group"].ToString();
m.ManagerDateOfBirth = row["Date_Of_Birth"].ToString();
m.ManagerEmail = row["Email"].ToString();
m.ManagerPhone = row["Phone"].ToString();
m.ManagerGender = row["Gender"].ToString();
m.ManagerMaritalStatus = row["Marital_Status"].ToString();
m.ManagerJoiningDate = row["Joining_Date"].ToString();
m.ManagerSalary = row["Salary"].ToString();
return(m);
}
static async Task Main(string[] args)
{
var employee = new EmployeeEntity()
{
Name = "mostafa mohammed"
};
/* coment */
var manager = new ManagerEntity()
{
Name = "sara ahmed",
DepartmentId = 4
};
var repository = new llbl();
await repository.PostManagerEmployeeData(employee, manager);
await repository.GetEmployeesAnManagers();
/*
*
* var employee=new EmployeeEntity(){
* Name="mostafa mohammed"
* };
*
* var manager=new ManagerEntity(){
* Name="sara ahmed",
* DepartmentId=4
* };
*
* var repository=new llbl();
* await repository.PostManagerEmployeeData(employee,manager);
*
* await repository.GetEmployeesAnManagers();
*
*
*/
}
public async Task <IActionResult> Create(AddUserViewModel view)
{
if (ModelState.IsValid)
{
var user = await AddUser(view);
if (user == null)
{
ModelState.AddModelError(string.Empty, "Este mail ya está en uso.");
return(View(view));
}
var manager = new ManagerEntity {
User = user
};
_dataContext.Managers.Add(manager);
await _dataContext.SaveChangesAsync();
var myToken = await _userHelper.GenerateEmailConfirmationTokenAsync(user);
var tokenLink = Url.Action("ConfirmEmail", "Account", new
{
userid = user.Id,
token = myToken
}, protocol: HttpContext.Request.Scheme);
_mailHelper.SendMail(view.Username, "Confirmación de Email", $"<h1>Confirmación de Email</h1>" +
$"Para habilitar el Usuario, " +
$"por favor haga clic en este link:</br></br><a href = \"{tokenLink}\">Confirmar Email</a>");
return(RedirectToAction(nameof(Index)));
}
return(View(view));
}
public void TestCleanup()
{
managerEntity = null;
}
private void BtnSave_Click(object sender, EventArgs e)
{
WaiterEntity w = new WaiterEntity();
WaiterRepository repo = new WaiterRepository();
ManagerEntity m = new ManagerEntity();
ManagerRepository mepo = new ManagerRepository();
AdminRepository arepo = new AdminRepository();
AdminEntity a = new AdminEntity();
if (rbGenderFemale.Checked == true || rbGenderMale.Checked == true)
{
if (cmbPost.Text == "Waiter")
{
if (IsValidToSave())
{
w.WaiterName = txtAddName.Text;
w.WaiterId = txtAddId.Text;
w.WaiterAddress = txtAddAddress.Text;
w.WaiterEmail = txtAddEmail.Text;
w.WaiterPhone = txtAddPhone.Text;
if (rbGenderFemale.Checked == true)
{
w.WaiterGender = "Female";
}
else if (rbGenderMale.Checked == true)
{
w.WaiterGender = "Male";
}
else
{
MessageBox.Show("Please Select A Gender");
}
w.WaiterDateOfBirth = dtDate_Of_Birth.Value.ToString();
w.WaiterJoiningDate = dtJoining_Date.Value.ToString();
w.WaiterMaritalStatus = cmbMaritalStatus.Text;
w.WaiterBloodGroup = cmbBlood_Group.Text;
w.WaiterSalary = txtSalary.Text;
repo.Save(w);
Denied();
clear();
AutoWaiterAppId();
}
else
{
MessageBox.Show("Invalid Fields");
}
}
else if (cmbPost.Text == "Admin")
{
if (IsValidToSave())
{
a.AdminName = txtAddName.Text;
a.AdminId = txtAddId.Text;
a.AdminAddress = txtAddAddress.Text;
a.AdminEmail = txtAddEmail.Text;
a.AdminPhone = txtAddPhone.Text;
if (rbGenderFemale.Checked == true)
{
a.AdminGender = "Female";
}
else if (rbGenderMale.Checked == true)
{
a.AdminGender = "Male";
}
a.AdminDateOfBirth = dtDate_Of_Birth.Value.ToString();
a.AdminJoiningDate = dtJoining_Date.Value.ToString();
m.ManagerMaritalStatus = cmbMaritalStatus.Text;
a.AdminBloodGroup = cmbBlood_Group.Text;
a.AdminSalary = txtSalary.Text;
arepo.Save(a);
//Denied();
clear();
AutoManagerAppId();
}
else
{
MessageBox.Show("Invalid Fiels");
}
}
else if (cmbPost.Text == "Manager")
{
if (IsValidToSave())
{
m.ManagerName = txtAddName.Text;
m.ManagerId = txtAddId.Text;
m.ManagerAddress = txtAddAddress.Text;
m.ManagerEmail = txtAddEmail.Text;
m.ManagerPhone = txtAddPhone.Text;
if (rbGenderFemale.Checked == true)
{
m.ManagerGender = "Female";
}
else if (rbGenderMale.Checked == true)
{
m.ManagerGender = "Male";
}
m.ManagerDateOfBirth = dtDate_Of_Birth.Value.ToString();
m.ManagerJoiningDate = dtJoining_Date.Value.ToString();
m.ManagerMaritalStatus = cmbMaritalStatus.Text;
m.ManagerBloodGroup = cmbBlood_Group.Text;
m.ManagerSalary = txtSalary.Text;
mepo.Save(m);
//Denied();
clear();
AutoAdminAppId();
}
else
{
MessageBox.Show("Invalid Fields");
}
}
else
{
MessageBox.Show("Please Select An Employee Type");
}
}
else
{
MessageBox.Show("Please Select A Gender");
}
}
