public void UpdateEmployeeDetails(Employees updateEmployee)
{
OleDbConnection con = new OleDbConnection(pathconn);
try
{
con.Open();
OleDbCommand cmd = new OleDbCommand("update [Sheet1$] set empname=?, emplastname=?, dateofbirth=?, dateofjoining=?, emailid=?, designation=?, empgender=?, empprifix=?, empmiddlename=?, empimagepath=? where empid=" + updateEmployee.EmpID + "", con);
string date = DateTime.Now.ToString();
// cmd.Parameters.Add("empid", OleDbType.Integer).Value = updateEmployee.EmpID;
cmd.Parameters.Add("empname", OleDbType.VarChar).Value = updateEmployee.EmpName;
cmd.Parameters.Add("emplastname", OleDbType.VarChar).Value = updateEmployee.EmpLastName;
cmd.Parameters.Add("dateofbirth", OleDbType.Date).Value = updateEmployee.DateOfBirth;
cmd.Parameters.Add("dateofjoining", OleDbType.Date).Value = updateEmployee.DateOfJoining;
cmd.Parameters.Add("emailid", OleDbType.VarChar).Value = updateEmployee.EmpID;
cmd.Parameters.Add("designation", OleDbType.VarChar).Value = updateEmployee.Designation;
cmd.Parameters.Add("empgender", OleDbType.VarChar).Value = updateEmployee.EmpGender;
cmd.Parameters.Add("empprifix", OleDbType.VarChar).Value = updateEmployee.EmpPrefix;
cmd.Parameters.Add("empmiddlename", OleDbType.VarChar).Value = updateEmployee.EmpMiddleName;
cmd.Parameters.Add("empimagepath", OleDbType.VarChar).Value = updateEmployee.EmpImagePath;
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
ExceptionLogger log = new ExceptionLogger();
log.DoLog(ex);
}
finally
{
if (con.State != ConnectionState.Closed)
con.Close();
}
}
public void UpdateEmployeeDetails(Employees updateEmployee)
{
throw new NotImplementedException();
}
public void AddEmployee(Employees newEmployee)
{
Int32 empid = 0;
OleDbConnection con = new OleDbConnection(pathconn);
try
{
con.Open();
OleDbCommand cm2 = new OleDbCommand("select MAX(empid) from [Sheet1$]", con);
empid = Convert.ToInt32(cm2.ExecuteScalar()) + 1;
OleDbCommand cmd = new OleDbCommand("insert into [Sheet1$] (empid,empname,empmiddlename, emplastname, dateofbirth, dateofjoining, emailid, designation, empgender, empprifix, empimagepath,IsDeleted) values(?,?,?,?,?,?,?,?,?,?,?,?)", con);
string date = DateTime.Now.ToString();
cmd.Parameters.Add("empid", OleDbType.Integer).Value = empid;
cmd.Parameters.Add("empname", OleDbType.VarChar).Value = newEmployee.EmpName;
cmd.Parameters.Add("empmiddlename", OleDbType.VarChar).Value = newEmployee.EmpMiddleName;
cmd.Parameters.Add("emplastname", OleDbType.VarChar).Value = newEmployee.EmpLastName;
cmd.Parameters.Add("dateofbirth", OleDbType.Date).Value = newEmployee.DateOfBirth.Date;
cmd.Parameters.Add("dateofjoining", OleDbType.Date).Value = newEmployee.DateOfJoining.Date;
cmd.Parameters.Add("emailid", OleDbType.VarChar).Value = newEmployee.EmailId;
cmd.Parameters.Add("designation", OleDbType.VarChar).Value = newEmployee.Designation;
cmd.Parameters.Add("empgender", OleDbType.VarChar).Value = newEmployee.EmpGender;
cmd.Parameters.Add("empprifix", OleDbType.VarChar).Value = newEmployee.EmpPrefix;
cmd.Parameters.Add("empimagepath", OleDbType.VarChar).Value = newEmployee.EmpImagePath;
cmd.Parameters.Add("IsDeleted", OleDbType.VarChar).Value = "no";
cmd.ExecuteNonQuery();
Template temp = new Template();
string templatestr = temp.templateNewBieBody(newEmployee.EmpName);
string _imagePath = "";
_imagePath = (string)ConfigurationSettings.AppSettings["ImagePath"] + newEmployee.EmpImagePath;
MailingClass sendmail = new MailingClass();
//sendmail.SendMail(fromEmailID, newEmployee.EmailId, ccLIst, templatestr, "Welcome To tavisca", "Welcome To Tavisca", _imagePath, _bodyImagePath);
}
catch (Exception ex)
{
ExceptionLogger log = new ExceptionLogger();
log.DoLog(ex);
}
finally
{
if (con.State != ConnectionState.Closed)
con.Close();
}
}
public void AddEmployee(Employees newEmployee)
{
SqlConnection conAdd = new SqlConnection(pathconn);
try
{
conAdd.Open();
SqlCommand sqlAdd = new SqlCommand("InsertEmployee", conAdd);
sqlAdd.CommandType = CommandType.StoredProcedure;
sqlAdd.Parameters.Add("name", SqlDbType.NVarChar).Value = newEmployee.EmpName;
sqlAdd.Parameters.Add("middlename", SqlDbType.NVarChar).Value = newEmployee.EmpMiddleName;
sqlAdd.Parameters.Add("lastname", SqlDbType.NVarChar).Value = newEmployee.EmpLastName;
sqlAdd.Parameters.Add("dob", SqlDbType.Date).Value = newEmployee.DateOfBirth;
sqlAdd.Parameters.Add("doj", SqlDbType.Date).Value = newEmployee.DateOfJoining;
sqlAdd.Parameters.Add("gender", SqlDbType.NVarChar).Value = newEmployee.EmpGender;
sqlAdd.Parameters.Add("isPresent", SqlDbType.Bit).Value = 1;
sqlAdd.Parameters.Add("prefix", SqlDbType.NVarChar).Value = newEmployee.EmpPrefix;
sqlAdd.Parameters.Add("emailid", SqlDbType.NVarChar).Value = newEmployee.EmailId;
sqlAdd.Parameters.Add("imagepath", SqlDbType.NVarChar).Value = newEmployee.EmpImagePath;
sqlAdd.Parameters.Add("designation", SqlDbType.NVarChar).Value = newEmployee.Designation;
sqlAdd.Parameters.Add("description", SqlDbType.NVarChar).Value = newEmployee.Description;
sqlAdd.Parameters.Add("teamid", SqlDbType.Int).Value = newEmployee.TeamId;
sqlAdd.ExecuteNonQuery();
}
catch (Exception ex)
{
}
}
