public int UpdateUserProfileEmployee(UserProfileEmployee emp) { try { return(UserProfileEmployeeIntegration.UpdateUserProfileEmployee(emp)); } catch (Exception ex) { throw (new Exception(MethodBase.GetCurrentMethod().DeclaringType.ToString() + "." + (new System.Diagnostics.StackFrame()).GetMethod().Name, ex)); } }
public int UpdateUserProfileEmployee(UserProfileEmployee emp) { try { int ReturnValue = 0; SqlCommand SqlCmd = new SqlCommand(); SqlCmd.CommandType = CommandType.StoredProcedure; SqlCmd.Parameters.Add(GetParameter("ReturnValue", SqlDbType.Int, ReturnValue)).Direction = ParameterDirection.Output; SqlCmd.Parameters.Add(GetParameter("EmployeeID", SqlDbType.Int, emp.EmployeeID)); //SqlCmd.Parameters.Add(GetParameter("Salutation", SqlDbType.VarChar, emp.Salutation)); //SqlCmd.Parameters.Add(GetParameter("EmployeeName", SqlDbType.VarChar, emp.EmployeeName)); //SqlCmd.Parameters.Add(GetParameter("FatherName", SqlDbType.VarChar, emp.FatherName)); //SqlCmd.Parameters.Add(GetParameter("SpouseName", SqlDbType.VarChar, emp.SpouseName)); SqlCmd.Parameters.Add(GetParameter("DateOfBirth", SqlDbType.DateTime, emp.DateOfBirth.ToString(MicroConstants.DateFormat))); //SqlCmd.Parameters.Add(GetParameter("Gender", SqlDbType.VarChar, emp.Gender)); //SqlCmd.Parameters.Add(GetParameter("BloodGroup", SqlDbType.VarChar, emp.BloodGroup)); //SqlCmd.Parameters.Add(GetParameter("Religion", SqlDbType.VarChar, emp.Religion)); //SqlCmd.Parameters.Add(GetParameter("Nationality", SqlDbType.VarChar, emp.Nationality)); //SqlCmd.Parameters.Add(GetParameter("MaritalStatus", SqlDbType.VarChar, emp.MaritalStatus)); //SqlCmd.Parameters.Add(GetParameter("KnownAilments", SqlDbType.VarChar, emp.KnownAilments)); //SqlCmd.Parameters.Add(GetParameter("IdentificationMark", SqlDbType.VarChar, emp.IdentificationMark)); SqlCmd.Parameters.Add(GetParameter("Address_Present_TownOrCity", SqlDbType.VarChar, emp.Address_Present_TownOrCity)); SqlCmd.Parameters.Add(GetParameter("Address_Present_LandMark", SqlDbType.VarChar, emp.Address_Present_LandMark)); SqlCmd.Parameters.Add(GetParameter("Address_Present_DistrictID", SqlDbType.Int, emp.Address_Present_DistrictID)); SqlCmd.Parameters.Add(GetParameter("Address_Present_Pincode", SqlDbType.VarChar, emp.Address_Present_Pincode)); //SqlCmd.Parameters.Add(GetParameter("Address_Permanent_TownOrCity", SqlDbType.VarChar, emp.Address_Permanent_TownOrCity)); //SqlCmd.Parameters.Add(GetParameter("Address_Permanent_LandMark", SqlDbType.VarChar, emp.Address_Permanent_LandMark)); //SqlCmd.Parameters.Add(GetParameter("Address_Permanent_DistrictID", SqlDbType.Int, emp.Address_Permanent_DistrictID)); //SqlCmd.Parameters.Add(GetParameter("Address_Permanent_Pincode", SqlDbType.VarChar, emp.Address_Permanent_Pincode)); SqlCmd.Parameters.Add(GetParameter("PhoneNumber", SqlDbType.VarChar, emp.PhoneNumber)); SqlCmd.Parameters.Add(GetParameter("Mobile", SqlDbType.VarChar, emp.Mobile)); SqlCmd.Parameters.Add(GetParameter("EmailID", SqlDbType.VarChar, emp.EmailID)); SqlCmd.Parameters.Add(GetParameter("PersonalEMailID", SqlDbType.VarChar, emp.PersonalEMailID)); SqlCmd.Parameters.Add(GetParameter("EmergencyContactNumber", SqlDbType.VarChar, emp.EmergencyContactNumber)); SqlCmd.Parameters.Add(GetParameter("ModifiedBy", SqlDbType.Int, Micro.Commons.Connection.LoggedOnUser.UserID)); SqlCmd.CommandText = "pHRM_UserProfile_Employee_Update"; ExecuteStoredProcedure(SqlCmd); ReturnValue = int.Parse(SqlCmd.Parameters[0].Value.ToString()); return(ReturnValue); } catch (Exception ex) { throw (new Exception(MethodBase.GetCurrentMethod().DeclaringType.ToString() + "." + (new System.Diagnostics.StackFrame()).GetMethod().Name, ex)); } }
private int UpdateEmployees(int employeeid) { int ProcReturnValue = 0; UserProfileEmployee theEmployee = new UserProfileEmployee(); theEmployee.EmployeeID = Connection.LoggedOnUser.UserReferenceID; //theEmployee.EmployeeCode = lbl_EmployeeCode.Text; //theEmployee.Salutation = txt_EmployeeSalutation.SelectedValue; //theEmployee.EmployeeName = txt_EmployeeName.Text; //theEmployee.FatherName = txt_EmployeeFatherName.Text; //theEmployee.SpouseName = txt_EmployeeSpouseName.Text; //theEmployee.DateOfBirth = DateTime.Parse(txt_EmployeeDateOfBirth.Text); //theEmployee.Gender = ddl_EmployeeGender.SelectedValue; //theEmployee.BloodGroup = ddl_EmployeeBloodGroup.SelectedValue; //theEmployee.Religion = ddl_EmployeeReligion.SelectedValue; //theEmployee.Nationality = ddl_EmployeeNationality.SelectedValue; //theEmployee.MaritalStatus = ddl_EmployeeMaritalStatus.SelectedValue; theEmployee.DateOfBirth = DateTime.Parse(txt_EmployeeDateOfBirth.Text); //theEmployee.KnownAilments = txt_EmployeeKnownAliments.Text; //theEmployee.IdentificationMark = txt_EmployeeIdentificationMark.Text; theEmployee.Address_Present_TownOrCity = txt_EmployeePresentTownOrCity.Text; theEmployee.Address_Present_LandMark = txt_EmployeePresentLandMark.Text; theEmployee.Address_Present_Pincode = txt_EmployeePresentPinCode.Text; theEmployee.Address_Present_DistrictID = int.Parse(ddl_EmployeePresentDistrict.SelectedValue); //theEmployee.Address_Permanent_TownOrCity = txt_EmployeePermanentTownOrCity.Text; //theEmployee.Address_Permanent_LandMark = txt_EmployeePermanentLandmark.Text; //theEmployee.Address_Permanent_Pincode = txt_EmployeePermanentPinCode.Text; //theEmployee.Address_Permanent_DistrictID = int.Parse(ddl_EmployeePermanentDistrict.SelectedValue); theEmployee.PhoneNumber = txt_EmployeePhoneNumber.Text; theEmployee.Mobile = txt_EmployeeMobile.Text; //theEmployee.EmailID = txt_EmployeeEmailId.Text; theEmployee.PersonalEMailID = txt_EmployeePersonalEmailId.Text; theEmployee.EmergencyContactNumber = txt_EmployeeEmergencyContactNumber.Text; //TODO Image ProcReturnValue = UserProfileEmployeeManagement.GetInstance.UpdateUserProfileEmployee(theEmployee); return(ProcReturnValue); }