public bool UpdateUserSalTaxDetails(Attendance.Entities.UserInfo objInfo, int EmployeeID, int EnteredBy, string Ipaddress)
{
bool success = false;
try
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["AttendanceConn"].ToString());
con.Open();
SqlCommand command = new SqlCommand("[USP_updateSalTaxDetails]", con);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@UserID", SqlDbType.Int).Value = EmployeeID;
// command.Parameters.Add("@EmpID", SqlDbType.VarChar).Value = objInfo.EmpID;
command.Parameters.Add("@WageID", SqlDbType.Int).Value = objInfo.WageID;
command.Parameters.Add("@salary", SqlDbType.VarChar).Value = objInfo.Salary;
command.Parameters.Add("@Deductions", SqlDbType.Int).Value = objInfo.Deductions;
command.Parameters.Add("@MaritalID", SqlDbType.Int).Value = objInfo.MaritalID;
command.Parameters.Add("@EnteredBy", SqlDbType.Int).Value = EnteredBy;
command.Parameters.Add("@IPAddress", SqlDbType.VarChar).Value = Ipaddress;
command.ExecuteNonQuery();
con.Close();
success = true;
}
catch (Exception ex)
{
}
return(success);
}
public bool UpdatePersonalDetails(Attendance.Entities.UserInfo objInfo, int EnteredBy, int userID, string ipaddress)
{
bool success = false;
try
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["AttendanceConn"].ToString());
con.Open();
SqlCommand command = new SqlCommand("[USP_UpdatePersonalDetailsByUserID]", con);
command.CommandType = CommandType.StoredProcedure;
//command.Parameters.Add("@EmpID", SqlDbType.VarChar).Value = objInfo.EmpID;
command.Parameters.Add("@EnterBY", SqlDbType.Int).Value = EnteredBy;
command.Parameters.Add("@UserID", SqlDbType.Int).Value = userID;
command.Parameters.Add("@Ipaddress", SqlDbType.VarChar).Value = ipaddress;
command.Parameters.Add("@Gender", SqlDbType.VarChar).Value = objInfo.Gender;
command.Parameters.Add("@phoneNum", SqlDbType.VarChar).Value = objInfo.Phone;
command.Parameters.Add("@DateofBirth", SqlDbType.DateTime).Value = objInfo.DateOfBirth;
command.Parameters.Add("@mobileNum", SqlDbType.VarChar).Value = objInfo.Mobile;
command.Parameters.Add("@businessEmail", SqlDbType.VarChar).Value = objInfo.BusinessEmail;
command.Parameters.Add("@personalEmail", SqlDbType.VarChar).Value = objInfo.PersonalEmail;
command.Parameters.Add("@County", SqlDbType.VarChar).Value = objInfo.County;
command.Parameters.Add("@StateID", SqlDbType.Int).Value = objInfo.StateID;
command.Parameters.Add("@Address1", SqlDbType.VarChar).Value = objInfo.Address1;
command.Parameters.Add("@Address2", SqlDbType.VarChar).Value = objInfo.Address2;
command.Parameters.Add("@zip", SqlDbType.VarChar).Value = objInfo.Zip;
command.Parameters.Add("@SSN", SqlDbType.VarChar).Value = objInfo.SSN;
command.Parameters.Add("@drivingLicenceNum", SqlDbType.VarChar).Value = objInfo.DriverLicense;
command.ExecuteNonQuery();
con.Close();
success = true;
}
catch (Exception ex)
{
}
return(success);
}
public bool UpdateUser(Attendance.Entities.UserInfo objInfo, int EmployeeID, int EnteredBy, string PhotoLink, string Ipaddress)
{
bool success = false;
try
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["AttendanceConn"].ToString());
con.Open();
SqlCommand command = new SqlCommand("[USP_UpdateUserDetails]", con);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@UserID", SqlDbType.Int).Value = EmployeeID;
// command.Parameters.Add("@EmpID", SqlDbType.VarChar).Value = objInfo.EmpID;
command.Parameters.Add("@FirstName", SqlDbType.VarChar).Value = objInfo.Firstname;
command.Parameters.Add("@LastName", SqlDbType.VarChar).Value = objInfo.Lastname;
command.Parameters.Add("@ProfessionalFirstName", SqlDbType.VarChar).Value = objInfo.BFirstname;
command.Parameters.Add("@ProfessionalLastName", SqlDbType.VarChar).Value = objInfo.BLastname;
command.Parameters.Add("@Startdate", SqlDbType.DateTime).Value = objInfo.StartDt;
command.Parameters.Add("@TermReason", SqlDbType.VarChar).Value = objInfo.TermReason;
command.Parameters.Add("@TermDate", SqlDbType.DateTime).Value = objInfo.TermDt;
command.Parameters.Add("@DeptName", SqlDbType.VarChar).Value = objInfo.Deptname;
command.Parameters.Add("@Designation", SqlDbType.VarChar).Value = objInfo.Designation;
command.Parameters.Add("@ScheduleID", SqlDbType.Int).Value = objInfo.ScheduleID;
command.Parameters.Add("@EmpTypeID", SqlDbType.Int).Value = objInfo.EmpTypeID;
command.Parameters.Add("@EnteredBy", SqlDbType.Int).Value = EnteredBy;
command.Parameters.Add("@IsActive", SqlDbType.Bit).Value = objInfo.IsActive;
command.Parameters.Add("@photoLink", SqlDbType.VarChar).Value = PhotoLink;
command.Parameters.Add("@Ipaddress", SqlDbType.VarChar).Value = Ipaddress;
command.ExecuteNonQuery();
con.Close();
success = true;
}
catch (Exception ex)
{
}
return(success);
}
public bool AddUser(Attendance.Entities.UserInfo objInfo, Attendance.Entities.EmergencyContactInfo objContactInfo, int EnteredBy, string Locationname, string PhotoLink)
{
bool success = false;
try
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["AttendanceConn"].ToString());
con.Open();
SqlCommand command = new SqlCommand("[USP_INSERT]", con);
command.CommandType = CommandType.StoredProcedure;
//command.Parameters.Add("@EmpID", SqlDbType.VarChar).Value = objInfo.EmpID;
command.Parameters.Add("@FirstName", SqlDbType.VarChar).Value = objInfo.Firstname;
command.Parameters.Add("@LastName", SqlDbType.VarChar).Value = objInfo.Lastname;
command.Parameters.Add("@ProfessionalFirstName", SqlDbType.VarChar).Value = objInfo.BFirstname;
command.Parameters.Add("@ProfessionalLastName", SqlDbType.VarChar).Value = objInfo.BLastname;
command.Parameters.Add("@Startdate", SqlDbType.DateTime).Value = objInfo.StartDt;
command.Parameters.Add("@DeptName", SqlDbType.VarChar).Value = objInfo.Deptname;
command.Parameters.Add("@Designation", SqlDbType.VarChar).Value = objInfo.Designation;
command.Parameters.Add("@Location", SqlDbType.VarChar).Value = Locationname;
command.Parameters.Add("@EnteredBy", SqlDbType.Int).Value = EnteredBy;
command.Parameters.Add("@scheduleID", SqlDbType.Int).Value = objInfo.ScheduleID;
command.Parameters.Add("@IsActive", SqlDbType.Bit).Value = objInfo.IsActive;
command.Parameters.Add("@photoLink", SqlDbType.VarChar).Value = PhotoLink;
command.Parameters.Add("@EmpTypeID", SqlDbType.Int).Value = objInfo.EmpTypeID;
//command.Parameters.Add("@EmpID", SqlDbType.VarChar).Value = objInfo.EmpID;
command.Parameters.Add("@Gender", SqlDbType.VarChar).Value = objInfo.Gender;
command.Parameters.Add("@phoneNum", SqlDbType.VarChar).Value = objInfo.Phone;
command.Parameters.Add("@DateofBirth", SqlDbType.DateTime).Value = objInfo.DateOfBirth;
command.Parameters.Add("@mobileNum", SqlDbType.VarChar).Value = objInfo.Mobile;
command.Parameters.Add("@BusinessEmail", SqlDbType.VarChar).Value = objInfo.BusinessEmail;
command.Parameters.Add("@PersonalEmail", SqlDbType.VarChar).Value = objInfo.PersonalEmail;
command.Parameters.Add("@MaritalStatusID", SqlDbType.Int).Value = objInfo.MaritalID;
command.Parameters.Add("@County", SqlDbType.VarChar).Value = objInfo.County;
command.Parameters.Add("@WageID", SqlDbType.Int).Value = objInfo.WageID;
command.Parameters.Add("@Deductions", SqlDbType.Int).Value = objInfo.Deductions;
command.Parameters.Add("@Salary", SqlDbType.VarChar).Value = objInfo.Salary;
command.Parameters.Add("@Person1", SqlDbType.VarChar).Value = objContactInfo.Person1;
command.Parameters.Add("@P1Address1", SqlDbType.VarChar).Value = objContactInfo.P1Address1;
command.Parameters.Add("@P1Address2", SqlDbType.VarChar).Value = objContactInfo.P1Address2;
command.Parameters.Add("@phone1", SqlDbType.VarChar).Value = objContactInfo.Phone1;
command.Parameters.Add("@relation1", SqlDbType.VarChar).Value = objContactInfo.Relation1;
command.Parameters.Add("@person2", SqlDbType.VarChar).Value = objContactInfo.Person2;
command.Parameters.Add("@p2Address1", SqlDbType.VarChar).Value = objContactInfo.P2Address1;
command.Parameters.Add("@p2Address2", SqlDbType.VarChar).Value = objContactInfo.P2Address2;
command.Parameters.Add("@phone2", SqlDbType.VarChar).Value = objContactInfo.Phone2;
command.Parameters.Add("@relation2", SqlDbType.VarChar).Value = objContactInfo.Relation2;
command.Parameters.Add("@email2", SqlDbType.VarChar).Value = objContactInfo.Email2;
command.Parameters.Add("@email1", SqlDbType.VarChar).Value = objContactInfo.Email1;
command.Parameters.Add("@email3", SqlDbType.VarChar).Value = objContactInfo.Email3;
command.Parameters.Add("@StateID1", SqlDbType.Int).Value = objContactInfo.StateID1;
command.Parameters.Add("@StateID2", SqlDbType.Int).Value = objContactInfo.StateID2;
command.Parameters.Add("@StateID3", SqlDbType.Int).Value = objContactInfo.StateID3;
command.Parameters.Add("@Zip1", SqlDbType.VarChar).Value = objContactInfo.Zip1;
command.Parameters.Add("@Zip2", SqlDbType.VarChar).Value = objContactInfo.Zip2;
command.Parameters.Add("@Zip3", SqlDbType.VarChar).Value = objContactInfo.Zip3;
command.Parameters.Add("@person3", SqlDbType.VarChar).Value = objContactInfo.Person3;
command.Parameters.Add("@p3Address1", SqlDbType.VarChar).Value = objContactInfo.P3Address1;
command.Parameters.Add("@p3Address2", SqlDbType.VarChar).Value = objContactInfo.P3Address2;
command.Parameters.Add("@phone3", SqlDbType.VarChar).Value = objContactInfo.Phone3;
command.Parameters.Add("@relation3", SqlDbType.VarChar).Value = objContactInfo.Relation3;
command.Parameters.Add("@StateID", SqlDbType.Int).Value = objInfo.StateID;
command.Parameters.Add("@Address1", SqlDbType.VarChar).Value = objInfo.Address1;
command.Parameters.Add("@Address2", SqlDbType.VarChar).Value = objInfo.Address2;
command.Parameters.Add("@zip", SqlDbType.VarChar).Value = objInfo.Zip;
command.Parameters.Add("@SSN", SqlDbType.VarChar).Value = objInfo.SSN;
command.Parameters.Add("@drivingLicenceNum", SqlDbType.VarChar).Value = objInfo.DriverLicense;
command.ExecuteNonQuery();
con.Close();
success = true;
}
catch (Exception ex)
{
}
return(success);
}
