protected void Page_Load(object sender, EventArgs e)
{
if (Session["user"] == null)
{
Response.Redirect("Default.aspx");
}
currentEmployer = (Employers)Session["user"];
Session["Id_Job"] = currentEmployer.Id_Employer;
loggedInAsLbl.Text = currentEmployer.UserName;
}
public ActionResult Edit([Bind(Include = "ID_Employers,Name_of_Emp,FK_Rank,Payment,Adress,Phone_Number")] Employers employers)
{
if (ModelState.IsValid)
{
db.Entry(employers).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.FK_Rank = new SelectList(db.Ranks, "ID_Rank", "Rank_name", employers.FK_Rank);
return(View(employers));
}
protected async Task <Employers> CheckEmployerExistenceAsync(long employerId)
{
Employers empl = await EmployersRepo.FindById(employerId);
if (empl == null)
{
throw new Exception(String.Format("Employer with id {0} does not exist", employerId));
}
return(empl);
}
public NewJobViewModel()
{
JobData jobData = JobData.GetInstance();
foreach (Employer field in jobData.Employers.ToList())
{
Employers.Add(new SelectListItem
{
Value = field.ID.ToString(),
Text = field.Value
});
}
foreach (Location field in jobData.Locations.ToList())
{
Locations.Add(new SelectListItem
{
Value = field.ID.ToString(),
Text = field.Value
});
}
foreach (CoreCompetency field in jobData.CoreCompetencies.ToList())
{
CoreCompetencies.Add(new SelectListItem
{
Value = field.ID.ToString(),
Text = field.Value
});
}
foreach (PositionType field in jobData.PositionTypes.ToList())
{
PositionTypes.Add(new SelectListItem
{
Value = field.ID.ToString(),
Text = field.Value
});
}
}
public async Task <IActionResult> Create([Bind("Id,Status,Name,Contacts")] Employers employers)
{
if (ModelState.IsValid)
{
_context.Add(employers);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(employers));
}
public void AddNewEmployer(string n)
{
EmployerObject EO = new EmployerObject();
//EO.OnPropertyChanged("-");
EO.Id = Employers.Count + 1;
EO.FullName = n;
Employers.Add(EO);
SaveEmployers();
}
/// <summary>
/// Gets all the available objects.
/// </summary>
public virtual Employers GetAll()
{
// create a new instance of the return object
Employers objects = new Employers();
// fill the objects
this.Fill(objects);
// return the filled object from the service
return(objects);
}
public async Task <ActionResult> Edit([Bind(Include = "Id,Name,FirstName,SurName,IIdent,EnterprisesId,PostsId")] Employers employers)
{
if (ModelState.IsValid)
{
db.Entry(employers).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
ViewBag.EnterprisesId = new SelectList(db.Enterprises, "Id", "Name", employers.EnterprisesId);
ViewBag.PostsId = new SelectList(db.Posts, "Id", "Name", employers.PostsId);
return(View(employers));
}
public ActionResult ShowEmployersList()
{
//CrMVCApp.Models.Customer c;
var c = (from b in db.EmployersLists select b).ToList();
Employers rpt = new Employers();
rpt.Load();
rpt.SetDataSource(c);
Stream s = rpt.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
return(File(s, "application/pdf"));
}
//List<int> empsourse = new List<int>();
public EmployeerInfo(Employers emp)
{
InitializeComponent();
WorkingStation.Text = "Дата начала работы: " + emp.WorkDate;
Post.Text = "Занимаемая должность: " + emp.EmployersPost.PostName;
FullNameBox.Text = "Полное имя: " + emp.FullName;
PassportBox.Text = "Паспортные данные: " + emp.Passport;
BirthdayDate.Text = "Дата рождения: " + emp.BirthDate;
INN.Text = "ИНН: " + emp.INN;
SNILS.Text = "Страховой полис: " + emp.SNILS;
Gender.Text = "Пол: " + emp.Gender1.GenderName;
Age.Text = "Возраст: " + emp.Age;
employeers = emp;
}
// GET: Employers/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Employers employers = db.Employers.Find(id);
if (employers == null)
{
return(HttpNotFound());
}
return(View(employers));
}
// GET: Guides/Employers/Details/5
public async Task <ActionResult> Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Employers employers = await db.Employers.FindAsync(id);
if (employers == null)
{
return(HttpNotFound());
}
return(View(employers));
}
public Employers Update(int id, Employers employers)
{
// TODO: error handler (id not found)
var entity = _context.Employers.Find(id);
entity.Name = employers.Name;
entity.WorkedAt = employers.WorkedAt;
entity.Group = employers.Group;
entity.BossesId = employers.BossesId;
_context.SaveChanges();
return(entity);
}
// GET: Employers/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Employers employers = db.Employers.Find(id);
if (employers == null)
{
return(HttpNotFound());
}
ViewBag.FK_Rank = new SelectList(db.Ranks, "ID_Rank", "Rank_name", employers.FK_Rank);
return(View(employers));
}
public void RemoveEmployer()
{
List <EmployerObject> ArchivedEmployers = manager.LoadEmployersArchive();
Employers.Remove(Employer);
ArchivedEmployers.Add(Employer);
// CARDS DISPOSING
/*foreach (CardObject CO in Employer.Cards)
* Cards.Remove(CO);*/
Employer = null;
SaveEmployers();
SaveEmployerArchive();
}
public NewJobViewModel()
{
JobData jobData = JobData.GetInstance();
foreach (Employer field in jobData.Employers.ToList())
{
Employers.Add(new SelectListItem {
Value = field.ID.ToString(),
Text = field.Value
});
}
// TODO #4 - populate the other List<SelectListItem>
// collections needed in the view
}
public NewJobViewModel()
{
JobData jobData = JobData.GetInstance();
foreach (Employer field in jobData.Employers.ToList())
{
Employers.Add(new SelectListItem
{
Value = field.ID.ToString(),
Text = field.Value
});
}
foreach (Location field in jobData.Locations.ToList())
{
Locations.Add(new SelectListItem
{
Value = field.ID.ToString(),
Text = field.Value
});
}
foreach (CoreCompetency field in jobData.CoreCompetencies.ToList())
{
CoreCompetencies.Add(new SelectListItem
{
Value = field.ID.ToString(),
Text = field.Value
});
}
foreach (PositionType field in jobData.PositionTypes.ToList())
{
PositionTypes.Add(new SelectListItem
{
Value = field.ID.ToString(),
Text = field.Value
});
}
foreach (Employer field in jobData.Employers.ToList())
{
Employers.Add(new SelectListItem
{
Value = field.ID.ToString(),
Text = field.Value
});
}
// TODO #4 - populate the other List<SelectListItem>
// collections needed in the view
}
// GET: Guides/Employers/Edit/5
public async Task <ActionResult> Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Employers employers = await db.Employers.FindAsync(id);
if (employers == null)
{
return(HttpNotFound());
}
ViewBag.EnterprisesId = new SelectList(db.Enterprises, "Id", "Name", employers.EnterprisesId);
ViewBag.PostsId = new SelectList(db.Posts, "Id", "Name", employers.PostsId);
return(View(employers));
}
private void EnterButton_Click(object sender, RoutedEventArgs e)
{
Employers updEmployers = (from emp in _db.Employers
where emp.ID == id
select emp).Single();
updEmployers.FullName = FullNameTextBox.Text;
updEmployers.Sex = SexComboBox.Text;
updEmployers.Salary = Convert.ToInt32(SalaryTextBox.Text);
updEmployers.Birthday = Convert.ToDateTime(BirthdayDatePicker.Text);
updEmployers.EmpAddress = AddressTextBox.Text;
updEmployers.EmpProfession = ProfessionComboBox.Text;
_db.SaveChanges();
MenuWindow.empDataGrid.ItemsSource = _db.Employers.ToList();
this.NavigationService.GoBack();
}
static void Main(string[] args)
{
List <Employers> listEmplyes = new List <Employers>();
Console.WriteLine("How many employees will be registred?");
var numberEmployes = int.Parse(Console.ReadLine());
while (listEmplyes.Count < numberEmployes)
{
Console.WriteLine($"Employee #{ listEmplyes.Count + 1 } :");
Console.Write("Id: ");
var id = int.Parse(Console.ReadLine());
Console.Write("Name: ");
var name = Console.ReadLine();
Console.Write("Salary: ");
var salary = double.Parse(Console.ReadLine());
listEmplyes.Add(new Employers(id, salary, name));
}
Console.WriteLine("Enter the employee id that will have salary increase: ");
var searchId = int.Parse(Console.ReadLine());
Employers valideId = listEmplyes.Find(e => e.Id == searchId);
if (valideId != null)
{
Console.WriteLine("Enter the percentage: ");
var percentage = double.Parse(Console.ReadLine());
valideId.IncreaseSalary(percentage);
}
else
{
Console.WriteLine("This id does not exist!");
}
Console.WriteLine("Updated list of employees:");
foreach (var obj in listEmplyes)
{
Console.WriteLine(obj.ToString());
}
}
private ObservableCollection <EmployerOrder> GetOrdersContext()
{
ObservableCollection <EmployerOrder> OC = new ObservableCollection <EmployerOrder>();
var orderList = context.OrdersTable.ToList();
foreach (OrdersTable OT in orderList)
{
EmployerOrder EO = new EmployerOrder()
{
Id = OT.Номер,
Name = OT.Название_товара,
Employer = Employers.Single(e => e.Id == OT.Сотрудник_ID)
};
OC.Add(EO);
}
return(OC);
}
private void EnterButton_Click(object sender, RoutedEventArgs e)
{
Employers newEmp = new Employers()
{
FullName = FullNameTextBox.Text,
Sex = SexComboBox.Text,
Salary = Convert.ToInt32(SalaryTextBox.Text),
Birthday = Convert.ToDateTime(BirthdayDatePicker.Text),
EmpAddress = AddressTextBox.Text,
EmpProfession = ProfessionComboBox.Text
};
_db.Employers.Add(newEmp);
_db.SaveChanges();
MenuWindow.empDataGrid.ItemsSource = _db.Employers.ToList();
this.NavigationService.GoBack();
}
public async Task <EmployersRestaurants> AddCoownerAsync(long ownerId, long restaurantId, long coownerId)
{
CheckTheLoggedInPerson();
EmployersRestaurants currentConnection = await CheckEmployerRestaurantAsync(ownerId, restaurantId);
Employers newEmployer = await CheckEmployerExistenceAsync(coownerId);
EmployersRestaurants item = new EmployersRestaurants
{
EmployerId = newEmployer.Id,
RestaurantId = currentConnection.TheRestaurant.Id
};
await EmployerRestaurantRepo.AddAsync(item, ModifierId);
return(item);
}
/// <summary>
/// The object factory for a particular data collection instance.
/// </summary>
public virtual void CreateObjectsFromData(Employers employers, System.Data.SqlClient.SqlDataReader data)
{
// Do nothing if we have nothing
if (data == null) return;
// Create a local variable for the new instance.
Employer newobj = null;
// Iterate through the data reader
while (data.Read())
{
// Create a new object instance
newobj = System.Activator.CreateInstance(employers.ContainsType[0]) as Employer;
// Let the instance set its own members
newobj.SetMembers(ref data);
// Add the new object to the collection instance
employers.Add(newobj);
}
}
/// <summary>
///
/// </summary>
/// <param name="employerVM"></param>
/// <returns></returns>
public async Task <EmployerViewModel> CreateEmployerAsync(EmployerViewModel employerVM)
{
employers = new Employers
{
CompanyName = employerVM.CompanyName,
Location = employerVM.Location,
MobileNo = employerVM.MobileNo,
AddressList = employerVM.AddressList,
AuthID = employerVM.AuthID,
CompanyContact = employerVM.CompanyContact,
IndustryList = employerVM.IndustryList,
RegistrationNo = employerVM.RegistrationNo
};
await _db.Employers.InsertOneAsync(employers);
return(GetEmployerByID(employers._id));
}
public Employer GetEmployer(string identifier)
{
if (identifier == null)
{
return(Employer);
}
var employer = Employers.SingleOrDefault(x => x.Identifier == identifier);
if (employer == null)
{
employer = GenerateEmployer().Generate(1).First();
employer.Identifier = identifier;
Employers.Add(employer);
}
return(employer);
}
public NewJobViewModel()
{
JobData jobData = JobData.GetInstance();
foreach (Employer field in jobData.Employers.ToList())
{
Employers.Add(new SelectListItem
{
Value = field.ID.ToString(),
Text = field.Value
});
}
//List <Select * Refer_to
// TODO #4 CHECK - populate the other List<SelectListItem>
// collections needed in the view
//copied the employer one just replaced Employer or Employers with whichever field Uses another method in the jobdata file to make a list of all the options
foreach (Location field in jobData.Locations.ToList())
{
Locations.Add(new SelectListItem
{
Value = field.ID.ToString(),
Text = field.Value
});
}
foreach (CoreCompetency field in jobData.CoreCompetencies.ToList())
{
CoreCompetencies.Add(new SelectListItem
{
Value = field.ID.ToString(),
Text = field.Value
});
}
foreach (PositionType field in jobData.PositionTypes.ToList())
{
PositionTypes.Add(new SelectListItem
{
Value = field.ID.ToString(),
Text = field.Value
});
}
}
/// <summary>
/// Fill method for populating a collection by BORROWER
/// </summary>
public void FillByBorrower(Employers employers, System.Int64 id)
{
// create the connection to use
SqlConnection cnn = new SqlConnection(Employer.GetConnectionString());
try
{
// discover the sql parameters
SqlParameterHash sqlparams = SqlHelperParameterCache.GetSpParameterSet(Employer.GetConnectionString(), "gsp_SelectEmployersByBorrower");
using (cnn)
{
// open the connection
cnn.Open();
// set the parameters
sqlparams["@borrowerId"].Value = id;
// create an instance of the reader to fill.
SqlDataReader datareader = SqlHelper.ExecuteReader(cnn, "gsp_SelectEmployersByBorrower", sqlparams);
// Send the collection and data to the object factory.
CreateObjectsFromData(employers, datareader);
// close the connection
cnn.Close();
}
// nullify the connection
cnn = null;
}
catch (SqlException sqlex)
{
throw sqlex;
}
}
private bool updateCurrentEmployee(Employers employer)
{
var currentEmployer = _dbContext.Employers.Where(x => x.Id == employer.Id).FirstOrDefault();
var currentEmployerProperties = currentEmployer.GetType().GetProperties();
foreach (System.Reflection.PropertyInfo propertyInfo in currentEmployerProperties)
{
if (!(employer.GetType().GetProperty(propertyInfo.Name).GetValue(employer, null).ToString() == currentEmployer.GetType().GetProperty(propertyInfo.Name).GetValue(currentEmployer, null).ToString()))
{
currentEmployer.GetType().GetProperty(propertyInfo.Name).SetValue(currentEmployer, employer.GetType().GetProperty(propertyInfo.Name).GetValue(employer, null));
}
// do stuff here
}
if (_dbContext.ChangeTracker.HasChanges())
{
_dbContext.SaveChangesAsync();
}
return(true);
}
protected void btSave_Click(object sender, EventArgs e)
{
Employers emp = new Employers();
emp.EmpName = txtName.Text;
bool gender = true;
if (DropDownList1.SelectedValue=="FeMale")
{
gender = false;
}
emp.EmpGender = gender;
emp.EmpMail = txtMail.Text;
emp.EmpOffice = txtOffice.Text;
emp.EmpQualification = txtQualification.Text;
emp.EmpRoleId = DropDownList2.SelectedIndex;
int k=EmployerBLL.UpdateEmployer(emp);
if(k>0){
Response.Write("<script>alert('Update successful')</script>");
}
}
//public List<SelectListItem> FirstName { get; set; } = new List<SelectListItem>();
//public List<SelectListItem> LastName { get; set; } = new List<SelectListItem>();
public NewJobViewModel()
{
JobData jobData = JobData.GetInstance();
foreach (Employer field in jobData.Employers.ToList())
{
Employers.Add(new SelectListItem {
Value = field.ID.ToString(),
Text = field.Value
});
}
foreach (Location field in jobData.Employers.ToList())
{
} Locations.Add(new SelectListItem {
Value = field.ID.ToString(),
Text = field.Value
});
}
public NewJobViewModel()
{
JobData jobData = JobData.GetInstance();
foreach (Employer employer in jobData.Employers.ToList())
{
Employers.Add(new SelectListItem {
Value = employer.ID.ToString(),
Text = employer.Value
});
}
// TODO #4 - populate the other List<SelectListItem>
// collections needed in the view
foreach (Location location in jobData.Locations.ToList())
{
Locations.Add(new SelectListItem
{
Value = location.ID.ToString(),
Text = location.Value
});
}
foreach (CoreCompetency coreCompetency in jobData.CoreCompetencies.ToList())
{
CoreCompetencies.Add(new SelectListItem
{
Value = coreCompetency.ID.ToString(),
Text = coreCompetency.Value
});
}
foreach (PositionType positionType in jobData.PositionTypes.ToList())
{
PositionTypes.Add(new SelectListItem
{
Value = positionType.ID.ToString(),
Text = positionType.Value
});
}
}
public void Put([FromBody] Employers employer)
{
var currentEmployer = _dbContext.Employers.Where(x => x.Id == employer.Id).FirstOrDefault();
//ActionResult
if (currentEmployer != null)
{
updateCurrentEmployee(employer);
_logger.LogInformation("employer [0] was updated", employer.Id);
}
else
{
_dbContext.Employers.Add(employer);
_logger.LogInformation("employer [0] was added", employer.Id);
}
if (_dbContext.ChangeTracker.HasChanges())
{
_dbContext.SaveChanges();
}
//return System.Web.Helpers.Json(data, JsonRequestBehavior.AllowGet);
}
protected void Button1_Click(object sender, EventArgs e)
{
Employers[] temp = EmployerBLL.GetAll();
Employers emp = new Employers();
emp.EmpUserName = TextBox1.Text;
emp.EmpPassword = TextBox2.Text;
emp.EmpName = TextBox3.Text;
emp.EmpGender = true;
if (RadioButton2.Checked)
{
emp.EmpGender = false;
}
emp.EmpDOB = Calendar1.SelectedDate;
emp.EmpMail = TextBox4.Text;
emp.EmpOffice = TextBox5.Text;
emp.EmpAddress = TextBox6.Text;
emp.EmpQualification = TextBox7.Text;
emp.EmpRoleId = DropDownListRole.SelectedIndex;
int k = 0;
for (int i = 0;i<temp.Length ;i++ )
{
if (temp[i].EmpUserName.Equals(emp.EmpUserName) | temp[i].EmpUserName.Contains(emp.EmpUserName))
{
Label9.Text = "User name was used";
k = 1;
break;
}
}
if (k==1)
{
reset();
}
if (k!=1)
{
EmployerBLL.AddEmployee(emp);
Label9.Text = "";
Response.Write("<script>alert('Add employer successfully')</script>");
reset();
}
}
protected void SubmitRegEmployerBtn_OnServerClick(object sender, EventArgs e)
{
if (RegPasswordEmployer.Value == RegPasswordRptEmployer.Value)
{
WrongPwLblEmployer.Visible = false;
Employers emp = new Employers(){
UserName = RegEmailEmployer.Value,
Password = RegPasswordEmployer.Value
};
LuffarJobbDBEntities db = new LuffarJobbDBEntities();
db.Employers.Add(emp);
db.SaveChanges();
ConfirmationLblEmployer.Visible = true;
Session["user"] = emp;
Response.Redirect("Emp_AddJob.aspx");
}
else if (RegPasswordEmployer.Value != RegPasswordRptEmployer.Value) WrongPwLblEmployer.Visible = true;
}
protected void btnLogin_Click(object sender, EventArgs e)
{
if (txtUsername.Text =="" && txtPassword.Text == "")
{
Response.Write("<script>alert('Please enter the Username and Password')</script>");
}
else
{
Admin adm = new Admin();
adm = AdminBLL.Get2Login(txtUsername.Text, txtPassword.Text);
Employers emp = new Employers();
emp = EmployerBLL.Get2login(txtUsername.Text, txtPassword.Text);
if (adm != null) {
Session.Add("admin", adm);
Response.Redirect("ManageEmployer.aspx");
}
if(emp!=null){
Session.Add("employer",emp);
Response.Redirect("Booking.aspx");
}
}
}
/// <summary>
/// The object factory for a particular data collection instance.
/// </summary>
public virtual void CreateObjectsFromData(Employers employers, System.Data.DataSet data)
{
// Do nothing if we have nothing
if (data == null || data.Tables.Count == 0 || data.Tables[0].Rows.Count == 0) return;
// Create a local variable for the new instance.
Employer newobj = null;
// Create a local variable for the data row instance.
System.Data.DataRow dr = null;
// Iterate through the table rows
for (int i = 0; i<data.Tables[0].Rows.Count; i++)
{
// Get a reference to the data row
dr = data.Tables[0].Rows[i];
// Create a new object instance
newobj = System.Activator.CreateInstance(employers.ContainsType[0]) as Employer;
// Let the instance set its own members
newobj.SetMembers(ref dr);
// Add the new object to the collection instance
employers.Add(newobj);
}
}
/// <summary>
/// Gets all the available objects.
/// </summary>
public virtual Employers GetAll()
{
// create a new instance of the return object
Employers objects = new Employers();
// fill the objects
this.Fill(objects);
// return the filled object from the service
return objects;
}
/// <summary>
/// Fill method for populating an entire collection of Employers
/// </summary>
public virtual void Fill(Employers employers)
{
// create the connection to use
SqlConnection cnn = new SqlConnection(Employer.GetConnectionString());
try
{
using (cnn)
{
// open the connection
cnn.Open();
// create an instance of the reader to fill.
SqlDataReader datareader = SqlHelper.ExecuteReader(cnn, "gsp_SelectEmployers");
// Send the collection and data to the object factory
CreateObjectsFromData(employers, datareader);
// close the connection
cnn.Close();
}
// nullify the connection
cnn = null;
}
catch (SqlException sqlex)
{
throw sqlex;
}
}
/// <summary>
/// Fill method for populating a collection by BORROWER
/// </summary>
public void FillByBorrower(Employers employers, System.Int64 id)
{
// create the connection to use
SqlConnection cnn = new SqlConnection(Employer.GetConnectionString());
try
{
// discover the sql parameters
SqlParameterHash sqlparams = SqlHelperParameterCache.GetSpParameterSet(Employer.GetConnectionString(), "gsp_SelectEmployersByBorrower");
using (cnn)
{
// open the connection
cnn.Open();
// set the parameters
sqlparams["@borrowerId"].Value = id;
// create an instance of the reader to fill.
SqlDataReader datareader = SqlHelper.ExecuteReader(cnn, "gsp_SelectEmployersByBorrower", sqlparams);
// Send the collection and data to the object factory.
CreateObjectsFromData(employers, datareader);
// close the connection
cnn.Close();
}
// nullify the connection
cnn = null;
}
catch (SqlException sqlex)
{
throw sqlex;
}
}
/// <summary>
/// Gets the objects for the EMPLOYER relationship.
/// </summary>
public Employers GetEmployers()
{
Employers employers = new Employers();
EmployerBase.ServiceObject.FillByBorrower(employers, _id);
return employers;
}
