public static void ConvertImage1(long id)
{
// Convert byte[] to Image
string filePath = @"C:\Users\dhinesh.ks\Documents\";
using (EmployeeOnboardingEntities1 db = new EmployeeOnboardingEntities1())
{
var g = (from imge in db.Proofs.Where(u => u.Employee_id == id)
select new
{
imge.ProofId
}).FirstOrDefault().ProofId;
var h = (from username in db.Employees.Where(u => u.Employee_id == id)
select new
{
username.FirstName
}).FirstOrDefault().FirstName;
string name = h + ".jpeg";
string last = g.Substring(g.LastIndexOf(',') + 1);
byte[] imageBytes = Convert.FromBase64String(last);
MemoryStream ms = new MemoryStream(imageBytes, 0, imageBytes.Length);
ms.Write(imageBytes, 0, imageBytes.Length);
ms.Position = 0;
System.Drawing.Image image = System.Drawing.Image.FromStream(ms, true);
System.Drawing.Image img = Base64ToImage(last);
img.Save(filePath + name, System.Drawing.Imaging.ImageFormat.Jpeg);
}
}
public static bool IsUsernameExist(string username) //Check User Name exists in the DB
{
try
{
using (EmployeeOnboardingEntities1 db = new EmployeeOnboardingEntities1())
{
var v = db.Employees.Where(u => u.UserName == username).FirstOrDefault();
return(v == null ? false : true);
}
}
catch (Exception ex)
{
LogFile.WriteLog(ex);
return(false);
}
}
public static int GetEmployeeID(string userName) //Getting Employee id from the User Name
{
try
{
using (EmployeeOnboardingEntities1 db = new EmployeeOnboardingEntities1())
{
var v = db.Employees.Where(u => u.UserName == userName).FirstOrDefault();
return(v.Employee_id);
}
}
catch (Exception ex)
{
LogFile.WriteLog(ex);
return(0);
}
}
public static bool IsEmailExist(string EmailID) //Check Email ID exists in the DB
{
try
{
using (EmployeeOnboardingEntities1 db = new EmployeeOnboardingEntities1())
{
var v = db.Employees.Where(u => u.PersonalEmail == EmailID).FirstOrDefault();
return(v == null ? false : true);
}
}
catch (Exception ex)
{
LogFile.WriteLog(ex);
return(false);
}
}
public static bool IsPersonalInfoExist(int id) //Check for the existence of same personalInfo details in the DB for an employee
{
try
{
using (EmployeeOnboardingEntities1 db = new EmployeeOnboardingEntities1())
{
var res = db.PersonalInfoes.Where(u => u.Employee_id == id).FirstOrDefault();
return(res == null ? false : true);
}
}
catch (Exception ex)
{
LogFile.WriteLog(ex);
return(false);
}
}
public static bool IsCourseExist(int id, string course) //Check for the existence of same course details in the DB for an employee
{
try
{
using (EmployeeOnboardingEntities1 db = new EmployeeOnboardingEntities1())
{
var res = db.Educations.Where(u => u.Employee_id == id && course == u.CourseCode).FirstOrDefault();
return(res == null ? false : true);
}
}
catch (Exception ex)
{
LogFile.WriteLog(ex);
return(false);
}
}
public static string LoginAttempt(string username, string password, out Employee emp) //Login function
{
try
{
using (EmployeeOnboardingEntities1 db = new EmployeeOnboardingEntities1())
{
emp = db.Employees.Where(l => l.UserName == username).FirstOrDefault();
//password = PWHashing.Hash(password);
if (emp != null)
{
bool isPasswordMatched = VerifyPassword(password, emp.HashedPassword, emp.Salt);
if (isPasswordMatched)
{
return("Successfull");
}
else
{
emp = null;
return("Password is Wrong");
}
}
else
{
emp = null;
return("Invalid Credentials");
}
}
}
catch (Exception ex)
{
LogFile.WriteLog(ex);
emp = null;
return("Exception Caused");
}
}
public static void PassDetails(long id) //Getting Employee id from the User Name
{
try
{
using (EmployeeOnboardingEntities1 db = new EmployeeOnboardingEntities1())
{
var a = (from pdf in db.Employees.Where(u => u.Employee_id == id)
select new
{
pdf.FirstName
}).FirstOrDefault().FirstName;
var b = (from pdf in db.Employees.Where(u => u.Employee_id == id)
select new
{
pdf.Employee_id
}).FirstOrDefault().Employee_id;
var c = (from pdf in db.Employees.Where(u => u.Employee_id == id)
select new
{
pdf.DOJ
}).FirstOrDefault().DOJ;
var d = (from pdf in db.Employees.Where(u => u.Employee_id == id)
select new
{
pdf.LastName
}).FirstOrDefault().LastName;
var e = (from pdf in db.Employees.Where(u => u.Employee_id == id)
select new
{
pdf.Department
}).FirstOrDefault().Department;
var f = (from pdf in db.Employees.Where(u => u.Employee_id == id)
select new
{
pdf.PersonalEmail
}).FirstOrDefault().PersonalEmail;
var g = (from pdf in db.PersonalInfoes.Where(u => u.Employee_id == id)
select new
{
pdf.DateOfBirth
}).FirstOrDefault().DateOfBirth;
var h = (from pdf in db.PersonalInfoes.Where(u => u.Employee_id == id)
select new
{
pdf.Gender
}).FirstOrDefault().Gender;
var i = (from pdf in db.PersonalInfoes.Where(u => u.Employee_id == id)
select new
{
pdf.MaritalStatus
}).FirstOrDefault().MaritalStatus;
var j = (from pdf in db.PersonalInfoes.Where(u => u.Employee_id == id)
select new
{
pdf.Address1
}).FirstOrDefault().Address1;
var k = (from pdf in db.PersonalInfoes.Where(u => u.Employee_id == id)
select new
{
pdf.City1
}).FirstOrDefault().City1;
var l = (from pdf in db.PersonalInfoes.Where(u => u.Employee_id == id)
select new
{
pdf.State1
}).FirstOrDefault().State1;
var m = (from pdf in db.PersonalInfoes.Where(u => u.Employee_id == id)
select new
{
pdf.Country1
}).FirstOrDefault().Country1;
var o = (from pdf in db.Employees.Where(u => u.Employee_id == id)
select new
{
pdf.JobTitle
}).FirstOrDefault().JobTitle;
var p = (from pdf in db.Educations.Where(u => u.Employee_id == id && u.CourseCode == "UnderGraduate")
select new
{
pdf.Course
}).FirstOrDefault().Course;
var q = (from pdf in db.Educations.Where(u => u.Employee_id == id && u.CourseCode == "UnderGraduate")
select new
{
pdf.Institute
}).FirstOrDefault().Institute;
var r = (from pdf in db.Educations.Where(u => u.Employee_id == id && u.CourseCode == "UnderGraduate")
select new
{
pdf.GradePoint
}).FirstOrDefault().GradePoint;
var s = (from pdf in db.Educations.Where(u => u.Employee_id == id && u.CourseCode == "UnderGraduate")
select new
{
pdf.From
}).FirstOrDefault().From;
var t = (from pdf in db.Educations.Where(u => u.Employee_id == id && u.CourseCode == "UnderGraduate")
select new
{
pdf.To
}).FirstOrDefault().To;
var a1 = (from pdf in db.Educations.Where(u => u.Employee_id == id && u.CourseCode == "HSC")
select new
{
pdf.Course
}).FirstOrDefault().Course;
var a2 = (from pdf in db.Educations.Where(u => u.Employee_id == id && u.CourseCode == "HSC")
select new
{
pdf.Institute
}).FirstOrDefault().Institute;
var a3 = (from pdf in db.Educations.Where(u => u.Employee_id == id && u.CourseCode == "HSC")
select new
{
pdf.GradePoint
}).FirstOrDefault().GradePoint;
var a4 = (from pdf in db.Educations.Where(u => u.Employee_id == id && u.CourseCode == "HSC")
select new
{
pdf.From
}).FirstOrDefault().From;
var a5 = (from pdf in db.Educations.Where(u => u.Employee_id == id && u.CourseCode == "HSC")
select new
{
pdf.To
}).FirstOrDefault().To;
var b1 = (from pdf in db.Educations.Where(u => u.Employee_id == id && u.CourseCode == "SSLC")
select new
{
pdf.Course
}).FirstOrDefault().Course;
var b2 = (from pdf in db.Educations.Where(u => u.Employee_id == id && u.CourseCode == "SSLC")
select new
{
pdf.Institute
}).FirstOrDefault().Institute;
var b3 = (from pdf in db.Educations.Where(u => u.Employee_id == id && u.CourseCode == "SSLC")
select new
{
pdf.GradePoint
}).FirstOrDefault().GradePoint;
var b4 = (from pdf in db.Educations.Where(u => u.Employee_id == id && u.CourseCode == "SSLC")
select new
{
pdf.From
}).FirstOrDefault().From;
var b5 = (from pdf in db.Educations.Where(u => u.Employee_id == id && u.CourseCode == "SSLC")
select new
{
pdf.To
}).FirstOrDefault().To;
PDF.PrintReceipt(a, b, c, d, e, f, g, h, i, j, k, l, m, o, p, q, r, s, t, a1, a2, a3, a4, a5, b1, b2, b3, b4, b5);
}
}
catch (Exception ex)
{
LogFile.WriteLog(ex);
}
}
