public void AddRole(RoleAttribute Role) { using (MySqlConnection conn = GetConnection()) { conn.Open(); MySqlCommand cmd = new MySqlCommand("sp_AddRole", conn); cmd.CommandType = System.Data.CommandType.StoredProcedure; // RoleAttributes rol = new RoleAttributes(); cmd.Parameters.AddWithValue("Employee_Id", Role.Employee_Id); cmd.Parameters.AddWithValue("Employee_Name", Role.Employee_Name); cmd.Parameters.AddWithValue("Role_Designation", Role.Role_Designation); cmd.Parameters.AddWithValue("Role_Description", Role.Role_Description); cmd.Parameters.AddWithValue("Role_Status", Role.Role_Status); cmd.Parameters.AddWithValue("Role_StartDate", Role.Role_StartDate); cmd.Parameters.AddWithValue("Role_EndDate", Role.Role_EndDate); // cmd.Parameters.AddWithValue("Role_CreatedBy", Role.Role_CreatedBy); // cmd.Parameters.AddWithValue("Role_CreatedDate", Role.Role_CreatedDate); // cmd.Parameters.AddWithValue("Role_LastUpdatedBy", Role.Role_LastUpdatedBy); // cmd.Parameters.AddWithValue("Role_LastUpdatedDate", Role.Role_LastUpdatedDate); cmd.ExecuteNonQuery(); conn.Close(); } }
public int UpdateRole(RoleAttribute role) { using (MySqlConnection conn = GetConnection()) { MySqlCommand cmd = new MySqlCommand("sp_UpdateRole", conn); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("emp_Id", role.Employee_Id); cmd.Parameters.AddWithValue("Employee_Name", role.Employee_Name); cmd.Parameters.AddWithValue("Role_Designation", role.Role_Designation); cmd.Parameters.AddWithValue("Role_Description", role.Role_Description); cmd.Parameters.AddWithValue("Role_Status", role.Role_Status); cmd.Parameters.AddWithValue("Role_StartDate", role.Role_StartDate); cmd.Parameters.AddWithValue("Role_EndDate", role.Role_EndDate); conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); } return(1); }