public ActionResult CalısanEkle(EmployeeRegister model)
{
if (ModelState.IsValid)
{
var user = new CMUser()
{
UserName = model.UserName,
CompanyId = model.CompanyId,
Email = model.Email,
};
var result = userManager.Create(user, model.Password);
if (result.Succeeded)
{
//kullanıcı başarılı şekilde oluşturulmuş ise login sayfasına gönderebiliriz.
return(RedirectToAction("Login"));
}
else
{
foreach (var error in result.Errors)
{
ModelState.AddModelError("", error);
}
}
}
return(View(model));
}
public List <EmployeeRegister> GetRecordDetails(int Id)
{
List <EmployeeRegister> Record = new List <EmployeeRegister>();
try
{
DataSet ds = new DataSet();
ds.ReadXml(HttpContext.Server.MapPath("~/XML/RecordList.xml"));
DataView dvPrograms;
dvPrograms = ds.Tables[0].DefaultView;
dvPrograms.Sort = "EmpId";
foreach (DataRowView dr in dvPrograms)
{
EmployeeRegister model = new EmployeeRegister();
model.EmpId = Convert.ToInt32(dr[0]);
model.Name = Convert.ToString(dr[1]);
model.Gender = Convert.ToString(dr[2]);
model.Qualification = Convert.ToString(dr[3]);
model.Age = Convert.ToInt32(dr[4]);
model.City = Convert.ToInt32(dr[5]);
model.State = Convert.ToInt32(dr[6]);
model.Email = Convert.ToString(dr[7]);
model.Password = Convert.ToString(dr[8]);
model.ConfirmPassword = Convert.ToString(dr[9]);
model.ProfilePic = Convert.ToString(dr[10]);
Record.Add(model);
}
}
catch (Exception ex)
{
return(Record);
}
return(Record.FindAll(o => o.EmpId.Equals(Id)));
}
/// <summary>
/// Funcion para insertar un nuevo elemento en la tabla historial
/// </summary>
/// <param name="customerLocation">Ubicacion del solicitante</param>
/// <param name="employeeName">Nombre del solicitante</param>
/// <param name="ticketRecord">Nuevo objeto para ser insertado en la base de datos </param>
/// <param name="ticketId">Id del ticket a actualizar</param>
/// <param name="customerEmail">Correo del solicitante</param>
/// <param name="customerExt">Extension del solicitante</param>
/// <param name="customerPhone">Telefono del solicitante</param>
/// <param name="customerArea">Area del solicitante</param>
/// <returns>Success booleano</returns>
public TicketRegisterResult UpdateTicket(long ticketId, string customerEmail, int customerExt,
string customerPhone, string customerArea,
string customerLocation, string employeeName, TK_DT_RECORDS ticketRecord)
{
var result = new TicketRegisterResult();
using (var db = new dbGoldenTicket())
{
if (!ticketRecord.TK_BT_EMPLOYEES_ID.IsNullOrWhiteSpace())
{
var employee = new TK_BT_EMPLOYEES
{
TK_BT_EMPLOYEES_ID = ticketRecord.TK_BT_EMPLOYEES_ID,
FULLNAME = employeeName
};
var employeeAux = new EmployeeRegister();
employeeAux.UpdateEmployee(employee);
}
// Actualizo la informacion de la tabla ticket
var ticket = (
from tblTicket in db.TK_HD_TICKETS
where tblTicket.TK_HD_TICKETS_ID == ticketId
select tblTicket
).SingleOrDefault();
if (ticket != null)
{
ticket.CUSTOMER_EMAIL = customerEmail;
ticket.CUSTOMER_EXTENSION = customerExt;
ticket.CUSTOMER_AREA = customerArea;
ticket.CUSTOMER_PHONE = customerPhone;
ticket.CUSTOMER_LOCATION = customerLocation;
db.SaveChanges();
result.CustomerEmail = ticket.CUSTOMER_EMAIL;
result.CustomerFullName = ticket.CUSTOMER_FULLNAME;
result.FolioNewTicket = ticket.FOLIO;
result.Content = ticket.CONTENT;
result.Title = ticket.TITLE;
result.IdNewTicket = ticket.TK_HD_TICKETS_ID;
ticketRecord.TK_DT_RECORDS_ID = GenerateRecordId(ticketRecord.TK_HD_TICKETS_ID);
db.TK_DT_RECORDS.Add(ticketRecord);
result.Status = ticketRecord.TK_CT_STATUS_ID;
result.Employee = ticketRecord.TK_BT_EMPLOYEES_ID;
result.Note = ticketRecord.NOTE;
db.SaveChanges();
}
result.Success = true;
result.Message = "op_exitosa";
}
return(result);
}
private async void LogOff()
{
ApplicationVM appvm = App.Current.MainWindow.DataContext as ApplicationVM;
using (HttpClient client = new HttpClient())
{
EmployeeRegister er = new EmployeeRegister()
{
RegisterID = 5, EmployeeID = CurrentEmployee.Barcode, From = appvm.From, Untill = DateTime.Now
};
string input = JsonConvert.SerializeObject(er);
HttpResponseMessage response = await client.PostAsync("http://localhost:41983/api/EmployeeRegister", new StringContent(input, Encoding.UTF8, "application/json"));
if (response.IsSuccessStatusCode)
{
string output = await response.Content.ReadAsStringAsync();
Console.WriteLine(Int32.Parse(output));
}
else
{
Console.WriteLine("error: could not save employeeregister");
}
}
appvm.ChangePage(new LoginVM());
}
// GET: RegisterEmployee
public ActionResult Index()
{
List <EmployeeRegister> lstRec = new List <EmployeeRegister>();
DataSet ds = new DataSet();
ds.ReadXml(HttpContext.Server.MapPath("~/XML/RecordList.xml"));
DataView dvPrograms;
if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0 && ds.Tables[0].Rows[0][1] != DBNull.Value)
{
dvPrograms = ds.Tables[0].DefaultView;
dvPrograms.Sort = "EmpId";
foreach (DataRowView dr in dvPrograms)
{
EmployeeRegister model = new EmployeeRegister();
model.EmpId = Convert.ToInt32(dr[0]);
model.Name = Convert.ToString(dr[1]);
model.Gender = Convert.ToString(dr[2]);
model.Qualification = Convert.ToString(dr[3]);
model.Age = Convert.ToInt32(dr[4]);
model.City = Convert.ToInt32(dr[5]);
model.State = Convert.ToInt32(dr[6]);
model.Email = Convert.ToString(dr[7]);
model.Password = Convert.ToString(dr[8]);
model.ConfirmPassword = Convert.ToString(dr[9]);
model.ProfilePic = Convert.ToString(dr[10]);
lstRec.Add(model);
}
}
return(View(lstRec));
}
public ActionResult CalısanEkle(int id)
{
EmployeeRegister register = new EmployeeRegister()
{
CompanyId = id,
Email = "*****@*****.**"
};
//var sender = new MailAddress("*****@*****.**", "Demo test");
//var receiver = new MailAddress("*****@*****.**", "test");
//var password = "******";
//var sub = "CompanyManagment";
//var body = "Please <a href=\"http://localhost:9585/Areas/Admin/Cal%C4%B1sanEkle/3\">login</a>";
//var smtp = new SmtpClient()
//{
// Host = "smtp.gmail.com",
// Port = 587,
// EnableSsl = true,
// DeliveryMethod = SmtpDeliveryMethod.Network,
// UseDefaultCredentials = false,
// Credentials = new NetworkCredential(sender.Address, password)
//};
//using (var message = new MailMessage(sender, receiver)
//{
// Subject = sub,
// Body = body,
//})
//{
// smtp.Send(message);
//}
return(View(register));
}
public static List <EmployeeRegister> GetRegisterEmployee(int RegisterId, IEnumerable <Claim> claims)
{
List <EmployeeRegister> list = new List <EmployeeRegister>();
string sql = "SELECT * FROM Register_Employee WHERE RegisterID=@id";
DbParameter par1 = Database.addParameter("AdminDB", "@id", RegisterId);
try
{ DbDataReader reader = Database.GetData(Database.GetConnection(CreateConnectionString(claims)), sql, par1);
while (reader.Read())
{
EmployeeRegister er = new EmployeeRegister()
{
EmployeeID = long.Parse(reader["EmployeeID"].ToString()),
RegisterID = int.Parse(reader["RegisterID"].ToString()),
From = DateTime.ParseExact(reader["Fromt"].ToString(), "yyyy-MM-dd HH:mm:ss",
System.Globalization.CultureInfo.InvariantCulture),
Untill = DateTime.ParseExact(reader["Untilt"].ToString(), "yyyy-MM-dd HH:mm:ss",
System.Globalization.CultureInfo.InvariantCulture)
};
list.Add(er);
}
return(list); }
catch (Exception)
{
return(null);
}
}
public ActionResult DeleteConfirmed(int id)
{
EmployeeRegister employeeRegister = db.EmployeeRegisters.Find(id);
db.EmployeeRegisters.Remove(employeeRegister);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public void EmployeeRegister_ShouldAddEmployees()
{
var employees = EmployeeFactory.GetEmployeesRecord();
var employeeRegister = new EmployeeRegister();
employeeRegister.AddEmployeesRecord(employees);
Assert.Equal(employees, employeeRegister.GetEmployeesRecord());
}
public void EmployeeRegister_ShouldReadEmployee()
{
var employees = EmployeeFactory.GetEmployeesRecord();
var employeeRegister = new EmployeeRegister();
employeeRegister.AddEmployeesRecord(employees);
Assert.NotEqual(EmployeeFactory.GetEmployeeRecord(), employeeRegister.GetEmployeeRecord(5));
}
static void Main(string[] args)
{
string instructions = "\nVad vill du göra?\nAvsluta: [quit]\nSkriv ut: [print]\nLägg till: [add <förnamn> <efternamn> <lön>]";
string errorMsg = "Felaktig inmatning!";
string prompt = ">";
EmployeeRegister register = new EmployeeRegister();
register.AddDummyEmployees();
Console.WriteLine("Välkommen till personalregistret!");
bool exit = false;
Command command = Command.Undefined;
decimal salary = 0;
string lastName = "";
string firstName = "";
while (!exit)
{
Console.WriteLine(instructions);
Console.Write(prompt);
var inputData = Console.ReadLine();
var isValidInput = TryGetInput(inputData, out command, out firstName, out lastName, out salary);
if (isValidInput)
{
if (command == Command.Print)
{
var employees = register.GetEmployees();
foreach (var employee in employees)
{
Console.WriteLine(string.Format("Namn: {0} {1} Lön: {2} kr", employee.FirstName, employee.LastName, employee.Salary.ToString()));
}
}
else if (command == Command.Add)
{
register.AddEmployee(new Employee(firstName, lastName, salary));
}
else if (command == Command.Quit)
{
exit = true;
}
else
{
Console.WriteLine(errorMsg);
}
}
else
{
Console.WriteLine(errorMsg);
}
}
Console.WriteLine("personalregistret avslutas!");
Console.WriteLine("Hit <return> ...");
Console.ReadLine();
}
public HttpResponseMessage Post(EmployeeRegister er)
{
int id = RegisterDA.InsertEmployeeRegister(er);
HttpResponseMessage message = new HttpResponseMessage(HttpStatusCode.OK);
message.Content = new StringContent(id.ToString());
return(message);
}
public ActionResult Edit([Bind(Include = "EID,FirstName,LastName,FatherName,MotherName,PresentAddress,PermanentAddress,SSC_Year,SSC_Result,SSc_Board,HSC_Year,HSC_Result,HSC_Board,Gradute_University,Passing_Year,Result,Grade,Salary_Scale,Commision_Percentage,Increment,Birth_Date,Gender,Married_or_Unmarried,Blood_Group,Religion,Nationality,Phone_Number,Email")] EmployeeRegister employeeRegister)
{
if (ModelState.IsValid)
{
db.Entry(employeeRegister).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(employeeRegister));
}
public bool insertEmployee(EmployeeRegister inEmp)
{
if (inEmp.FirstName == "")
{
return(false);
}
else
{
return(true);
}
}
// GET: EmployeeRegisters/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
EmployeeRegister employeeRegister = db.EmployeeRegisters.Find(id);
if (employeeRegister == null)
{
return(HttpNotFound());
}
return(View(employeeRegister));
}
public void CreateOrUpdateXML(EmployeeRegister mdl)
{
List <EmployeeRegister> rLists = AllRecords();
bool iSavail = (rLists.Where(rd => rd.EmpId == mdl.EmpId).Any());
if (iSavail)
{
XDocument xmlDoc = XDocument.Load(HttpContext.Server.MapPath("~/XML/RecordList.xml"));
var items = (from item in xmlDoc.Descendants("Employee") select item).ToList();
XElement selected = items.Where(p => p.Element("EmpId").Value == mdl.EmpId.ToString()).FirstOrDefault();
selected.Remove();
xmlDoc.Save(HttpContext.Server.MapPath("~/XML/RecordList.xml"));
xmlDoc.Element("Employees").Add(new XElement("Employee",
new XElement("EmpId", mdl.EmpId),
new XElement("Name", mdl.Name),
new XElement("Gender", mdl.Gender),
new XElement("Qualification", mdl.Qualification),
new XElement("Age", mdl.Age),
new XElement("City", mdl.City),
new XElement("State", mdl.State),
new XElement("Email", mdl.Email),
new XElement("Password", mdl.Password),
new XElement("ConfirmPassword", mdl.ConfirmPassword),
new XElement("ProfilePic", mdl.ProfilePic)
));
xmlDoc.Save(HttpContext.Server.MapPath("~/XML/RecordList.xml"));
}
else
{
XmlDocument oXmlDocument = new XmlDocument();
oXmlDocument.Load(HttpContext.Server.MapPath("~/XML/RecordList.xml"));
XmlNodeList nodelist = oXmlDocument.GetElementsByTagName("Employee");
XDocument xmlDoc = XDocument.Load(HttpContext.Server.MapPath("~/XML/RecordList.xml"));
xmlDoc.Element("Employees").Add(new XElement("Employee",
new XElement("EmpId", mdl.EmpId),
new XElement("Name", mdl.Name),
new XElement("Gender", mdl.Gender),
new XElement("Qualification", mdl.Qualification),
new XElement("Age", mdl.Age),
new XElement("City", mdl.City),
new XElement("State", mdl.State),
new XElement("Email", mdl.Email),
new XElement("Password", mdl.Password),
new XElement("ConfirmPassword", mdl.ConfirmPassword),
new XElement("ProfilePic", mdl.ProfilePic)
));
xmlDoc.Save(HttpContext.Server.MapPath("~/XML/RecordList.xml"));
}
}
public void EmployeeFixture_ShouldUpdateEmployee()
{
var employees = EmployeeFactory.GetEmployeesRecord();
var employeeRegister = new EmployeeRegister();
employeeRegister.AddEmployeesRecord(employees);
var newEmployee = new Employee()
{
EmpId = 5,
EmpName = "emp5",
EmpRole = EmployeeRole.Admin
};
employeeRegister.UpdateEmployeeRecord(newEmployee);
Assert.Equal(newEmployee, employeeRegister.GetEmployeeRecord(5));
}
public ActionResult EmployeeRegister([Bind(Include = "Id,UserId,FirstName,LastName,DateOfBirth,Gender,PhoneNumber,Address,City,State,ZipCode,Email,UserName,Password,ConfirmPassword,SecretQuestions,Answer,RegisterDate")] EmployeeRegister employeeRegister, string UserRole)
{
if (ModelState.IsValid)
{
if (UserRole == "Employee")
{
db.EmployeeRegisters.Add(employeeRegister);
db.SaveChanges();
return(RedirectToAction("EmployeeLogin"));
}
}
else
{
ModelState.AddModelError(" ", "pass the correct user role");
}
return(View());
}
public static int InsertEmployeeRegister(EmployeeRegister er)
{
ConnectionStringSettings con = Database.CreateConnectionString("System.Data.SqlClient", @"MCT-NIELS\DATAMANAGEMENT", DBNAME, DBLOGIN, DBPASS);
string sql = "INSERT INTO Register_Employee VALUES(@RegisterID,@EmployeeID,@From,@Untill)";
DbParameter par1 = Database.addParameter("AdminDB", "@RegisterID", er.RegisterID);
DbParameter par2 = Database.addParameter("AdminDB", "@From", er.From.ToString("yyyy-MM-dd HH:mm:ss"));
DbParameter par3 = Database.addParameter("AdminDB", "@Untill", er.Untill.ToString("yyyy-MM-dd HH:mm:ss"));
DbParameter par4 = Database.addParameter("AdminDB", "@EmployeeID", er.EmployeeID);
try
{
return(Database.InsertData(Database.GetConnection(con), sql, par1, par2, par3, par4));
}
catch (Exception)
{
return(0);
}
}
public ActionResult Register(EmployeeRegister inEmp)
{
if (ModelState.IsValid)
{
var bll = _AdminBll;
if (bll.usernameExist(inEmp.Username))
{
ViewBag.UsernameExist = true;
return(View());
}
if (bll.insertEmployee(inEmp))
{
TempData["NewEmployee"] = true;
return(RedirectToAction("ListEmployee"));
}
}
return(RedirectToAction("Error"));
}
public bool insertEmployee(EmployeeRegister inEmp)
{
using (var db = new WAPPContext())
{
try
{
var newEmp = new Employee_DB();
var newShadow = new Shadow_DB();
string salt = Salt();
var passwordNSalt = inEmp.Password + salt;
byte[] passwordDB = Hash(passwordNSalt);
newEmp.FirstName = inEmp.FirstName;
newEmp.LastName = inEmp.LastName;
newEmp.Address = inEmp.Address;
newEmp.ZipCode = inEmp.ZipCode;
newEmp.EMail = inEmp.EMail;
newEmp.PhoneNumber = inEmp.PhoneNumber;
newShadow.Username = inEmp.Username;
newShadow.Password = passwordDB;
newShadow.Salt = salt;
newEmp.Shadow = newShadow;
var existingZip = db.City.Find(inEmp.ZipCode);
if (existingZip == null)
{
var newCity = new City()
{
ZipCode = inEmp.ZipCode,
CityName = inEmp.City
};
newEmp.City = newCity;
}
db.Employee.Add(newEmp);
db.SaveChanges();
return(true);
}
catch (Exception exception)
{
LogException(exception);
return(false);
}
}
}
public ActionResult WriteToXml(EmployeeRegister oModel, HttpPostedFileBase ProfilePhoto)
{
if (ModelState.IsValid)
{
try
{
if (ProfilePhoto != null)
{
//virtual
string fileName = Path.GetFileNameWithoutExtension(ProfilePhoto.FileName);
string extension = Path.GetExtension(ProfilePhoto.FileName);
var supportedTypes = new[] { ".png", ".jpg", ".jpeg", ".gif", ".tiff" };
if (!supportedTypes.Contains(extension))
{
ModelState.AddModelError("", "Not a valid image file format that you have try to upload.");
}
fileName = fileName + DateTime.Now.ToString("yyMMddssfff") + extension;
oModel.ProfilePic = fileName;
fileName = Path.Combine(Server.MapPath("~/Content/ProfilePhoto/"), fileName);
}
CreateOrUpdateXML(oModel);
return(RedirectToAction("Index"));
}
catch (Exception ex)
{
throw new ApplicationException("Something went wrong in XML Generation:" + ex.Message);
}
}
var stateList = getAllStates();
ViewBag.State = stateList;
return(View());
}
public ActionResult PasswordUpdate(int id, NewPassword newPassword)
{
EmployeeRegister user1 = new EmployeeRegister();
if (!ModelState.IsValid)
{
return(View());
}
else
{
if (newPassword != null)
{
user1 = db.EmployeeRegisters.FirstOrDefault(x => x.UserId == id);
user1.Password = newPassword.Password;
user1.ConfirmPassword = newPassword.ConfirmPassword;
methods.Save(db);
ViewBag.msg = "Password Reset Successfully";
return(View());
}
ModelState.AddModelError("", "Invalid Credentials.");
return(View());
}
}
public void Run()
{
EmployeeRegister register = new EmployeeRegister();
consoleInteraction.ShowWelcome();
bool exit = false;
while (!exit)
{
consoleInteraction.ShowPrompt();
var inputData = consoleInteraction.GetUserInputs();
CommandBase cmd;
if (TryGetCommand(inputData, out cmd))
{
if (cmd is CommandHelp)
{
consoleInteraction.ShowRows(CommandItems.GetSyntaxes());
}
else if (cmd is CommandQuit)
{
exit = true;
}
else if (cmd is CommandAdd)
{
var cmdAdd = cmd as CommandAdd;
register.AddEmployee(new Employee(cmdAdd.FirstName, cmdAdd.LastName, cmdAdd.Salary));
}
else if (cmd is CommandClear)
{
consoleInteraction.ClearScreen();
}
else if (cmd is CommandAddMany)
{
List <Employee> dummys = new List <Employee>()
{
new Employee("Musse", "Pigg", 25000),
new Employee("Kalle", "Anka", 14500.90m),
new Employee("Janne", "Långben", 10000.50m),
};
foreach (var employee in dummys)
{
register.AddEmployee(employee);
}
}
else if (cmd is CommandPrint)
{
var employees = register.GetEmployees();
foreach (var employee in employees)
{
consoleInteraction.ShowRows(new string[] { string.Format("Namn: {0} {1} Lön: {2} kr", employee.FirstName, employee.LastName, employee.Salary.ToString()) });
}
}
else
{
consoleInteraction.ShowFaultyInput();
}
}
}
consoleInteraction.ShowGoodBye();
}
private void btnPersonalhantering_Click(object sender, RoutedEventArgs e)
{
EmployeeRegister employeeRegister = new EmployeeRegister();
employeeRegister.ShowDialog();
}
public bool insertEmployee(EmployeeRegister inEmp)
{
return(_repository.insertEmployee(inEmp));
}
public async Task <ApiResponse <Employee> > RegisterEmployee(EmployeeRegister employee)
{
var response = await _restService.Post <Employee>($"employee", JsonConvert.SerializeObject(employee));
return(response);
}