//public long EmployeeSqlConnection(EmployeeDetailsModel EmployeeDetailsmodel)
//{
// SqlConnection mysqlconnection = new SqlConnection();
// mysqlconnection.ConnectionString = "Data Source = DESKTOP-6T65F42;" +
// "database = PioneerTechConsultancy_Database;Integrated security = SSPI";
// mysqlconnection.Open();
// SqlCommand EmployeeDetailCommand = new SqlCommand("INSERT INTO EmployeeDetail VALUES(" +
// "'" + EmployeeDetailsmodel.FirstName + "','" + EmployeeDetailsmodel.LastName + "','" + EmployeeDetailsmodel.EmailId + "'," +
// EmployeeDetailsmodel.PhoneNumber + "," + EmployeeDetailsmodel.AlternatePhoneNumber + ",'" + EmployeeDetailsmodel.Address1 + "','" + EmployeeDetailsmodel.Address2 +
// "','" + EmployeeDetailsmodel.HomeCountry + "','" + EmployeeDetailsmodel.CurrentCountry + "'," + EmployeeDetailsmodel.ZipCode + ")", mysqlconnection);
// long EmployeeConnection = EmployeeDetailCommand.ExecuteNonQuery();
// mysqlconnection.Close();
// return EmployeeConnection;
//}
public long SaveEmployeeSqlConnection(EmployeeDetailsModel employeeDetail)
{
SqlConnection mysqlconnection = new SqlConnection();
mysqlconnection.ConnectionString = "Data Source = DESKTOP-6T65F42;" +
"database = PioneerTechConsultancy_Database;Integrated security = SSPI";
mysqlconnection.Open();
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.Connection = mysqlconnection;
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.CommandText = "uspSaveEmployeeDetails";
sqlCommand.Parameters.Add("@FirstName", SqlDbType.VarChar).Value = employeeDetail.FirstName;
sqlCommand.Parameters.Add("@LastName", SqlDbType.VarChar).Value = employeeDetail.LastName;
sqlCommand.Parameters.Add("@Email", SqlDbType.VarChar).Value = employeeDetail.EmailId;
sqlCommand.Parameters.Add("@ContactNumber", SqlDbType.VarChar).Value = employeeDetail.PhoneNumber;
sqlCommand.Parameters.Add("@AlternateContactNumber", SqlDbType.VarChar).Value = employeeDetail.AlternatePhoneNumber;
sqlCommand.Parameters.Add("@Address", SqlDbType.VarChar).Value = employeeDetail.Address1;
sqlCommand.Parameters.Add("@AlternateAddress", SqlDbType.VarChar).Value = employeeDetail.Address2;
sqlCommand.Parameters.Add("@CurrentCountry", SqlDbType.VarChar).Value = employeeDetail.HomeCountry;
sqlCommand.Parameters.Add("@HomeCountry", SqlDbType.VarChar).Value = employeeDetail.CurrentCountry;
sqlCommand.Parameters.Add("@ZipCode", SqlDbType.VarChar).Value = employeeDetail.ZipCode;
long returnValue = sqlCommand.ExecuteNonQuery();
sqlCommand.Dispose();
mysqlconnection.Close();
return(returnValue);
}
protected void SaveButton_Click(object sender, EventArgs e)
{
try
{
EmployeeDetailsModel employee = new EmployeeDetailsModel()
{
First_Name = First_NameTextBox.Text,
Last_Name = Last_NameTextBox.Text,
Email = EmailTextBox.Text,
Mobile_Number = Mobile_NumberTextBox.Text,
AlternateMobileNumber = AlternateMobileNumberTextBox.Text,
Address1 = Address1TextBox.Text,
Address2 = Address2TextBox.Text,
Current_Country = Current_CountryTextBox.Text,
Home_Country = Home_CountryTextBox.Text,
ZipCode = Convert.ToInt64(ZipCodeTextBox.Text),
};
EmployeeDataAccess employeedata = new EmployeeDataAccess();
string emdata = employeedata.SaveEmployee(employee);
if (emdata.Equals("success"))
{
Response.Write("<script>alert('Details have been saved successfully!');</script>");
}
}
catch (Exception ex)
{
//MessageBox.Show("Please enter the values: " +ex.Message);
Response.Write("<script>alert('Please enter the values!" + ex.Message + "');</script>");
}
}
public EmployeeDetailsModel GetEmployeeDatailsForDashboard(int EmpId, int year)
{
try
{
var userData = user.GetUserDetails(EmpId);
var announcements = user.GetAnnouncements();
var leaveReportDetails = user.GetLeaveReportDetails(EmpId, year);
var VerifiedUser = new EmployeeDetailsModel();
VerifiedUser.leaveDetails = leaveReportDetails;
foreach (var item in announcements)
{
LMS_WebAPI_Domain.Announcement announceItem = new LMS_WebAPI_Domain.Announcement();
announceItem.ImagePath = item.ImagePath;
announceItem.CarouselContent = item.CarouselContent;
announceItem.Title = item.Title;
announceItem.Id = item.Id;
VerifiedUser.Announcements.Add(announceItem);
}
if (null != userData)
{
VerifiedUser.RoleName = userData.RoleName;
VerifiedUser.TotalCountTaken = userData.TotalCountTaken;
VerifiedUser.TotalLeaveCount = userData.TotalLeaveCount;
VerifiedUser.ManagerName = userData.ManagerName;
VerifiedUser.ProjectName = userData.ProjectName;
VerifiedUser.DateOfJoining = Convert.ToDateTime(userData.DateOfJoining);
}
return(VerifiedUser);
}
catch (Exception ex)
{
throw ex;
}
}
protected void Save_Click(object sender, EventArgs e)
{
EmployeeDetailsModel employeeDetailobj = new EmployeeDetailsModel
{
FirstName = FirstNameTextBox.Text,
LastName = LastNameTextBox.Text,
EmailId = EmailIDTextBox3.Text,
PhoneNumber = Convert.ToInt64(MobileNumberTextBox.Text),
AlternatePhoneNumber = Convert.ToInt64(AlternateMobileNumberTextBox.Text),
Address1 = Address1TextBox.Text,
Address2 = Address2TextBox.Text,
HomeCountry = HomeCountryTextBox.Text,
CurrentCountry = CurrentCountryTextBox.Text,
ZipCode = Convert.ToInt64(ZipCodeTextBox.Text)
};
EmployeeDataAccessLayer employeeDataAccessobj = new EmployeeDataAccessLayer();
long RowsAffected = employeeDataAccessobj.SaveEmployeeSqlConnection(employeeDetailobj);
if (RowsAffected > 0)
{
string display = "Successful!";
ClientScript.RegisterStartupScript(this.GetType(), "Operation was", "alert('" + display + "');", true);
}
else
{
string display = "UnSuccessful!";
ClientScript.RegisterStartupScript(this.GetType(), "Operation was", "alert('" + display + "');", true);
}
}
protected void EditButton_Click(object sender, EventArgs e)
{
EmployeeDetailsModel model = new EmployeeDetailsModel
{
FirstName = FirstNameTextBox.Text,
LastName = LastNameTextBox.Text,
EmailId = EmailIDTextBox3.Text,
PhoneNumber = Convert.ToInt64(MobileNumberTextBox.Text),
AlternatePhoneNumber = Convert.ToInt64(AlternateMobileNumberTextBox.Text),
Address1 = Address1TextBox.Text,
Address2 = Address2TextBox.Text,
HomeCountry = HomeCountryTextBox.Text,
CurrentCountry = CurrentCountryTextBox.Text,
ZipCode = Convert.ToInt64(ZipCodeTextBox.Text)
};
long EditEmployeeId = Convert.ToInt32(EmployeeIdDropDownList1.Text);
SqlConnection mysqlconnection = new SqlConnection();
mysqlconnection.ConnectionString = "Data Source = DESKTOP-6T65F42;" +
"database = PioneerTechConsultancy_Database;Integrated security = SSPI";
SqlCommand employeeDetail_cmd = new SqlCommand("UPDATE [EmployeeDetail] SET[FirstName] = " +
"'" + model.FirstName + "',[LastName] = '" + model.LastName + "',[Email] = '" + model.EmailId + "',[ContactNumber] = " + model.PhoneNumber + ",[AlternateContactNumber] = " + model.AlternatePhoneNumber + ",[Address] ='" + model.Address1 + "',[AlternateAddress] ='" + model.Address2 + "',[CurrentCountry] ='" + model.CurrentCountry + "',[HomeCountry] ='" + model.HomeCountry + "',[ZipCode] = " + model.ZipCode +
" WHERE EmployeeID = " + EditEmployeeId, mysqlconnection);
mysqlconnection.Open();
long result = employeeDetail_cmd.ExecuteNonQuery();
ClientScript.RegisterStartupScript(this.GetType(), "Operation was", "alert(' Employee Details SUCCESSFULLY Edited');", true);
}
public int SaveEmployee(EmployeeDetailsModel employee)
{
int result = 0;
try
{
string connectionstring = "Data Source=RAKI;Initial Catalog=PioneerEmployeeDB;" + "Integrated Security=True";
SqlConnection mysqlconnection = new SqlConnection(connectionstring);
mysqlconnection.Open();
string sqlemployeedetails = @"INSERT INTO Employee_Details
(First_Name,Last_Name,Email,Mobile_Number,AlternateMobileNumber,Address1,Adress2,Current_Country,Home_Country,ZipCode)VALUES('" + employee.First_Name + "'," + "" + "'" + employee.Last_Name + "'," + "" + "'" + employee.Email + "'," + "" + "" + employee.Mobile_Number + "," + "" + employee.AlternateMobileNumber + "," + "" + "'" + employee.Address1 + "'," + "'" + employee.Address2 + "'," + "" + "" + "'" + employee.Current_Country + "'," + "'" + employee.Home_Country + "'," + "" + employee.ZipCode + ")";
SqlCommand command;
command = new SqlCommand(sqlemployeedetails, mysqlconnection);
result = command.ExecuteNonQuery();
if (result > 0)
{
MessageBox.Show("Details have been saved Successfully:");
}
mysqlconnection.Close();
}
catch (Exception ex)
{
MessageBox.Show("An error has been occured, please contact the administartor: " + ex.Message);
}
return(result);
}
private static void AddSkills(IElementListener document, EmployeeDetailsModel user)
{
var table = new PdfPTable(3)
{
WidthPercentage = 100
};
table.DefaultCell.Border = Rectangle.NO_BORDER;
table.SpacingBefore = 20;
var headerCell = new PdfPCell {
Border = Rectangle.NO_BORDER, Colspan = 3
};
var headerPhrase = new Phrase("Skills & Expertise");
headerCell.Phrase = headerPhrase;
headerPhrase.Font.Color = BaseColor.BLUE;
table.AddCell(headerCell);
foreach (var skill in user.Skills)
{
table.AddCell(skill);
}
var last = 3 - user.Skills.Count % 3;
for (int i = 0; i < last; i++)
{
table.AddCell("");
}
document.Add(table);
}
protected void EditButton_Click(object sender, EventArgs e)
{
try
{
EmployeeDetailsModel empeditmodels = new EmployeeDetailsModel()
{
EmployeeID = Convert.ToInt32(EmployeeIDDropDownList.SelectedValue),
First_Name = First_NameTextBox.Text,
Last_Name = Last_NameTextBox.Text,
Email = EmailTextBox.Text,
Mobile_Number = Mobile_NumberTextBox.Text,
AlternateMobileNumber = AlternateMobileNumberTextBox.Text,
Address1 = Address1TextBox.Text,
Address2 = Address2TextBox.Text,
Current_Country = Current_CountryTextBox.Text,
Home_Country = Home_CountryTextBox.Text,
ZipCode = Convert.ToInt64(ZipCodeTextBox.Text),
};
EmployeeDataAccess empeditaccess = new EmployeeDataAccess();
string emedit = empeditaccess.Editemployee(empeditmodels);
if (emedit.Equals("success"))
{
Response.Write("<script>alert('Details have been updated successfully!');</script>");
}
}
catch (Exception ex)
{
//MessageBox.Show("Details have been updated: " + ex.Message);
Response.Write("<script>alert('Please enter the values!" + ex.Message + "');</script>");
}
}
private static void AddHeader(IElementListener document, EmployeeDetailsModel user)
{
var table = new PdfPTable(3)
{
WidthPercentage = 100
};
table.DefaultCell.Border = Rectangle.NO_BORDER;
table.SpacingAfter = 20;
Image image = Image.GetInstance(user.Photo);
image.ScaleToFit(80, 80);
image.ScaleToFitHeight = true;
var imageCell = new PdfPCell(image)
{
Border = Rectangle.NO_BORDER
};
var nameCell = new PdfPCell {
Border = Rectangle.NO_BORDER
};
var namePhrase = new Phrase(user.FirstName + " " + user.LastName);
nameCell.AddElement(namePhrase);
var infoCell = GetUserContactsTable(user);
table.AddCell(imageCell);
table.AddCell(nameCell);
table.AddCell(infoCell);
document.Add(table);
}
private void employeeDetailSaveButton_Click(object sender, EventArgs e)
{
try
{
EmployeeDetailsModel employeeDetailobj = new EmployeeDetailsModel
{
FirstName = firstNameTextBox.Text,
LastName = lastNameTextBox.Text,
EmailId = emailIDTextBox.Text,
PhoneNumber = Convert.ToInt64(phoneNumberTextBox.Text),
AlternatePhoneNumber = Convert.ToInt64(alternatePhoneTextBox.Text),
Address1 = address1TextBox.Text,
Address2 = address2TextBox.Text,
HomeCountry = homeCountryTextBox.Text,
CurrentCountry = currentCountryTextBox.Text,
ZipCode = Convert.ToInt32(zipcodeTextBox.Text)
};
ServiceReference1.Service1Client client = new ServiceReference1.Service1Client();
long RowsAffected = client.SaveEmployeeData(employeeDetailobj);
}
catch (Exception exception)
{
MessageBox.Show("An Error has Occured, Please contact the Administrator!" + exception.Message);
}
finally
{
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
EmployeeDetailsModel emp = new EmployeeDetailsModel();
emp.Firstname = FirstNametextbox.Text;
emp.Lastname = LastNametextbox.Text;
emp.Email = Emailtextbox.Text;
emp.MobileNumber = Convert.ToInt64(MobileNumbertextbox.Text);
emp.AlternateMobileNumber = Convert.ToInt64(AlternateMobileNumbertextbox.Text);
emp.Address1 = Address1textbox.Text;
emp.Address2 = Address2textbox.Text;
emp.CurrentCountry = CurrentCountrytextbox.Text;
emp.HomeCountry = HomeCountrytextbox.Text;
emp.Zipcode = Convert.ToInt32(Zipcodetextbox.Text);
EmployeeDataAcessLayer objemployeedetails = new EmployeeDataAcessLayer();
objemployeedetails.SaveEmployee(emp);
//string connectionstring = @"Data Source=DINESH-COMPUTER\MYSQL;Initial Catalog = pioneerdb;" +
// "Integrated Security=True";
//SqlConnection mysqlconnection = new SqlConnection(connectionstring);
//mysqlconnection.Open();
//string COMMAND = "INSERT INTO EMPLOYEEDETAILS(FirstName,LastName,EmailId,mobilenumber,Alternatemobilenumber,Address1,Address2,currentcountry,Homecountry,zipcode)VALUES('"+Firstname+"',"+"'"+Lastname+"',"+"'"+Email+"',"+""+MobileNumber+","+""+AlternateMobileNumber+","+"'"+Address1+"',"+"'"+Address2+"',"+"'"+CurrentCountry+"',"+"'"+HomeCountry+"',"+""+Zipcode+")";
//SqlCommand cmd = new SqlCommand(COMMAND, mysqlconnection);
//cmd.ExecuteNonQuery();
//mysqlconnection.Close();
}
catch (Exception ex)
{
MessageBox.Show("error occured:" + ex.Message);
}
}
public int insertemployee(EmployeeDetailsModel employee)
{
EmployeeDataAccess acces = new EmployeeDataAccess();
int emp = acces.SaveEmployee(employee);
return(emp);
}
public EmployeeDetailsModel GetEmployeeDetails(int employeeid)
{
EmployeeDetailsModel empdmodel = new EmployeeDetailsModel();
sqlConnection = OpenConnection();
sqlCommand = new SqlCommand();
sqlCommand.Connection = sqlConnection;
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.CommandText = "uspGetEmployeeDetails";
sqlCommand.Parameters.Add("@EmployeeID", SqlDbType.Int).Value = Convert.ToInt32(employeeid);
SqlDataReader employeedatareader = sqlCommand.ExecuteReader();
while (employeedatareader.Read())
{
empdmodel.EmployeeID = employeedatareader.GetInt32(employeedatareader.GetOrdinal("EmployeeID"));
empdmodel.First_Name = employeedatareader.GetString(employeedatareader.GetOrdinal("First_Name"));
empdmodel.Last_Name = employeedatareader.GetString(employeedatareader.GetOrdinal("Last_Name"));
empdmodel.Email = employeedatareader.GetString(employeedatareader.GetOrdinal("Email"));
empdmodel.Mobile_Number = employeedatareader.GetString(employeedatareader.GetOrdinal("Mobile_Number"));
empdmodel.AlternateMobileNumber = employeedatareader.GetString(employeedatareader.GetOrdinal("AlternateMobileNumber"));
empdmodel.Address1 = employeedatareader.GetString(employeedatareader.GetOrdinal("Address1"));
empdmodel.Address2 = employeedatareader.GetString(employeedatareader.GetOrdinal("Address2"));
empdmodel.Current_Country = employeedatareader.GetString(employeedatareader.GetOrdinal("Current_Country"));
empdmodel.Home_Country = employeedatareader.GetString(employeedatareader.GetOrdinal("Home_Country"));
empdmodel.ZipCode = employeedatareader.GetInt64(employeedatareader.GetOrdinal("ZipCode"));
}
CloseConncetion(sqlConnection);
return(empdmodel);
}
private static void AddLanguages(IElementListener document, EmployeeDetailsModel user)
{
var table = new PdfPTable(1)
{
WidthPercentage = 100
};
table.DefaultCell.Border = Rectangle.NO_BORDER;
table.SpacingBefore = 20;
var headerCell = new PdfPCell {
Border = Rectangle.NO_BORDER
};
var headerPhrase = new Phrase("Language");
headerCell.Phrase = headerPhrase;
headerPhrase.Font.Color = BaseColor.BLUE;
table.AddCell(headerCell);
var languageContext = user.Languages[0];
for (var i = 1; i < user.Languages.Count; i++)
{
languageContext += " | " + user.Languages[i];
}
var cellContext = new PdfPCell(new Phrase(languageContext))
{
Border = Rectangle.NO_BORDER
};
table.AddCell(cellContext);
document.Add(table);
}
private void button1_Click(object sender, EventArgs e)
{
try
{
EmployeeDetailsModel emp = new EmployeeDetailsModel()
{
First_Name = FirstNametextbox.Text,
Last_Name = LastNametextbox.Text,
Email = Emailtextbox.Text,
Mobile_Number = Convert.ToInt64(MobileNumbertextbox.Text),
AlternateMobileNumber = Convert.ToInt64(AlternateMobileNumbertextbox.Text),
Address1 = Address1textbox.Text,
Address2 = Address2textbox.Text,
Current_Country = CurrentCountrytextbox.Text,
Home_Country = HomeCountrytextbox.Text,
ZipCode = Convert.ToInt32(Zipcodetextbox.Text),
};
EmployeeDataAccess employee = new EmployeeDataAccess();
employee.SaveEmployee(emp);
}
catch (Exception ex)
{
MessageBox.Show("Please enter the values:");
}
}
public async Task <ActionResult> Dashboard()
{
if (null != Session[Constants.SESSION_OBJ_USER])
{
var data = (UserAccount)Session[Constants.SESSION_OBJ_USER];
EmployeeDetailsModel datares = await user.GetUserDetailsAsync(data.RefEmployeeId);
Models.LoginModel model = new Models.LoginModel();
model.EmpName = data.UserName;
model.UserName = data.UserName;
model.Projectname = datares.ProjectName;
model.ManagerName = datares.ManagerName;
model.TotalLeaveCount = Convert.ToInt16(datares.TotalLeaveCount);
model.TotalTaken = datares.TotalCountTaken;
model.TotalLeft = Convert.ToInt16(datares.TotalLeaveCount - datares.TotalCountTaken);
model.DateOfJoining = DateTime.Now;
model.RoleName = datares.RoleName;
model.Announcements = new List <Models.Announcement>();
foreach (var item in datares.Announcements)
{
Models.Announcement announceItem = new Models.Announcement();
announceItem.ImagePath = item.ImagePath;
announceItem.CarouselContent = item.CarouselContent;
announceItem.Title = item.Title;
model.Announcements.Add(announceItem);
}
model.LeaveDetails = datares.LeaveDetails;
// model.Announcements = (Models.Announcement)datares.Announcements;
return(View(model));
}
return(View("Login"));
}
private static void AddEducation(IElementListener document, EmployeeDetailsModel user)
{
var table = new PdfPTable(2)
{
WidthPercentage = 100
};
table.SetWidths(new int[] { 1, 4 });
table.DefaultCell.Border = Rectangle.NO_BORDER;
table.SpacingBefore = 20;
var headerCell = new PdfPCell {
Border = Rectangle.NO_BORDER, Colspan = 2
};
var headerPhrase = new Phrase("Education");
headerCell.Phrase = headerPhrase;
headerPhrase.Font.Color = BaseColor.BLUE;
table.AddCell(headerCell);
foreach (var education in user.Educations)
{
var yearAttendedTo = education.YearAttendedTo != 0 ? education.YearAttendedTo.ToString() : "Current time";
var years = new Phrase(education.YearAttendedFrom + " - " + yearAttendedTo);
table.AddCell(years);
table.AddCell(education.School);
table.AddCell("");
table.AddCell(education.Degree);
}
document.Add(table);
}
public ActionResult Edit(int id)
{
EmployeeDetailsModel edmod = new EmployeeDetailsModel();
DataTable dtbemployee = new DataTable();
using (SqlConnection sqlcon = new SqlConnection(connectionstring))
{
sqlcon.Open();
string editquery = "SELECT * FROM Employee_Details WHERE EmployeeID=@EmployeeID";
SqlDataAdapter sqladp = new SqlDataAdapter(editquery, sqlcon);
sqladp.SelectCommand.Parameters.AddWithValue("@EmployeeID", id);
sqladp.Fill(dtbemployee);
}
if (dtbemployee.Rows.Count == 1)
{
edmod.EmployeeID = Convert.ToInt32(dtbemployee.Rows[0][0].ToString());
edmod.First_Name = dtbemployee.Rows[0][1].ToString();
edmod.Last_Name = dtbemployee.Rows[0][2].ToString();
edmod.Email = dtbemployee.Rows[0][3].ToString();
edmod.Mobile_Number = dtbemployee.Rows[0][4].ToString();
edmod.AlternateMobileNumber = dtbemployee.Rows[0][5].ToString();
edmod.Address1 = dtbemployee.Rows[0][6].ToString();
edmod.Address2 = dtbemployee.Rows[0][7].ToString();
edmod.Current_Country = dtbemployee.Rows[0][8].ToString();
edmod.Home_Country = dtbemployee.Rows[0][9].ToString();
edmod.ZipCode = Convert.ToInt32(dtbemployee.Rows[0][10].ToString());
return(View(edmod));
}
else
{
return(RedirectToAction("Index"));
}
}
public EmployeePdfModel GeneratePdf(EmployeeDetailsModel user)
{
using (var memoryStream = new MemoryStream())
{
EmployeePdfModel employeePdf = new EmployeePdfModel();
Document document = new Document(PageSize.A4, 25, 25, 30, 30);
PdfWriter pdfWriter = PdfWriter.GetInstance(document, memoryStream);
document.AddAuthor("Archysoft");
document.AddCreator("Archysoft");
document.AddKeywords(user.FirstName + " resume");
document.AddSubject(user.LastName);
document.AddTitle("The document title - PDF creation using iTextSharp");
document.Open();
AddHeader(document, user);
document.Add(new LineSeparator());
AddPersonalInfo(document, user);
AddExperience(document, user);
AddEducation(document, user);
AddSkills(document, user);
AddLanguages(document, user);
document.Close();
pdfWriter.Close();
employeePdf.Data = memoryStream.ToArray();
return(employeePdf);
}
}
// GET: Employee/Details/5
public async Task <ActionResult> Details(int id)
{
Employee emp = await _mediator.Send(new GetEmployeeByIdQuery(id)
{
IncludeEmployeePayrolls = true,
IncludeFundsFlows = true,
IncludeFundsFlowsBuildingObject = true,
IncludePdSections = true,
IncludePdSectionsBuildingObject = true
});
var model = new EmployeeDetailsModel
{
FullName = emp.FullName,
Email = emp.Email,
Salary = emp.Salary.ToDecimal(),
AccountableBalance = emp.FundsFlows.Where(ff => ff.Outgo.HasValue && ff.OutgoType == OutgoType.Accountable).Sum(ff => ff.Outgo.Value) -
emp.FundsFlows.Where(ff => ff.Outgo.HasValue && ff.OutgoType == OutgoType.WriteOffAccountable).Sum(ff => ff.Outgo.Value),
Id = emp.Id,
BuildingObjects = GetEmployeeBuildingObjectDetails(emp),
MonthlyEmployeePayrolls = GetEmployeeMonthlyPayrolls(emp)
};
return(View(model));
}
public async Task <IActionResult> GetEmployeeDetails(int employeeId)
{
EmployeeDetailsDto employeeDetailsDto = await _employeeService.GetEmployeeDetailsAsync(employeeId);
EmployeeDetailsModel employeeDetailsModel = _mapper.Map <EmployeeDetailsModel>(employeeDetailsDto);
return(Ok(employeeDetailsModel));
}
public int SaveEmployee(EmployeeDetailsModel model)
{
//branchModel.RecordStatus = "A";
var employeeDetail = Mapper.DynamicMap <tblEmployeeDetail>(model);
_employeeDetailsRepository.Add(employeeDetail);
return(_employeeDetailsRepository.SaveChanges());
}
public EmployeeDetailsModel getEmployeeDetails()
{
EmployeeDetailsModel empDetails = new EmployeeDetailsModel();
List <EmployeeModel> empList = new List <EmployeeModel>()
{
new EmployeeModel()
{
EmployeeId = "466",
EmployeeFName = "Harsha",
EmployeeLName = "Gowda",
EmployeeJoiningDate = new DateTime(),
EmployeeRole = "Software Engineer",
EmployeeSalary = 500000,
EmployeePhoneNumber = 9999977777,
EmployeeEmail = "*****@*****.**"
},
new EmployeeModel()
{
EmployeeId = "450",
EmployeeFName = "Suresh",
EmployeeLName = "Kumar",
EmployeeJoiningDate = new DateTime(),
EmployeeRole = "Software Engineer",
EmployeeSalary = 600000,
EmployeePhoneNumber = 9999977777,
EmployeeEmail = "*****@*****.**"
},
new EmployeeModel()
{
EmployeeId = "476",
EmployeeFName = "Abhi",
EmployeeLName = "Bhat",
EmployeeJoiningDate = new DateTime(),
EmployeeRole = "Software Engineer",
EmployeeSalary = 705000,
EmployeePhoneNumber = 9999977777,
EmployeeEmail = "*****@*****.**"
},
new EmployeeModel()
{
EmployeeId = "155",
EmployeeFName = "Vishwas",
EmployeeLName = "Rai",
EmployeeJoiningDate = new DateTime(),
EmployeeRole = "Software Engineer",
EmployeeSalary = 500000,
EmployeePhoneNumber = 9999977777,
EmployeeEmail = "*****@*****.**"
}
};
empDetails.RowData = empList;
empDetails.ColumnData = GetColumnInfo();
return(empDetails);
}
// PUT api/<controller>/5
public int Put([FromBody] EmployeeDetailsModel model)
{
model.EmpID = int.Parse(UserIdentity);
model.LastUpdatedDate = DateTime.Now;
if (model.ProfilePhotoBase64 != null)
{
model.ProfilePhoto = System.Convert.FromBase64String(model.ProfilePhotoBase64);
}
return(_employeeDetailsService.UpdateEmployee(model));
}
public Task <bool> DeleteEmployee(EmployeeDetailsModel Emp)
{
if (Emp == null)
{
throw new System.ArgumentNullException(nameof(Emp));
}
foreach (var employee in Emp.Employees.Where(x => x.Id != 0))
{
_empRepository.DeleteEmployee(employee);
}
return(_empRepository.SaveAll());
}
// View Model Constructor
public AddSkillsViewModel(INavigation navigation)
{
Navigation = navigation;
addSkills = new List <int>();
BackButtonClicked = new Command(BackButton_Tapped);
SubmitButtonClicked = new Command(SubmitButton_Tapped);
SwitchToggledForAddingSkills = new Command(SwitchToggledFor_AddingSkills);
SwitchToggledForRemovingSkills = new Command(SwitchToggledFor_RemovingSkills);
apiManager = new ApiManager(new RestServices());
employeeDetailsWithSkills = new EmployeeDetailsModel();
GetAllSkillsList();
}
public IHttpActionResult GetEmployeeDetails()
{
EmployeeDetailsModel empDetails = _employeeRepo.getEmployeeDetails();
if (empDetails != null)
{
return(Ok(empDetails));
}
else
{
string message = "EmployeeDetails are not available";
return(ResponseMessage(Request.CreateErrorResponse(HttpStatusCode.NotFound, message)));
}
}
/// <summary>
/// Edit and update the Employee details using Empoyee Id
/// </summary>
/// <param name="employeeId"></param>
/// <returns></returns>
public ActionResult Edit(string employeeId)
{
ViewBag.Page2 = "Employee Settings";
//Validate the Model
if (ModelState.IsValid)
{
//Verify the EmployeeId
if (!string.IsNullOrEmpty(employeeId))
{
//Generate New Id
Guid id = new Guid(employeeId);
//Get the Employee Id
Employee employeeBasicDetails = db.Employees.Find(id);
EmployeeDetailsModel employeeDetails = new EmployeeDetailsModel();
//Update the Employee Basic Details
if (employeeBasicDetails != null)
{
employeeDetails.Id = employeeBasicDetails.Id;
employeeDetails.FirstName = employeeBasicDetails.FirstName;
employeeDetails.LastName = employeeBasicDetails.LastName;
employeeDetails.Gender = employeeBasicDetails.Gender;
employeeDetails.MobileNumber = employeeBasicDetails.MobileNumber;
employeeDetails.Code = employeeBasicDetails.Code;
employeeDetails.CreatedOn = employeeBasicDetails.CreatedOn;
EmployeeAddress employeeAddress = GetEmployeeAddress(employeeBasicDetails.Id);
//Update the Employee Address
if (employeeAddress != null)
{
employeeDetails.Address1 = employeeAddress.Address1;
employeeDetails.Address2 = employeeAddress.Address2;
employeeDetails.State = employeeAddress.State;
employeeDetails.City = employeeAddress.City;
employeeDetails.Country = employeeAddress.Country;
employeeDetails.Pincode = employeeAddress.Pincode;
}
}
if (employeeDetails == null)
{
return(HttpNotFound());
}
return(View(employeeDetails));
}
}
return(HttpNotFound());
}
public void SaveEmployee(EmployeeDetailsModel emp)
{
try
{
string connectionstring = @"Data Source=DINESH-COMPUTER\MYSQL;Initial Catalog = pioneerdb;" +
"Integrated Security=True";
SqlConnection mysqlconnection = new SqlConnection(connectionstring);
mysqlconnection.Open();
string COMMAND = "INSERT INTO EMPLOYEEDETAILS(firstname,lastname,email,mobilenumber,alternatemobilenumber,Address1,Address2,currentcountry,Homecountry,zipcode)VALUES('" + emp.Firstname + "'," + "'" + emp.Lastname + "'," + "'" + emp.Email + "'," + "" + emp.MobileNumber + "," + "" + emp.AlternateMobileNumber + "," + "'" + emp.Address1 + "'," + "'" + emp.Address2 + "'," + "'" + emp.CurrentCountry + "'," + "'" + emp.HomeCountry + "'," + "" + emp.Zipcode + ")";
SqlCommand cmd = new SqlCommand(COMMAND, mysqlconnection);
cmd.ExecuteNonQuery();
mysqlconnection.Close();
}
finally
{
}
}
public async Task <EmployeeDetailsModel> GetEmplyeeDetails(int employeeId)
{
// you can implement a dictionary here with the requests that have come in and their data
// and perhaps a time stamp. So, when a request comes along, you can check if it was alrady
// cached and if it was recently enough - skip calling the database and return from memory
// the data caching and retrieval is entirely up to the application and its practices/needs
BasicEmployee employee = data.Where(empl => empl.Id == employeeId).FirstOrDefault();
EmployeeDetailsModel details = new EmployeeDetailsModel(employee);
details.Salary = rnd.Next(1000, 5000);
details.ActiveProjects = rnd.Next(2, 10);
details.HireDate = DateTime.Now.AddYears(-rnd.Next(1, 10)).AddMonths(-rnd.Next(0, 10)).AddDays(-rnd.Next(0, 10));
await Task.Delay(800); // simulate real life delay. Remove this in a real app
return(details);
}