public static List <UserProfileEmployeeProfile> SetPhotoByEmployeeID(DataTable EmployeeProfileDataTable) { try { List <UserProfileEmployeeProfile> EmployeeList = new List <UserProfileEmployeeProfile>(); foreach (DataRow dr in EmployeeProfileDataTable.Rows) { UserProfileEmployeeProfile theEmployeeProfile = new UserProfileEmployeeProfile(); theEmployeeProfile.EmployeeID = int.Parse(dr["EmployeeID"].ToString()); theEmployeeProfile.SettingKeyValue = ImageFunctions.ByteToImage((Byte[])(dr["SettingKeyValue"])); //theWebForm.ModuleID = int.Parse(dr["ModuleID"].ToString()); //theWebForm.WebFormName = dr["WebFormName"].ToString(); //theWebForm.WebFormURL = dr["WebFormURL"].ToString(); //theWebForm.WebFormImageURL = dr["WebFormImageURL"].ToString(); //theWebForm.ModuleName = dr["ModuleName"].ToString(); //theWebForm.CompanyCode = dr["CompanyCode"].ToString(); //theWebForm.IsActive = bool.Parse(dr["IsActive"].ToString()); //theWebForm.IsDeleted = bool.Parse(dr["IsDeleted"].ToString()); //theWebForm.WebFormDescription = dr["WebFormDescription"].ToString(); EmployeeList.Add(theEmployeeProfile); } return(EmployeeList); } catch (Exception ex) { throw (new Exception(MethodBase.GetCurrentMethod().DeclaringType.ToString() + "." + (new System.Diagnostics.StackFrame()).GetMethod().Name, ex)); } }
public int UpdateUserProfileEmployeeProfile(UserProfileEmployeeProfile objUserProfileEmployeeProfile) { 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, objUserProfileEmployeeProfile.EmployeeID)); SqlCmd.Parameters.Add(GetParameter("SettingKeyID", SqlDbType.Int, objUserProfileEmployeeProfile.SettingKeyID)); SqlCmd.Parameters.Add(GetParameter("SettingKeyValue", SqlDbType.VarBinary, ImageFunctions.ImageToByte(objUserProfileEmployeeProfile.SettingKeyValue))); SqlCmd.Parameters.Add(GetParameter("SettingKeyDescription", SqlDbType.VarChar, objUserProfileEmployeeProfile.SettingKeyDescription)); //SqlCmd.Parameters.Add(GetParameter("DateModified", SqlDbType.DateTime, objUserProfileEmployeeProfile.DateModified)); SqlCmd.Parameters.Add(GetParameter("ModifiedBy", SqlDbType.Int, Micro.Commons.Connection.LoggedOnUser.UserID)); SqlCmd.CommandText = "pHRM_UserProfile_EmployeeProfiles_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)); } }
public int UpdateUserProfileEmployeeProfile(UserProfileEmployeeProfile objUserProfileEmployeeProfile) { try { return(UserProfileEmployeeProfileIntegration.UpdateUserProfileEmployeeProfile(objUserProfileEmployeeProfile)); } catch (Exception ex) { throw (new Exception(MethodBase.GetCurrentMethod().DeclaringType.ToString() + "." + (new System.Diagnostics.StackFrame()).GetMethod().Name, ex)); } }
public static UserProfileEmployeeProfile GetEmployeePhotoByUserID(int EmployeeID) { try { DataRow DtRow = UserProfileEmployeeProfileDataAccess.GetInstance.GetPhotoByUserID(EmployeeID); UserProfileEmployeeProfile objEmployeeProfile = new UserProfileEmployeeProfile(); objEmployeeProfile.EmployeeID = int.Parse(DtRow["EmployeeID"].ToString()); objEmployeeProfile.SettingKeyValue = Base64ToImage(DtRow["SettingKeyValue"].ToString()); return(objEmployeeProfile); } catch (Exception ex) { throw (new Exception(MethodBase.GetCurrentMethod().DeclaringType.ToString() + "." + (new System.Diagnostics.StackFrame()).GetMethod().Name, ex)); } }
public int GetEmployeePhotoByUserID(UserProfileEmployeeProfile objUserProfileEmployeeProfile) { 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, objUserProfileEmployeeProfile.EmployeeID)); SqlCmd.Parameters.Add(GetParameter("SettingKeyValue", SqlDbType.VarBinary, ImageFunctions.ImageToByte(objUserProfileEmployeeProfile.SettingKeyValue))); SqlCmd.CommandText = "pHRM_EmployeePhoto_Select"; 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)); } }